blob: 395ebd0220af54125823c0982e297c3d8d1930fb [file] [log] [blame]
DROP TABLE IF EXISTS `lportal`.`users_vacation_entitlement`;
CREATE TABLE `lportal`.`users_vacation_entitlement` (
`userid` bigint(20) unsigned NOT NULL,
`daysentitle` int(10) unsigned NOT NULL,
`carryover` float NOT NULL,
`lastupdated` datetime NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `lportal`.`users_vacation_history`;
CREATE TABLE `lportal`.`users_vacation_history` (
`iduservacation` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` bigint(10) unsigned NOT NULL,
`fromdate` datetime NOT NULL,
`todate` datetime NOT NULL,
`daystaken` float NOT NULL,
`daysnottaken` float NOT NULL,
`comments` varchar(45) NOT NULL,
PRIMARY KEY (`iduservacation`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;