Code:
CREATE TABLE tblLog( id int identity, Log_Date datetime, Log_Type varchar(100), Log_Data varchar(2048), CONSTRAINT pkID3 PRIMARY KEY (ID) ) CREATE INDEX idx01 ON tblLog (Log_Date ASC) CREATE INDEX idx02 ON tblLog (Log_Type ASC) CREATE TABLE tblSyslog( id int identity, Syslog_Date datetime, Syslog_Facility int, Syslog_Severity int, Syslog_Hostname varchar(50), Syslog_Msg_Tag varchar(32), Syslog_Msg_Content varchar(2048), CONSTRAINT pkID4 PRIMARY KEY (ID) ) CREATE INDEX idx03 ON tblSyslog (Syslog_Date ASC) CREATE INDEX idx04 ON tblSyslog (Syslog_Facility ASC) CREATE INDEX idx05 ON tblSyslog (Syslog_Severity ASC) CREATE INDEX idx06 ON tblSyslog (Syslog_Hostname ASC) CREATE INDEX idx07 ON tblSyslog (Syslog_Msg_Tag ASC) CREATE TABLE tblDeviceValueLog(id int identity, ts datetime, hc char(1) NOT NULL, dc varchar(3) NOT NULL, data1 int NOT NULL, data2 int NOT NULL, CONSTRAINT pkID1 PRIMARY KEY (ID) ) CREATE INDEX idx08 ON tblDeviceValueLog (ts ASC) CREATE INDEX idx09 ON tblDeviceValueLog (hc ASC) CREATE INDEX idx10 ON tblDeviceValueLog (dc ASC) CREATE TABLE tblDeviceStatusLog(id int identity, ts datetime, hc char(1) NOT NULL, dc varchar(3) NOT NULL, status int NOT NULL, data1 int NOT NULL, data2 int NOT NULL, CONSTRAINT pkID2 PRIMARY KEY (ID) ) CREATE INDEX idx11 ON tblDeviceStatusLog (ts ASC) CREATE INDEX idx12 ON tblDeviceStatusLog (hc ASC) CREATE INDEX idx13 ON tblDeviceStatusLog (dc ASC)
Comment