From 4ec8b47558aef0984eb65aec818b2839ced40fdf Mon Sep 17 00:00:00 2001 From: mensonge Date: Tue, 13 May 2008 17:27:47 +0000 Subject: Improve upgrade git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@125 b3834d28-1941-0410-a4f8-b48e95affb8f --- tables.sql | 2 +- upgrade.txt | 9 +++++++++ 2 files changed, 10 insertions(+), 1 deletion(-) diff --git a/tables.sql b/tables.sql index 8280ac3..6f70eb6 100644 --- a/tables.sql +++ b/tables.sql @@ -33,7 +33,7 @@ CREATE TABLE `sc_tags` ( `tag` varchar(32) NOT NULL default '', `uId` int(11) NOT NULL default '0', `tDescription` varchar(255) default NULL, - PRIMARY KEY (`id`), + PRIMARY KEY (`tId`), UNIQUE KEY `sc_tags_tag_uId` (`tag`, `uId`) ); diff --git a/upgrade.txt b/upgrade.txt index 11464eb..ba4f710 100644 --- a/upgrade.txt +++ b/upgrade.txt @@ -23,6 +23,15 @@ PRIMARY KEY (`shId`) ); + CREATE TABLE `sc_tags` ( + `tId` int(11) NOT NULL auto_increment, + `tag` varchar(32) NOT NULL default '', + `uId` int(11) NOT NULL default '0', + `tDescription` varchar(255) default NULL, + PRIMARY KEY (`tId`), + UNIQUE KEY `sc_tags_tag_uId` (`tag`, `uId`) + ); + - Upgrade your current configuration file (config.inc.php) with respect to config.inc.php.example - add line: $sizeSearchHistory = 10; -- cgit v1.2.3