raw_factions1.sql 687 B

123456789101112131415
  1. DROP TABLE IF EXISTS `raw_factions`;
  2. CREATE TABLE `raw_factions` (
  3. `faction_id` INT(11) NOT NULL AUTO_INCREMENT,
  4. `name` VARCHAR(512) DEFAULT NULL,
  5. `category` VARCHAR(512) DEFAULT NULL,
  6. `description` VARCHAR(512) DEFAULT NULL,
  7. `unknown` VARCHAR(512) DEFAULT NULL,
  8. `con` TINYINT(3) NOT NULL DEFAULT '0',
  9. `percentage` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  10. `unknown2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  11. `value` MEDIUMINT(5) NOT NULL DEFAULT '0',
  12. `log_file` VARCHAR(255) DEFAULT '',
  13. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  14. PRIMARY KEY (`faction_id`)
  15. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;