
-- --------------------------------------------------------

--
-- Table structure for table `holiday`
--

CREATE TABLE IF NOT EXISTS `holiday` (
  `holiday_name` enum('New Year''s Day','President''s Day','Memorial Day','Independence Day','Labor Day','Columbus Day','Veteran''s Day','Day before Thanksgiving','Thanksgiving','Black Friday','Saturday after Black Friday','Sunday after Black Friday','Cyber Monday','Tuesday after Cyber Monday','Day before Christmas','Christmas Day','Day after Christmas') NOT NULL,
  `holiday_date` date NOT NULL,
  PRIMARY KEY (`holiday_name`,`holiday_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `holiday`
--

INSERT INTO `holiday` (`holiday_name`, `holiday_date`) VALUES
('New Year''s Day', '2012-01-01'),
('New Year''s Day', '2013-01-01'),
('New Year''s Day', '2014-01-01'),
('New Year''s Day', '2015-01-01'),
('President''s Day', '2012-02-20'),
('President''s Day', '2013-02-18'),
('President''s Day', '2014-02-17'),
('President''s Day', '2015-02-16'),
('Memorial Day', '2012-05-28'),
('Memorial Day', '2013-05-27'),
('Memorial Day', '2014-05-26'),
('Memorial Day', '2015-05-25'),
('Independence Day', '2012-07-04'),
('Independence Day', '2013-07-04'),
('Independence Day', '2014-07-04'),
('Independence Day', '2015-07-04'),
('Labor Day', '2012-09-03'),
('Labor Day', '2013-09-02'),
('Labor Day', '2014-09-01'),
('Labor Day', '2015-09-07'),
('Columbus Day', '2012-10-08'),
('Columbus Day', '2013-10-14'),
('Columbus Day', '2014-10-13'),
('Columbus Day', '2015-10-12'),
('Veteran''s Day', '2012-11-11'),
('Veteran''s Day', '2013-11-11'),
('Veteran''s Day', '2014-11-11'),
('Veteran''s Day', '2015-11-11'),
('Day before Thanksgiving', '2012-11-21'),
('Day before Thanksgiving', '2013-11-27'),
('Day before Thanksgiving', '2014-11-26'),
('Day before Thanksgiving', '2015-11-26'),
('Thanksgiving', '2012-11-22'),
('Thanksgiving', '2013-11-28'),
('Thanksgiving', '2014-11-27'),
('Thanksgiving', '2015-11-26'),
('Black Friday', '2012-11-23'),
('Black Friday', '2013-11-29'),
('Black Friday', '2014-11-28'),
('Black Friday', '2015-11-27'),
('Saturday after Black Friday', '2012-11-24'),
('Saturday after Black Friday', '2013-11-30'),
('Saturday after Black Friday', '2014-11-29'),
('Saturday after Black Friday', '2015-11-28'),
('Sunday after Black Friday', '2012-11-25'),
('Sunday after Black Friday', '2013-12-01'),
('Sunday after Black Friday', '2014-11-30'),
('Sunday after Black Friday', '2015-11-29'),
('Cyber Monday', '2012-11-26'),
('Cyber Monday', '2013-12-02'),
('Cyber Monday', '2014-12-01'),
('Cyber Monday', '2015-11-30'),
('Tuesday after Cyber Monday', '2012-11-27'),
('Tuesday after Cyber Monday', '2013-12-03'),
('Tuesday after Cyber Monday', '2014-12-02'),
('Tuesday after Cyber Monday', '2015-12-01'),
('Day before Christmas', '2012-12-24'),
('Day before Christmas', '2013-12-24'),
('Day before Christmas', '2014-12-24'),
('Day before Christmas', '2015-12-24'),
('Christmas Day', '2012-12-25'),
('Christmas Day', '2013-12-25'),
('Christmas Day', '2014-12-25'),
('Christmas Day', '2015-12-25'),
('Day after Christmas', '2012-12-26'),
('Day after Christmas', '2013-12-26'),
('Day after Christmas', '2014-12-26'),
('Day after Christmas', '2015-12-26');