From 96a45ecba6d1cb84075391fb06c6f5e1b9cb128e Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 9 Nov 2002 20:19:13 +0000 Subject: - Updated the PostgreSQL database scheme (thanks James) and the MySQL database scheme. --- database/database.mysql | 17 +++++++---------- 1 file changed, 7 insertions(+), 10 deletions(-) (limited to 'database/database.mysql') 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; -- -- cgit v1.2.3