mt-site
RSS
Clean up SQL table definitions.
darkmorford -
71b3ae5f1390
Not Reviewed
Show More
Add another comment
Collapse all files
TODOs: 0 unresolved 0 Resolved
COMMENTS: 0 General 0 Inline
Show file before | Show file after | Show commentsHide comments
@@ -68,7 +68,7 CREATE TABLE `admin_section` (
68 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
68 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
69 `name` tinytext,
69 `name` tinytext,
70 PRIMARY KEY (`id`)
70 PRIMARY KEY (`id`)
71 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
71 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
72 /*!40101 SET character_set_client = @saved_cs_client */;
72 /*!40101 SET character_set_client = @saved_cs_client */;
73
73
74 --
74 --
@@ -107,7 +107,7 CREATE TABLE `contributor` (
107 `default_link` tinytext,
107 `default_link` tinytext,
108 PRIMARY KEY (`id`),
108 PRIMARY KEY (`id`),
109 UNIQUE KEY `name` (`name`)
109 UNIQUE KEY `name` (`name`)
110 ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
110 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
111 /*!40101 SET character_set_client = @saved_cs_client */;
111 /*!40101 SET character_set_client = @saved_cs_client */;
112
112
113 --
113 --
@@ -138,7 +138,7 CREATE TABLE `media_t` (
138 `description` tinytext,
138 `description` tinytext,
139 PRIMARY KEY (`id`),
139 PRIMARY KEY (`id`),
140 UNIQUE KEY `extension` (`extension`)
140 UNIQUE KEY `extension` (`extension`)
141 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
141 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142 /*!40101 SET character_set_client = @saved_cs_client */;
142 /*!40101 SET character_set_client = @saved_cs_client */;
143
143
144 --
144 --
@@ -169,7 +169,7 CREATE TABLE `meta_t` (
169 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
169 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
170 `name` tinytext,
170 `name` tinytext,
171 PRIMARY KEY (`id`)
171 PRIMARY KEY (`id`)
172 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
172 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
173 /*!40101 SET character_set_client = @saved_cs_client */;
173 /*!40101 SET character_set_client = @saved_cs_client */;
174
174
175 --
175 --
@@ -197,7 +197,7 CREATE TABLE `rant` (
197 KEY `halp` (`author`,`imagetype`,`published`),
197 KEY `halp` (`author`,`imagetype`,`published`),
198 CONSTRAINT `rant_ibfk_1` FOREIGN KEY (`author`) REFERENCES `contributor` (`id`) ON UPDATE CASCADE,
198 CONSTRAINT `rant_ibfk_1` FOREIGN KEY (`author`) REFERENCES `contributor` (`id`) ON UPDATE CASCADE,
199 CONSTRAINT `rant_ibfk_2` FOREIGN KEY (`imagetype`) REFERENCES `media_t` (`id`) ON UPDATE CASCADE
199 CONSTRAINT `rant_ibfk_2` FOREIGN KEY (`imagetype`) REFERENCES `media_t` (`id`) ON UPDATE CASCADE
200 ) ENGINE=InnoDB AUTO_INCREMENT=1099 DEFAULT CHARSET=utf8;
200 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
201 /*!40101 SET character_set_client = @saved_cs_client */;
201 /*!40101 SET character_set_client = @saved_cs_client */;
202
202
203 --
203 --
@@ -216,7 +216,7 CREATE TABLE `rant_attachment` (
216 KEY `media` (`media`),
216 KEY `media` (`media`),
217 CONSTRAINT `rant_attachment_ibfk_1` FOREIGN KEY (`rant`) REFERENCES `rant` (`id`) ON UPDATE CASCADE,
217 CONSTRAINT `rant_attachment_ibfk_1` FOREIGN KEY (`rant`) REFERENCES `rant` (`id`) ON UPDATE CASCADE,
218 CONSTRAINT `rant_attachment_ibfk_2` FOREIGN KEY (`media`) REFERENCES `media_t` (`id`) ON UPDATE CASCADE
218 CONSTRAINT `rant_attachment_ibfk_2` FOREIGN KEY (`media`) REFERENCES `media_t` (`id`) ON UPDATE CASCADE
219 ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
219 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
220 /*!40101 SET character_set_client = @saved_cs_client */;
220 /*!40101 SET character_set_client = @saved_cs_client */;
221
221
222 --
222 --
@@ -260,7 +260,7 CREATE TABLE `sponsor` (
260 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
260 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
261 `name` tinytext NOT NULL,
261 `name` tinytext NOT NULL,
262 PRIMARY KEY (`id`)
262 PRIMARY KEY (`id`)
263 ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
263 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
264 /*!40101 SET character_set_client = @saved_cs_client */;
264 /*!40101 SET character_set_client = @saved_cs_client */;
265
265
266 --
266 --
@@ -336,7 +336,7 CREATE TABLE `strip_t` (
336 UNIQUE KEY `name` (`name`),
336 UNIQUE KEY `name` (`name`),
337 KEY `meta` (`meta`),
337 KEY `meta` (`meta`),
338 CONSTRAINT `strip_t_ibfk_1` FOREIGN KEY (`meta`) REFERENCES `meta_t` (`id`) ON UPDATE CASCADE
338 CONSTRAINT `strip_t_ibfk_1` FOREIGN KEY (`meta`) REFERENCES `meta_t` (`id`) ON UPDATE CASCADE
339 ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
339 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
340 /*!40101 SET character_set_client = @saved_cs_client */;
340 /*!40101 SET character_set_client = @saved_cs_client */;
341
341
342 --
342 --
@@ -359,7 +359,7 CREATE TABLE `support` (
359 KEY `banner` (`banner`),
359 KEY `banner` (`banner`),
360 CONSTRAINT `support_ibfk_1` FOREIGN KEY (`sponsor`) REFERENCES `sponsor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
360 CONSTRAINT `support_ibfk_1` FOREIGN KEY (`sponsor`) REFERENCES `sponsor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
361 CONSTRAINT `support_ibfk_2` FOREIGN KEY (`banner`) REFERENCES `banner` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
361 CONSTRAINT `support_ibfk_2` FOREIGN KEY (`banner`) REFERENCES `banner` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
362 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
362 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
363 /*!40101 SET character_set_client = @saved_cs_client */;
363 /*!40101 SET character_set_client = @saved_cs_client */;
364
364
365 --
365 --
@@ -413,7 +413,7 CREATE TABLE `twitter_status` (
413 `position` int(10) unsigned NOT NULL,
413 `position` int(10) unsigned NOT NULL,
414 `message` varchar(140) DEFAULT NULL,
414 `message` varchar(140) DEFAULT NULL,
415 PRIMARY KEY (`id`)
415 PRIMARY KEY (`id`)
416 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
416 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
417 /*!40101 SET character_set_client = @saved_cs_client */;
417 /*!40101 SET character_set_client = @saved_cs_client */;
418
418
419 --
419 --
@@ -432,7 +432,7 CREATE TABLE `twitter_user` (
432 `oauth_access_token` tinytext,
432 `oauth_access_token` tinytext,
433 PRIMARY KEY (`id`),
433 PRIMARY KEY (`id`),
434 UNIQUE KEY `username` (`username`(100))
434 UNIQUE KEY `username` (`username`(100))
435 ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
435 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
436 /*!40101 SET character_set_client = @saved_cs_client */;
436 /*!40101 SET character_set_client = @saved_cs_client */;
437 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
437 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
438
438
Comments 0
You need to be logged in to leave comments. Login now