CREATE TABLE atdtimeordercalendar
(
calendardate
date NOT NULL COMMENT ‘行事日期’,
TIMEORDERID
varchar(40) NOT NULL DEFAULT ‘’ COMMENT ‘班次ID’,
CALENDARTYPE
int(11) DEFAULT ‘0’ COMMENT ‘行事类型’
PRIMARY KEY (Id
) /*T![clustered_index] NONCLUSTERED */,
KEY ix_calendardate
(calendardate
),
KEY ix_TIMEORDERID
(TIMEORDERID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin