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