ixwgEbuS

1--
2-- Table structure for table `gallery`
3--
4
5CREATE TABLE IF NOT EXISTS `gallery` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `category_id` int(11) DEFAULT NULL,
8  `user_id` int(11) DEFAULT NULL,
9  `title` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
10  `description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
11  `folder` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
12  `status` enum('published','pending','archived') COLLATE utf8_unicode_ci DEFAULT NULL,
13  `date_added` datetime DEFAULT NULL,
14  `date` datetime DEFAULT NULL,
15  `position` int(11) DEFAULT NULL,
16  PRIMARY KEY (`id`),
17  KEY `category_id_idx` (`category_id`),
18  KEY `user_id_idx` (`user_id`)
19) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=143 ;
20
21-- --------------------------------------------------------
22
23--
24-- Table structure for table `gallery_pic`
25--
26
27CREATE TABLE IF NOT EXISTS `gallery_pic` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `gallery_id` int(11) DEFAULT NULL,
30  `category_id` int(11) DEFAULT NULL,
31  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
32  `all_tags` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
33  `status` enum('published','pending','archived') COLLATE utf8_unicode_ci DEFAULT NULL,
34  PRIMARY KEY (`id`),
35  KEY `category_id_idx` (`category_id`),
36  KEY `gallery_id_idx` (`gallery_id`)
37) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12059 ;
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `gallery_tags_xref`
43--
44
45CREATE TABLE IF NOT EXISTS `gallery_tags_xref` (
46  `id` bigint(20) NOT NULL AUTO_INCREMENT,
47  `gallery_id` int(11) DEFAULT NULL,
48  `tag_id` int(11) DEFAULT NULL,
49  PRIMARY KEY (`id`),
50  KEY `gallery_id_idx` (`gallery_id`),
51  KEY `tag_id_idx` (`tag_id`)
52) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=527 ;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `pic_tags_xref`
58--
59
60CREATE TABLE IF NOT EXISTS `pic_tags_xref` (
61  `id` bigint(20) NOT NULL AUTO_INCREMENT,
62  `picture_id` int(11) DEFAULT NULL,
63  `tag_id` int(11) DEFAULT NULL,
64  PRIMARY KEY (`id`),
65  KEY `picture_id_idx` (`picture_id`),
66  KEY `tag_id_idx` (`tag_id`)
67) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=21725 ;
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `tag`
73--
74
75CREATE TABLE IF NOT EXISTS `tag` (
76  `id` int(11) NOT NULL AUTO_INCREMENT,
77  `type_id` int(11) DEFAULT NULL,
78  `name` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
79  PRIMARY KEY (`id`),
80  KEY `type_id_idx` (`type_id`)
81) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=920 ;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `tag_type`
87--
88
89CREATE TABLE IF NOT EXISTS `tag_type` (
90  `id` int(11) NOT NULL AUTO_INCREMENT,
91  `name` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
92  `position` int(11) DEFAULT NULL,
93  PRIMARY KEY (`id`)
94) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;
95
96-- --------------------------------------------------------
97
98--
99-- Table structure for table `user`
100--
101--
102-- Constraints for dumped tables
103--
104
105--
106-- Constraints for table `gallery`
107--
108ALTER TABLE `gallery`
109  ADD CONSTRAINT `gallery_category_id_category_id` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
110  ADD CONSTRAINT `gallery_user_id_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
111
112--
113-- Constraints for table `gallery_pic`
114--
115ALTER TABLE `gallery_pic`
116  ADD CONSTRAINT `gallery_pic_category_id_category_id` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
117  ADD CONSTRAINT `gallery_pic_gallery_id_gallery_id` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`);
118
119--
120-- Constraints for table `gallery_tags_xref`
121--
122ALTER TABLE `gallery_tags_xref`
123  ADD CONSTRAINT `gallery_tags_xref_gallery_id_gallery_id` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`) ON DELETE CASCADE,
124  ADD CONSTRAINT `gallery_tags_xref_tag_id_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE;
125
126--
127-- Constraints for table `pic_tags_xref`
128--
129ALTER TABLE `pic_tags_xref`
130  ADD CONSTRAINT `pic_tags_xref_picture_id_gallery_pic_id` FOREIGN KEY (`picture_id`) REFERENCES `gallery_pic` (`id`) ON DELETE CASCADE,
131  ADD CONSTRAINT `pic_tags_xref_tag_id_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE;
132
133--
134-- Constraints for table `tag`
135--
136ALTER TABLE `tag`
137  ADD CONSTRAINT `tag_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `tag_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;