· 8 years ago · Nov 25, 2017, 05:00 PM
1-- MySQL dump 10.13 Distrib 5.7.20, for osx10.12 (x86_64)
2--
3-- Host: localhost Database: signsfive_dev
4-- ------------------------------------------------------
5-- Server version 5.7.20
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `SequelizeMeta`
20--
21
22DROP TABLE IF EXISTS `SequelizeMeta`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `SequelizeMeta` (
26 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
27 PRIMARY KEY (`name`),
28 UNIQUE KEY `name` (`name`),
29 UNIQUE KEY `SequelizeMeta_name_unique` (`name`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Table structure for table `authors`
35--
36
37DROP TABLE IF EXISTS `authors`;
38/*!40101 SET @saved_cs_client = @@character_set_client */;
39/*!40101 SET character_set_client = utf8 */;
40CREATE TABLE `authors` (
41 `id` int(11) NOT NULL AUTO_INCREMENT,
42 `email` varchar(255) DEFAULT NULL,
43 `username` varchar(255) DEFAULT NULL,
44 `auth0_id` varchar(255) DEFAULT NULL,
45 `createdAt` datetime NOT NULL,
46 `updatedAt` datetime NOT NULL,
47 `regionId` int(11) DEFAULT NULL,
48 PRIMARY KEY (`id`),
49 KEY `authors_regionId_foreign_idx` (`regionId`),
50 CONSTRAINT `authors_regionId_foreign_idx` FOREIGN KEY (`regionId`) REFERENCES `regions` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
51) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52/*!40101 SET character_set_client = @saved_cs_client */;
53
54--
55-- Table structure for table `categories`
56--
57
58DROP TABLE IF EXISTS `categories`;
59/*!40101 SET @saved_cs_client = @@character_set_client */;
60/*!40101 SET character_set_client = utf8 */;
61CREATE TABLE `categories` (
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `name` varchar(255) DEFAULT NULL,
64 `description` text,
65 `createdAt` datetime NOT NULL,
66 `updatedAt` datetime NOT NULL,
67 PRIMARY KEY (`id`)
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Table structure for table `category_sign`
73--
74
75DROP TABLE IF EXISTS `category_sign`;
76/*!40101 SET @saved_cs_client = @@character_set_client */;
77/*!40101 SET character_set_client = utf8 */;
78CREATE TABLE `category_sign` (
79 `categoryId` int(11) NOT NULL,
80 `signId` int(11) NOT NULL,
81 `createdAt` datetime NOT NULL,
82 `updatedAt` datetime NOT NULL,
83 PRIMARY KEY (`categoryId`,`signId`),
84 UNIQUE KEY `category_sign_category_id_sign_id` (`categoryId`,`signId`),
85 KEY `signId` (`signId`),
86 CONSTRAINT `category_sign_ibfk_1` FOREIGN KEY (`categoryId`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
87 CONSTRAINT `category_sign_ibfk_2` FOREIGN KEY (`signId`) REFERENCES `signs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
88) ENGINE=InnoDB DEFAULT CHARSET=utf8;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Table structure for table `category_source`
93--
94
95DROP TABLE IF EXISTS `category_source`;
96/*!40101 SET @saved_cs_client = @@character_set_client */;
97/*!40101 SET character_set_client = utf8 */;
98CREATE TABLE `category_source` (
99 `categoryId` int(11) NOT NULL,
100 `sourceId` int(11) NOT NULL,
101 `createdAt` datetime NOT NULL,
102 `updatedAt` datetime NOT NULL,
103 PRIMARY KEY (`categoryId`,`sourceId`),
104 UNIQUE KEY `category_source_category_id_source_id` (`categoryId`,`sourceId`),
105 KEY `sourceId` (`sourceId`),
106 CONSTRAINT `category_source_ibfk_1` FOREIGN KEY (`categoryId`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
107 CONSTRAINT `category_source_ibfk_2` FOREIGN KEY (`sourceId`) REFERENCES `sources` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
108) ENGINE=InnoDB DEFAULT CHARSET=utf8;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Table structure for table `gloss_gloss`
113--
114
115DROP TABLE IF EXISTS `gloss_gloss`;
116/*!40101 SET @saved_cs_client = @@character_set_client */;
117/*!40101 SET character_set_client = utf8 */;
118CREATE TABLE `gloss_gloss` (
119 `glossId` int(11) NOT NULL,
120 `alt_glossId` int(11) NOT NULL,
121 `createdAt` datetime NOT NULL,
122 `updatedAt` datetime NOT NULL,
123 PRIMARY KEY (`glossId`,`alt_glossId`),
124 UNIQUE KEY `gloss_gloss_gloss_id_alt_gloss_id` (`glossId`,`alt_glossId`),
125 KEY `alt_glossId` (`alt_glossId`),
126 CONSTRAINT `gloss_gloss_ibfk_1` FOREIGN KEY (`glossId`) REFERENCES `glosses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
127 CONSTRAINT `gloss_gloss_ibfk_2` FOREIGN KEY (`alt_glossId`) REFERENCES `glosses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
128) ENGINE=InnoDB DEFAULT CHARSET=utf8;
129/*!40101 SET character_set_client = @saved_cs_client */;
130
131--
132-- Table structure for table `gloss_sign`
133--
134
135DROP TABLE IF EXISTS `gloss_sign`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `gloss_sign` (
139 `glossId` int(11) NOT NULL,
140 `signId` int(11) NOT NULL,
141 `createdAt` datetime NOT NULL,
142 `updatedAt` datetime NOT NULL,
143 PRIMARY KEY (`glossId`,`signId`),
144 UNIQUE KEY `gloss_sign_gloss_id_sign_id` (`glossId`,`signId`),
145 KEY `signId` (`signId`),
146 CONSTRAINT `gloss_sign_ibfk_1` FOREIGN KEY (`glossId`) REFERENCES `glosses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
147 CONSTRAINT `gloss_sign_ibfk_2` FOREIGN KEY (`signId`) REFERENCES `signs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
148) ENGINE=InnoDB DEFAULT CHARSET=utf8;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Table structure for table `gloss_source`
153--
154
155DROP TABLE IF EXISTS `gloss_source`;
156/*!40101 SET @saved_cs_client = @@character_set_client */;
157/*!40101 SET character_set_client = utf8 */;
158CREATE TABLE `gloss_source` (
159 `glossId` int(11) NOT NULL,
160 `sourceId` int(11) NOT NULL,
161 `createdAt` datetime NOT NULL,
162 `updatedAt` datetime NOT NULL,
163 PRIMARY KEY (`glossId`,`sourceId`),
164 UNIQUE KEY `gloss_source_gloss_id_source_id` (`glossId`,`sourceId`),
165 KEY `sourceId` (`sourceId`),
166 CONSTRAINT `gloss_source_ibfk_1` FOREIGN KEY (`glossId`) REFERENCES `glosses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
167 CONSTRAINT `gloss_source_ibfk_2` FOREIGN KEY (`sourceId`) REFERENCES `sources` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
168) ENGINE=InnoDB DEFAULT CHARSET=utf8;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Table structure for table `glosses`
173--
174
175DROP TABLE IF EXISTS `glosses`;
176/*!40101 SET @saved_cs_client = @@character_set_client */;
177/*!40101 SET character_set_client = utf8 */;
178CREATE TABLE `glosses` (
179 `id` int(11) NOT NULL AUTO_INCREMENT,
180 `name` varchar(255) DEFAULT NULL,
181 `description` text,
182 `createdAt` datetime NOT NULL,
183 `updatedAt` datetime NOT NULL,
184 PRIMARY KEY (`id`)
185) ENGINE=InnoDB DEFAULT CHARSET=utf8;
186/*!40101 SET character_set_client = @saved_cs_client */;
187
188--
189-- Table structure for table `region_sign`
190--
191
192DROP TABLE IF EXISTS `region_sign`;
193/*!40101 SET @saved_cs_client = @@character_set_client */;
194/*!40101 SET character_set_client = utf8 */;
195CREATE TABLE `region_sign` (
196 `regionId` int(11) NOT NULL,
197 `signId` int(11) NOT NULL,
198 `createdAt` datetime NOT NULL,
199 `updatedAt` datetime NOT NULL,
200 PRIMARY KEY (`regionId`,`signId`),
201 UNIQUE KEY `region_sign_region_id_sign_id` (`regionId`,`signId`),
202 KEY `signId` (`signId`),
203 CONSTRAINT `region_sign_ibfk_1` FOREIGN KEY (`regionId`) REFERENCES `regions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
204 CONSTRAINT `region_sign_ibfk_2` FOREIGN KEY (`signId`) REFERENCES `signs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
205) ENGINE=InnoDB DEFAULT CHARSET=utf8;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Table structure for table `regions`
210--
211
212DROP TABLE IF EXISTS `regions`;
213/*!40101 SET @saved_cs_client = @@character_set_client */;
214/*!40101 SET character_set_client = utf8 */;
215CREATE TABLE `regions` (
216 `id` int(11) NOT NULL AUTO_INCREMENT,
217 `name` varchar(255) DEFAULT NULL,
218 `loc` point DEFAULT NULL,
219 `createdAt` datetime NOT NULL,
220 `updatedAt` datetime NOT NULL,
221 PRIMARY KEY (`id`)
222) ENGINE=InnoDB DEFAULT CHARSET=utf8;
223/*!40101 SET character_set_client = @saved_cs_client */;
224
225--
226-- Table structure for table `signs`
227--
228
229DROP TABLE IF EXISTS `signs`;
230/*!40101 SET @saved_cs_client = @@character_set_client */;
231/*!40101 SET character_set_client = utf8 */;
232CREATE TABLE `signs` (
233 `id` int(11) NOT NULL AUTO_INCREMENT,
234 `giphy_id` varchar(255) NOT NULL,
235 `createdAt` datetime NOT NULL,
236 `updatedAt` datetime NOT NULL,
237 `authorId` int(11) DEFAULT NULL,
238 PRIMARY KEY (`id`),
239 KEY `signs_authorId_foreign_idx` (`authorId`),
240 CONSTRAINT `signs_authorId_foreign_idx` FOREIGN KEY (`authorId`) REFERENCES `authors` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
241) ENGINE=InnoDB DEFAULT CHARSET=utf8;
242/*!40101 SET character_set_client = @saved_cs_client */;
243
244--
245-- Table structure for table `sources`
246--
247
248DROP TABLE IF EXISTS `sources`;
249/*!40101 SET @saved_cs_client = @@character_set_client */;
250/*!40101 SET character_set_client = utf8 */;
251CREATE TABLE `sources` (
252 `id` int(11) NOT NULL AUTO_INCREMENT,
253 `url` varchar(255) DEFAULT NULL,
254 `createdAt` datetime NOT NULL,
255 `updatedAt` datetime NOT NULL,
256 PRIMARY KEY (`id`)
257) ENGINE=InnoDB DEFAULT CHARSET=utf8;
258/*!40101 SET character_set_client = @saved_cs_client */;
259/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
260
261/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
262/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
263/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
264/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
265/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
266/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
267/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
268
269-- Dump completed on 2017-11-23 14:22:50