From e986cbfa627d260015ba076a201c02da3c568e7b Mon Sep 17 00:00:00 2001
From: Robert Sesek <rsesek@bluestatic.org>
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 @@
+<?php
+/*=====================================================================*\
+|| ################################################################### ||
+|| # BugStrike [#]version[#]
+|| # --------------------------------------------------------------- # ||
+|| # Copyright ©2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
+|| # This file may not be reproduced in any way without permission.  # ||
+|| # --------------------------------------------------------------- # ||
+|| # User License Agreement at http://www.iris-studios.com/license/  # ||
+|| ################################################################### ||
+\*=====================================================================*/
+
+require_once('./global.php');
+
+if (!can_perform('canadminfields'))
+{
+	admin_login();
+}
+
+// ###################################################################
+
+if (empty($_REQUEST['do']))
+{
+	$_REQUEST['do'] = 'modify';
+}
+
+// ###################################################################
+
+if ($_REQUEST['do'] == 'kill')
+{
+	// run code to remove item in database
+}
+
+// ###################################################################
+
+if ($_REQUEST['do'] == 'delete')
+{
+	// display delete confirmation message
+}
+
+// ###################################################################
+
+if ($_POST['do'] == 'insert')
+{
+	// run code to insert new item into database
+}
+
+// ###################################################################
+
+if ($_REQUEST['do'] == 'add')
+{
+	// display form to add new item
+}
+
+// ###################################################################
+
+if ($_POST['do'] == 'update')
+{
+	// run code to update item in database
+}
+
+// ###################################################################
+
+if ($_REQUEST['do'] == 'edit')
+{
+	// display form to edit item
+}
+
+// ###################################################################
+
+if ($_REQUEST['do'] == 'modify')
+{
+	// show default branch for this script
+}
+
+/*=====================================================================*\
+|| ###################################################################
+|| # $HeadURL$
+|| # $Id$
+|| ###################################################################
+\*=====================================================================*/
+?>
\ 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.22.5