From e986cbfa627d260015ba076a201c02da3c568e7b Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sat, 21 May 2005 19:50:06 +0000 Subject: [PATCH] r188: Checking in the initial files for custom bug fields --- admin/fields.php | 82 +++++++++++++++++++++++++++++++++++++++++ admin/global.php | 3 +- docs/schema_changes.sql | 22 +++++++++++ 3 files changed, 106 insertions(+), 1 deletion(-) create mode 100644 admin/fields.php diff --git a/admin/fields.php b/admin/fields.php new file mode 100644 index 0000000..be20ae7 --- /dev/null +++ b/admin/fields.php @@ -0,0 +1,82 @@ + \ No newline at end of file diff --git a/admin/global.php b/admin/global.php index 3e0733c..df8947f 100755 --- a/admin/global.php +++ b/admin/global.php @@ -33,7 +33,8 @@ $globalnav = array( 'Priorities' => 'priority.php', 'Resolutions' => 'resolution.php', 'Severities' => 'severity.php', - 'Statuses' => 'status.php' + 'Statuses' => 'status.php', + 'Custom Bug Fields' => 'fields.php' ), 'User Management' => array( diff --git a/docs/schema_changes.sql b/docs/schema_changes.sql index 07cd832..c7835c3 100644 --- a/docs/schema_changes.sql +++ b/docs/schema_changes.sql @@ -27,4 +27,26 @@ CREATE TABLE `history` ( `original` MEDIUMTEXT NOT NULL, `changed` MEDIUMTEXT NOT NULL, PRIMARY KEY (`historyid`) +); + +CREATE TABLE `bugfields` ( + `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, + `usereditable` 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 `bugvalues` ( + `bugid` INT(10) UNSIGNED NOT NULL, + PRIMARY KEY (`bugid`) ); \ No newline at end of file -- 2.43.5