secfilter-create.sql 363 B

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