diff options
Diffstat (limited to 'tables.sql')
-rw-r--r-- | tables.sql | 18 |
1 files changed, 17 insertions, 1 deletions
@@ -65,4 +65,20 @@ CREATE TABLE `sc_watched` ( `watched` int(11) NOT NULL default '0', PRIMARY KEY (`wId`), KEY `sc_watched_uId` (`uId`) -);
\ No newline at end of file +); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `sc_tags_tags` +-- + +CREATE TABLE `sc_tags2tags` ( + `ttId` int(11) NOT NULL auto_increment, + `tag1` varchar(32) NOT NULL default '', + `tag2` varchar(32) NOT NULL default '', + `relationType` varchar(32) NOT NULL default '', + `uId` int(11) NOT NULL default '0', + PRIMARY KEY (`ttId`), + UNIQUE KEY `sc_tags2tags_tag1_tag2_uId` (`tag1`,`tag2`,`relationType`,`uId`) +); |