raw_titles.sql 399 B

12345678910
  1. DROP TABLE IF EXISTS `raw_titles`;
  2. CREATE TABLE `raw_titles`(
  3. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `title_name` VARCHAR(250) NOT NULL DEFAULT '',
  5. `prefix` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  6. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  7. `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  8. PRIMARY KEY (`id`),
  9. UNIQUE KEY `NewIndex` (`title_name`)
  10. ) ENGINE=MYISAM;