root/dev/install/sql/sql_tbldata_ship_classes.sql @ 233

Revision 233, 2.3 KB (checked in by ralle030583, 15 years ago)

- changed summarytable format to 5 rows each cause of cap. industrial
- bugfix in autoupgrade of navigation table (Kills were linked to Home :-/)
- added chk_cap_industrial to autoupgrade
- added Capital Industrial to sql install files

Line 
1TRUNCATE TABLE `kb3_ship_classes`;
2INSERT IGNORE INTO `kb3_ship_classes` VALUES ('1','Battleship','35000000','750');
3INSERT IGNORE INTO `kb3_ship_classes` VALUES ('2','Capsule','5000000','5');
4INSERT IGNORE INTO `kb3_ship_classes` VALUES ('3','Noobship','0','5');
5INSERT IGNORE INTO `kb3_ship_classes` VALUES ('4','Frigate','200000','50');
6INSERT IGNORE INTO `kb3_ship_classes` VALUES ('5','Interceptor','10000000','60');
7INSERT IGNORE INTO `kb3_ship_classes` VALUES ('6','Assault frigate','15000000','80');
8INSERT IGNORE INTO `kb3_ship_classes` VALUES ('7','Industrial','500000','20');
9INSERT IGNORE INTO `kb3_ship_classes` VALUES ('8','Cruiser','3000000','100');
10INSERT IGNORE INTO `kb3_ship_classes` VALUES ('9','Heavy assault','80000000','400');
11INSERT IGNORE INTO `kb3_ship_classes` VALUES ('10','Battlecruiser','20000000','250');
12INSERT IGNORE INTO `kb3_ship_classes` VALUES ('11','Shuttle','8000','5');
13INSERT IGNORE INTO `kb3_ship_classes` VALUES ('12','Mining barge','15000000','20');
14INSERT IGNORE INTO `kb3_ship_classes` VALUES ('13','Logistics','20000000','175');
15INSERT IGNORE INTO `kb3_ship_classes` VALUES ('14','Transport','60000000','30');
16INSERT IGNORE INTO `kb3_ship_classes` VALUES ('15','Destroyer','800000','60');
17INSERT IGNORE INTO `kb3_ship_classes` VALUES ('16','Covert ops','15000000','80');
18INSERT IGNORE INTO `kb3_ship_classes` VALUES ('17','Drone','0','0');
19INSERT IGNORE INTO `kb3_ship_classes` VALUES ('18','Unknown','0','0');
20INSERT IGNORE INTO `kb3_ship_classes` VALUES ('19','Dreadnought','1500000000','4000');
21INSERT IGNORE INTO `kb3_ship_classes` VALUES ('20','Freighter','1000000000','1500');
22INSERT IGNORE INTO `kb3_ship_classes` VALUES ('21','Command ship','180000000','450');
23INSERT IGNORE INTO `kb3_ship_classes` VALUES ('22','Exhumer','20000000','20');
24INSERT IGNORE INTO `kb3_ship_classes` VALUES ('23','Interdictor','20000000','60');
25INSERT IGNORE INTO `kb3_ship_classes` VALUES ('24','Recon ship','100000000','350');
26INSERT IGNORE INTO `kb3_ship_classes` VALUES ('26','Titan','70000000000','20000');
27INSERT IGNORE INTO `kb3_ship_classes` VALUES ('27','Carrier','1000000000','3000');
28INSERT IGNORE INTO `kb3_ship_classes` VALUES ('28','Mothership','25000000000','6000');
29INSERT IGNORE INTO `kb3_ship_classes` VALUES ('29','Cap. Industrial','1850000000','5000');
Note: See TracBrowser for help on using the browser.