1 CREATE TABLE core_holiday (
2 id int(11) NOT NULL auto_increment,
6 ALTER TABLE core_holiday ADD COLUMN holiday_date DATE NOT NULL DEFAULT '0000-00-00';
7 ALTER TABLE core_holiday ADD COLUMN country VARCHAR(4) NOT NULL DEFAULT '';
10 alter table core_holiday add index lookup (holiday_date, country);