25 lines
1020 B
Plaintext
25 lines
1020 B
Plaintext
CREATE TABLE `employeeappcode` (
|
|
`Oid` BIGINT(19) NULL AUTO_INCREMENT COMMENT '',
|
|
`Employeeoid` BIGINT(19) NULL COMMENT '',
|
|
`Tid` INT(10) NULL COMMENT '',
|
|
`Notice` VARCHAR(1024) NULL COMMENT '',
|
|
`InsTs` DATETIME NULL COMMENT '',
|
|
`InsUser` VARCHAR(1024) NULL COMMENT '',
|
|
`Version` BIGINT(19) NULL COMMENT '',
|
|
`UdpUser` VARCHAR(256) NULL COMMENT '',
|
|
`IsActive` TINYINT(4) NULL COMMENT '',
|
|
`SystemEntryID` INT(10) NULL COMMENT '',
|
|
`EmployeeCode` VARCHAR(1024) NULL COMMENT '',
|
|
`EmployeeCodegenDate` DATETIME NULL COMMENT '',
|
|
`IsChatActive` VARCHAR(45) NULL COMMENT '',
|
|
PRIMARY KEY (`Oid`) COMMENT '');
|
|
|
|
ALTER TABLE `employeeappcode`
|
|
CHANGE COLUMN `EmployeeCode` `EmployeeCode` VARCHAR(512) NULL DEFAULT NULL COMMENT '' ,
|
|
CHANGE COLUMN `IsChatActive` `IsChatActive` VARCHAR(45) NULL DEFAULT 0 COMMENT '' ,
|
|
ADD UNIQUE INDEX `EmployeeCode_UNIQUE` (`EmployeeCode` ASC) COMMENT '';
|
|
|
|
|
|
ALTER TABLE `employeeappcode`
|
|
ADD COLUMN `NotfallStatement` VARCHAR(1024) NULL COMMENT '' AFTER `IsChatActive`;
|