1 -- update script 2003-12-12 by rk
3 -- * adds filter and filtergroups to the database
5 -- This script will terminate with an error the second time it's run,
6 -- so running this script when it isn't needed can't do any harm.
11 CREATE SEQUENCE "filter_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
13 CREATE TABLE "filter" (
14 "id" integer DEFAULT nextval('filter_id_seq'::text) NOT NULL,
16 "filter_group_id" integer,
17 "type" character varying(255) NOT NULL,
18 "expression" character varying(255) NOT NULL,
19 "tag" character varying(255) NOT NULL,
21 "articleaction" character varying(255) NOT NULL,
22 "commentaction" character varying(255) NOT NULL,
23 "last_hit" timestamp with time zone
30 CREATE SEQUENCE "filter_group_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
32 CREATE TABLE "filter_group" (
33 "id" integer DEFAULT nextval('filter_group_id_seq'::text) NOT NULL,
34 "name" character varying(255),