secfilter-create.sql 315 B

1234567891011
  1. CREATE TABLE secfilter (
  2. id SERIAL 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');