K8wNmtiP

1CREATE TABLE IF NOT EXISTS `communities` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `community_id` varchar(35) COLLATE utf8mb4_bin DEFAULT NULL,
4  `title` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
5  `description` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL,
6  `type` tinyint(4) DEFAULT NULL,
7  `image_url` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
8  `size` smallint(6) DEFAULT NULL,
9  `team_instinct` tinyint(4) DEFAULT NULL,
10  `team_mystic` tinyint(4) DEFAULT NULL,
11  `team_valor` tinyint(4) DEFAULT NULL,
12  `has_invite_url` varchar(4) COLLATE utf8mb4_bin DEFAULT NULL,
13  `invite_url` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL,
14  `lat` double(18,14) DEFAULT NULL,
15  `lon` double(18,14) DEFAULT NULL,
16  `updated` bigint(20) DEFAULT NULL,
17  `source` tinyint(4) DEFAULT NULL,
18  `submitted_by` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
19  PRIMARY KEY (`id`),
20  UNIQUE KEY `community_id` (`community_id`)
21) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
22
23CREATE TABLE IF NOT EXISTS `ingress_portals` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `external_id` varchar(35) COLLATE utf8mb4_bin DEFAULT NULL,
26  `lat` double(18,14) DEFAULT NULL,
27  `lon` double(18,14) DEFAULT NULL,
28  `name` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
29  `url` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
30  `updated` bigint(11) NOT NULL,
31  `imported` bigint(11) DEFAULT NULL,
32  `checked` tinyint(4) DEFAULT NULL,
33  PRIMARY KEY (`id`),
34  UNIQUE KEY `external_id` (`external_id`)
35) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
36
37CREATE TABLE IF NOT EXISTS `nests` (
38  `nest_id` bigint(20) NOT NULL AUTO_INCREMENT,
39  `lat` double(18,14) DEFAULT NULL,
40  `lon` double(18,14) DEFAULT NULL,
41  `pokemon_id` int(11) DEFAULT 0,
42  `updated` bigint(20) DEFAULT NULL,
43  `type` tinyint(1) NOT NULL DEFAULT 0,
44  `nest_submitted_by` varchar(200) DEFAULT NULL,
45  PRIMARY KEY (`nest_id`)
46) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
47
48CREATE TABLE IF NOT EXISTS `payments` (
49  `id` int(11) NOT NULL AUTO_INCREMENT,
50  `selly_id` varchar(100) NOT NULL,
51  `product_id` int(30) NOT NULL,
52  `email` varchar(250) NOT NULL,
53  `value` int(11) NOT NULL,
54  `quantity` int(11) NOT NULL,
55  `timestamp` int(11) NOT NULL,
56  PRIMARY KEY (`id`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
58
59CREATE TABLE IF NOT EXISTS `users` (
60  `id` bigint(20) NOT NULL AUTO_INCREMENT,
61  `user` varchar(250) NOT NULL,
62  `password` varchar(250) DEFAULT NULL,
63  `temp_password` varchar(250) DEFAULT NULL,
64  `expire_timestamp` int(11) NOT NULL,
65  `session_id` varchar(100) DEFAULT NULL,
66  `login_system` varchar(40) NOT NULL,
67  `access_level` tinyint(1) DEFAULT NULL,
68  PRIMARY KEY (`id`)
69) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;