blob: b859c75e5789775a2fed8003b56ba66ec0bb6221 [file] [log] [blame]
--
-- Legal Notice
--
-- This document and associated source code (the "Work") is a part of a
-- benchmark specification maintained by the TPC.
--
-- The TPC reserves all right, title, and interest to the Work as provided
-- under U.S. and international laws, including without limitation all patent
-- and trademark rights therein.
--
-- No Warranty
--
-- 1.1 TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, THE INFORMATION
-- CONTAINED HEREIN IS PROVIDED "AS IS" AND WITH ALL FAULTS, AND THE
-- AUTHORS AND DEVELOPERS OF THE WORK HEREBY DISCLAIM ALL OTHER
-- WARRANTIES AND CONDITIONS, EITHER EXPRESS, IMPLIED OR STATUTORY,
-- INCLUDING, BUT NOT LIMITED TO, ANY (IF ANY) IMPLIED WARRANTIES,
-- DUTIES OR CONDITIONS OF MERCHANTABILITY, OF FITNESS FOR A PARTICULAR
-- PURPOSE, OF ACCURACY OR COMPLETENESS OF RESPONSES, OF RESULTS, OF
-- WORKMANLIKE EFFORT, OF LACK OF VIRUSES, AND OF LACK OF NEGLIGENCE.
-- ALSO, THERE IS NO WARRANTY OR CONDITION OF TITLE, QUIET ENJOYMENT,
-- QUIET POSSESSION, CORRESPONDENCE TO DESCRIPTION OR NON-INFRINGEMENT
-- WITH REGARD TO THE WORK.
-- 1.2 IN NO EVENT WILL ANY AUTHOR OR DEVELOPER OF THE WORK BE LIABLE TO
-- ANY OTHER PARTY FOR ANY DAMAGES, INCLUDING BUT NOT LIMITED TO THE
-- COST OF PROCURING SUBSTITUTE GOODS OR SERVICES, LOST PROFITS, LOSS
-- OF USE, LOSS OF DATA, OR ANY INCIDENTAL, CONSEQUENTIAL, DIRECT,
-- INDIRECT, OR SPECIAL DAMAGES WHETHER UNDER CONTRACT, TORT, WARRANTY,
-- OR OTHERWISE, ARISING IN ANY WAY OUT OF THIS OR ANY OTHER AGREEMENT
-- RELATING TO THE WORK, WHETHER OR NOT SUCH AUTHOR OR DEVELOPER HAD
-- ADVANCE NOTICE OF THE POSSIBILITY OF SUCH DAMAGES.
--
-- Contributors:
-- Gradient Systems
--
--
--
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-- Begin distribution definitions
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
------
-- calendar
-- value weight
-- ===== ======
-- 1 day number uniform, non-leap year
-- 2 month name uniform, leap year
-- 3 day of month sales liklihood (skewed)
-- 4 season "" "" (leap year)
-- 5 month number returns liklihood (skewed)
-- 6 quarter "" "" (leap year)
-- 7 first of month combined skew (low+medium_high)
-- 8 is_holiday low
-- 9 medium
-- 10 high
------
create calendar;
set types = (int, varchar, int, varchar, int, int, int, int);
set weights = 10;
set names = (day_seq, month_name, date, season, month_num, quarter, fom, holiday:uniform, uniform_leap, sales, sales_leap, returns, returns_leap, skewed, low, medium, high);
add (1, "January", 1, "Winter", 1, 1, 1, 1:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (2, "January", 2, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (3, "January", 3, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (4, "January", 4, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (5, "January", 5, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (6, "January", 6, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (7, "January", 7, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (8, "January", 8, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (9, "January", 9, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (10, "January", 10, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (11, "January", 11, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (12, "January", 12, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (13, "January", 13, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (14, "January", 14, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (15, "January", 15, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (16, "January", 16, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (17, "January", 17, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (18, "January", 18, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (19, "January", 19, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (20, "January", 20, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (21, "January", 21, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (22, "January", 22, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (23, "January", 23, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (24, "January", 24, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (25, "January", 25, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (26, "January", 26, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (27, "January", 27, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (28, "January", 28, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (29, "January", 29, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (30, "January", 30, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (31, "January", 31, "Winter", 1, 1, 1, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (32, "February", 1, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (33, "February", 2, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (34, "February", 3, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (35, "February", 4, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (36, "February", 5, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (37, "February", 6, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (38, "February", 7, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (39, "February", 8, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (40, "February", 9, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (41, "February", 10, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (42, "February", 11, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (43, "February", 12, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (44, "February", 13, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (45, "February", 14, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (46, "February", 15, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (47, "February", 16, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (48, "February", 17, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (49, "February", 18, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (50, "February", 19, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (51, "February", 20, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (52, "February", 21, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (53, "February", 22, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (54, "February", 23, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (55, "February", 24, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (56, "February", 25, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (57, "February", 26, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (58, "February", 27, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (59, "February", 28, "Winter", 2, 1, 32, 0:1, 1, 29, 29, 100, 100, 29, 1, 0, 0);
add (60, "February", 29, "Winter", 2, 1, 32, 0:0, 1, 0, 29, 0, 100, 0, 0, 0, 0);
add (61, "March", 1, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (62, "March", 2, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (63, "March", 3, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (64, "March", 4, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (65, "March", 5, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (66, "March", 6, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (67, "March", 7, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (68, "March", 8, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (69, "March", 9, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (70, "March", 10, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (71, "March", 11, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (72, "March", 12, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (73, "March", 13, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (74, "March", 14, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (75, "March", 15, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (76, "March", 16, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (77, "March", 17, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (78, "March", 18, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (79, "March", 19, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (80, "March", 20, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (81, "March", 21, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (82, "March", 22, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (83, "March", 23, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (84, "March", 24, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (85, "March", 25, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (86, "March", 26, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (87, "March", 27, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (88, "March", 28, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (89, "March", 29, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (90, "March", 30, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (91, "March", 31, "Spring", 3, 1, 61, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (92, "April", 1, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (93, "April", 2, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (94, "April", 3, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (95, "April", 4, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (96, "April", 5, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (97, "April", 6, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (98, "April", 7, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (99, "April", 8, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (100, "April", 9, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (101, "April", 10, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (102, "April", 11, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (103, "April", 12, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (104, "April", 13, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (105, "April", 14, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (106, "April", 15, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (107, "April", 16, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (108, "April", 17, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (109, "April", 18, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (110, "April", 19, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (111, "April", 20, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (112, "April", 21, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (113, "April", 22, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (114, "April", 23, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (115, "April", 24, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (116, "April", 25, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (117, "April", 26, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (118, "April", 27, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (119, "April", 28, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (120, "April", 29, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (121, "April", 30, "Spring", 4, 2, 92, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (122, "May", 1, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (123, "May", 2, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (124, "May", 3, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (125, "May", 4, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (126, "May", 5, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (127, "May", 6, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (128, "May", 7, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (129, "May", 8, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (130, "May", 9, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (131, "May", 10, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (132, "May", 11, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (133, "May", 12, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (134, "May", 13, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (135, "May", 14, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (136, "May", 15, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (137, "May", 16, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (138, "May", 17, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (139, "May", 18, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (140, "May", 19, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (141, "May", 20, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (142, "May", 21, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (143, "May", 22, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (144, "May", 23, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (145, "May", 24, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (146, "May", 25, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (147, "May", 26, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (148, "May", 27, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (149, "May", 28, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (150, "May", 29, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (151, "May", 30, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (152, "May", 31, "Spring", 5, 2, 122, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (153, "June", 1, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (154, "June", 2, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (155, "June", 3, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (156, "June", 4, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (157, "June", 5, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (158, "June", 6, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (159, "June", 7, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (160, "June", 8, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (161, "June", 9, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (162, "June", 10, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (163, "June", 11, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (164, "June", 12, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (165, "June", 13, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (166, "June", 14, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (167, "June", 15, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (168, "June", 16, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (169, "June", 17, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (170, "June", 18, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (171, "June", 19, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (172, "June", 20, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (173, "June", 21, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (174, "June", 22, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (175, "June", 23, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (176, "June", 24, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (177, "June", 25, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (178, "June", 26, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (179, "June", 27, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (180, "June", 28, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (181, "June", 29, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (182, "June", 30, "Summer", 6, 2, 153, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (183, "July", 1, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (184, "July", 2, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (185, "July", 3, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (186, "July", 4, "Summer", 7, 3, 183, 1:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (187, "July", 5, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (188, "July", 6, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (189, "July", 7, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (190, "July", 8, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (191, "July", 9, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (192, "July", 10, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (193, "July", 11, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (194, "July", 12, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (195, "July", 13, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (196, "July", 14, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (197, "July", 15, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (198, "July", 16, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (199, "July", 17, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (200, "July", 18, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (201, "July", 19, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (202, "July", 20, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (203, "July", 21, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (204, "July", 22, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (205, "July", 23, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (206, "July", 24, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (207, "July", 25, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (208, "July", 26, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (209, "July", 27, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (210, "July", 28, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (211, "July", 29, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (212, "July", 30, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (213, "July", 31, "Summer", 7, 3, 183, 0:1, 1, 29, 29, 29, 29, 29, 1, 0, 0);
add (214, "August", 1, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (215, "August", 2, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (216, "August", 3, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (217, "August", 4, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (218, "August", 5, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (219, "August", 6, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (220, "August", 7, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (221, "August", 8, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (222, "August", 9, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (223, "August", 10, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (224, "August", 11, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (225, "August", 12, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (226, "August", 13, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (227, "August", 14, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (228, "August", 15, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (229, "August", 16, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (230, "August", 17, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (231, "August", 18, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (232, "August", 19, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (233, "August", 20, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (234, "August", 21, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (235, "August", 22, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (236, "August", 23, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (237, "August", 24, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (238, "August", 25, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (239, "August", 26, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (240, "August", 27, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (241, "August", 28, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (242, "August", 29, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (243, "August", 30, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (244, "August", 31, "Summer", 8, 3, 214, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (245, "September", 1, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (246, "September", 2, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (247, "September", 3, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (248, "September", 4, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (249, "September", 5, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (250, "September", 6, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (251, "September", 7, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (252, "September", 8, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (253, "September", 9, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (254, "September", 10, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (255, "September", 11, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (256, "September", 12, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (257, "September", 13, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (258, "September", 14, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (259, "September", 15, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (260, "September", 16, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (261, "September", 17, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (262, "September", 18, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (263, "September", 19, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (264, "September", 20, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (265, "September", 21, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (266, "September", 22, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (267, "September", 23, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (268, "September", 24, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (269, "September", 25, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (270, "September", 26, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (271, "September", 27, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (272, "September", 28, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (273, "September", 29, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (274, "September", 30, "Fall", 9, 3, 245, 0:1, 1, 66, 66, 29, 29, 66, 0, 1, 0);
add (275, "October", 1, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (276, "October", 2, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (277, "October", 3, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (278, "October", 4, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (279, "October", 5, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (280, "October", 6, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (281, "October", 7, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (282, "October", 8, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (283, "October", 9, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (284, "October", 10, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (285, "October", 11, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (286, "October", 12, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (287, "October", 13, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (288, "October", 14, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (289, "October", 15, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (290, "October", 16, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (291, "October", 17, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (292, "October", 18, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (293, "October", 19, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (294, "October", 20, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (295, "October", 21, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (296, "October", 22, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (297, "October", 23, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (298, "October", 24, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (299, "October", 25, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (300, "October", 26, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (301, "October", 27, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (302, "October", 28, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (303, "October", 29, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (304, "October", 30, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (305, "October", 31, "Fall", 10, 4, 275, 0: 1, 1, 66, 66, 66, 66, 66, 0, 1, 0);
add (306, "November", 1, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (307, "November", 2, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (308, "November", 3, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (309, "November", 4, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (310, "November", 5, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (311, "November", 6, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (312, "November", 7, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (313, "November", 8, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (314, "November", 9, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (315, "November", 10, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (316, "November", 11, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (317, "November", 12, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (318, "November", 13, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (319, "November", 14, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (320, "November", 15, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (321, "November", 16, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (322, "November", 17, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (323, "November", 18, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (324, "November", 19, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (325, "November", 20, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (326, "November", 21, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (327, "November", 22, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (328, "November", 23, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (329, "November", 24, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (330, "November", 25, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (331, "November", 26, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (332, "November", 27, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (333, "November", 28, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (334, "November", 29, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (335, "November", 30, "Fall", 11, 4, 306, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (336, "December", 1, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (337, "December", 2, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (338, "December", 3, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (339, "December", 4, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (340, "December", 5, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (341, "December", 6, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (342, "December", 7, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (343, "December", 8, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (344, "December", 9, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (345, "December", 10, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (346, "December", 11, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (347, "December", 12, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (348, "December", 13, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (349, "December", 14, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (350, "December", 15, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (351, "December", 16, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (352, "December", 17, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (353, "December", 18, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (354, "December", 19, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (355, "December", 20, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (356, "December", 21, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (357, "December", 22, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (358, "December", 23, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (359, "December", 24, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (360, "December", 25, "Winter", 12, 4, 336, 1: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (361, "December", 26, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (362, "December", 27, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (363, "December", 28, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (364, "December", 29, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (365, "December", 30, "Winter", 12, 4, 336, 0: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
add (366, "December", 31, "Winter", 12, 4, 336, 1: 1, 1, 100, 100, 66, 66, 100, 0, 0, 1);
------
-- week_info
-- values: ("name", is_weekday, is_weekend)
-- weights: (uniform, skewed)
------
create week_info;
set types = (varchar, int, int);
set weights = 1;
add ("Sunday", 0, 1: 1);
add ("Monday", 1, 0: 1);
add ("Tuesday", 1, 0: 1);
add ("Wednesday", 1, 0: 1);
add ("Thursday", 1, 0: 1);
add ("Friday", 1, 0: 1);
add ("Saturday", 0, 1: 1);