fork download
  1. CREATE TABLE `notification_url` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `reg` tinyint(4) DEFAULT NULL,
  4. `teg` tinyint(4) DEFAULT NULL,
  5. `url` tinyint(4) DEFAULT NULL,
  6. `zip` tinytext,
  7. `date` datetime DEFAULT NULL,
  8. `size` bigint(20) DEFAULT NULL,
  9. `status` tinyint(1) DEFAULT NULL,
  10. PRIMARY KEY (`id`),
  11. KEY `notification_url_reg` (`reg`),
  12. KEY `notification_url_teg` (`teg`),
  13. KEY `notification_url_url` (`url`),
  14. KEY `notification_url_zip` (`zip`(100)),
  15. KEY `notification_url_date` (`date`),
  16. KEY `notification_url_size` (`size`),
  17. KEY `notification_url_status` (`status`),
  18. KEY `index_url_regions` (`teg`,`url`,`reg`,`status`,`date`,`size`,`zip`(50)),
  19. KEY `index_notification_url_id` (`id`)
  20. ) ENGINE=InnoDB DEFAULT CHARSET=utf8
Success #stdin #stdout #stderr 0s 3448KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Error: incomplete SQL: CREATE TABLE `notification_url` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reg` tinyint(4) DEFAULT NULL,
  `teg` tinyint(4) DEFAULT NULL,
  `url` tinyint(4) DEFAULT NULL,
  `zip` tinytext,
  `date` datetime DEFAULT NULL,
  `size` bigint(20) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_url_reg` (`reg`),
  KEY `notification_url_teg` (`teg`),
  KEY `notification_url_url` (`url`),
  KEY `notification_url_zip` (`zip`(100)),
  KEY `notification_url_date` (`date`),
  KEY `notification_url_size` (`size`),
  KEY `notification_url_status` (`status`),
  KEY `index_url_regions` (`teg`,`url`,`reg`,`status`,`date`,`size`,`zip`(50)),
  KEY `index_notification_url_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8