player tablosunu attığım esnada hata veriyor acaba neyden kaynaklı
Kod:
[SQL] Query player start
[ERR] 1265 - Data truncated for column 'setAffectFlag' at row 1
[ERR]
INSERT INTO `refine_proto` VALUES (701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500000, 0, 0, 45);
INSERT INTO `refine_proto` VALUES (702, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2000000, 0, 0, 25);
INSERT INTO `refine_proto` VALUES (703, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100);
INSERT INTO `refine_proto` VALUES (751, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100000, 0, 0, 45);
INSERT INTO `refine_proto` VALUES (752, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500000, 0, 0, 54);
INSERT INTO `refine_proto` VALUES (753, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2000000, 0, 0, 36);
INSERT INTO `refine_proto` VALUES (758, 71123, 2, 71129, 3, 0, 0, 0, 0, 0, 0, 125000, 0, 0, 100);
INSERT INTO `refine_proto` VALUES (759, 71123, 3, 71129, 4, 0, 0, 0, 0, 0, 0, 200000, 0, 0, 100);
-- ----------------------------
-- Table structure for safebox
-- ----------------------------
DROP TABLE IF EXISTS `safebox`;
CREATE TABLE `safebox` (
`account_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
`size` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
`password` varchar(6) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
`gold` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of safebox
-- ----------------------------
-- ----------------------------
-- Table structure for shop
-- ----------------------------
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
`vnum` int(11) NOT NULL DEFAULT 0,
`name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Noname',
`npc_vnum` smallint(6) NOT NULL DEFAULT 0,
PRIMARY KEY (`vnum`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of shop
-- ----------------------------
INSERT INTO `shop` VALUES (1, 'silah_saticisi', 9001);
INSERT INTO `shop` VALUES (2, 'balikci', 9009);
INSERT INTO `shop` VALUES (3, 'satici', 9003);
INSERT INTO `shop` VALUES (4, 'zirh_saticisi', 9002);
INSERT INTO `shop` VALUES (5, 'imba_shop2', 9007);
INSERT INTO `shop` VALUES (6, 'imba_shop1', 9008);
INSERT INTO `shop` VALUES (1001, 'all_sword', 20086);
INSERT INTO `shop` VALUES (1002, 'all_dualhand_sword', 0);
INSERT INTO `shop` VALUES (1003, 'all_bow', 0);
INSERT INTO `shop` VALUES (1004, 'all_twohand_sword', 0);
INSERT INTO `shop` VALUES (1005, 'all_bell', 0);
INSERT INTO `shop` VALUES (1006, 'all_fan', 0);
INSERT INTO `shop` VALUES (1007, 'all_warrior_armour', 20087);
INSERT INTO `shop` VALUES (1008, 'all_assassin_armour', 0);
INSERT INTO `shop` VALUES (1009, 'all_sura_armour', 0);
INSERT INTO `shop` VALUES (1010, 'all_shaman_armour', 0);
INSERT INTO `shop` VALUES (1011, 'all_warrior_helmet', 0);
INSERT INTO `shop` VALUES (1012, 'all_assassin_helmet', 0);
INSERT INTO `shop` VALUES (1013, 'all_sura_helmet', 0);
INSERT INTO `shop` VALUES (1014, 'all_shaman_helmet', 0);
INSERT INTO `shop` VALUES (1015, 'all_shield', 0);
INSERT INTO `shop` VALUES (1016, 'all_bracelet', 0);
INSERT INTO `shop` VALUES (1017, 'all_shoe', 0);
INSERT INTO `shop` VALUES (1018, 'all_necklace', 0);
INSERT INTO `shop` VALUES (1019, 'all_ring', 0);
INSERT INTO `shop` VALUES (7, 'gold_bar_shop', 9005);
INSERT INTO `shop` VALUES (8, 'firework_shop', 9004);
INSERT INTO `shop` VALUES (9, '?? ???', 20042);
INSERT INTO `shop` VALUES (10, 'pick_shop', 20015);
INSERT INTO `shop` VALUES (2000, 'hairstyles_mage', 20094);
INSERT INTO `shop` VALUES (2001, 'hairstyles_ninja', 20094);
INSERT INTO `shop` VALUES (2002, 'hairstyles_warrior', 20094);
INSERT INTO `shop` VALUES (2003, 'hairstyles_sura', 20094);
-- ----------------------------
-- Table structure for shop_item
-- ----------------------------
DROP TABLE IF EXISTS `shop_item`;
CREATE TABLE `shop_item` (
`shop_vnum` int(11) NOT NULL DEFAULT 0,
`item_vnum` int(11) NOT NULL DEFAULT 0,
`count` tinyint(4) UNSIGNED NOT NULL DEFAULT 1,
UNIQUE INDEX `vnum_unique`(`shop_vnum`, `item_vnu
[SQL] Finished with error
En son bir moderatör tarafından düzenlenmiş:
