/* 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 */