diff options
author | Dries Buytaert <dries@buytaert.net> | 2001-01-13 16:33:19 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2001-01-13 16:33:19 +0000 |
commit | 8b4c95b259089c54331e9a6d014495c1ec807cea (patch) | |
tree | f034ed8a5ad4c13ddd9c558857b7011f7cc1dceb /database/database.mysql | |
parent | f9e5aa52ccad84784d8e134129f531751ccd34b2 (diff) | |
download | brdo-8b4c95b259089c54331e9a6d014495c1ec807cea.tar.gz brdo-8b4c95b259089c54331e9a6d014495c1ec807cea.tar.bz2 |
- rewrote the block placement stuff and updated the themes.
IMPORTANT: you have to drop 2 tables "blocks" and "layout"
and you have to recreate them again with those
in database/database.mysql
- integrated the documentation written by UnConeD
Diffstat (limited to 'database/database.mysql')
-rw-r--r-- | database/database.mysql | 20 |
1 files changed, 11 insertions, 9 deletions
diff --git a/database/database.mysql b/database/database.mysql index ab3685850..699407a45 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -8,6 +8,16 @@ CREATE TABLE affiliates ( PRIMARY KEY (id) ); +CREATE TABLE blocks ( + name varchar(64) DEFAULT '' NOT NULL, + module varchar(64) DEFAULT '' NOT NULL, + offset tinyint(2) DEFAULT '0' NOT NULL, + status tinyint(2) DEFAULT '0' NOT NULL, + weight tinyint(1) DEFAULT '0' NOT NULL, + region tinyint(1) DEFAULT '0' NOT NULL, + PRIMARY KEY (name) +); + CREATE TABLE boxes ( id tinyint(4) DEFAULT '0' NOT NULL auto_increment, subject varchar(64) DEFAULT '' NOT NULL, @@ -30,13 +40,6 @@ CREATE TABLE bans ( PRIMARY KEY (id) ); -CREATE TABLE blocks ( - name varchar(64) DEFAULT '' NOT NULL, - module varchar(64) DEFAULT '' NOT NULL, - offset tinyint(2) DEFAULT '0' NOT NULL, - status tinyint(2) DEFAULT '0' NOT NULL, - PRIMARY KEY (name) -); CREATE TABLE channel ( id int(11) DEFAULT '0' NOT NULL auto_increment, @@ -100,8 +103,7 @@ CREATE TABLE headlines ( CREATE TABLE layout ( user int(11) DEFAULT '0' NOT NULL, - block varchar(64) DEFAULT '' NOT NULL, - weight int(11) DEFAULT '0' NOT NULL + block varchar(64) DEFAULT '' NOT NULL ); CREATE TABLE modules ( |