raw_poi_locations.sql 450 B

1234567891011
  1. CREATE TABLE `raw_poi_locations`(
  2. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
  3. `unknown` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' ,
  4. `x` FLOAT NOT NULL DEFAULT '0' ,
  5. `y` FLOAT NOT NULL DEFAULT '0' ,
  6. `z` FLOAT NOT NULL DEFAULT '0' ,
  7. `num_locations` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' ,
  8. `data_version` INT(10) UNSIGNED NOT NULL DEFAULT '0' ,
  9. `log_file` VARCHAR(250) NOT NULL DEFAULT '' ,
  10. PRIMARY KEY (`id`)
  11. ) ENGINE=MyISAM;