CREATE TABLE atdadjusttimeorder
(
begindate
date NOT NULL COMMENT ‘开始日期’,
enddate
date NOT NULL COMMENT ‘结束日期’,
PERSONID
varchar(40) NOT NULL DEFAULT ‘’ COMMENT ‘人员ID’,
TIMEORDERID
varchar(40) DEFAULT ‘’ COMMENT ‘班次ID’
PRIMARY KEY (Id
) /*T![clustered_index] NONCLUSTERED */,
KEY ATDADJUSTTIMEORDER_Main
(PERSONID
,begindate
,enddate
),
KEY ix_TIMEORDERID
(TIMEORDERID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin