aboutsummaryrefslogtreecommitdiff
path: root/data/schema/2.sql
blob: 171e0115ccac0f15b14f64da6fa446d5c108fb61 (plain)
1
2
3
4
5
6
7
8
9
10
ALTER TABLE `sc_bookmarks` CHANGE `bDescription` `bDescription` VARCHAR( 1500 );
CREATE TABLE `sc_tagscache` (
   `tcId` int(11) NOT NULL auto_increment,
   `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 (`tcId`),
   UNIQUE KEY `sc_tagscache_tag1_tag2_type_uId` (`tag1`,`tag2`,`relationType`,`uId`)
);