blob: 26e090a2018e8a2e6261878bfae149fc60d84e66 [file] [log] [blame]
DELETE From users_vacation_history;
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11201, '2006-11-24', '2007-01-05', 28, 0, "Back home visit");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11201, '2009-06-15', '2009-06-19', 5, 0, "Time off");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11201, '2009-12-13', '2009-12-17', 5, 0, "US Visit");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11201, '2010-05-21', '2010-05-21', 1, 0, "Montreal Trip");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11201, '2010-09-15', '2010-09-15', 0.5, 0, "Doctor Appointment");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11201, '2010-04-21', '2010-04-21', 0.5, 0, "Dentist Visit");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11252, '2010-09-15', '2010-09-15', 0.5, 0, "Doctor Appointment");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11252, '2010-04-21', '2010-04-21', 0.5, 0, "Dentist Visit");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11252, '2009-06-15', '2009-06-19', 5, 0, "Time off");
INSERT INTO users_vacation_history
(userid, fromdate, todate, daystaken, daysnottaken, comments)
VALUES
(11252, '2009-12-13', '2009-12-17', 5, 0, "US Vsist");
DELETE From users_vacation_entitlement;
INSERT INTO users_vacation_entitlement
(userid, daysentitle, carryover, lastupdated)
VALUES
(11201, 20, 12.5, '2010-03-01');
INSERT INTO users_vacation_entitlement
(userid, daysentitle, carryover, lastupdated)
VALUES
(11252, 15, 16, '2010-01-01');