jR7Ggqqy

1DROP PROCEDURE IF EXISTS add_migration;
2delimiter ??
3CREATE PROCEDURE `add_migration`()
4BEGIN
5DECLARE v INT DEFAULT 1;
6SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20190314171530');
7IF v=0 THEN
8INSERT INTO `migrations` VALUES ('20190314171530');
9-- Add your query below.
10
11
12DROP TABLE IF EXISTS `logs_warden`;
13CREATE TABLE `logs_warden` (
14  `entry` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log entry ID',
15  `check` smallint(5) unsigned NOT NULL COMMENT 'Failed Warden check ID',
16  `action` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Action taken (enum WardenActions)',
17  `account` int(11) unsigned NOT NULL COMMENT 'Account ID',
18  `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Player GUID',
19  `map` int(11) unsigned DEFAULT NULL COMMENT 'Map ID',
20  `position_x` float DEFAULT NULL COMMENT 'Player position X',
21  `position_y` float DEFAULT NULL COMMENT 'Player position Y',
22  `position_z` float DEFAULT NULL COMMENT 'Player position Z',
23  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date of the log entry',
24  PRIMARY KEY (`entry`)
25) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Warden log of failed checks';
26
27
28-- End of migration.
29END IF;
30END??
31delimiter ; 
32CALL add_migration();
33DROP PROCEDURE IF EXISTS add_migration;