diff options
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 29 |
1 files changed, 21 insertions, 8 deletions
diff --git a/database/database.mysql b/database/database.mysql index cecc968f7..14e8325ba 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -1,11 +1,3 @@ -CREATE TABLE admin_blocks ( - id tinyint(4) DEFAULT '0' NOT NULL auto_increment, - subject varchar(64) DEFAULT '' NOT NULL, - content text, - info varchar(128) DEFAULT '' NOT NULL, - link varchar(128) DEFAULT '' NOT NULL, - PRIMARY KEY (id) -); CREATE TABLE affiliates ( id int(11) DEFAULT '0' NOT NULL auto_increment, @@ -16,6 +8,18 @@ CREATE TABLE affiliates ( PRIMARY KEY (id) ); +CREATE TABLE boxes ( + id tinyint(4) DEFAULT '0' NOT NULL auto_increment, + subject varchar(64) DEFAULT '' NOT NULL, + content text, + info varchar(128) DEFAULT '' NOT NULL, + link varchar(128) DEFAULT '' NOT NULL, + type tinyint(2) DEFAULT '0' NOT NULL, + UNIQUE subject (subject), + UNIQUE info (info), + PRIMARY KEY (id) +); + CREATE TABLE bans ( id tinyint(4) DEFAULT '0' NOT NULL auto_increment, mask varchar(255) DEFAULT '' NOT NULL, @@ -76,6 +80,15 @@ CREATE TABLE diaries ( PRIMARY KEY (id) ); +CREATE TABLE drupals ( + id int(11) DEFAULT '0' NOT NULL auto_increment, + link varchar(255) DEFAULT '' NOT NULL, + name varchar(255) DEFAULT '' NOT NULL, + contact varchar(255) DEFAULT '' NOT NULL, + UNIQUE link (link), + PRIMARY KEY (id) +); + CREATE TABLE headlines ( id int(11) DEFAULT '0' NOT NULL, title varchar(255) DEFAULT '' NOT NULL, |