diff options
| -rw-r--r-- | database/database.mysql | 33 |
1 files changed, 28 insertions, 5 deletions
diff --git a/database/database.mysql b/database/database.mysql index e458cc987..404eb587f 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -31,15 +31,15 @@ CREATE TABLE book ( ); CREATE TABLE boxes ( - id tinyint(4) DEFAULT '0' NOT NULL auto_increment, - subject varchar(64) DEFAULT '' NOT NULL, - content text, + bid tinyint(4) DEFAULT '0' NOT NULL auto_increment, + title varchar(64) DEFAULT '' NOT NULL, + body text, info varchar(128) DEFAULT '' NOT NULL, link varchar(128) DEFAULT '' NOT NULL, type tinyint(2) DEFAULT '0' NOT NULL, - UNIQUE subject (subject), + UNIQUE subject (title), UNIQUE info (info), - PRIMARY KEY (id) + PRIMARY KEY (bid) ); CREATE TABLE bundle ( @@ -50,6 +50,13 @@ CREATE TABLE bundle ( PRIMARY KEY (bid) ); +CREATE TABLE cache ( + url varchar(255) DEFAULT '' NOT NULL, + data text NOT NULL, + timestamp int(11) DEFAULT '0' NOT NULL, + PRIMARY KEY (url) +); + CREATE TABLE category ( cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, name varchar(32) DEFAULT '' NOT NULL, @@ -262,6 +269,11 @@ CREATE TABLE rating ( PRIMARY KEY (user) ); +CREATE TABLE referer ( + url varchar(255) DEFAULT '' NOT NULL, + timestamp int(11) DEFAULT '0' NOT NULL +); + CREATE TABLE role ( rid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, name varchar(32) DEFAULT '' NOT NULL, @@ -270,6 +282,17 @@ CREATE TABLE role ( PRIMARY KEY (rid) ); +CREATE TABLE site ( + sid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + title varchar(128) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + size text NOT NULL, + timestamp int(11) DEFAULT '0' NOT NULL, + UNIQUE title (title), + UNIQUE url (url), + PRIMARY KEY (sid) +); + CREATE TABLE story ( lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, nid int(10) unsigned DEFAULT '0' NOT NULL, |