-
Notifications
You must be signed in to change notification settings - Fork 3
/
Holidays.sql
83 lines (83 loc) · 7.24 KB
/
Holidays.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
DROP TABLE IF EXISTS `Holidays`;
CREATE TABLE `Holidays` ( `ID` INT NOT NULL DEFAULT '0',
`Duration_1` INT NOT NULL DEFAULT '0',
`Duration_2` INT NOT NULL DEFAULT '0',
`Duration_3` INT NOT NULL DEFAULT '0',
`Duration_4` INT NOT NULL DEFAULT '0',
`Duration_5` INT NOT NULL DEFAULT '0',
`Duration_6` INT NOT NULL DEFAULT '0',
`Duration_7` INT NOT NULL DEFAULT '0',
`Duration_8` INT NOT NULL DEFAULT '0',
`Duration_9` INT NOT NULL DEFAULT '0',
`Duration_10` INT NOT NULL DEFAULT '0',
`Date_1` INT NOT NULL DEFAULT '0',
`Date_2` INT NOT NULL DEFAULT '0',
`Date_3` INT NOT NULL DEFAULT '0',
`Date_4` INT NOT NULL DEFAULT '0',
`Date_5` INT NOT NULL DEFAULT '0',
`Date_6` INT NOT NULL DEFAULT '0',
`Date_7` INT NOT NULL DEFAULT '0',
`Date_8` INT NOT NULL DEFAULT '0',
`Date_9` INT NOT NULL DEFAULT '0',
`Date_10` INT NOT NULL DEFAULT '0',
`Date_11` INT NOT NULL DEFAULT '0',
`Date_12` INT NOT NULL DEFAULT '0',
`Date_13` INT NOT NULL DEFAULT '0',
`Date_14` INT NOT NULL DEFAULT '0',
`Date_15` INT NOT NULL DEFAULT '0',
`Date_16` INT NOT NULL DEFAULT '0',
`Date_17` INT NOT NULL DEFAULT '0',
`Date_18` INT NOT NULL DEFAULT '0',
`Date_19` INT NOT NULL DEFAULT '0',
`Date_20` INT NOT NULL DEFAULT '0',
`Date_21` INT NOT NULL DEFAULT '0',
`Date_22` INT NOT NULL DEFAULT '0',
`Date_23` INT NOT NULL DEFAULT '0',
`Date_24` INT NOT NULL DEFAULT '0',
`Date_25` INT NOT NULL DEFAULT '0',
`Date_26` INT NOT NULL DEFAULT '0',
`Region` INT NOT NULL DEFAULT '0',
`Looping` INT NOT NULL DEFAULT '0',
`CalendarFlags_1` INT NOT NULL DEFAULT '0',
`CalendarFlags_2` INT NOT NULL DEFAULT '0',
`CalendarFlags_3` INT NOT NULL DEFAULT '0',
`CalendarFlags_4` INT NOT NULL DEFAULT '0',
`CalendarFlags_5` INT NOT NULL DEFAULT '0',
`CalendarFlags_6` INT NOT NULL DEFAULT '0',
`CalendarFlags_7` INT NOT NULL DEFAULT '0',
`CalendarFlags_8` INT NOT NULL DEFAULT '0',
`CalendarFlags_9` INT NOT NULL DEFAULT '0',
`CalendarFlags_10` INT NOT NULL DEFAULT '0',
`HolidayNameID` INT NOT NULL DEFAULT '0',
`HolidayDescriptionID` INT NOT NULL DEFAULT '0',
`TextureFilename` TEXT NULL,
`Priority` INT NOT NULL DEFAULT '0',
`CalendarFilterType` INT NOT NULL DEFAULT '0',
`Flags` INT NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `Holidays` VALUES (62,18,0,0,0,0,0,0,0,0,0,526449024,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,3,0,0,0,0,0,0,0,0,0,12,11,"",0,-1,1);
INSERT INTO `Holidays` VALUES (141,432,0,0,0,0,0,0,0,0,0,531872128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,14,13,"Calendar_WinterVeil",75,-1,1);
INSERT INTO `Holidays` VALUES (181,168,0,0,0,0,0,0,0,0,0,120700928,136675328,154550272,170967040,188071936,204587008,220692480,238338048,254869504,270958592,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,15,14,"Calendar_Noblegarden",2,-1,1);
INSERT INTO `Holidays` VALUES (201,168,0,0,0,0,0,0,0,0,0,71319552,88080384,104284160,121044992,138461184,155222016,171982848,188743680,204931072,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,13,12,"Calendar_ChildrensWeek",2,-1,1);
INSERT INTO `Holidays` VALUES (283,96,912,0,0,0,0,0,0,0,0,127301632,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,22,22,"",0,2,1);
INSERT INTO `Holidays` VALUES (284,96,912,0,0,0,0,0,0,0,0,127956992,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,25,25,"",0,2,1);
INSERT INTO `Holidays` VALUES (285,96,912,0,0,0,0,0,0,0,0,127072256,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,23,23,"",0,2,1);
INSERT INTO `Holidays` VALUES (301,2,0,0,0,0,0,0,0,0,0,536855424,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,6,4,"Calendar_FishingExtravaganza",0,0,0);
INSERT INTO `Holidays` VALUES (321,168,0,0,0,0,0,0,0,0,0,92456960,110118912,126208000,142723072,159823872,176420864,193034240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,17,16,"Calendar_HarvestFestival",2,-1,1);
INSERT INTO `Holidays` VALUES (324,335,0,0,0,0,0,0,0,0,0,529823808,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,16,15,"Calendar_HallowsEnd",3,-1,1);
INSERT INTO `Holidays` VALUES (327,504,0,0,0,0,0,0,0,0,0,101104000,118749568,135346560,151386496,169048448,184924160,201684992,218429440,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,18,17,"Calendar_LunarFestival",3,-1,1);
INSERT INTO `Holidays` VALUES (335,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,9,9,"Calendar_LoveInTheAir",2,-1,1);
INSERT INTO `Holidays` VALUES (341,336,0,0,0,0,0,0,0,0,0,525678592,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,11,10,"Calendar_Midsummer",2,-1,1);
INSERT INTO `Holidays` VALUES (353,96,912,0,0,0,0,0,0,0,0,127186944,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,24,24,"",0,2,1);
INSERT INTO `Holidays` VALUES (372,168,384,0,0,0,0,0,0,0,0,528693248,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,7,8,"Calendar_Brewfest",2,-1,1);
INSERT INTO `Holidays` VALUES (374,48,168,0,0,0,0,0,0,0,0,128415744,136427520,139556864,142686208,145831936,153188352,156317696,159447040,162592768,169244672,173078528,176207872,179353600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,1,1,"Calendar_DarkmoonFaireElwynn",1,1,0);
INSERT INTO `Holidays` VALUES (375,48,168,0,0,0,0,0,0,0,0,126957568,134281216,137426944,140572672,143702016,151025664,154187776,157333504,160462848,167786496,170948608,174094336,177223680,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,1,26,"Calendar_DarkmoonFaireMulgore",1,1,0);
INSERT INTO `Holidays` VALUES (376,48,168,0,0,0,0,0,0,0,0,127956993,135280640,138442752,141572096,144816128,151484416,155203584,157792256,160921600,168245248,171407360,174553088,177682432,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,1,27,"Calendar_DarkmoonFaireTerokkar",1,1,0);
INSERT INTO `Holidays` VALUES (398,24,0,0,0,0,0,0,0,0,0,528791552,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,21,21,"Calendar_PiratesDay",0,-1,1);
INSERT INTO `Holidays` VALUES (400,96,912,0,0,0,0,0,0,0,0,128071680,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,41,41,"",0,2,1);
INSERT INTO `Holidays` VALUES (404,167,0,0,0,0,0,0,0,0,0,161824832,178585664,195346496,212090944,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,101,101,"Calendar_HarvestFestival",2,-1,1);
INSERT INTO `Holidays` VALUES (406,0,0,0,0,0,0,0,0,0,0,144914432,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,61,61,"Calendar_WotLKLaunch",0,-1,0);
INSERT INTO `Holidays` VALUES (409,47,0,0,0,0,0,0,0,0,0,530593856,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,81,81,"Calendar_DayOfTheDead",2,-1,1);
INSERT INTO `Holidays` VALUES (420,96,912,0,0,0,0,0,0,0,0,128186368,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,121,121,"",0,2,1);
INSERT INTO `Holidays` VALUES (423,336,0,0,0,0,0,0,0,0,0,168919040,185679872,202440704,219185152,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,9,9,"Calendar_LoveInTheAir",2,-1,1);
INSERT INTO `Holidays` VALUES (424,1,0,0,0,0,0,0,0,0,0,536867712,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,161,161,"Calendar_FishingExtravaganza",0,0,0);