Subversion-Projekte lars-tiefland.prado

Revision

Revision 9 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 9 Revision 10
Zeile 9... Zeile 9...
9 
);
 9 
);
Zeile 10... Zeile 10...
10
10
11 
/* create posts table */
 11 
/* create posts table */
12 
CREATE TABLE prado_posts (
 12 
CREATE TABLE prado_posts (
13 
  post_id       INTEGER auto_increment NOT NULL PRIMARY KEY,
 13 
  post_id       INTEGER auto_increment NOT NULL PRIMARY KEY,
14 
  author_id     VARCHAR(128) NOT NULL
 - 
 
15 
                CONSTRAINT fk_author REFERENCES users(username),
 14 
  author_id     VARCHAR(128) NOT NULL,
16 
  create_time   INTEGER NOT NULL,       /* UNIX timestamp */
 15 
  create_time   INTEGER NOT NULL,       /* UNIX timestamp */
17 
  title         VARCHAR(256) NOT NULL,  /* title of the post */
 16 
  title         VARCHAR(256) NOT NULL,  /* title of the post */
18 
  content       TEXT,                   /* post body */
 17 
  content       TEXT,                   /* post body */
19 
  status        INTEGER NOT NULL        /* 0: published; 1: draft; 2: pending; 2: denied */
 18 
  status        INTEGER NOT NULL        /* 0: published; 1: draft; 2: pending; 2: denied */