aboutsummaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-12-09 17:12:23 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-12-09 17:12:23 +0000
commit37c58e490f141b5fcc77531aeee163a6650d6bd8 (patch)
tree4f584a7151487085ca254b6de04349c7d556f966 /tables.sql
parentc5fd6018702a3450469f1f3e815105123b75af7d (diff)
downloadsemanticscuttle-37c58e490f141b5fcc77531aeee163a6650d6bd8.tar.gz
semanticscuttle-37c58e490f141b5fcc77531aeee163a6650d6bd8.tar.bz2
Interface fix: make longer descriptions fields
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@201 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'tables.sql')
-rw-r--r--tables.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/tables.sql b/tables.sql
index 10a48e2..cf12636 100644
--- a/tables.sql
+++ b/tables.sql
@@ -14,7 +14,7 @@ CREATE TABLE `sc_bookmarks` (
`bModified` datetime NOT NULL default '0000-00-00 00:00:00',
`bTitle` varchar(255) NOT NULL default '',
`bAddress` text NOT NULL,
- `bDescription` varchar(255) default NULL,
+ `bDescription` varchar(1500) default NULL,
`bHash` varchar(32) NOT NULL default '',
PRIMARY KEY (`bId`),
KEY `sc_bookmarks_usd` (`uId`,`bStatus`,`bDatetime`),
@@ -32,7 +32,7 @@ CREATE TABLE `sc_tags` (
`tId` int(11) NOT NULL auto_increment,
`tag` varchar(100) NOT NULL default '',
`uId` int(11) NOT NULL default '0',
- `tDescription` varchar(255) default NULL,
+ `tDescription` varchar(1500) default NULL,
PRIMARY KEY (`tId`),
UNIQUE KEY `sc_tags_tag_uId` (`tag`, `uId`)
);
@@ -131,7 +131,7 @@ CREATE TABLE `sc_commondescription` (
`tag` varchar(100) NOT NULL default '',
`bHash` varchar(32) NOT NULL default '',
`cdTitle` varchar(255) NOT NULL default '',
- `cdDescription` varchar(2000) default NULL,
+ `cdDescription` varchar(1500) default NULL,
`cdDatetime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`cdId`),
UNIQUE KEY `sc_commondescription_tag_datetime` (`tag`,`cdDatetime`),