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/1.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/1.sql')
| -rw-r--r-- | data/schema/1.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/data/schema/1.sql b/data/schema/1.sql new file mode 100644 index 0000000..e09a210 --- /dev/null +++ b/data/schema/1.sql @@ -0,0 +1,20 @@ +RENAME TABLE `sc_tags` TO `sc_bookmarks2tags` ; + + CREATE TABLE `sc_searchhistory` ( + `shId` int(11) NOT NULL auto_increment, + `shTerms` varchar(255) NOT NULL default '', + `shRange` varchar(32) NOT NULL default '', + `shDatetime` datetime NOT NULL default '0000-00-00 00:00:00', + `shNbResults` int(6) NOT NULL default '0', + `uId` int(11) NOT NULL default '0', + PRIMARY KEY (`shId`) + ); + + CREATE TABLE `sc_tags` ( + `tId` int(11) NOT NULL auto_increment, + `tag` varchar(32) NOT NULL default '', + `uId` int(11) NOT NULL default '0', + `tDescription` varchar(255) default NULL, + PRIMARY KEY (`tId`), + UNIQUE KEY `sc_tags_tag_uId` (`tag`, `uId`) + ); |