From df06f54ab5ead53d7993cb125fe09e460859f8e4 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sat, 9 Sep 2006 18:22:50 +0000 Subject: [PATCH] r1132: Updating the schema file --- install/schema.php | 24 ++++++------------------ 1 file changed, 6 insertions(+), 18 deletions(-) diff --git a/install/schema.php b/install/schema.php index 2ec9bf2..487fad9 100644 --- a/install/schema.php +++ b/install/schema.php @@ -31,7 +31,7 @@ CREATE TABLE " . TABLE_PREFIX . "attachment description varchar(255) NOT NULL, dateline bigint unsigned NOT NULL, userid int unsigned NOT NULL, - obsolete bool NOT NULL, + obsolete bool unsigned NOT NULL, PRIMARY KEY (attachmentid) );"; @@ -131,8 +131,8 @@ CREATE TABLE " . TABLE_PREFIX . "datastore PRIMARY KEY (title) );"; -$query['favourite'] = " -CREATE TABLE " . TABLE_PREFIX . "favourite +$query['favorite'] = " +CREATE TABLE " . TABLE_PREFIX . "favorite ( userid int unsigned NOT NULL, bugid int unsigned NOT NULL, @@ -168,24 +168,12 @@ CREATE TABLE " . TABLE_PREFIX . "language ( languageid int unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, - languagecode varchar(5) NOT NULL, + langcode varchar(5) NOT NULL, charset varchar(15) NOT NULL, direction char(3) NOT NULL, - filename varchar(255) NOT NULL, userselect smallint unsigned NOT NULL, - debug smallint unsigned NOT NULL, PRIMARY KEY (languageid), - UNIQUE KEY languagecode (languagecode) -);"; - -$query['localization'] = " -CREATE TABLE " . TABLE_PREFIX . "localization -( - localid int unsigned NOT NULL AUTO_INCREMENT, - localkey text NOT NULL, - localtext text NOT NULL, - languageid int unsigned NOT NULL, - PRIMARY KEY (localid) + UNIQUE KEY languagecode (langcode) );"; $query['permission'] = " @@ -277,7 +265,7 @@ CREATE TABLE " . TABLE_PREFIX . "user salt varchar(15) NOT NULL, authkey varchar(65) NOT NULL, showemail smallint unsigned NOT NULL, - showcolours smallint unsigned NOT NULL, + showcolors bool NULL, languageid int unsigned NOT NULL, timezone smallint NOT NULL, usedst bool NOT NULL, -- 2.22.5