diff options
| author | mensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2008-09-24 08:27:34 +0000 |
|---|---|---|
| committer | mensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2008-09-24 08:27:34 +0000 |
| commit | c35ab1bf2b7a464401b8cce9b62c03e2221f3b08 (patch) | |
| tree | 3ba0c630ff2768c0ad78a8c260d8cfbae1078347 /tables.sql | |
| parent | 0074b6d54e2d753a5a83965def84571bcdc69214 (diff) | |
| download | semanticscuttle-c35ab1bf2b7a464401b8cce9b62c03e2221f3b08.tar.gz semanticscuttle-c35ab1bf2b7a464401b8cce9b62c03e2221f3b08.tar.bz2 | |
Bug fix: tag max length has been increased into tables
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@149 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'tables.sql')
| -rw-r--r-- | tables.sql | 12 |
1 files changed, 6 insertions, 6 deletions
@@ -30,7 +30,7 @@ CREATE TABLE `sc_bookmarks` ( CREATE TABLE `sc_tags` ( `tId` int(11) NOT NULL auto_increment, - `tag` varchar(32) NOT NULL default '', + `tag` varchar(100) NOT NULL default '', `uId` int(11) NOT NULL default '0', `tDescription` varchar(255) default NULL, PRIMARY KEY (`tId`), @@ -46,7 +46,7 @@ CREATE TABLE `sc_tags` ( CREATE TABLE `sc_bookmarks2tags` ( `id` int(11) NOT NULL auto_increment, `bId` int(11) NOT NULL default '0', - `tag` varchar(32) NOT NULL default '', + `tag` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `sc_bookmarks2tags_tag_bId` (`tag`,`bId`), KEY `sc_bookmarks2tags_bId` (`bId`) @@ -93,8 +93,8 @@ CREATE TABLE `sc_watched` ( CREATE TABLE `sc_tags2tags` ( `ttId` int(11) NOT NULL auto_increment, - `tag1` varchar(32) NOT NULL default '', - `tag2` varchar(32) NOT NULL default '', + `tag1` varchar(100) NOT NULL default '', + `tag2` varchar(100) NOT NULL default '', `relationType` varchar(32) NOT NULL default '', `uId` int(11) NOT NULL default '0', PRIMARY KEY (`ttId`), @@ -109,7 +109,7 @@ CREATE TABLE `sc_tags2tags` ( CREATE TABLE `sc_tagsstats` ( `tstId` int(11) NOT NULL auto_increment, - `tag1` varchar(32) NOT NULL default '', + `tag1` varchar(100) NOT NULL default '', `relationType` varchar(32) NOT NULL default '', `uId` int(11) NOT NULL default '0', `nb` int(11) NOT NULL default '0', @@ -128,7 +128,7 @@ CREATE TABLE `sc_tagsstats` ( CREATE TABLE `sc_commondescription` ( `cdId` int(11) NOT NULL auto_increment, `uId` int(11) NOT NULL default '0', - `tag` varchar(32) NOT NULL default '', + `tag` varchar(100) NOT NULL default '', `bHash` varchar(32) NOT NULL default '', `cdTitle` varchar(255) NOT NULL default '', `cdDescription` varchar(2000) default NULL, |