diff options
| author | Christian Weiske <cweiske@cweiske.de> | 2011-05-27 06:59:33 +0200 |
|---|---|---|
| committer | Christian Weiske <cweiske@cweiske.de> | 2011-05-27 06:59:33 +0200 |
| commit | 2419885577b4e38b82f5b0f4fbfe8077f680d825 (patch) | |
| tree | 3d4d6c68e18cbaf5ca850b2ec53cbeaa9663821b /data/schema/2.sql | |
| parent | 511124934764a6a420da89038aa2c3f02234692d (diff) | |
| download | semanticscuttle-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.sql | 10 |
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`) +); |