View file holidays/db.sql

DROP TABLE IF EXISTS `holidays`;  CREATE TABLE `holidays` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(500) NOT NULL,  `id_user` int(11) NOT NULL,  `id_object` int(11) NOT NULL,  `d` int(11) NOT NULL,  `m` int(11) NOT NULL,  `type` varchar(120) NOT NULL,  `read` enum('0','1') NOT NULL DEFAULT '1',  `time` int(11) NOT NULL,  PRIMARY KEY (`id`)  ) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;