From 33f460564b420ce519addfd5e54bee3a1ba51b7d Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sat, 15 Oct 2005 18:34:18 +0000 Subject: [PATCH] r556: Pre-tag preparation --- docs/bugtrack.sql | 56 +++++++++++++++++++++++--------- docs/datatools_store.php | 2 +- docs/schema_changes.sql | 69 ---------------------------------------- 3 files changed, 42 insertions(+), 85 deletions(-) diff --git a/docs/bugtrack.sql b/docs/bugtrack.sql index 089754b..9411c3e 100644 --- a/docs/bugtrack.sql +++ b/docs/bugtrack.sql @@ -6,7 +6,7 @@ CREATE TABLE `attachment` ( `filename` varchar(255) NOT NULL default '', `mimetype` varchar(255) NOT NULL default '', `filesize` int(20) unsigned NOT NULL default '0', - `attachment` mediumtext NOT NULL, + `attachment` mediumblob NOT NULL, `description` varchar(255) NOT NULL default '', `dateline` int(20) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', @@ -103,13 +103,19 @@ CREATE TABLE `dependency` ( PRIMARY KEY (`dependencyid`) ) ENGINE=MyISAM; +CREATE TABLE `favourite` ( + `userid` int(10) unsigned NOT NULL default '0', + `bugid` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`userid`,`bugid`) +) ENGINE=MyISAM; + CREATE TABLE `history` ( `historyid` int(20) unsigned NOT NULL auto_increment, `bugid` int(10) unsigned NOT NULL default '0', + `attachmentid` int(10) unsigned NOT NULL default '0', + `commentid` int(10) unsigned NOT NULL default '0', `dateline` int(20) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', - `language` varchar(255) NOT NULL default '', - `arguments` mediumtext NOT NULL, `field` varchar(255) NOT NULL default '', `original` mediumtext NOT NULL, `changed` mediumtext NOT NULL, @@ -122,26 +128,27 @@ CREATE TABLE `language` ( `languagecode` varchar(5) NOT NULL default '', `charset` varchar(15) NOT NULL default '', `direction` char(3) NOT NULL default '', + `filename` varchar(255) NOT NULL default '', `default` int(2) unsigned NOT NULL default '0', `userselect` int(2) unsigned NOT NULL default '0', - `filename` varchar(30) NOT NULL default '', + `debug` int(2) unsigned NOT NULL default '0', PRIMARY KEY (`languageid`), - UNIQUE KEY `languagecode` (`languagecode`), - UNIQUE KEY `filename` (`filename`) + UNIQUE KEY `languagecode` (`languagecode`) ) ENGINE=MyISAM; -CREATE TABLE `locale` ( +CREATE TABLE `localization` ( + `localid` int(10) unsigned NOT NULL auto_increment, + `localkey` mediumtext NOT NULL, + `localtext` mediumtext NOT NULL, `languageid` int(10) unsigned NOT NULL default '0', - `varname` varchar(255) NOT NULL default '', - `phrasetext` mediumtext NOT NULL, - KEY `languageid` (`languageid`) + PRIMARY KEY (`localid`) ) ENGINE=MyISAM; -CREATE TABLE `phrase` ( - `varname` varchar(255) NOT NULL default '', - `phrasetext` mediumtext NOT NULL, - `imported` int(20) unsigned NOT NULL default '0', - UNIQUE KEY `varname` (`varname`) +CREATE TABLE `permission` ( + `usergroupid` int(10) unsigned NOT NULL default '0', + `productid` int(10) unsigned NOT NULL default '0', + `mask` int(5) NOT NULL default '0', + PRIMARY KEY (`usergroupid`,`productid`) ) ENGINE=MyISAM; CREATE TABLE `priority` ( @@ -168,6 +175,16 @@ CREATE TABLE `resolution` ( PRIMARY KEY (`resolutionid`) ) ENGINE=MyISAM; +CREATE TABLE `search` ( + `userid` int(10) unsigned NOT NULL default '0', + `dateline` int(20) unsigned NOT NULL default '0', + `query` mediumtext NOT NULL, + `ids` mediumtext NOT NULL, + `orderby` mediumtext NOT NULL, + `hilight` varchar(255) NOT NULL default '', + PRIMARY KEY (`userid`) +) ENGINE=MyISAM; + CREATE TABLE `setting` ( `varname` varchar(255) NOT NULL default '', `value` mediumtext NOT NULL, @@ -198,6 +215,7 @@ CREATE TABLE `user` ( `salt` varchar(15) NOT NULL default '', `authkey` varchar(65) NOT NULL default '', `showemail` int(2) unsigned NOT NULL default '0', + `showcolours` int(2) unsigned NOT NULL default '0', `languageid` int(10) unsigned NOT NULL default '0', `timezone` int(4) NOT NULL default '0', PRIMARY KEY (`userid`) @@ -227,4 +245,12 @@ CREATE TABLE `version` ( `version` varchar(255) NOT NULL default '', `displayorder` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`versionid`) +) ENGINE=MyISAM; + +CREATE TABLE `vote` ( + `bugid` int(10) unsigned NOT NULL default '0', + `userids` mediumtext NOT NULL, + `votefor` int(10) unsigned NOT NULL default '0', + `voteagainst` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`bugid`) ) ENGINE=MyISAM; \ No newline at end of file diff --git a/docs/datatools_store.php b/docs/datatools_store.php index 6922bbe..782572b 100644 --- a/docs/datatools_store.php +++ b/docs/datatools_store.php @@ -3,6 +3,6 @@ // stores exported data data // SVN $Id$ -$DATASTORE = "a:5:{s:10:\"usergroups\";a:6:{i:0;a:6:{s:11:\"usergroupid\";s:1:\"1\";s:5:\"title\";s:26:\"Unregistered/Not Logged In\";s:12:\"displaytitle\";s:5:\"Guest\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:2:\"67\";}i:1;a:6:{s:11:\"usergroupid\";s:1:\"2\";s:5:\"title\";s:16:\"Registered Users\";s:12:\"displaytitle\";s:10:\"Registered\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:3:\"255\";}i:2;a:6:{s:11:\"usergroupid\";s:1:\"3\";s:5:\"title\";s:27:\"Awaiting Email Confirmation\";s:12:\"displaytitle\";s:18:\"Pending Activation\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:1:\"3\";}i:3;a:6:{s:11:\"usergroupid\";s:1:\"4\";s:5:\"title\";s:16:\"Pending Approval\";s:12:\"displaytitle\";s:15:\"Account Pending\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:1:\"3\";}i:4;a:6:{s:11:\"usergroupid\";s:1:\"5\";s:5:\"title\";s:10:\"Developers\";s:12:\"displaytitle\";s:9:\"Developer\";s:7:\"opentag\";s:8:\"\";s:8:\"closetag\";s:9:\"\";s:11:\"permissions\";s:7:\"7348223\";}i:5;a:6:{s:11:\"usergroupid\";s:1:\"6\";s:5:\"title\";s:14:\"Administrators\";s:12:\"displaytitle\";s:13:\"Administrator\";s:7:\"opentag\";s:12:\"\";s:8:\"closetag\";s:14:\"\";s:11:\"permissions\";s:7:\"8388607\";}}s:8:\"statuses\";a:5:{i:0;a:4:{s:8:\"statusid\";s:1:\"1\";s:6:\"status\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";s:5:\"color\";s:7:\"#CC3300\";}i:1;a:4:{s:8:\"statusid\";s:1:\"2\";s:6:\"status\";s:8:\"Verified\";s:12:\"displayorder\";s:1:\"2\";s:5:\"color\";s:7:\"#FFFF00\";}i:2;a:4:{s:8:\"statusid\";s:1:\"3\";s:6:\"status\";s:8:\"Assigned\";s:12:\"displayorder\";s:1:\"3\";s:5:\"color\";s:7:\"#9933CC\";}i:3;a:4:{s:8:\"statusid\";s:1:\"4\";s:6:\"status\";s:6:\"Closed\";s:12:\"displayorder\";s:1:\"4\";s:5:\"color\";s:7:\"#66CC00\";}i:4;a:4:{s:8:\"statusid\";s:1:\"5\";s:6:\"status\";s:8:\"Reopened\";s:12:\"displayorder\";s:1:\"5\";s:5:\"color\";s:7:\"#00CCFF\";}}s:8:\"severity\";a:6:{i:0;a:3:{s:10:\"severityid\";s:1:\"1\";s:8:\"severity\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:1;a:3:{s:10:\"severityid\";s:1:\"2\";s:8:\"severity\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:2;a:3:{s:10:\"severityid\";s:1:\"3\";s:8:\"severity\";s:8:\"Moderate\";s:12:\"displayorder\";s:1:\"3\";}i:3;a:3:{s:10:\"severityid\";s:1:\"4\";s:8:\"severity\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"4\";}i:4;a:3:{s:10:\"severityid\";s:1:\"5\";s:8:\"severity\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"5\";}i:5;a:3:{s:10:\"severityid\";s:1:\"6\";s:8:\"severity\";s:11:\"Enhancement\";s:12:\"displayorder\";s:1:\"6\";}}s:10:\"priorities\";a:5:{i:0;a:3:{s:10:\"priorityid\";s:1:\"1\";s:8:\"priority\";s:6:\"Normal\";s:12:\"displayorder\";s:1:\"1\";}i:1;a:3:{s:10:\"priorityid\";s:1:\"2\";s:8:\"priority\";s:3:\"Low\";s:12:\"displayorder\";s:1:\"2\";}i:2;a:3:{s:10:\"priorityid\";s:1:\"3\";s:8:\"priority\";s:4:\"High\";s:12:\"displayorder\";s:1:\"3\";}i:3;a:3:{s:10:\"priorityid\";s:1:\"4\";s:8:\"priority\";s:11:\"Address Now\";s:12:\"displayorder\";s:1:\"4\";}i:4;a:3:{s:10:\"priorityid\";s:1:\"5\";s:8:\"priority\";s:8:\"Deferred\";s:12:\"displayorder\";s:1:\"5\";}}s:11:\"resolutions\";a:6:{i:0;a:3:{s:12:\"resolutionid\";s:1:\"1\";s:10:\"resolution\";s:4:\"Open\";s:12:\"displayorder\";s:1:\"1\";}i:1;a:3:{s:12:\"resolutionid\";s:1:\"2\";s:10:\"resolution\";s:5:\"Fixed\";s:12:\"displayorder\";s:1:\"2\";}i:2;a:3:{s:12:\"resolutionid\";s:1:\"3\";s:10:\"resolution\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"3\";}i:3;a:3:{s:12:\"resolutionid\";s:1:\"4\";s:10:\"resolution\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:4;a:3:{s:12:\"resolutionid\";s:1:\"5\";s:10:\"resolution\";s:9:\"Won\'t Fix\";s:12:\"displayorder\";s:1:\"5\";}i:5;a:3:{s:12:\"resolutionid\";s:1:\"6\";s:10:\"resolution\";s:12:\"Works for Me\";s:12:\"displayorder\";s:1:\"6\";}}}"; +$DATASTORE = "a:5:{s:10:\"usergroups\";a:6:{i:0;a:6:{s:11:\"usergroupid\";s:1:\"1\";s:5:\"title\";s:26:\"Unregistered/Not Logged In\";s:12:\"displaytitle\";s:5:\"Guest\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:2:\"83\";}i:1;a:6:{s:11:\"usergroupid\";s:1:\"2\";s:5:\"title\";s:16:\"Registered Users\";s:12:\"displaytitle\";s:10:\"Registered\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:3:\"255\";}i:2;a:6:{s:11:\"usergroupid\";s:1:\"3\";s:5:\"title\";s:27:\"Awaiting Email Confirmation\";s:12:\"displaytitle\";s:18:\"Pending Activation\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:1:\"3\";}i:3;a:6:{s:11:\"usergroupid\";s:1:\"4\";s:5:\"title\";s:16:\"Pending Approval\";s:12:\"displaytitle\";s:15:\"Account Pending\";s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"permissions\";s:1:\"3\";}i:4;a:6:{s:11:\"usergroupid\";s:1:\"5\";s:5:\"title\";s:10:\"Developers\";s:12:\"displaytitle\";s:9:\"Developer\";s:7:\"opentag\";s:8:\"\";s:8:\"closetag\";s:9:\"\";s:11:\"permissions\";s:8:\"15736831\";}i:5;a:6:{s:11:\"usergroupid\";s:1:\"6\";s:5:\"title\";s:14:\"Administrators\";s:12:\"displaytitle\";s:13:\"Administrator\";s:7:\"opentag\";s:12:\"\";s:8:\"closetag\";s:14:\"\";s:11:\"permissions\";s:8:\"16777215\";}}s:8:\"statuses\";a:5:{i:0;a:4:{s:8:\"statusid\";s:1:\"1\";s:6:\"status\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";s:5:\"color\";s:7:\"#D96640\";}i:1;a:4:{s:8:\"statusid\";s:1:\"2\";s:6:\"status\";s:8:\"Verified\";s:12:\"displayorder\";s:1:\"2\";s:5:\"color\";s:7:\"#FFFF40\";}i:2;a:4:{s:8:\"statusid\";s:1:\"3\";s:6:\"status\";s:8:\"Assigned\";s:12:\"displayorder\";s:1:\"3\";s:5:\"color\";s:7:\"#B266D9\";}i:3;a:4:{s:8:\"statusid\";s:1:\"4\";s:6:\"status\";s:6:\"Closed\";s:12:\"displayorder\";s:1:\"4\";s:5:\"color\";s:7:\"#8CD940\";}i:4;a:4:{s:8:\"statusid\";s:1:\"5\";s:6:\"status\";s:8:\"Reopened\";s:12:\"displayorder\";s:1:\"5\";s:5:\"color\";s:7:\"#40D9FF\";}}s:8:\"severity\";a:6:{i:0;a:3:{s:10:\"severityid\";s:1:\"1\";s:8:\"severity\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:1;a:3:{s:10:\"severityid\";s:1:\"2\";s:8:\"severity\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:2;a:3:{s:10:\"severityid\";s:1:\"3\";s:8:\"severity\";s:8:\"Moderate\";s:12:\"displayorder\";s:1:\"3\";}i:3;a:3:{s:10:\"severityid\";s:1:\"4\";s:8:\"severity\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"4\";}i:4;a:3:{s:10:\"severityid\";s:1:\"5\";s:8:\"severity\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"5\";}i:5;a:3:{s:10:\"severityid\";s:1:\"6\";s:8:\"severity\";s:11:\"Enhancement\";s:12:\"displayorder\";s:1:\"6\";}}s:10:\"priorities\";a:5:{i:0;a:3:{s:10:\"priorityid\";s:1:\"1\";s:8:\"priority\";s:6:\"Normal\";s:12:\"displayorder\";s:1:\"1\";}i:1;a:3:{s:10:\"priorityid\";s:1:\"2\";s:8:\"priority\";s:3:\"Low\";s:12:\"displayorder\";s:1:\"2\";}i:2;a:3:{s:10:\"priorityid\";s:1:\"3\";s:8:\"priority\";s:4:\"High\";s:12:\"displayorder\";s:1:\"3\";}i:3;a:3:{s:10:\"priorityid\";s:1:\"4\";s:8:\"priority\";s:11:\"Address Now\";s:12:\"displayorder\";s:1:\"4\";}i:4;a:3:{s:10:\"priorityid\";s:1:\"5\";s:8:\"priority\";s:8:\"Deferred\";s:12:\"displayorder\";s:1:\"5\";}}s:11:\"resolutions\";a:6:{i:0;a:3:{s:12:\"resolutionid\";s:1:\"1\";s:10:\"resolution\";s:4:\"Open\";s:12:\"displayorder\";s:1:\"1\";}i:1;a:3:{s:12:\"resolutionid\";s:1:\"2\";s:10:\"resolution\";s:5:\"Fixed\";s:12:\"displayorder\";s:1:\"2\";}i:2;a:3:{s:12:\"resolutionid\";s:1:\"3\";s:10:\"resolution\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"3\";}i:3;a:3:{s:12:\"resolutionid\";s:1:\"4\";s:10:\"resolution\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:4;a:3:{s:12:\"resolutionid\";s:1:\"5\";s:10:\"resolution\";s:9:\"Won\'t Fix\";s:12:\"displayorder\";s:1:\"5\";}i:5;a:3:{s:12:\"resolutionid\";s:1:\"6\";s:10:\"resolution\";s:12:\"Works for Me\";s:12:\"displayorder\";s:1:\"6\";}}}"; ?> \ No newline at end of file diff --git a/docs/schema_changes.sql b/docs/schema_changes.sql index 55a0454..9de1d44 100644 --- a/docs/schema_changes.sql +++ b/docs/schema_changes.sql @@ -1,71 +1,2 @@ ## SVN $Id$ -CREATE TABLE `favourite` ( - `userid` INT(10) UNSIGNED NOT NULL, - `bugid` INT(10) UNSIGNED NOT NULL -); - -ALTER TABLE `favourite` ADD PRIMARY KEY (`userid`,`bugid`); - -CREATE TABLE `vote` ( - `bugid` INT(10) UNSIGNED NOT NULL, - `userids` MEDIUMTEXT NOT NULL, - `votefor` INT(10) UNSIGNED NOT NULL, - `voteagainst` INT(10) UNSIGNED NOT NULL, - PRIMARY KEY (`bugid`) -); - -ALTER TABLE `language` DROP `filename`; - -CREATE TABLE `search` ( - `userid` INT(10) UNSIGNED NOT NULL, - `dateline` INT(20) UNSIGNED NOT NULL, - `query` MEDIUMTEXT NOT NULL, - `ids` MEDIUMTEXT NOT NULL -); - -ALTER TABLE `search` ADD PRIMARY KEY(`userid`); - -ALTER TABLE `search` ADD `orderby` MEDIUMTEXT NOT NULL; - -ALTER TABLE `search` ADD `hilight` VARCHAR(255) NOT NULL; - -ALTER TABLE `language` ADD `debug` INT(2) UNSIGNED NOT NULL; - -ALTER TABLE `phrase` DROP INDEX `varname`; - -ALTER TABLE `phrase` CHANGE `varname` `localkey` MEDIUMTEXT NOT NULL; - -ALTER TABLE `phrase` DROP `imported`; - -DROP TABLE `locale`; - -ALTER TABLE `phrase` RENAME `localization`; - -ALTER TABLE `localization` ADD `languageid` INT(10) UNSIGNED NOT NULL; - -ALTER TABLE `localization` ADD `localid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; - -ALTER TABLE `localization` CHANGE `phrasetext` `localtext` MEDIUMTEXT NOT NULL; - -ALTER TABLE `language` ADD `filename` VARCHAR(255) NOT NULL AFTER `direction`; - -ALTER TABLE `history` DROP `language`; - -ALTER TABLE `history` DROP `arguments`; - -ALTER TABLE `user` ADD `showcolours` INT(2) UNSIGNED NOT NULL AFTER `showemail`; - -ALTER TABLE `history` ADD `attachmentid` INT(10) UNSIGNED NOT NULL AFTER `bugid`; - -ALTER TABLE `history` ADD `commentid` INT(10) UNSIGNED NOT NULL AFTER `attachmentid`; - -CREATE TABLE `permission` ( - `usergroupid` INT(10) UNSIGNED NOT NULL, - `productid` INT(10) UNSIGNED NOT NULL, - `mask` INT(5) NOT NULL -); - -ALTER TABLE `permission` ADD PRIMARY KEY (`usergroupid`,`productid`); - -ALTER TABLE `attachment` CHANGE `attachment` `attachment` MEDIUMBLOB NOT NULL; \ No newline at end of file -- 2.22.5