fVaDBfYj

1-- Database: `sa_index`
2--
3CREATE DATABASE `sa_index` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
4USE `sa_index`;
5
6-- --------------------------------------------------------
7
8--
9-- Structure for table `arc`
10--
11
12CREATE TABLE IF NOT EXISTS `arc` (
13  `id` bigint(20) NOT NULL AUTO_INCREMENT,
14  `title` varchar(200) NOT NULL,
15  `description` text NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
18
19-- --------------------------------------------------------
20
21--
22-- Structure for table `arctocomic`
23--
24
25CREATE TABLE IF NOT EXISTS `arctocomic` (
26  `arcid` bigint(20) NOT NULL,
27  `comicid` bigint(20) NOT NULL,
28  PRIMARY KEY (`arcid`,`comicid`),
29  KEY `comicid` (`comicid`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
32-- --------------------------------------------------------
33
34--
35-- Structure for table `character`
36--
37
38CREATE TABLE IF NOT EXISTS `character` (
39  `id` bigint(20) NOT NULL AUTO_INCREMENT,
40  `name` varchar(200) NOT NULL,
41  `nickname` varchar(255) NOT NULL,
42  `description` text NOT NULL,
43  PRIMARY KEY (`id`),
44  UNIQUE KEY `name` (`name`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
46
47-- --------------------------------------------------------
48
49--
50-- Structure for table `charactertocomic`
51--
52
53CREATE TABLE IF NOT EXISTS `charactertocomic` (
54  `comicid` bigint(20) NOT NULL,
55  `characterid` bigint(20) NOT NULL,
56  PRIMARY KEY (`comicid`,`characterid`),
57  KEY `characterid` (`characterid`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60-- --------------------------------------------------------
61
62--
63-- Structure for table `comic`
64--
65
66CREATE TABLE IF NOT EXISTS `comic` (
67  `id` bigint(20) NOT NULL AUTO_INCREMENT,
68  `comicnumber` int(11) NOT NULL,
69  `title` varchar(255) NOT NULL,
70  `summary` text NOT NULL,
71  `url` varchar(255) NOT NULL,
72  PRIMARY KEY (`id`),
73  UNIQUE KEY `comicnumber` (`comicnumber`)
74) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
75
76-- --------------------------------------------------------
77
78--
79-- Structure for table `tag`
80--
81
82CREATE TABLE IF NOT EXISTS `tag` (
83  `id` bigint(20) NOT NULL AUTO_INCREMENT,
84  `name` varchar(100) NOT NULL,
85  PRIMARY KEY (`id`),
86  UNIQUE KEY `name` (`name`)
87) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
88
89-- --------------------------------------------------------
90
91--
92-- Structure for table `tagtocomic`
93--
94
95CREATE TABLE IF NOT EXISTS `tagtocomic` (
96  `comicid` bigint(20) NOT NULL,
97  `tagid` bigint(20) NOT NULL,
98  PRIMARY KEY (`comicid`,`tagid`),
99  KEY `tagid` (`tagid`)
100) ENGINE=InnoDB DEFAULT CHARSET=utf8;
101
102
103--
104-- Constraints for table `arctocomic`
105--
106ALTER TABLE `arctocomic`
107  ADD CONSTRAINT `arctocomic_ibfk_2` FOREIGN KEY (`comicid`) REFERENCES `comic` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
108  ADD CONSTRAINT `arctocomic_ibfk_1` FOREIGN KEY (`arcid`) REFERENCES `arc` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
109
110--
111-- Constraints for table `charactertocomic`
112--
113ALTER TABLE `charactertocomic`
114  ADD CONSTRAINT `charactertocomic_ibfk_2` FOREIGN KEY (`characterid`) REFERENCES `character` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
115  ADD CONSTRAINT `charactertocomic_ibfk_1` FOREIGN KEY (`comicid`) REFERENCES `comic` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
116
117--
118-- Constraints for table `tagtocomic`
119--
120ALTER TABLE `tagtocomic`
121  ADD CONSTRAINT `tagtocomic_ibfk_2` FOREIGN KEY (`tagid`) REFERENCES `tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
122  ADD CONSTRAINT `tagtocomic_ibfk_1` FOREIGN KEY (`comicid`) REFERENCES `comic` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;