CREATE TABLE psnaccount
(
PERSONID
varchar(40) NOT NULL DEFAULT ‘’ COMMENT ‘人员Id’
PRIMARY KEY (PERSONID
) /*T![clustered_index] NONCLUSTERED */,
UNIQUE KEY EMPLOYEEID
(EMPLOYEEID
),
KEY ix_psnaccount_TPB
(TRUENAME
,PERSONID
,BRANCHID
),
KEY ix_psnaccount_PERSONID
(PERSONID
),
KEY ix_psnaccount_TRUENAME
(TRUENAME
),
KEY ix_psnaccount_BE
(BRANCHID
,EMPLOYEEID
),
KEY ix_psnaccount_EA
(EMPLOYEEID
,ATTENDONDATE
),
KEY idx_ATTENDONDATE
(ATTENDONDATE
),
KEY idx_DIMISSIONDATE
(DIMISSIONDATE
),
KEY idx_EmployeeTypeId
(EMPLOYEETYPEID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin