owang.tw-logger-jdbc.1.1.1.3.source-code.schema.sql Maven / Gradle / Ivy
CREATE TABLE IF NOT EXISTS `Operationlog`(
`ID` VARCHAR(32) PRIMARY KEY NOT NULL,
`software` VARCHAR(150) NOT NULL ,
`version` VARCHAR(10) NOT NULL ,
`CreatelogDate` TIMESTAMP NOT NULL ,
`ClientIP` VARCHAR(15) NOT NULL ,
`Operation` INTEGER NOT NULL ,
`Model` VARCHAR(30) NOT NULL ,
`SeatNo` VARCHAR(32) ,
`Operator` VARCHAR(30) ,
`OperatorID` VARCHAR(64) ,
`OperatorDeptName` VARCHAR(150),
`OperatorDeptCode` VARCHAR(64),
`CreateDate` TIMESTAMP NOT NULL
);