94RcmDH0

1
2SET FOREIGN_KEY_CHECKS=0;
3-- Copiando estrutura para tabela bingo.daily_missions
4DROP TABLE IF EXISTS `daily_missions`;
5CREATE TABLE IF NOT EXISTS `daily_missions` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `mission_type` int(11) NOT NULL,
8  `description` varchar(255) NOT NULL,
9  `level` int(11) NOT NULL,
10  `minimum_player_level` int(11) NOT NULL,
11  `room_id` smallint(6) unsigned DEFAULT NULL,
12  `prize_id` varchar(255) DEFAULT NULL,
13  `chips_reward` int(11) NOT NULL,
14  `coins_reward` int(11) NOT NULL,
15  `total` int(11) NOT NULL,
16  `start_date` datetime NOT NULL,
17  `duration` time DEFAULT NULL,
18  `active` tinyint(4) NOT NULL DEFAULT '0',
19  PRIMARY KEY (`id`),
20  UNIQUE KEY `id` (`id`),
21  KEY `room_id` (`room_id`),
22  KEY `FK_daily_missions_daily_missions_types` (`mission_type`),
23  CONSTRAINT `FK_daily_missions_bingo_rooms_info` FOREIGN KEY (`room_id`) REFERENCES `bingo_rooms_info` (`id`),
24  CONSTRAINT `FK_daily_missions_daily_missions_types` FOREIGN KEY (`mission_type`) REFERENCES `daily_missions_types` (`id`)
25) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
26
27-- Copiando dados para a tabela bingo.daily_missions: ~12 rows (aproximadamente)
28INSERT 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
29	(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),
30	(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),
31	(3, 1, 'Ganhe 10 prêmios Linhas', 1, 2, NULL, 'linha', 50, 0, 10, '0000-00-00 00:00:00', '24:00:00', 1),
32	(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),
33	(5, 1, 'Ganhe 20 prêmios Espada', 2, 3, 12, 'espada', 100, 0, 20, '0000-00-00 00:00:00', '24:00:00', 1),
34	(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),
35	(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),
36	(19, 1, 'Ganhe 30 prêmios Fantasmas', 3, 3, 13, 'fantasmas', 150, 0, 30, '0000-00-00 00:00:00', '24:00:00', 1),
37	(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);
38
39-- Copiando estrutura para tabela bingo.daily_missions_types
40DROP TABLE IF EXISTS `daily_missions_types`;
41CREATE TABLE IF NOT EXISTS `daily_missions_types` (
42  `id` int(11) NOT NULL AUTO_INCREMENT,
43  `type` varchar(255) DEFAULT NULL,
44  PRIMARY KEY (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
46
47-- Copiando dados para a tabela bingo.daily_missions_types: ~2 rows (aproximadamente)
48
49INSERT INTO `daily_missions_types` (`id`, `type`) VALUES
50	(1, 'prize'),
51	(2, 'play'),
52	(3, 'donation'),
53	(4, 'invite');
54
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=5 DEFAULT CHARSET=latin1;
72
73-- Copiando dados para a tabela bingo.mission_requirements: ~4 rows (aproximadamente)
74
75INSERT INTO `mission_requirements` (`id`, `mission_id`, `room`, `donation`) VALUES
76	(1, 1, 1, NULL),
77	(2, 17, 15, NULL),
78	(7, 19, 13, NULL),
79	(8, 5, 12, NULL),
80	(9, 18, 4, NULL);
81
82
83-- Copiando estrutura para tabela bingo.mission_requirements_donation
84DROP TABLE IF EXISTS `mission_requirements_donation`;
85CREATE TABLE IF NOT EXISTS `mission_requirements_donation` (
86  `id` int(11) NOT NULL AUTO_INCREMENT,
87  `donation_quantity` int(11) DEFAULT NULL,
88  PRIMARY KEY (`id`),
89  UNIQUE KEY `id` (`id`)
90) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
91
92-- Copiando dados para a tabela bingo.mission_requirements_donation: ~0 rows (aproximadamente)
93
94INSERT INTO `mission_requirements_donation` (`id`, `donation_quantity`) VALUES
95	(1, 1),
96	(2, 5),
97	(3, 7);
98
99
100-- Copiando estrutura para tabela bingo.mission_requirements_room
101DROP TABLE IF EXISTS `mission_requirements_room`;
102CREATE TABLE IF NOT EXISTS `mission_requirements_room` (
103  `id` int(11) NOT NULL AUTO_INCREMENT,
104  `room_id` smallint(6) unsigned DEFAULT NULL,
105  PRIMARY KEY (`id`),
106  UNIQUE KEY `id` (`id`),
107  KEY `FK_mission_requirements_room_bingo_rooms_info` (`room_id`),
108  CONSTRAINT `FK_mission_requirements_room_bingo_rooms_info` FOREIGN KEY (`room_id`) REFERENCES `bingo_rooms_info` (`id`)
109) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
110
111-- Copiando dados para a tabela bingo.mission_requirements_room: ~0 rows (aproximadamente)
112
113INSERT INTO `mission_requirements_room` (`id`, `room_id`) VALUES
114	(1, 1),
115	(2, 2),
116	(3, 3),
117	(4, 4),
118	(5, 5),
119	(6, 6),
120	(7, 7),
121	(8, 8),
122	(9, 9),
123	(10, 10),
124	(11, 11),
125	(12, 12),
126	(13, 13),
127	(14, 14),
128	(15, 15);
129
130SET FOREIGN_KEY_CHECKS=1;