JAF27j2u

1-- --------------------------------------------------------
2
3--
4-- Table structure for table `tag`
5--
6
7CREATE TABLE IF NOT EXISTS `tag` (
8  `tagid` int(10) unsigned NOT NULL COMMENT 'TAG ID',
9  `tag` varchar(100) NOT NULL COMMENT 'Tag',
10  PRIMARY KEY  (`tagid`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
13-- --------------------------------------------------------
14
15--
16-- Table structure for table `url`
17--
18
19CREATE TABLE IF NOT EXISTS `url` (
20  `url_id` int(10) unsigned NOT NULL COMMENT 'URL ID',
21  `url` varchar(255) NOT NULL COMMENT 'Link (duh)',
22  `tinyurl` varchar(50) NOT NULL COMMENT 'TinyURL for this link (if there was one generated)',
23  `nick` varchar(32) NOT NULL COMMENT 'Who mentioned it?',
24  `reffed` varchar(32) defaault NULL COMMENT 'Who was reffed?',
25  `channel` varchar(32) NOT NULL COMMENT 'Where was it mentioned?',
26  `date` int(10) unsigned NOT NULL COMMENT 'When was it mentioned',
27  PRIMARY KEY  (`url_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29
30-- --------------------------------------------------------
31
32--
33-- Table structure for table `urltag`
34--
35
36CREATE TABLE IF NOT EXISTS `urltag` (
37  `url_id` int(10) unsigned NOT NULL,
38  `tag_id` int(10) unsigned NOT NULL,
39  PRIMARY KEY  (`url_id`,`tag_id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41
42ALTER TABLE `urltag`
43  ADD CONSTRAINT `urltag_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tagid`) ON DELETE CASCADE,
44  ADD CONSTRAINT `urltag_ibfk_1` FOREIGN KEY (`url_id`) REFERENCES `url` (`url_id`) ON DELETE CASCADE;