CREATE TABLE dchecks ( dcheckid bigint DEFAULT '0' NOT NULL, druleid bigint DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, key_ varchar(255) DEFAULT '0' NOT NULL, snmp_community varchar(255) DEFAULT '0' NOT NULL, ports varchar(255) DEFAULT '0' NOT NULL, PRIMARY KEY (dcheckid) ) with OIDS;