diff options
Diffstat (limited to 'data/tables.sql')
| -rw-r--r-- | data/tables.sql | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/data/tables.sql b/data/tables.sql index 68d5ba9..86779c2 100644 --- a/data/tables.sql +++ b/data/tables.sql @@ -5,6 +5,9 @@ -- Table structure for table `sc_bookmarks` -- +# to avoid STRICT_TRANS_TABLES mode +SET sql_mode = ''; + CREATE TABLE `sc_bookmarks` ( `bId` int(11) NOT NULL auto_increment, `uId` int(11) NOT NULL default '0', @@ -17,8 +20,8 @@ CREATE TABLE `sc_bookmarks` ( `bDescription` text default NULL, `bPrivateNote` text default NULL, `bHash` varchar(32) NOT NULL default '', - `bVotes` int(11) NOT NULL, - `bVoting` int(11) NOT NULL, + `bVotes` int(11) NOT NULL default '0', + `bVoting` int(11) NOT NULL default '0', `bShort` varchar(16) default NULL, PRIMARY KEY (`bId`), KEY `sc_bookmarks_usd` (`uId`,`bStatus`,`bDatetime`), @@ -56,6 +59,8 @@ CREATE TABLE `sc_bookmarks2tags` ( KEY `sc_bookmarks2tags_bId` (`bId`) ) CHARACTER SET utf8 COLLATE utf8_general_ci ; +CREATE INDEX sc_bookmarks2tags_index ON sc_bookmarks2tags(tag); + -- -------------------------------------------------------- -- |