gdymtsceshi/WebContent/assets/lib/jquery-workday/table.sql

-- **************************************************
-- Name:        x_workday
-- Purpose:     工作日节假日表
-- Deviser:     韩林平
-- Devistime:   2018-10-19
-- **************************************************
drop table x_workday;
create table x_workday
(
   TDate            VARCHAR(10)     not null, -- 自然日
   TYear            VARCHAR(4)      not null, -- 所属年   
   TType            VARCHAR(80)             , -- 日期类型  工作日，节假日
   TInfo            VARCHAR(80)             , -- 节假日描述  春节，调休  
   constraint PK_x_workday primary key (TDate)
);
create index IX_x_workday_TYear on x_workday(TYear);  
create index IX_x_workday_TType on x_workday(TType); 


INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
        VALUES ('0606','初始化节假日','06','/0/06/0606/','0','/myconsole/complaint/workday/initData','','true','true','complaint.workday.initData','menu','6.00'); 
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
        VALUES ('0607','管理节假日','06','/0/06/0607/','0','/myconsole/complaint/workday/workDay','','true','true','complaint.workday.workDay','menu','7.00');