From 34de24ce26aece980444b04b1bf0c2b43d50bb48 Mon Sep 17 00:00:00 2001
From: Robert Sesek <rsesek@bluestatic.org>
Date: Sun, 11 Mar 2007 23:43:04 +0000
Subject: [PATCH] r1451: Updating the schema file

---
 install/schema.php | 55 ++++++++++++++++++++++++++++++++++++++--------
 1 file changed, 46 insertions(+), 9 deletions(-)

diff --git a/install/schema.php b/install/schema.php
index bc8c127..49716d9 100644
--- a/install/schema.php
+++ b/install/schema.php
@@ -19,6 +19,15 @@
 || ###################################################################
 \*=====================================================================*/
 
+$schema['adminsession'] = "
+CREATE TABLE " . TABLE_PREFIX . "adminsession
+(
+	sessionid varchar(250) NOT NULL,
+	userid int unsigned NOT NULL,
+	dateline int unsigned NOT NULL,
+	PRIMARY KEY (sessionid)
+);";
+
 $schema['attachment'] = "
 CREATE TABLE " . TABLE_PREFIX . "attachment
 (
@@ -102,13 +111,6 @@ CREATE TABLE " . TABLE_PREFIX . "bugfieldpermission
 	PRIMARY KEY (usergroupid, fieldid)
 );";
 
-$schema['bugvaluefill'] = "
-CREATE TABLE " . TABLE_PREFIX . "bugvaluefill
-(
-	bugid int unsigned NOT NULL,
-	PRIMARY KEY (bugid)
-);";
-
 $schema['comment'] = "
 CREATE TABLE " . TABLE_PREFIX . "comment
 (
@@ -119,10 +121,22 @@ CREATE TABLE " . TABLE_PREFIX . "comment
 	comment text NOT NULL,
 	comment_parsed text NOT NULL,
 	hidden smallint unsigned NOT NULL,
+	parselinks bool NULL,
 	PRIMARY KEY (commentid),
 	FULLTEXT KEY comment (comment)
 );";
 
+$schema['component'] = "
+CREATE TABLE " . TABLE_PREFIX . "component
+(
+	componentid int unsigned NOT NULL AUTO_INCREMENT,
+	productid int unsigned NOT NULL,
+	displayorder int unsigned NOT NULL,
+	title varchar(255) NOT NULL,
+	description text NOT NULL,
+	PRIMARY KEY (componentid)
+);";
+
 $schema['datastore'] = "
 CREATE TABLE " . TABLE_PREFIX . "datastore
 (
@@ -176,6 +190,15 @@ CREATE TABLE " . TABLE_PREFIX . "language
 	UNIQUE KEY languagecode (langcode)
 );";
 
+$schema['passwordreset'] = "
+CREATE TABLE " . TABLE_PREFIX . "passwordreset
+(
+	activatorid varchar(250) NOT NULL,
+	userid int NOT NULL,
+	dateline int NOT NULL,
+	PRIMARY KEY (activatorid)
+);";
+
 $schema['permission'] = "
 CREATE TABLE " . TABLE_PREFIX . "permission
 (
@@ -198,7 +221,7 @@ $schema['product'] = "
 CREATE TABLE " . TABLE_PREFIX . "product
 (
 	productid int unsigned NOT NULL AUTO_INCREMENT,
-	componentmother int unsigned NOT NULL,
+	parentid int unsigned NULL,
 	displayorder int unsigned NOT NULL,
 	title varchar(255) NOT NULL,
 	description text NOT NULL,
@@ -217,6 +240,7 @@ CREATE TABLE " . TABLE_PREFIX . "resolution
 $schema['search'] = "
 CREATE TABLE " . TABLE_PREFIX . "search
 (
+	searchid int unsigned NOT NULL AUTO_INCREMENT,
 	userid int unsigned NOT NULL,
 	dateline bigint unsigned NOT NULL,
 	query text NOT NULL,
@@ -224,7 +248,8 @@ CREATE TABLE " . TABLE_PREFIX . "search
 	orderby text NOT NULL,
 	hilight varchar(255) NOT NULL,
 	resultcount int NULL,
-	PRIMARY KEY (userid)
+	name varchar(250) NULL,
+	PRIMARY KEY (searchid)
 );";
 
 $schema['setting'] = "
@@ -254,6 +279,15 @@ CREATE TABLE " . TABLE_PREFIX . "status
 	PRIMARY KEY (statusid)
 );";
 
+$schema['template'] = "
+CREATE TABLE " . TABLE_PREFIX . "template
+(
+	filename varchar(255) NOT NULL,
+	template text NOT NULL,
+	timestamp int unsigned NOT NULL,
+	PRIMARY KEY (filename)
+);";
+
 $schema['user'] = "
 CREATE TABLE " . TABLE_PREFIX . "user
 (
@@ -272,6 +306,8 @@ CREATE TABLE " . TABLE_PREFIX . "user
 	hidestatuses text NOT NULL,
 	defaultsortkey varchar(50) NULL,
 	defaultsortas varchar(10) NULL,
+	columnoptions text NULL,
+	authid varchar(255) NULL,
 	PRIMARY KEY (userid)
 );";
 
@@ -310,6 +346,7 @@ CREATE TABLE " . TABLE_PREFIX . "version
 	productid int unsigned NOT NULL,
 	version varchar(255) NOT NULL,
 	displayorder int unsigned NOT NULL,
+	obsolete bool NULL,
 	PRIMARY KEY (versionid)
 );";
 
-- 
2.22.5