· 4 years ago · Feb 11, 2021, 05:48 AM
1CREATE PROCEDURE INIT_TABLES()
2 MODIFIES SQL DATA
3 BEGIN
4 DECLARE sum1 INT;
5
6 CREATE TABLE IF NOT EXISTS unique_stats_yesterday ( `unuque_type` int(11) DEFAULT NULL, `steamid` varchar(64) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `ip` varchar(64) DEFAULT NULL ) DEFAULT CHARSET=utf8;
7 CREATE TABLE IF NOT EXISTS unique_stats_today ( `unuque_type` int(11) DEFAULT NULL, `steamid` varchar(64) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `ip` varchar(64) DEFAULT NULL ) DEFAULT CHARSET=utf8;
8 CREATE TABLE IF NOT EXISTS unique_stats_week ( `day1` int(11) DEFAULT NULL, `day2` int(11) DEFAULT NULL, `day3` int(11) DEFAULT NULL, `day4` int(11) DEFAULT NULL, `day5` int(11) DEFAULT NULL, `day6` int(11) DEFAULT NULL, `day7` int(11) DEFAULT NULL);
9
10 SET sum1 = (SELECT COUNT(*) FROM unique_stats_week);
11 IF sum1 = 0 THEN
12 INSERT INTO unique_stats_week (`day1`, `day2`, `day3`, `day4`, `day5`, `day6`, `day7`) VALUES ('0', '0', '0', '0', '0', '0', '0');
13 END IF;
14 END ;
15CALL INIT_TABLES();
16DROP PROCEDURE INIT_TABLES;
17