diff options
| author | Dries Buytaert <dries@buytaert.net> | 2002-11-09 20:19:13 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2002-11-09 20:19:13 +0000 |
| commit | 96a45ecba6d1cb84075391fb06c6f5e1b9cb128e (patch) | |
| tree | 49f19e246f4f3669fc1de7ac2baad5b5aa9b2580 /database/database.mysql | |
| parent | 6d1ffea494a977c4fca39be7b5155c5fb310cdb8 (diff) | |
| download | brdo-96a45ecba6d1cb84075391fb06c6f5e1b9cb128e.tar.gz brdo-96a45ecba6d1cb84075391fb06c6f5e1b9cb128e.tar.bz2 | |
- Updated the PostgreSQL database scheme (thanks James) and the MySQL
database scheme.
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 17 |
1 files changed, 7 insertions, 10 deletions
diff --git a/database/database.mysql b/database/database.mysql index 994ea4f91..bcfb4b0f0 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -47,16 +47,13 @@ CREATE TABLE authmap ( -- CREATE TABLE blocks ( - name varchar(64) NOT NULL default '', - module varchar(64) NOT NULL default '', - delta tinyint(2) NOT NULL default '0', - status tinyint(2) NOT NULL default '0', - weight tinyint(1) NOT NULL default '0', - region tinyint(1) NOT NULL default '0', - remove tinyint(1) NOT NULL default '0', - path varchar(255) NOT NULL default '', - custom tinyint(2) NOT NULL default '0', - PRIMARY KEY (name) + module varchar(64) DEFAULT '' NOT NULL, + delta 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, + path varchar(255) DEFAULT '' NOT NULL, + custom tinyint(2) DEFAULT '0' NOT NULL ) TYPE=MyISAM; -- |