summaryrefslogtreecommitdiff
path: root/data/schema/2.sql
diff options
context:
space:
mode:
authorChristian Weiske <cweiske@cweiske.de>2011-05-27 06:59:33 +0200
committerChristian Weiske <cweiske@cweiske.de>2011-05-27 06:59:33 +0200
commit2419885577b4e38b82f5b0f4fbfe8077f680d825 (patch)
tree3d4d6c68e18cbaf5ca850b2ec53cbeaa9663821b /data/schema/2.sql
parent511124934764a6a420da89038aa2c3f02234692d (diff)
downloadsemanticscuttle-2419885577b4e38b82f5b0f4fbfe8077f680d825.tar.gz
semanticscuttle-2419885577b4e38b82f5b0f4fbfe8077f680d825.tar.bz2
make upgrade file fully rST-compatible and move SQL commands out into single schema files
Diffstat (limited to 'data/schema/2.sql')
-rw-r--r--data/schema/2.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/data/schema/2.sql b/data/schema/2.sql
new file mode 100644
index 0000000..6c3bfaf
--- /dev/null
+++ b/data/schema/2.sql
@@ -0,0 +1,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`)
+);