update.sql 1.1 KB

1234567891011121314151617181920
  1. -- auto-generated definition
  2. create table xd_schedule
  3. (
  4. id varchar(50) not null comment 'id'
  5. primary key,
  6. day date not null,
  7. week varchar(100) null,
  8. isworking tinyint(1) null comment '是否工作日',
  9. year int(4) null comment '年份',
  10. month int(2) null comment '月份',
  11. weeknum int(10) null comment '周序号',
  12. dayofweek int(1) null comment '星期几',
  13. create_by varchar(32) null comment '创建人',
  14. create_time datetime null comment '创建时间',
  15. update_by varchar(32) null comment '修改人',
  16. update_time datetime null comment '修改时间',
  17. del_flag tinyint(1) null comment '删除标识0-正常,1-已删除'
  18. )
  19. CHARSET=utf8 comment '时间表';
  20. INSERT INTO `sys_permission` VALUES ('xd_schedule', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '时间表', '/xd_schedule', 'append/XdSchedule/XdScheduleList', null, null, '1', null, '1', '99.00', '0', 'hourglass', '1', '1', '0', '0', null, 'admin', '2019-10-29 09:53:51', 'admin', '2019-12-02 16:41:48', '0', '0', '1', '0');