CREATE TABLE T_EVENTS
(
RECINDEX INTEGER NOT NULL,
RECTIME DOUBLE PRECISION NOT NULL,
MODULENAME VARCHAR(32) NOT NULL,
UNITNAME VARCHAR(32) NOT NULL,
ERRTYPE SMALLINT NOT NULL,
ERRCODE VARCHAR(48) NOT NULL,
ERRMARK SMALLINT NOT NULL,
ERRVALUE DOUBLE PRECISION,
ERRVKIND INTEGER,
ERRVDESC VARCHAR(200),
OPUSERNAME VARCHAR(64),
STATUS SMALLINT NOT NULL,
CONSTRAINT K_T_EVENTS PRIMARY KEY(RECINDEX)
) |
String sSQL =
_T("CREATE TABLE T_EVENTS\r\n")
_T("(\r\n")
_T(" RECINDEX INTEGER NOT NULL,\r\n")
_T(" RECTIME DOUBLE PRECISION NOT NULL,\r\n")
_T(" MODULENAME VARCHAR(32) NOT NULL,\r\n")
_T(" UNITNAME VARCHAR(32) NOT NULL,\r\n")
_T(" ERRTYPE SMALLINT NOT NULL,\r\n")
_T(" ERRCODE VARCHAR(48) NOT NULL,\r\n")
_T(" ERRMARK SMALLINT NOT NULL,\r\n")
_T(" ERRVALUE DOUBLE PRECISION,\r\n")
_T(" ERRVKIND INTEGER,\r\n")
_T(" ERRVDESC VARCHAR(200),\r\n")
_T(" OPUSERNAME VARCHAR(64),\r\n")
_T(" STATUS SMALLINT NOT NULL,\r\n")
_T(" CONSTRAINT K_T_EVENTS PRIMARY KEY(RECINDEX)\r\n")
_T(")\r\n")
; |
