From 64ae7ce0004e2ff85eb642a8a6ae451550b9eaa4 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sat, 2 Jul 2005 16:04:20 +0000 Subject: [PATCH] r277: Finishing Beta 1 --- docs/bugtrack.sql | 83 ++++++++++++++++++++++++++++++++++----- docs/datatools_store.php | 2 +- docs/lang_file_master.php | 17 ++++++++ docs/roadmap.txt | 4 -- docs/schema_changes.sql | 81 -------------------------------------- 5 files changed, 91 insertions(+), 96 deletions(-) diff --git a/docs/bugtrack.sql b/docs/bugtrack.sql index 219463a..089754b 100644 --- a/docs/bugtrack.sql +++ b/docs/bugtrack.sql @@ -1,5 +1,28 @@ ## SVN $Id$ +CREATE TABLE `attachment` ( + `attachmentid` int(10) unsigned NOT NULL auto_increment, + `bugid` int(10) unsigned NOT NULL default '0', + `filename` varchar(255) NOT NULL default '', + `mimetype` varchar(255) NOT NULL default '', + `filesize` int(20) unsigned NOT NULL default '0', + `attachment` mediumtext NOT NULL, + `description` varchar(255) NOT NULL default '', + `dateline` int(20) unsigned NOT NULL default '0', + `userid` int(10) unsigned NOT NULL default '0', + `obsolete` int(1) unsigned NOT NULL default '0', + PRIMARY KEY (`attachmentid`) +) ENGINE=MyISAM; + +CREATE TABLE `autoaction` ( + `actionid` int(10) unsigned NOT NULL auto_increment, + `name` varchar(255) NOT NULL default '', + `description` mediumtext NOT NULL, + `fieldchanges` mediumtext NOT NULL, + `comment` mediumtext NOT NULL, + PRIMARY KEY (`actionid`) +) ENGINE=MyISAM; + CREATE TABLE `bug` ( `bugid` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', @@ -13,13 +36,48 @@ CREATE TABLE `bug` ( `status` int(10) unsigned NOT NULL default '0', `resolution` int(10) unsigned NOT NULL default '0', `assignedto` int(10) unsigned NOT NULL default '0', + `duplicateof` int(10) unsigned NOT NULL default '0', + `dependency` mediumtext NOT NULL, + `hidden` int(2) unsigned NOT NULL default '0', `initialreport` int(10) unsigned NOT NULL default '0', `lastposttime` int(20) unsigned NOT NULL default '0', `lastpostby` int(10) unsigned NOT NULL default '0', + `hiddenlastposttime` int(10) unsigned NOT NULL default '0', + `hiddenlastpostby` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`bugid`), FULLTEXT KEY `summary` (`summary`) ) ENGINE=MyISAM; +CREATE TABLE `bugfield` ( + `fieldid` int(10) unsigned NOT NULL auto_increment, + `name` varchar(255) NOT NULL default '', + `description` mediumtext NOT NULL, + `type` varchar(50) NOT NULL default '', + `selects` mediumtext NOT NULL, + `required` int(2) NOT NULL default '0', + `cansearch` int(2) NOT NULL default '0', + `regexmatch` mediumtext NOT NULL, + `defaultvalue` mediumtext NOT NULL, + `usedefault` int(2) NOT NULL default '0', + `maxlength` int(5) unsigned NOT NULL default '0', + PRIMARY KEY (`fieldid`) +) ENGINE=MyISAM; + +CREATE TABLE `bugfieldpermission` ( + `usergroupid` int(10) unsigned NOT NULL default '0', + `fieldid` int(10) unsigned NOT NULL default '0', + `mask` int(5) unsigned NOT NULL default '0', + PRIMARY KEY (`usergroupid`,`fieldid`) +) ENGINE=MyISAM; + +CREATE TABLE `bugvaluefill` ( + `bugid` int(10) unsigned NOT NULL default '0', + `field2` mediumtext, + `field4` mediumtext, + `field5` mediumtext, + PRIMARY KEY (`bugid`) +) ENGINE=MyISAM; + CREATE TABLE `comment` ( `commentid` int(10) unsigned NOT NULL auto_increment, `bugid` int(10) unsigned NOT NULL default '0', @@ -27,6 +85,7 @@ CREATE TABLE `comment` ( `dateline` int(20) unsigned NOT NULL default '0', `comment` mediumtext NOT NULL, `comment_parsed` mediumtext NOT NULL, + `hidden` int(2) unsigned NOT NULL default '0', PRIMARY KEY (`commentid`), FULLTEXT KEY `comment` (`comment`) ) ENGINE=MyISAM; @@ -44,6 +103,19 @@ CREATE TABLE `dependency` ( PRIMARY KEY (`dependencyid`) ) ENGINE=MyISAM; +CREATE TABLE `history` ( + `historyid` int(20) unsigned NOT NULL auto_increment, + `bugid` 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, + PRIMARY KEY (`historyid`) +) ENGINE=MyISAM; + CREATE TABLE `language` ( `languageid` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', @@ -113,19 +185,10 @@ CREATE TABLE `status` ( `statusid` int(10) unsigned NOT NULL auto_increment, `status` varchar(255) NOT NULL default '', `displayorder` int(10) unsigned NOT NULL default '0', + `color` varchar(10) NOT NULL default '', PRIMARY KEY (`statusid`) ) ENGINE=MyISAM; -CREATE TABLE `templateset` ( - `templatesetid` int(10) unsigned NOT NULL auto_increment, - `title` varchar(255) NOT NULL default '', - `shortname` varchar(50) NOT NULL default '', - `default` int(2) unsigned NOT NULL default '0', - `userselect` int(2) unsigned NOT NULL default '0', - PRIMARY KEY (`templatesetid`), - UNIQUE KEY `title` (`title`) -) ENGINE=MyISAM; - CREATE TABLE `user` ( `userid` int(10) unsigned NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', diff --git a/docs/datatools_store.php b/docs/datatools_store.php index ff0c8f7..00441ba 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:1:\"3\";}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:\"3153919\";}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:\"4194303\";}}s:8:\"statuses\";a:6:{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:\"#FFBBAA\";}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:\"#99BBAA\";}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:\"#BBAAFF\";}i:3;a:4:{s:8:\"statusid\";s:1:\"4\";s:6:\"status\";s:8:\"Resolved\";s:12:\"displayorder\";s:1:\"4\";s:5:\"color\";s:7:\"#AAFFBB\";}i:4;a:4:{s:8:\"statusid\";s:1:\"5\";s:6:\"status\";s:6:\"Closed\";s:12:\"displayorder\";s:1:\"5\";s:5:\"color\";s:7:\"#AAAAAA\";}i:5;a:4:{s:8:\"statusid\";s:1:\"6\";s:6:\"status\";s:8:\"Reopened\";s:12:\"displayorder\";s:1:\"6\";s:5:\"color\";s:7:\"#BBEEFF\";}}s:8:\"severity\";a:5:{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\";}}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:\"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:\"#FFBBAA\";}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:\"#99BBAA\";}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:\"#BBAAFF\";}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:\"#AAFFBB\";}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:\"#BBEEFF\";}}s:8:\"severity\";a:5:{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\";}}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/lang_file_master.php b/docs/lang_file_master.php index 554ae0f..1ff20df 100755 --- a/docs/lang_file_master.php +++ b/docs/lang_file_master.php @@ -12,7 +12,9 @@ $language = array( 'action' => 'Action', + 'additional_bug_fields' => 'Additional Bug Fields', 'add_component' => 'Add Component', + 'add_new_field' => 'Add New Bug Field', 'add_new_priority' => 'Add New Priority', 'add_new_product' => 'Add New Product', 'add_new_resolution' => 'Add New Resolution', @@ -34,6 +36,7 @@ $language = array( 'confirm_delete_usergroup' => 'Are you sure you want to delete this usergroup? All users in this group will be set back to the default registered usergroup (id: 2).', 'confirm_delete_version' => 'Are you sure you want to delete this version? Doing so will do x to the bugs with this version.', 'delete_wraplink' => '[Delete]', + 'edit_field' => 'Edit Field', 'edit_priority' => 'Edit Priority', 'edit_priority_title' => 'Edit Priority - %1$s (priorityid: %2$s)', 'edit_product' => 'Edit Product', @@ -50,6 +53,9 @@ $language = array( 'edit_wraplink' => '[Edit]', 'email' => 'Email', 'error' => 'Error', + 'error_invalid_id' => 'That is an invalid ID.', + 'error_no_permission' => 'You do not have permission to access this page. If you think that this is an error, please contact an administrator.', + 'field_x_is_required' => 'The field titled "%1$s" is a required field.', 'fill_in_version_number' => 'Please fill in a version number.', 'global_versions' => 'Global Versions', 'go' => 'Go', @@ -57,6 +63,14 @@ $language = array( 'guest' => 'Guest', 'invalid_admin_session_terminated' => 'Invalid admin session has been terminated.', 'login' => 'Login', + 'log_kill_attachment' => 'Removed attachment #%1$s', + 'log_mark_obsoletes' => 'Marking other attachments obsolete', + 'log_new_attachment' => 'Uploaded new attachment "%1$s" (attachmentid: %2$s)', + 'log_new_attachment_comment' => 'Created comment #%2$s', + 'log_new_comment' => 'Added comment (commentid: #%1$s)', + 'log_update_attachment' => 'Updated attachment #%1$s', + 'log_update_bug' => 'Updated bug', + 'log_update_comment' => 'Updated comment #%1$s', 'new_priority' => 'New Priority', 'new_resolution' => 'New Resolution', 'new_severity' => 'New Severity', @@ -86,6 +100,7 @@ $language = array( 'permissions_cansubmitbugs' => 'Can Submit Bugs', 'permissions_cansubscribe' => 'Can Subscribe to Bugs', 'permissions_canviewbugs' => 'Can View Bugs', + 'permissions_canviewhidden' => 'Can View Hidden Bugs and Comments', 'permissions_canvote' => 'Can Vote on Polls', 'permissions_group_admin' => 'Administrator Permissions', 'permissions_group_general' => 'General Permissions', @@ -117,6 +132,8 @@ $language = array( 'setting_dateformat_title' => 'Date Format', 'setting_defaultassign_desc' => 'This is the default developer new bugs will be assigned to. If a user does not have permisssion to assign bugs, this will be the default. If you don\'t want any default assignment, leave this as Not Selected.', 'setting_defaultassign_title' => 'Default Bug Assignment', + 'setting_defaultcomment_desc' => 'If you wish to set a template for entering the initial comment of a bug report, then you may specify this here. However, the template will only take effect on the initial report/comment. Note: the template cannot be forced on the user as there is no way to validate it.', + 'setting_defaultcomment_title' => 'Default Comment Text', 'setting_defaultpriority_desc' => 'The default priority that will be selected when creating a new bug report. Depending on your permission setup, the user may not be able to set this in a new report so this will act as the value.', 'setting_defaultpriority_title' => 'Default Priority', 'setting_defaultresolve_desc' => 'This is the default bug resolution. If a user is not able to change this field, setting this will act as the default value.', diff --git a/docs/roadmap.txt b/docs/roadmap.txt index 61e2182..0d8e7e9 100755 --- a/docs/roadmap.txt +++ b/docs/roadmap.txt @@ -5,10 +5,6 @@ SVN: $Id$ ############################################################################### BUGTRACK 1.0 ----------------------------------------- - BETA 1 ----------------------------------------- - ---------------------------------------- BETA 2 ---------------------------------------- diff --git a/docs/schema_changes.sql b/docs/schema_changes.sql index ac1c332..9de1d44 100644 --- a/docs/schema_changes.sql +++ b/docs/schema_changes.sql @@ -1,83 +1,2 @@ ## SVN $Id$ -ALTER TABLE `status` ADD `color` VARCHAR(10) NOT NULL; - -CREATE TABLE `attachment` ( - `attachmentid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, - `bugid` INT(10) UNSIGNED NOT NULL, - `filename` VARCHAR(255) NOT NULL, - `mimetype` VARCHAR(255) NOT NULL, - `filesize` INT(20) UNSIGNED NOT NULL, - `attachment` MEDIUMTEXT NOT NULL, - `description` VARCHAR(255) NOT NULL, - `dateline` INT(20) UNSIGNED NOT NULL, - `userid` INT(10) UNSIGNED NOT NULL, - `obsolete` INT(1) UNSIGNED NOT NULL, - PRIMARY KEY (`attachmentid`) -); - -CREATE TABLE `history` ( - `historyid` INT(20) UNSIGNED NOT NULL AUTO_INCREMENT, - `bugid` INT(10) UNSIGNED NOT NULL, - `dateline` INT(20) UNSIGNED NOT NULL, - `userid` INT(10) UNSIGNED NOT NULL, - `language` VARCHAR(255) NOT NULL, - `arguments` MEDIUMTEXT NOT NULL, - `field` VARCHAR(255) NOT NULL, - `original` MEDIUMTEXT NOT NULL, - `changed` MEDIUMTEXT NOT NULL, - PRIMARY KEY (`historyid`) -); - -CREATE TABLE `bugfield` ( - `fieldid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, - `shortname` VARCHAR(100) NOT NULL, - `name` VARCHAR(255) NOT NULL, - `description` MEDIUMTEXT NOT NULL, - `type` VARCHAR(50) NOT NULL, - `selects` MEDIUMTEXT NOT NULL, - `required` INT(2) NOT NULL, - `private` INT(2) NOT NULL, - `regexmatch` MEDIUMTEXT NOT NULL, - `defaultvalue` MEDIUMTEXT NOT NULL, - `usedefault` INT(2) NOT NULL, - `maxlength` INT(5) UNSIGNED NOT NULL, - PRIMARY KEY (`fieldid`) -); - -CREATE TABLE `bugvaluefill` ( - `bugid` INT(10) UNSIGNED NOT NULL, - PRIMARY KEY (`bugid`) -); - -ALTER TABLE `bug` ADD `hidden` INT(2) UNSIGNED NOT NULL AFTER `assignedto`; - -ALTER TABLE `comment` ADD `hidden` INT(2) UNSIGNED NOT NULL; - -ALTER TABLE `bug` ADD `hiddenlastposttime` INT(10) UNSIGNED NOT NULL, ADD `hiddenlastpostby` INT(10) UNSIGNED NOT NULL; - -ALTER TABLE `bug` ADD `duplicateof` INT(10) UNSIGNED NOT NULL AFTER `assignedto`, ADD `dependency` MEDIUMTEXT NOT NULL AFTER `duplicateof`; - -DROP TABLE IF EXISTS `templateset`; - -CREATE TABLE `bugfieldpermission` ( - `permissionid` INT(10) UNSIGNED NOT NULL, - `usergroupid` INT(10) UNSIGNED NOT NULL, - `fieldid` INT(10) UNSIGNED NOT NULL, - `mask` INT(5) UNSIGNED NOT NULL, - PRIMARY KEY (`permissionid`, `fieldid`) -); - -ALTER TABLE `bugfield` CHANGE `private` `cansearch` INT(2) DEFAULT '0' NOT NULL; - -ALTER TABLE `bugfield` DROP `shortname`; - -CREATE TABLE `autoaction` ( - `actionid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, - `name` VARCHAR(55) NOT NULL, - `description` MEDIUMTEXT NOT NULL, - `fieldchanges` MEDIUMTEXT NOT NULL, - PRIMARY KEY (`actionid`) -); - -ALTER TABLE `autoaction` ADD `comment` MEDIUMTEXT NOT NULL; \ No newline at end of file -- 2.22.5