Hwy8PPmm

1CREATE TABLE IF NOT EXISTS `owned_shops` (
2  `identifier` varchar(250) DEFAULT NULL,
3  `ShopNumber` int(11) DEFAULT NULL,
4  `money` int(11) DEFAULT '0',
5  `ShopValue` int(11) DEFAULT NULL,
6  `LastRobbery` int(11) DEFAULT '0',
7  `ShopName` varchar(30) DEFAULT NULL
8) ENGINE=InnoDB DEFAULT CHARSET=latin1;
9
10INSERT INTO `owned_shops` (`identifier`, `ShopNumber`, `money`, `ShopValue`, `LastRobbery`, `ShopName`) VALUES
11  ('0', 1, 0, 280000, 1549643682, '0'),
12  ('0', 2, 0, 220000, 1549643682, '0'),
13  ('0', 3, 0, 235000, 1549643682, '0'),
14  ('0', 4, 0, 285000, 1549643682, '0'),
15  ('0', 5, 0, 135000, 1549643682, '0'),
16  ('0', 6, 0, 235000, 1549643682, '0'),
17  ('0', 7, 0, 160000, 1549643682, '0'),
18  ('0', 8, 0, 275000, 1549643682, '0'),
19  ('0', 9, 0, 265000, 1549643682, '0'),
20  ('0', 10, 0, 300000, 1549643682, '0'),
21  ('0', 12, 0, 145000, 1549643682, '0'),
22  ('0', 13, 0, 145000, 1549643682, '0'),
23  ('0', 14, 0, 280000, 1549643682, '0'),
24  ('0', 15, 0, 300000, 1549643682, '0'),
25  ('0', 16, 0, 435000, 1549643682, '0'),
26  ('0', 18, 0, 235000, 1549643682, '0'),
27  ('0', 11, 0, 225000, 1549643682, '0'),
28  ('0', 19, 0, 150000, 1549643682, '0'),
29  ('0', 20, 0, 165000, 1549643682, '0'),
30  ('0', 17, 0, 150000, 1549643682, '0');
31  
32CREATE TABLE IF NOT EXISTS `shipments` (
33  `id` int(11) DEFAULT NULL,
34  `identifier` varchar(50) DEFAULT NULL,
35  `label` varchar(50) DEFAULT NULL,
36  `item` varchar(50) DEFAULT NULL,
37  `price` varchar(50) DEFAULT NULL,
38  `count` varchar(50) DEFAULT NULL,
39  `time` int(20) DEFAULT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42
43CREATE TABLE IF NOT EXISTS `shops` (
44  `ShopNumber` int(11) NOT NULL DEFAULT '0',
45  `src` varchar(50) NOT NULL,
46  `count` int(11) NOT NULL,
47  `item` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
48  `price` int(11) NOT NULL,
49  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;