secfilter-create.sql 364 B

1234567891011
  1. CREATE TABLE `secfilter` (
  2. `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
  3. `action` TINYINT(1) DEFAULT 0 NOT NULL,
  4. `type` TINYINT(1) 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');