· 6 years ago · Sep 22, 2019, 06:48 PM
1
2-- --------------------------------------------------------
3--
4-- Table structure for table `clan_bitva_users`
5--
6
7DROP TABLE IF EXISTS `clan_bitva_users`;
8CREATE TABLE `clan_bitva_users` (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `clan_id` int(11) NOT NULL,
11 `user_id` int(11) NOT NULL,
12 `clan_bitva_id` int(11) NOT NULL,
13 `hp` int(11) NOT NULL,
14 `str` int(11) NOT NULL,
15 `def` int(11) NOT NULL,
16 `opponent` int(11) NOT NULL,
17 `time` int(11) NOT NULL,
18 `uron` int(11) NOT NULL,
19 PRIMARY KEY (`id`)
20) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
21
22-- --------------------------------------------------------
23--
24-- Dumping data for table `clan_bitva_users`
25--
26
27INSERT INTO `clan_bitva_users` VALUES ('1','29','1','1','3962','3962','3953','38','1569175663','0');
28INSERT INTO `clan_bitva_users` VALUES ('2','23','43','1','14200','14200','14200','1','1569173271','0');
29INSERT INTO `clan_bitva_users` VALUES ('3','27','49','1','14200','14200','14200','77','1569173778','0');
30INSERT INTO `clan_bitva_users` VALUES ('4','16','47','1','14200','14200','14200','0','0','0');
31INSERT INTO `clan_bitva_users` VALUES ('5','27','20','1','9317','9329','9317','71','1569173626','0');
32INSERT INTO `clan_bitva_users` VALUES ('6','16','29','1','14500','14500','14500','0','0','0');
33INSERT INTO `clan_bitva_users` VALUES ('7','23','73','1','3219','3219','3219','0','0','0');
34INSERT INTO `clan_bitva_users` VALUES ('8','23','77','1','513','528','543','0','0','0');
35INSERT INTO `clan_bitva_users` VALUES ('9','23','71','1','3574','3574','3574','0','0','0');
36INSERT INTO `clan_bitva_users` VALUES ('10','23','62','1','14083','14083','14083','49','1569176432','0');
37INSERT INTO `clan_bitva_users` VALUES ('11','23','38','1','14350','14350','14350','41','1569174023','0');
38INSERT INTO `clan_bitva_users` VALUES ('12','23','41','1','14350','14350','14350','41','1569176513','0');