diff options
Diffstat (limited to 'tables.sql')
-rw-r--r-- | tables.sql | 20 |
1 files changed, 18 insertions, 2 deletions
@@ -1,5 +1,6 @@ -- Semantice Scuttle - Tables creation SQL script -- ! Dont forget to change table names according to $tableprefix defined in config.inc.php ! + -- -- Table structure for table `sc_bookmarks` -- @@ -28,12 +29,27 @@ CREATE TABLE `sc_bookmarks` ( -- 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 (`id`), + UNIQUE KEY `sc_tags_tag_uId` (`tag`, `uId`) +); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `sc_bookmarks2tags` +-- + +CREATE TABLE `sc_bookmarks2tags` ( `id` int(11) NOT NULL auto_increment, `bId` int(11) NOT NULL default '0', `tag` varchar(32) NOT NULL default '', PRIMARY KEY (`id`), - UNIQUE KEY `sc_tags_tag_bId` (`tag`,`bId`), - KEY `sc_tags_bId` (`bId`) + UNIQUE KEY `sc_bookmarks2tags_tag_bId` (`tag`,`bId`), + KEY `sc_bookmarks2tags_bId` (`bId`) ); -- -------------------------------------------------------- |