27 lines
537 B
MySQL
27 lines
537 B
MySQL
|
/* SQL to generate a new database */
|
||
|
|
|
||
|
|
/* define command structure
|
||
|
|
type command struct {
|
||
|
|
action string
|
||
|
|
object string
|
||
|
|
extra string
|
||
|
|
} // end command structure */
|
||
|
|
|
||
|
|
create table logs (
|
||
|
|
id int not null auto_increment,
|
||
|
|
action varchar(255),
|
||
|
|
object varchar(255),
|
||
|
|
extra varchar(255),
|
||
|
|
date datetime default now() not null,
|
||
|
|
primary key (id)
|
||
|
|
);
|
||
|
|
|
||
|
|
/* define note structure
|
||
|
|
type note struct {
|
||
|
|
slug string
|
||
|
|
title string
|
||
|
|
note string
|
||
|
|
url string
|
||
|
|
file bool
|
||
|
|
} // end note structure */
|