9
3

eq2_books.sql 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. DROP TABLE IF EXISTS `raw_books`;
  2. CREATE TABLE `raw_books` (
  3. `id` TINYINT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `spawn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  5. `book_title` VARCHAR(100) NOT NULL,
  6. `unknown` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  7. `book_type` VARCHAR(100) NOT NULL,
  8. `unknown2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  9. `unknown3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  10. `unknown4` INT(10) NOT NULL DEFAULT '0',
  11. `unknown5` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  12. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  13. `log_file` VARCHAR(255) DEFAULT NULL,
  14. PRIMARY KEY (`id`),
  15. UNIQUE KEY `NewIndex` (`spawn_id`)
  16. ) ENGINE=MYISAM DEFAULT CHARSET=latin1;
  17. DROP TABLE IF EXISTS `raw_book_images`;
  18. CREATE TABLE `raw_book_images` (
  19. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  20. `spawn_id` INT(10) UNSIGNED NOT NULL,
  21. `image_file` VARCHAR(255) DEFAULT NULL,
  22. `image_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  23. `unknown6` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  24. PRIMARY KEY (`id`)
  25. ) ENGINE=MYISAM DEFAULT CHARSET=latin1;
  26. DROP TABLE IF EXISTS `raw_book_pages`;
  27. CREATE TABLE `raw_book_pages` (
  28. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  29. `spawn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  30. `page_text` VARCHAR(1024) DEFAULT NULL,
  31. `page_text_valign` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  32. `page_text_halign` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  33. PRIMARY KEY (`id`)
  34. ) ENGINE=MYISAM DEFAULT CHARSET=latin1;