Lt4kZXE6

1-- ----------------------------
2-- Table structure for clan_data
3-- ----------------------------
4DROP TABLE IF EXISTS `clan_data`;
5CREATE TABLE `clan_data`  (
6  `clan_id` int NOT NULL DEFAULT 0,
7  `clan_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
8  `clan_level` int NOT NULL DEFAULT 0,
9  `reputation_score` int NOT NULL DEFAULT 0,
10  `hasCastle` tinyint NOT NULL DEFAULT 0,
11  `ally_id` int NOT NULL DEFAULT 0,
12  `ally_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
13  `leader_id` int NOT NULL DEFAULT 0,
14  `new_leader_id` int NOT NULL DEFAULT 0,
15  `crest_id` int NOT NULL DEFAULT 0,
16  `crest_large_id` int NOT NULL DEFAULT 0,
17  `ally_crest_id` int NOT NULL DEFAULT 0,
18  `auction_bid_at` int NOT NULL DEFAULT 0,
19  `ally_penalty_expiry_time` bigint NOT NULL DEFAULT 0,
20  `ally_penalty_type` int NOT NULL DEFAULT 0,
21  `char_penalty_expiry_time` bigint NOT NULL DEFAULT 0,
22  `dissolving_expiry_time` bigint NOT NULL DEFAULT 0,
23  `enabled` tinyint NOT NULL DEFAULT 0,
24  `notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
25  `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
26  PRIMARY KEY (`clan_id`) USING BTREE,
27  INDEX `leader_id`(`leader_id`) USING BTREE,
28  INDEX `ally_id`(`ally_id`) USING BTREE
29) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
30
31SET FOREIGN_KEY_CHECKS = 1;