diff options
| author |  mensonge | 2008-12-09 17:12:23 +0000 |
|---|---|---|
| committer | mensonge | 2008-12-09 17:12:23 +0000 |
| commit | 37c58e490f141b5fcc77531aeee163a6650d6bd8 (patch) | |
| tree | 4f584a7151487085ca254b6de04349c7d556f966 | |
| parent | c5fd6018702a3450469f1f3e815105123b75af7d (diff) | |
| download | scuttle-37c58e490f141b5fcc77531aeee163a6650d6bd8.tar.gz scuttle-37c58e490f141b5fcc77531aeee163a6650d6bd8.zip | |
Interface fix: make longer descriptions fields
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@201 b3834d28-1941-0410-a4f8-b48e95affb8f
| -rw-r--r-- | tables.sql | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -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`), |