summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2001-01-13 16:33:19 +0000
committerDries Buytaert <dries@buytaert.net>2001-01-13 16:33:19 +0000
commit8b4c95b259089c54331e9a6d014495c1ec807cea (patch)
treef034ed8a5ad4c13ddd9c558857b7011f7cc1dceb /database/database.mysql
parentf9e5aa52ccad84784d8e134129f531751ccd34b2 (diff)
downloadbrdo-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.mysql20
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 (