1CREATE TABLE moc_archive_events (
 2    sensing_time timestamp NOT NULL,
 3    sid_num smallint NOT NULL,
 4    msg_id varchar(100) NOT NULL,
 5    category varchar(50) NOT NULL,
 6    domain varchar(50) NOT NULL,
 7    event_id varchar(100) NOT NULL,
 8    event_type varchar(50) NOT NULL,
 9    gen_time timestamp NOT NULL,
10    source varchar(50) NOT NULL,
11    application varchar(50) NOT NULL,
12    severity varchar(50) NOT NULL,
13    msg_type varchar(50) NOT NULL,
14    workstation varchar(50) NOT NULL,
15    message varchar(2048) NOT NULL
16);
17ALTER TABLE moc_archive_events ADD CONSTRAINT moc_archive_events_idx0 PRIMARY KEY (sid_num,sensing_time,application);