Codice PHP:
CREATE TABLE IF NOT EXISTS `uni1_planets` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT 'Hauptplanet',
`id_owner` int(11) unsigned DEFAULT NULL,
`id_level` tinyint(1) unsigned DEFAULT '0',
`universe` tinyint(3) unsigned NOT NULL,
`galaxy` tinyint(3) NOT NULL DEFAULT '0',
`system` smallint(5) NOT NULL DEFAULT '0',
`planet` tinyint(3) NOT NULL DEFAULT '0',
`last_update` int(11) DEFAULT NULL,
`planet_type` enum('1','3') NOT NULL DEFAULT '1',
`destruyed` int(11) NOT NULL DEFAULT '0',
`b_building` int(11) NOT NULL DEFAULT '0',
`b_building_id` varchar(500) NOT NULL DEFAULT '',
`b_hangar` int(11) NOT NULL DEFAULT '0',
`b_hangar_id` varchar(500) NOT NULL DEFAULT '',
`b_hangar_plus` int(11) NOT NULL DEFAULT '0',
`image` varchar(32) NOT NULL DEFAULT 'normaltempplanet01',
`diameter` int(11) unsigned NOT NULL DEFAULT '12800',
`field_current` smallint(5) unsigned NOT NULL DEFAULT '0',
`field_max` smallint(5) unsigned NOT NULL DEFAULT '163',
`temp_min` int(3) NOT NULL DEFAULT '-17',
`temp_max` int(3) NOT NULL DEFAULT '23',
`metal` double(50,0) unsigned NOT NULL DEFAULT '0',
`metal_perhour` decimal(10,0) unsigned NOT NULL DEFAULT '0',
`metal_max` bigint(20) unsigned DEFAULT '100000',
`crystal` double(50,0) unsigned NOT NULL DEFAULT '0',
`crystal_perhour` decimal(10,0) unsigned NOT NULL DEFAULT '0',
`crystal_max` bigint(20) unsigned DEFAULT '100000',
`deuterium` double(50,0) unsigned NOT NULL DEFAULT '0',
`deuterium_used` int(11) unsigned NOT NULL DEFAULT '0',
`deuterium_perhour` decimal(10,0) unsigned NOT NULL DEFAULT '0',
`deuterium_max` bigint(20) unsigned DEFAULT '100000',
`energy_used` bigint(11) unsigned NOT NULL DEFAULT '0',
`energy_max` bigint(20) unsigned NOT NULL DEFAULT '0',
`metal_mine` tinyint(3) unsigned NOT NULL DEFAULT '0',
`crystal_mine` tinyint(3) unsigned NOT NULL DEFAULT '0',
`deuterium_sintetizer` tinyint(3) unsigned NOT NULL DEFAULT '0',
`solar_plant` tinyint(3) unsigned NOT NULL DEFAULT '0',
`fusion_plant` tinyint(3) unsigned NOT NULL DEFAULT '0',
`robot_factory` tinyint(3) unsigned NOT NULL DEFAULT '0',
`nano_factory` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hangar` tinyint(3) unsigned NOT NULL DEFAULT '0',
`metal_store` tinyint(3) unsigned NOT NULL DEFAULT '0',
`crystal_store` tinyint(3) unsigned NOT NULL DEFAULT '0',
`deuterium_store` tinyint(3) unsigned NOT NULL DEFAULT '0',
`laboratory` tinyint(3) unsigned NOT NULL DEFAULT '0',
`terraformer` tinyint(3) unsigned NOT NULL DEFAULT '0',
`university` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ally_deposit` tinyint(3) unsigned NOT NULL DEFAULT '0',
`silo` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mondbasis` tinyint(3) unsigned NOT NULL DEFAULT '0',
`phalanx` tinyint(3) unsigned NOT NULL DEFAULT '0',
`sprungtor` tinyint(3) unsigned NOT NULL DEFAULT '0',
`small_ship_cargo` bigint(20) unsigned NOT NULL DEFAULT '0',
`big_ship_cargo` bigint(20) unsigned NOT NULL DEFAULT '0',
`light_hunter` bigint(20) unsigned NOT NULL DEFAULT '0',
`heavy_hunter` bigint(20) unsigned NOT NULL DEFAULT '0',
`crusher` bigint(20) unsigned NOT NULL DEFAULT '0',
`battle_ship` bigint(20) unsigned NOT NULL DEFAULT '0',
`colonizer` bigint(20) unsigned NOT NULL DEFAULT '0',
`recycler` bigint(20) unsigned NOT NULL DEFAULT '0',
`spy_sonde` bigint(20) unsigned NOT NULL DEFAULT '0',
`bomber_ship` bigint(20) unsigned NOT NULL DEFAULT '0',
`solar_satelit` bigint(20) unsigned NOT NULL DEFAULT '0',
`destructor` bigint(20) unsigned NOT NULL DEFAULT '0',
`dearth_star` bigint(20) unsigned NOT NULL DEFAULT '0',
`battleship` bigint(20) unsigned NOT NULL DEFAULT '0',
`lune_noir` bigint(20) unsigned NOT NULL DEFAULT '0',
`ev_transporter` bigint(20) unsigned NOT NULL DEFAULT '0',
`star_crasher` bigint(20) unsigned NOT NULL DEFAULT '0',
`giga_recykler` bigint(20) unsigned NOT NULL DEFAULT '0',
`dm_ship` bigint(20) NOT NULL DEFAULT '0',
`orbital_station` bigint(20) unsigned NOT NULL DEFAULT '0',
`misil_launcher` bigint(20) unsigned NOT NULL DEFAULT '0',
`small_laser` bigint(20) unsigned NOT NULL DEFAULT '0',
`big_laser` bigint(20) unsigned NOT NULL DEFAULT '0',
`gauss_canyon` bigint(20) unsigned NOT NULL DEFAULT '0',
`ionic_canyon` bigint(20) unsigned NOT NULL DEFAULT '0',
`buster_canyon` bigint(20) unsigned NOT NULL DEFAULT '0',
`small_protection_shield` tinyint(1) unsigned NOT NULL DEFAULT '0',
`planet_protector` tinyint(1) unsigned NOT NULL DEFAULT '0',
`big_protection_shield` tinyint(1) unsigned NOT NULL DEFAULT '0',
`graviton_canyon` bigint(20) unsigned NOT NULL DEFAULT '0',
`interceptor_misil` int(11) unsigned NOT NULL DEFAULT '0',
`interplanetary_misil` int(11) unsigned NOT NULL DEFAULT '0',
`metal_mine_porcent` enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '10',
`crystal_mine_porcent` enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '10',
`deuterium_sintetizer_porcent` enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '10',
`solar_plant_porcent` enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '10',
`fusion_plant_porcent` enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '10',
`solar_satelit_porcent` enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '10',
`last_jump_time` int(11) NOT NULL DEFAULT '0',
`der_metal` double(50,0) unsigned NOT NULL DEFAULT '0',
`der_crystal` double(50,0) unsigned NOT NULL DEFAULT '0',
`id_luna` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_luna` (`id_luna`),
KEY `galaxy` (`galaxy`,`system`,`planet`,`planet_type`),
KEY `id_owner` (`id_owner`),
KEY `destruyed` (`destruyed`),
Devi aggiungere 1000 ai campi metal, crystall e deuterium
Rispondi quotando