· 8 years ago · Dec 03, 2017, 01:24 PM
1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for `item_attr_neno_rare`
5-- ----------------------------
6DROP TABLE IF EXISTS `item_attr_neno_rare`;
7CREATE TABLE `item_attr_neno_rare` (
8 `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_BONUS_TO_MONSTER', 'ANTI_PENETRATE_PCT', 'ANTI_CRITICAL_PCT', 'APPLY_CRITICAL_PCT', 'CRITICAL_PCT', 'PENETRATE_PCT', 'ATTBONUS_UNDEAD', 'ATTBONUS_DEVIL', 'POISON_PCT') CHARACTER SET latin1 NOT NULL DEFAULT 'MAX_HP',
9 `prob` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
10 `lv1` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
11 `lv2` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
12 `lv3` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
13 `lv4` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
14 `lv5` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
15 `weapon` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
16 `body` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
17 `wrist` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
18 `foots` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
19 `neck` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
20 `head` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
21 `shield` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
22 `ear` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT ''
23) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
24
25-- ----------------------------
26-- Records of item_attr_neno_rare
27-- ----------------------------
28INSERT INTO `item_attr_neno_rare` VALUES ('CON', '1', '3', '3', '3', '3', '3', '5', '5', '5', '5', '5', '5', '5', '5');
29INSERT INTO `item_attr_neno_rare` VALUES ('INT', '1', '3', '3', '3', '3', '3', '5', '5', '5', '5', '5', '5', '5', '5');
30INSERT INTO `item_attr_neno_rare` VALUES ('STR', '1', '3', '3', '3', '3', '3', '5', '5', '5', '5', '5', '5', '5', '5');
31INSERT INTO `item_attr_neno_rare` VALUES ('DEX', '1', '3', '3', '3', '3', '3', '5', '5', '5', '5', '5', '5', '5', '5');
32INSERT INTO `item_attr_neno_rare` VALUES ('ATT_BONUS_TO_MONSTER', '1', '2', '2', '3', '4', '4', '5', '5', '5', '5', '5', '5', '5', '5');
33INSERT INTO `item_attr_neno_rare` VALUES ('MAX_HP', '1', '1000', '1000', '1500', '2000', '2000', '5', '5', '5', '5', '5', '5', '5', '5');
34INSERT INTO `item_attr_neno_rare` VALUES ('MAX_MP', '1', '100', '100', '150', '200', '200', '5', '5', '5', '5', '5', '5', '5', '5');
35INSERT INTO `item_attr_neno_rare` VALUES ('ANTI_CRITICAL_PCT', '1', '2', '2', '2', '2', '3', '5', '5', '5', '5', '5', '5', '5', '5');
36INSERT INTO `item_attr_neno_rare` VALUES ('ANTI_PENETRATE_PCT', '1', '2', '2', '2', '2', '3', '5', '5', '5', '5', '5', '5', '5', '5');
37INSERT INTO `item_attr_neno_rare` VALUES ('CRITICAL_PCT', '1', '2', '2', '2', '3', '3', '5', '5', '5', '5', '5', '5', '5', '5');
38INSERT INTO `item_attr_neno_rare` VALUES ('PENETRATE_PCT', '1', '2', '2', '2', '3', '3', '5', '5', '5', '5', '5', '5', '5', '5');
39INSERT INTO `item_attr_neno_rare` VALUES ('ATTBONUS_UNDEAD', '1', '2', '2', '3', '4', '4', '5', '5', '5', '5', '5', '5', '5', '5');
40INSERT INTO `item_attr_neno_rare` VALUES ('ATTBONUS_DEVIL', '1', '2', '2', '3', '4', '4', '5', '5', '5', '5', '5', '5', '5', '5');
41INSERT INTO `item_attr_neno_rare` VALUES ('POISON_PCT', '1', '1', '1', '2', '2', '2', '5', '5', '5', '5', '5', '5', '5', '5');