diff options
| -rw-r--r-- | tables.sql | 2 | ||||
| -rw-r--r-- | upgrade.txt | 9 |
2 files changed, 10 insertions, 1 deletions
@@ -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; |