ALTER TABLE `oa_attendstat` ADD `toMakeup` decimal(12,2) NOT NULL DEFAULT 0.00 AFTER `actual`;
ALTER TABLE `oa_attendstat` ADD `toLieu` decimal(12,2) NOT NULL DEFAULT 0.00 AFTER `toMakeup`;

ALTER TABLE `sys_user` ADD `annualLeave` text NOT NULL AFTER `lastService`;

INSERT INTO `sys_cron` (`m`, `h`, `dom`, `mon`, `dow`, `command`, `remark`, `type`, `buildin`, `status`, `lastTime`) VALUES
('30', '1', '1', '1', '*', 'appName=oa&moduleName=leave&methodName=giveAnnualLeave', '定时发放年假', 'zdoo', 1, 'normal', '0000-00-00 00:00:00');
