summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-05-13 17:27:47 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-05-13 17:27:47 +0000
commit4ec8b47558aef0984eb65aec818b2839ced40fdf (patch)
treee716e090e7365009877176b7463677062b88f01d
parent01ddabc89381433d841490298a9c1938a66f43a5 (diff)
downloadsemanticscuttle-4ec8b47558aef0984eb65aec818b2839ced40fdf.tar.gz
semanticscuttle-4ec8b47558aef0984eb65aec818b2839ced40fdf.tar.bz2
Improve upgrade
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@125 b3834d28-1941-0410-a4f8-b48e95affb8f
-rw-r--r--tables.sql2
-rw-r--r--upgrade.txt9
2 files changed, 10 insertions, 1 deletions
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;