CREATE TABLE `secfilter` ( `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, `action` SMALLINT DEFAULT 0 NOT NULL, `type` SMALLINT DEFAULT 0 NOT NULL, `data` VARCHAR(64) DEFAULT '' NOT NULL ); CREATE INDEX secfilter_idx ON secfilter (`action`, `type`, `data`); INSERT INTO version (table_name, table_version) values ('secfilter','1');