diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-01-23 22:14:29 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-01-23 22:14:29 +0000 |
| commit | 3d0f6b3032abdb53fcf43790f8ee57ad5a323522 (patch) | |
| tree | ad1bc0483eb55417da889f582ce310c8dab62388 /database/database.mysql | |
| parent | 0b9b32587300130ff04a0606be7656c370252ab6 (diff) | |
| download | brdo-3d0f6b3032abdb53fcf43790f8ee57ad5a323522.tar.gz brdo-3d0f6b3032abdb53fcf43790f8ee57ad5a323522.tar.bz2 | |
- fixes table bug
- add ienie-wiene of information
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/database/database.mysql b/database/database.mysql index e11bf1e57..362b7dff6 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -8,19 +8,11 @@ CREATE TABLE affiliates ( PRIMARY KEY (id) ); -CREATE TABLE sections ( - name varchar(64) DEFAULT '' NOT NULL, - post tinyint(3) DEFAULT '0' NOT NULL, - dump tinyint(3) DEFAULT '0' NOT NULL, - timout tinyint(3) DEFAULT '0' NOT NULL, - status tinyint(2) DEFAULT '0' NOT NULL, - PRIMARY KEY (name) -); - 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) @@ -120,6 +112,15 @@ CREATE TABLE modules ( PRIMARY KEY (name) ); +CREATE TABLE sections ( + name varchar(64) DEFAULT '' NOT NULL, + post tinyint(3) DEFAULT '0' NOT NULL, + dump tinyint(3) DEFAULT '0' NOT NULL, + timout tinyint(3) DEFAULT '0' NOT NULL, + status tinyint(2) DEFAULT '0' NOT NULL, + PRIMARY KEY (name) +); + CREATE TABLE stories ( id int(11) DEFAULT '0' NOT NULL auto_increment, author int(6) DEFAULT '0' NOT NULL, |