· 10 years ago · Aug 31, 2016, 08:30 PM
1DROP TABLE IF EXISTS `resources`;
2CREATE TABLE `resources` (
3 `resource` varchar(12) NOT NULL,
4 `price` int(5) NOT NULL,
5 `selltimes` int(8) NOT NULL,
6 `min` text NOT NULL,
7 `max` text NOT NULL
8) ENGINE=InnoDB DEFAULT CHARSET=latin1;
9
10-- ----------------------------
11-- Records of resources
12-- ----------------------------
13INSERT INTO `resources` VALUES ('oilp', '2146', '28124', '1575', '2668');
14INSERT INTO `resources` VALUES ('iron_r', '1134', '10225', '1035', '1755');
15INSERT INTO `resources` VALUES ('diamondc', '2096', '10118', '1131', '2502');
16INSERT INTO `resources` VALUES ('copper_r', '780', '16219', '800', '1350');
17INSERT INTO `resources` VALUES ('salt_r', '1561', '8112', '766', '1950');
18INSERT INTO `resources` VALUES ('glass', '1272', '14047', '850', '1800');
19INSERT INTO `resources` VALUES ('rubisp', '2287', '8325', '1155', '2502');
20INSERT INTO `resources` VALUES ('charbonp', '1879', '4152', '915', '1879');
21INSERT INTO `resources` VALUES ('armesF', '11466', '9157', '3166', '12725');
22INSERT INTO `resources` VALUES ('turtle', '15028', '2892', '7000', '15750');
23INSERT INTO `resources` VALUES ('marijuana', '4327', '10203', '4300', '7025');
24INSERT INTO `resources` VALUES ('cocainep', '6111', '9197', '4300', '7025');
25INSERT INTO `resources` VALUES ('heroinp', '6019', '11603', '4000', '6975');
26INSERT INTO `resources` VALUES ('vin', '1014', '10892', '550', '1250');
27INSERT INTO `resources` VALUES ('acier', '6649', '8454', '2160', '8564');
28INSERT INTO `resources` VALUES ('speed', '15814', '3365', '6600', '18000');
29INSERT INTO `resources` VALUES ('bijoux', '2998', '10583', '2160', '9450');
30INSERT INTO `resources` VALUES ('salema', '520', '262', '500', '1000');
31INSERT INTO `resources` VALUES ('mackerel', '1043', '139', '1000', '2000');
32INSERT INTO `resources` VALUES ('tuna', '1500', '94', '1500', '3000');
33INSERT INTO `resources` VALUES ('mullet', '1165', '145', '1000', '2000');
34INSERT INTO `resources` VALUES ('catshark', '1120', '55', '1500', '3000');
35INSERT INTO `resources` VALUES ('ornate', '531', '263', '500', '1000');