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 | |
| parent | 6d1ffea494a977c4fca39be7b5155c5fb310cdb8 (diff) | |
| download | brdo-96a45ecba6d1cb84075391fb06c6f5e1b9cb128e.tar.gz brdo-96a45ecba6d1cb84075391fb06c6f5e1b9cb128e.tar.bz2 | |
- Updated the PostgreSQL database scheme (thanks James) and the MySQL
database scheme.
| -rw-r--r-- | database/database.mysql | 17 | ||||
| -rw-r--r-- | database/database.pgsql | 3 |
2 files changed, 7 insertions, 13 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; -- diff --git a/database/database.pgsql b/database/database.pgsql index c40381ccb..78401a98f 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -44,16 +44,13 @@ CREATE TABLE authmap ( -- CREATE TABLE blocks ( - name varchar(64) NOT NULL default '', module varchar(64) NOT NULL default '', delta smallint NOT NULL default '0', status smallint NOT NULL default '0', weight smallint NOT NULL default '0', region smallint NOT NULL default '0', - remove smallint NOT NULL default '0', path varchar(255) NOT NULL default '', custom smallint NOT NULL default '0', - PRIMARY KEY (name) ); -- |