| 12345678910111213141516171819202122232425 |
- -- **************************************************
- -- Name: x_workday
- -- Purpose: 工作日节假日表
- -- Deviser: 韩林平
- -- Devistime: 2018-04-27
- -- **************************************************
- 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');
-
-
|
