SHOW:
|
|
- or go back to the newest paste.
| 1 | CREATE TABLE `ad` ( | |
| 2 | `id` int(11) NOT NULL, | |
| 3 | `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| 4 | `creationDate` datetime NOT NULL, | |
| 5 | `updateDate` datetime DEFAULT NULL, | |
| 6 | `isDisabled` tinyint(1) NOT NULL, | |
| 7 | `filename` varchar(100) COLLATE utf8_unicode_ci NOT NULL, | |
| 8 | `displayPosition` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:json_array)', | |
| 9 | `targetLink` varchar(255) COLLATE utf8_unicode_ci NOT NULL | |
| 10 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| 11 | ||
| 12 | CREATE TABLE `settings` ( | |
| 13 | `id` int(11) NOT NULL, | |
| 14 | `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| 15 | `adShowDuration` int(11) NOT NULL | |
| 16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
