· 7 years ago · Feb 27, 2019, 10:21 PM
1
2SET FOREIGN_KEY_CHECKS=0;
3
4-- Copiando estrutura para tabela bingo.daily_missions_types
5DROP TABLE IF EXISTS `daily_missions_types`;
6CREATE TABLE IF NOT EXISTS `daily_missions_types` (
7 `id` int(11) NOT NULL AUTO_INCREMENT,
8 `type` varchar(255) DEFAULT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
11
12-- Copiando estrutura para tabela bingo.daily_missions
13DROP TABLE IF EXISTS `daily_missions`;
14CREATE TABLE IF NOT EXISTS `daily_missions` (
15 `id` int(11) NOT NULL AUTO_INCREMENT,
16 `mission_type` int(11) NOT NULL,
17 `description` varchar(255) NOT NULL,
18 `level` int(11) NOT NULL,
19 `minimum_player_level` int(11) NOT NULL,
20 `room_id` smallint(6) unsigned DEFAULT NULL,
21 `prize_id` varchar(255) DEFAULT NULL,
22 `chips_reward` int(11) NOT NULL,
23 `coins_reward` int(11) NOT NULL,
24 `total` int(11) NOT NULL,
25 `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
26 `duration` time NOT NULL DEFAULT '24:00:00',
27 `active` tinyint(4) DEFAULT '1',
28 PRIMARY KEY (`id`),
29 UNIQUE KEY `id` (`id`),
30 KEY `room_id` (`room_id`),
31 KEY `FK_daily_missions_daily_missions_types` (`mission_type`),
32 CONSTRAINT `FK_daily_missions_bingo_rooms_info` FOREIGN KEY (`room_id`) REFERENCES `bingo_rooms_info` (`id`),
33 CONSTRAINT `FK_daily_missions_daily_missions_types` FOREIGN KEY (`mission_type`) REFERENCES `daily_missions_types` (`id`)
34) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;
35
36-- Copiando estrutura para tabela bingo.mission_requirements_donation
37DROP TABLE IF EXISTS `mission_requirements_donation`;
38CREATE TABLE IF NOT EXISTS `mission_requirements_donation` (
39 `id` int(11) NOT NULL AUTO_INCREMENT,
40 `donation_quantity` int(11) DEFAULT NULL,
41 PRIMARY KEY (`id`),
42 UNIQUE KEY `id` (`id`)
43) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
44
45-- Copiando estrutura para tabela bingo.mission_requirements_room
46DROP TABLE IF EXISTS `mission_requirements_room`;
47CREATE TABLE IF NOT EXISTS `mission_requirements_room` (
48 `id` int(11) NOT NULL AUTO_INCREMENT,
49 `room_id` smallint(6) unsigned DEFAULT NULL,
50 PRIMARY KEY (`id`),
51 UNIQUE KEY `id` (`id`),
52 KEY `FK_mission_requirements_room_bingo_rooms_info` (`room_id`),
53 CONSTRAINT `FK_mission_requirements_room_bingo_rooms_info` FOREIGN KEY (`room_id`) REFERENCES `bingo_rooms_info` (`id`)
54) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
55
56-- Copiando estrutura para tabela bingo.mission_requirements
57DROP TABLE IF EXISTS `mission_requirements`;
58CREATE TABLE IF NOT EXISTS `mission_requirements` (
59 `id` int(11) NOT NULL AUTO_INCREMENT,
60 `mission_id` int(11) NOT NULL,
61 `room` int(11) DEFAULT NULL,
62 `donation` int(11) DEFAULT NULL,
63 PRIMARY KEY (`id`),
64 UNIQUE KEY `id` (`id`),
65 KEY `FK_mission_requirements_daily_missions` (`mission_id`),
66 KEY `FK_mission_requirements_mission_requirements_room` (`room`),
67 KEY `FK_mission_requirements_mission_requirements_donation` (`donation`),
68 CONSTRAINT `FK_mission_requirements_daily_missions` FOREIGN KEY (`mission_id`) REFERENCES `daily_missions` (`id`),
69 CONSTRAINT `FK_mission_requirements_mission_requirements_donation` FOREIGN KEY (`donation`) REFERENCES `mission_requirements_donation` (`id`),
70 CONSTRAINT `FK_mission_requirements_mission_requirements_room` FOREIGN KEY (`room`) REFERENCES `mission_requirements_room` (`id`)
71) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;
72
73-- Copiando estrutura para tabela bingo.user_daily_missions
74DROP TABLE IF EXISTS `user_daily_missions`;
75CREATE TABLE IF NOT EXISTS `user_daily_missions` (
76 `id` int(11) NOT NULL AUTO_INCREMENT,
77 `mission_id` int(11) NOT NULL,
78 `user_id` int(11) NOT NULL,
79 `active` tinyint(4) NOT NULL DEFAULT '1',
80 `rewarded` tinyint(4) NOT NULL DEFAULT '0',
81 `actual_progression` int(11) NOT NULL DEFAULT '0',
82 `start_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
83 `done` tinyint(4) NOT NULL DEFAULT '0',
84 PRIMARY KEY (`id`),
85 KEY `FK_user_daily_missions_daily_missions` (`mission_id`),
86 CONSTRAINT `FK_user_daily_missions_daily_missions` FOREIGN KEY (`mission_id`) REFERENCES `daily_missions` (`id`)
87) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
88
89-- Copiando dados para a tabela bingo.mission_requirements_room: ~15 rows (aproximadamente)
90DELETE FROM `mission_requirements_room`;
91INSERT INTO `mission_requirements_room` (`id`, `room_id`) VALUES
92 (1, 1),
93 (2, 2),
94 (3, 3),
95 (4, 4),
96 (5, 5),
97 (6, 6),
98 (7, 7),
99 (8, 8),
100 (9, 9),
101 (10, 10),
102 (11, 11),
103 (12, 12),
104 (13, 13),
105 (14, 14),
106 (15, 15);
107
108-- Copiando dados para a tabela bingo.mission_requirements_donation: ~3 rows (aproximadamente)
109DELETE FROM `mission_requirements_donation`;
110INSERT INTO `mission_requirements_donation` (`id`, `donation_quantity`) VALUES
111 (1, 1),
112 (2, 5),
113 (3, 7);
114
115-- Copiando dados para a tabela bingo.daily_missions_types: ~4 rows (aproximadamente)
116DELETE FROM `daily_missions_types`;
117INSERT INTO `daily_missions_types` (`id`, `type`) VALUES
118 (1, 'prize'),
119 (2, 'play'),
120 (3, 'donation'),
121 (4, 'invite');
122
123-- Copiando dados para a tabela bingo.daily_missions: ~108 rows (aproximadamente)
124DELETE FROM `daily_missions`;
125INSERT INTO `daily_missions` (`id`, `mission_type`, `description`, `level`, `minimum_player_level`, `room_id`, `prize_id`, `chips_reward`, `coins_reward`, `total`, `start_date`, `duration`, `active`) VALUES
126 (1, 2, 'Jogue 10 partidas na sala Recife da Sereia', 1, 2, 1, '', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
127 (2, 2, 'Jogue 10 partidas na sala Tartaruga da Sorte', 1, 2, 2, '', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
128 (3, 2, 'Jogue 10 partidas na sala Castelo da Princesa', 1, 2, 11, '', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
129 (4, 2, 'Jogue 10 partidas na sala Cavalheiro Destemido', 1, 2, 10, '', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
130 (5, 2, 'Jogue 10 partidas na sala Circo Fantástico', 1, 3, 4, '', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
131 (6, 2, 'Jogue 10 partidas na sala Cartola do Coelho', 1, 3, 5, '', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
132 (7, 1, 'Ganhe 10 prêmios Linhas', 1, 2, NULL, 'linha', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
133 (8, 1, 'Ganhe 10 prêmios 2 Colunas', 1, 2, NULL, '2colunas', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
134 (9, 1, 'Ganhe 10 prêmios Espada', 1, 2, 12, 'espada', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
135 (10, 1, 'Ganhe 10 prêmios Fantasmas', 1, 3, 13, 'fantasmas', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
136 (11, 1, 'Ganhe 3 prêmios Linha Dupla', 1, 2, NULL, 'linhadupla', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
137 (12, 1, 'Ganhe 3 prêmios 3 Colunas', 1, 2, NULL, '3colunas', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
138 (13, 1, 'Ganhe 3 prêmios Dragão', 1, 2, 12, 'dragao', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
139 (14, 1, 'Ganhe 3 prêmios Holograma', 1, 4, 15, 'bordas', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
140 (15, 1, 'Ganhe 3 Bingos na sala Recife da Sereia', 1, 2, 1, 'bingo', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
141 (16, 1, 'Ganhe 3 Bingos na sala Cavaleiro Destemido', 1, 2, 10, 'bingo', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
142 (17, 1, 'Ganhe 3 Bingos na sala Cartola do Coelho', 1, 3, 5, 'bingo', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
143 (18, 4, 'Convide 5 amigos para jogar o Fantasy', 1, 2, NULL, '', 50, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
144 (19, 3, 'Faça 1 doação para um amigo que precisa de ajuda.', 1, 2, NULL, '', 50, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
145 (20, 1, 'Ganhe 10 prêmios Linhas na sala Tesouros Submersos', 1, 2, 3, 'linha', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
146 (21, 1, 'Ganhe 10 prêmios 2 Colunas na sala Tesouros Submersos', 1, 2, 3, '2colunas', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
147 (22, 1, 'Ganhe 3 prêmios Linha Dupla na sala Tesouros Submersos', 1, 2, 3, 'linhadupla', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
148 (23, 1, 'Ganhe 3 prêmios 3 Colunas na sala Tesouros Submersos', 1, 2, 3, '3colunas', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
149 (24, 1, 'Ganhe 10 prêmios Linhas na sala Sorte nas Estrelas', 1, 4, 15, 'linha', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
150 (25, 1, 'Ganhe 10 prêmios 2 Colunas na sala Sorte nas Estrelas', 1, 4, 15, '2colunas', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
151 (26, 1, 'Ganhe 3 prêmios Linha Dupla na sala Sorte nas Estrelas', 1, 4, 15, 'linhadupla', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
152 (27, 1, 'Ganhe 3 prêmios 3 Colunas na sala Sorte nas Estrelas', 1, 4, 15, '3colunas', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
153 (28, 1, 'Ganhe 5 prêmios Linha na sala Tartaruga da Sorte', 1, 2, 2, 'linha', 50, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
154 (29, 1, 'Ganhe 5 prêmios Linha na sala Castelo da Princesa', 1, 2, 11, 'linha', 50, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
155 (30, 1, 'Ganhe 5 prêmios Linha na sala Circo Fantástico', 1, 3, 4, 'linha', 50, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
156 (31, 1, 'Ganhe 3 prêmios Linha Dupla na sala Tartaruga da Sorte', 1, 2, 2, 'linhadupla', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
157 (32, 1, 'Ganhe 3 prêmios Linha Dupla na sala Castelo da Princesa', 1, 2, 11, 'linhadupla', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
158 (33, 1, 'Ganhe 3 prêmios Linha Dupla na sala Circo Fantástico', 1, 3, 4, 'linhadupla', 50, 0, 3, '0000-00-00 00:00:00', '24:00:00', 1),
159 (34, 2, 'Jogue 20 partidas na sala Recife da Sereia', 2, 2, 1, '', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
160 (35, 2, 'Jogue 20 partidas na sala Tartaruga da Sorte', 2, 2, 2, '', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
161 (36, 2, 'Jogue 20 partidas na sala Castelo da Princesa', 2, 2, 11, '', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
162 (37, 2, 'Jogue 20 partidas na sala Cavalheiro Destemido', 2, 2, 10, '', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
163 (38, 2, 'Jogue 20 partidas na sala Circo Fantástico', 2, 3, 4, '', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
164 (39, 2, 'Jogue 20 partidas na sala Cartola do Coelho', 2, 3, 5, '', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
165 (40, 1, 'Ganhe 20 prêmios Linhas', 2, 2, NULL, 'linha', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
166 (41, 1, 'Ganhe 20 prêmios 2 Colunas', 2, 2, NULL, '2colunas', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
167 (42, 1, 'Ganhe 20 prêmios Espada', 2, 2, 12, 'espada', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
168 (43, 1, 'Ganhe 20 prêmios Fantasmas', 2, 3, 13, 'fantasmas', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
169 (44, 1, 'Ganhe 5 prêmios Linha Dupla', 2, 2, NULL, 'linhadupla', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
170 (45, 1, 'Ganhe 5 prêmios 3 Colunas', 2, 2, NULL, '3colunas', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
171 (46, 1, 'Ganhe 5 prêmios Dragão', 2, 2, 12, 'dragao', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
172 (47, 1, 'Ganhe 5 prêmios Holograma', 2, 4, 15, 'bordas', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
173 (48, 1, 'Ganhe 5 Bingos na sala Recife da Sereia', 2, 2, 1, 'bingo', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
174 (49, 1, 'Ganhe 5 Bingos na sala Cavaleiro Destemido', 2, 2, 10, 'bingo', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
175 (50, 1, 'Ganhe 5 Bingos na sala Cartola do Coelho', 2, 3, 5, 'bingo', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
176 (51, 1, 'Ganhe um prêmio Sereia na sala Recife da Sereia', 2, 2, 1, 'jackpot_accumulated', 100, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
177 (52, 1, 'Ganhe um prêmio Dragão na sala Cavaleiro Destemido', 2, 2, 10, 'jackpot_accumulated', 100, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
178 (53, 1, 'Ganhe um prêmio Trapézio na sala Cartola do Coelho', 2, 3, 5, 'jackpot_accumulated', 100, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
179 (54, 4, 'Convide 10 amigos para jogar o Fantasy', 2, 2, NULL, '', 100, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
180 (55, 3, 'Faça 5 doações para amigos que precisam de ajuda.', 2, 2, NULL, '', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
181 (56, 1, 'Ganhe 20 prêmios Linhas na sala Tesouros Submersos', 2, 2, 3, 'linha', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
182 (57, 1, 'Ganhe 20 prêmios 2 Colunas na sala Tesouros Submersos', 2, 2, 3, '2colunas', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
183 (58, 1, 'Ganhe 5 prêmios Linha Dupla na sala Tesouros Submersos', 2, 2, 3, 'linhadupla', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
184 (59, 1, 'Ganhe 5 prêmios 3 Colunas na sala Tesouros Submersos', 2, 2, 3, '3colunas', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
185 (60, 1, 'Ganhe 20 prêmios Linhas na sala Sorte nas Estrelas', 2, 4, 15, 'linha', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
186 (61, 1, 'Ganhe 20 prêmios 2 Colunas na sala Sorte nas Estrelas', 2, 4, 15, '2colunas', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
187 (62, 1, 'Ganhe 5 prêmios Linha Dupla na sala Sorte nas Estrelas', 2, 4, 15, 'linhadupla', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
188 (63, 1, 'Ganhe 5 prêmios 3 Colunas na sala Sorte nas Estrelas', 2, 4, 15, '3colunas', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
189 (64, 1, 'Ganhe 10 prêmios Linha na sala Tartaruga da Sorte', 2, 2, 2, 'linha', 100, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
190 (65, 1, 'Ganhe 10 prêmios Linha na sala Castelo da Princesa', 2, 2, 11, 'linha', 100, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
191 (66, 1, 'Ganhe 10 prêmios Linha na sala Circo Fantástico', 2, 3, 4, 'linha', 100, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
192 (67, 1, 'Ganhe 5 prêmios Linha Dupla na sala Tartaruga da Sorte', 2, 2, 2, 'linhadupla', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
193 (68, 1, 'Ganhe 5 prêmios Linha Dupla na sala Castelo da Princesa', 2, 2, 11, 'linhadupla', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
194 (69, 1, 'Ganhe 5 prêmios Linha Dupla na sala Circo Fantástico', 2, 3, 4, 'linhadupla', 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
195 (70, 2, 'Jogue 30 partidas na sala Recife da Sereia', 3, 2, 1, '', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
196 (71, 2, 'Jogue 30 partidas na sala Tartaruga da Sorte', 3, 2, 2, '', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
197 (72, 2, 'Jogue 30 partidas na sala Castelo da Princesa', 3, 2, 11, '', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
198 (73, 2, 'Jogue 30 partidas na sala Cavalheiro Destemido', 3, 2, 10, '', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
199 (74, 2, 'Jogue 30 partidas na sala Circo Fantástico', 3, 3, 4, '', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
200 (75, 2, 'Jogue 30 partidas na sala Cartola do Coelho', 3, 3, 5, '', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
201 (76, 1, 'Ganhe 30 prêmios Linhas', 3, 2, NULL, 'linha', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
202 (77, 1, 'Ganhe 30 prêmios 2 Colunas', 3, 2, NULL, '2colunas', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
203 (78, 1, 'Ganhe 30 prêmios Espada', 3, 2, 12, 'espada', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
204 (79, 1, 'Ganhe 30 prêmios Fantasmas', 3, 3, 13, 'fantasmas', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
205 (80, 1, 'Ganhe 7 prêmios Linha Dupla', 3, 2, NULL, 'linhadupla', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
206 (81, 1, 'Ganhe 7 prêmios 3 Colunas', 3, 2, NULL, '3colunas', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
207 (82, 1, 'Ganhe 7 prêmios Dragão', 3, 2, 12, 'dragao', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
208 (83, 1, 'Ganhe 7 prêmios Holograma', 3, 4, 15, 'bordas', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
209 (84, 1, 'Ganhe 10 Bingos na sala Recife da Sereia', 3, 2, 1, 'bingo', 150, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
210 (85, 1, 'Ganhe 10 Bingos na sala Cavaleiro Destemido', 3, 2, 10, 'bingo', 150, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
211 (86, 1, 'Ganhe 10 Bingos na sala Cartola do Coelho', 3, 3, 5, 'bingo', 150, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
212 (87, 1, 'Ganhe um Bingo na sala Tesouros Submersos', 3, 2, 3, 'bingo', 150, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
213 (88, 1, 'Ganhe um Bingo na sala Floresta Encantada', 3, 2, 14, 'bingo', 150, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
214 (89, 1, 'Ganhe um Bingo na sala Princesa e o Dragão', 3, 2, 12, 'bingo', 150, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
215 (90, 1, 'Ganhe um Bingo na sala Festa de Halloween', 3, 3, 13, 'bingo', 150, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
216 (91, 1, 'Ganhe um Bingo na sala Canhão da Sorte', 3, 3, 6, 'bingo', 150, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
217 (92, 1, 'Ganhe um Bingo na sala Sorte nas Estrelas', 3, 4, 15, 'bingo', 150, 0, 1, '0000-00-00 00:00:00', '24:00:00', 1),
218 (93, 4, 'Convide 15 amigos para jogar o Fantasy', 3, 2, NULL, '', 150, 0, 15, '0000-00-00 00:00:00', '24:00:00', 1),
219 (94, 3, 'Faça 7 doações para amigos que precisam de ajuda.', 3, 2, NULL, '', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
220 (95, 1, 'Ganhe 30 prêmios Linhas na sala Tesouros Submersos', 3, 2, 3, 'linha', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
221 (96, 1, 'Ganhe 30 prêmios 2 Colunas na sala Tesouros Submersos', 3, 2, 3, '2colunas', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
222 (97, 1, 'Ganhe 7 prêmios Linha Dupla na sala Tesouros Submersos', 3, 2, 3, 'linhadupla', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
223 (98, 1, 'Ganhe 7 prêmios 3 Colunas na sala Tesouros Submersos', 3, 2, 3, '3colunas', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
224 (99, 1, 'Ganhe 30 prêmios Linhas na sala Sorte nas Estrelas', 3, 4, 15, 'linha', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
225 (100, 1, 'Ganhe 30 prêmios 2 Colunas na sala Sorte nas Estrelas', 3, 4, 15, '2colunas', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
226 (101, 1, 'Ganhe 7 prêmios Linha Dupla na sala Sorte nas Estrelas', 3, 4, 15, 'linhadupla', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
227 (102, 1, 'Ganhe 7 prêmios 3 Colunas na sala Sorte nas Estrelas', 3, 4, 15, '3colunas', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
228 (103, 1, 'Ganhe 15 prêmios Linha na sala Tartaruga da Sorte', 3, 2, 2, 'linha', 150, 0, 15, '0000-00-00 00:00:00', '24:00:00', 1),
229 (104, 1, 'Ganhe 15 prêmios Linha na sala Castelo da Princesa', 3, 2, 11, 'linha', 150, 0, 15, '0000-00-00 00:00:00', '24:00:00', 1),
230 (105, 1, 'Ganhe 15 prêmios Linha na sala Circo Fantástico', 3, 3, 4, 'linha', 150, 0, 15, '0000-00-00 00:00:00', '24:00:00', 1),
231 (106, 1, 'Ganhe 7 prêmios Linha Dupla na sala Tartaruga da Sorte', 3, 2, 2, 'linhadupla', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
232 (107, 1, 'Ganhe 7 prêmios Linha Dupla na sala Castelo da Princesa', 3, 2, 11, 'linhadupla', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1),
233 (108, 1, 'Ganhe 7 prêmios Linha Dupla na sala Circo Fantástico', 3, 3, 4, 'linhadupla', 150, 0, 7, '0000-00-00 00:00:00', '24:00:00', 1);
234
235-- Copiando dados para a tabela bingo.mission_requirements: ~93 rows (aproximadamente)
236DELETE FROM `mission_requirements`;
237INSERT INTO `mission_requirements` (`id`, `mission_id`, `room`, `donation`) VALUES
238 (1, 1, 1, NULL),
239 (2, 2, 2, NULL),
240 (3, 3, 11, NULL),
241 (4, 4, 10, NULL),
242 (5, 5, 4, NULL),
243 (6, 6, 5, NULL),
244 (7, 9, 12, NULL),
245 (8, 10, 13, NULL),
246 (9, 13, 12, NULL),
247 (10, 14, 15, NULL),
248 (11, 15, 1, NULL),
249 (12, 16, 10, NULL),
250 (13, 17, 5, NULL),
251 (14, 20, 3, NULL),
252 (15, 21, 3, NULL),
253 (16, 22, 3, NULL),
254 (17, 23, 3, NULL),
255 (18, 24, 15, NULL),
256 (19, 25, 15, NULL),
257 (20, 26, 15, NULL),
258 (21, 27, 15, NULL),
259 (22, 28, 2, NULL),
260 (23, 29, 11, NULL),
261 (24, 30, 4, NULL),
262 (25, 31, 2, NULL),
263 (26, 32, 11, NULL),
264 (27, 33, 4, NULL),
265 (28, 34, 1, NULL),
266 (29, 35, 2, NULL),
267 (30, 36, 11, NULL),
268 (31, 37, 10, NULL),
269 (32, 38, 4, NULL),
270 (33, 39, 5, NULL),
271 (34, 42, 12, NULL),
272 (35, 43, 13, NULL),
273 (36, 46, 12, NULL),
274 (37, 47, 15, NULL),
275 (38, 48, 1, NULL),
276 (39, 49, 10, NULL),
277 (40, 50, 5, NULL),
278 (41, 51, 1, NULL),
279 (42, 52, 10, NULL),
280 (43, 53, 5, NULL),
281 (44, 56, 3, NULL),
282 (45, 57, 3, NULL),
283 (46, 58, 3, NULL),
284 (47, 59, 3, NULL),
285 (48, 60, 15, NULL),
286 (49, 61, 15, NULL),
287 (50, 62, 15, NULL),
288 (51, 63, 15, NULL),
289 (52, 64, 2, NULL),
290 (53, 65, 11, NULL),
291 (54, 66, 4, NULL),
292 (55, 67, 2, NULL),
293 (56, 68, 11, NULL),
294 (57, 69, 4, NULL),
295 (58, 70, 1, NULL),
296 (59, 71, 2, NULL),
297 (60, 72, 11, NULL),
298 (61, 73, 10, NULL),
299 (62, 74, 4, NULL),
300 (63, 75, 5, NULL),
301 (64, 78, 12, NULL),
302 (65, 79, 13, NULL),
303 (66, 82, 12, NULL),
304 (67, 83, 15, NULL),
305 (68, 84, 1, NULL),
306 (69, 85, 10, NULL),
307 (70, 86, 5, NULL),
308 (71, 87, 3, NULL),
309 (72, 88, 14, NULL),
310 (73, 89, 12, NULL),
311 (74, 90, 13, NULL),
312 (75, 91, 6, NULL),
313 (76, 92, 15, NULL),
314 (77, 95, 3, NULL),
315 (78, 96, 3, NULL),
316 (79, 97, 3, NULL),
317 (80, 98, 3, NULL),
318 (81, 99, 15, NULL),
319 (82, 100, 15, NULL),
320 (83, 101, 15, NULL),
321 (84, 102, 15, NULL),
322 (85, 103, 2, NULL),
323 (86, 104, 11, NULL),
324 (87, 105, 4, NULL),
325 (88, 106, 2, NULL),
326 (89, 107, 11, NULL),
327 (90, 108, 4, NULL),
328 (91, 19, NULL, 1),
329 (92, 55, NULL, 2),
330 (93, 94, NULL, 3);
331
332SET FOREIGN_KEY_CHECKS=1;