· 7 years ago · Feb 26, 2019, 01:48 PM
1SET FOREIGN_KEY_CHECKS=0;
2-- Copiando estrutura para tabela bingo.daily_missions
3DROP TABLE IF EXISTS `daily_missions`;
4CREATE TABLE IF NOT EXISTS `daily_missions` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `mission_type` int(11) NOT NULL,
7 `description` varchar(255) NOT NULL,
8 `level` int(11) NOT NULL,
9 `minimum_player_level` int(11) NOT NULL,
10 `room_id` smallint(6) unsigned DEFAULT NULL,
11 `prize_id` varchar(255) DEFAULT NULL,
12 `chips_reward` int(11) NOT NULL,
13 `coins_reward` int(11) NOT NULL,
14 `total` int(11) NOT NULL,
15 `start_date` datetime NOT NULL,
16 `duration` time DEFAULT NULL,
17 `active` tinyint(4) NOT NULL DEFAULT '0',
18 PRIMARY KEY (`id`),
19 UNIQUE KEY `id` (`id`),
20 KEY `room_id` (`room_id`),
21 KEY `FK_daily_missions_daily_missions_types` (`mission_type`),
22 CONSTRAINT `FK_daily_missions_bingo_rooms_info` FOREIGN KEY (`room_id`) REFERENCES `bingo_rooms_info` (`id`),
23 CONSTRAINT `FK_daily_missions_daily_missions_types` FOREIGN KEY (`mission_type`) REFERENCES `daily_missions_types` (`id`)
24) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
25
26
27-- Copiando estrutura para tabela bingo.daily_missions_types
28DROP TABLE IF EXISTS `daily_missions_types`;
29CREATE TABLE IF NOT EXISTS `daily_missions_types` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `type` varchar(255) DEFAULT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
34
35-- Copiando estrutura para tabela bingo.mission_requirements
36DROP TABLE IF EXISTS `mission_requirements`;
37CREATE TABLE IF NOT EXISTS `mission_requirements` (
38 `id` int(11) NOT NULL AUTO_INCREMENT,
39 `mission_id` int(11) NOT NULL,
40 `room` int(11) DEFAULT NULL,
41 `donation` int(11) DEFAULT NULL,
42 PRIMARY KEY (`id`),
43 UNIQUE KEY `id` (`id`),
44 KEY `FK_mission_requirements_daily_missions` (`mission_id`),
45 KEY `FK_mission_requirements_mission_requirements_room` (`room`),
46 KEY `FK_mission_requirements_mission_requirements_donation` (`donation`),
47 CONSTRAINT `FK_mission_requirements_daily_missions` FOREIGN KEY (`mission_id`) REFERENCES `daily_missions` (`id`),
48 CONSTRAINT `FK_mission_requirements_mission_requirements_donation` FOREIGN KEY (`donation`) REFERENCES `mission_requirements_donation` (`id`),
49 CONSTRAINT `FK_mission_requirements_mission_requirements_room` FOREIGN KEY (`room`) REFERENCES `mission_requirements_room` (`id`)
50) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
51
52-- Copiando estrutura para tabela bingo.mission_requirements_donation
53DROP TABLE IF EXISTS `mission_requirements_donation`;
54CREATE TABLE IF NOT EXISTS `mission_requirements_donation` (
55 `id` int(11) NOT NULL AUTO_INCREMENT,
56 `donation_quantity` int(11) DEFAULT NULL,
57 PRIMARY KEY (`id`),
58 UNIQUE KEY `id` (`id`)
59) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
60
61-- Copiando estrutura para tabela bingo.mission_requirements_room
62DROP TABLE IF EXISTS `mission_requirements_room`;
63CREATE TABLE IF NOT EXISTS `mission_requirements_room` (
64 `id` int(11) NOT NULL AUTO_INCREMENT,
65 `room_id` smallint(6) unsigned DEFAULT NULL,
66 PRIMARY KEY (`id`),
67 UNIQUE KEY `id` (`id`),
68 KEY `FK_mission_requirements_room_bingo_rooms_info` (`room_id`),
69 CONSTRAINT `FK_mission_requirements_room_bingo_rooms_info` FOREIGN KEY (`room_id`) REFERENCES `bingo_rooms_info` (`id`)
70) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
71
72-- Copiando estrutura para tabela bingo.user_daily_missions
73DROP TABLE IF EXISTS `user_daily_missions`;
74CREATE TABLE IF NOT EXISTS `user_daily_missions` (
75 `id` int(11) NOT NULL AUTO_INCREMENT,
76 `mission_id` int(11) NOT NULL,
77 `user_id` int(11) NOT NULL,
78 `active` tinyint(4) NOT NULL DEFAULT '1',
79 `rewarded` tinyint(4) NOT NULL DEFAULT '0',
80 `actual_progression` int(11) NOT NULL DEFAULT '0',
81 `start_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
82 `done` tinyint(4) NOT NULL DEFAULT '0',
83 PRIMARY KEY (`id`),
84 KEY `FK_user_daily_missions_daily_missions` (`mission_id`),
85 CONSTRAINT `FK_user_daily_missions_daily_missions` FOREIGN KEY (`mission_id`) REFERENCES `daily_missions` (`id`)
86) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=latin1;
87
88-- Copiando dados para a tabela bingo.daily_missions_types: ~4 rows (aproximadamente)
89DELETE FROM `daily_missions_types`;
90INSERT INTO `daily_missions_types` (`id`, `type`) VALUES
91 (1, 'prize'),
92 (2, 'play'),
93 (3, 'donation'),
94 (4, 'invite');
95
96-- Copiando dados para a tabela bingo.mission_requirements_donation: ~3 rows (aproximadamente)
97DELETE FROM `mission_requirements_donation`;
98INSERT INTO `mission_requirements_donation` (`id`, `donation_quantity`) VALUES
99 (1, 1),
100 (2, 5),
101 (3, 7);
102
103-- Copiando dados para a tabela bingo.mission_requirements_room: ~15 rows (aproximadamente)
104DELETE FROM `mission_requirements_room`;
105INSERT INTO `mission_requirements_room` (`id`, `room_id`) VALUES
106 (1, 1),
107 (2, 2),
108 (3, 3),
109 (4, 4),
110 (5, 5),
111 (6, 6),
112 (7, 7),
113 (8, 8),
114 (9, 9),
115 (10, 10),
116 (11, 11),
117 (12, 12),
118 (13, 13),
119 (14, 14),
120 (15, 15);
121
122-- Copiando dados para a tabela bingo.daily_missions: ~9 rows (aproximadamente)
123DELETE FROM `daily_missions`;
124INSERT 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
125 (1, 2, 'Jogue 10 partidas na sala Recife da Sereia', 1, 2, 1, NULL, 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
126 (2, 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),
127 (3, 1, 'Ganhe 10 prêmios Linhas', 1, 2, NULL, 'linha', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
128 (4, 2, 'Jogue 20 partidas na sala Castelo da Princesa', 2, 2, 11, NULL, 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
129 (5, 1, 'Ganhe 20 prêmios Espada', 2, 3, 12, 'espada', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
130 (17, 1, 'Ganhe 5 prêmios Linha Dupla na sala Sorte nas Estrelas', 2, 4, NULL, NULL, 100, 0, 5, '0000-00-00 00:00:00', '24:00:00', 1),
131 (18, 2, 'Jogue 30 partidas na sala Circo Fantástico', 3, 3, 4, NULL, 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
132 (19, 1, 'Ganhe 30 prêmios Fantasmas', 3, 3, 13, 'fantasmas', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
133 (20, 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);
134
135-- Copiando dados para a tabela bingo.mission_requirements: ~5 rows (aproximadamente)
136DELETE FROM `mission_requirements`;
137INSERT INTO `mission_requirements` (`id`, `mission_id`, `room`, `donation`) VALUES
138 (1, 1, 1, NULL),
139 (2, 17, 15, NULL),
140 (7, 19, 13, NULL),
141 (8, 5, 12, NULL),
142 (9, 18, 4, NULL);
143
144-- Copiando dados para a tabela bingo.user_daily_missions: ~2 rows (aproximadamente)
145DELETE FROM `user_daily_missions`;
146INSERT INTO `user_daily_missions` (`id`, `mission_id`, `user_id`, `active`, `rewarded`, `actual_progression`, `start_date`, `done`) VALUES
147 (225, 1, 684291, 1, 0, 0, '2019-02-26 10:17:49', 0),
148 (226, 5, 684291, 1, 0, 0, '2019-02-26 10:17:49', 0),
149 (227, 20, 684291, 1, 0, 1, '2019-02-26 10:17:49', 0);
150
151SET FOREIGN_KEY_CHECKS=1;