aboutsummaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-09-24 08:27:34 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-09-24 08:27:34 +0000
commitc35ab1bf2b7a464401b8cce9b62c03e2221f3b08 (patch)
tree3ba0c630ff2768c0ad78a8c260d8cfbae1078347 /tables.sql
parent0074b6d54e2d753a5a83965def84571bcdc69214 (diff)
downloadsemanticscuttle-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.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/tables.sql b/tables.sql
index 6f70eb6..10a48e2 100644
--- a/tables.sql
+++ b/tables.sql
@@ -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,