Gcj9yy4x

1-- Tables
2CREATE TABLE IF NOT EXISTS `lottery_info` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `name` varchar(255) NOT NULL,
5  `value` int(11) NOT NULL DEFAULT '0',
6  PRIMARY KEY (`id`)
7) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
8CREATE TABLE IF NOT EXISTS `lottery_tickets` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `pid` varchar(17) NOT NULL,
11  `name` varchar(255) NOT NULL,
12  `code` varchar(255) NOT NULL,
13  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14  `deleted_at` timestamp NULL DEFAULT NULL,
15  PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17
18-- Columns
19ALTER TABLE players ADD lottery_win int(100) NOT NULL DEFAULT '0';
20
21-- Data
22INSERT INTO `lottery_info` (`id`, `name`, `value`) VALUES
23	(1, 'lottery_lvl2', 3),
24	(2, 'lottery_lvl3', 7),
25	(3, 'lottery_lvl4', 25),
26	(4, 'lottery_lvl5', 65),
27	(5, 'lottery_lvl6', 100),
28	(6, 'lottery_jackpot', 0);
29
30-- Procedures
31DELIMITER //
32CREATE DEFINER=`arma3`@`localhost` PROCEDURE `lotterydeltickets`()
33BEGIN
34	 UPDATE `lottery_tickets` SET `deleted_at`= CURRENT_TIMESTAMP;
35END//
36
37CREATE DEFINER=`arma3`@`localhost` PROCEDURE `lotterydelwin`()
38BEGIN
39	UPDATE `players` SET `lottery_win`= 0;
40END//
41DELIMITER ;