Changeset 85

Timestamp:

09/11/25 17:47:47 (3 days ago)

Author:

Kris Deugau

Message:

/trunk/dnsbl

Refresh SQL definition

File:

• trunk/dnsbl/dnsbl.sql (modified) (5 diffs)

trunk/dnsbl/dnsbl.sql

@@ -15 +15 @@
     listme boolean DEFAULT false,
     orgid integer,
-    "level" integer DEFAULT 0,
+    level integer DEFAULT 0,
     comments text DEFAULT ''::text,
     parent cidr NOT NULL,
-    ipcount integer NOT NULL
+    ipcount integer NOT NULL,
+    exclude boolean DEFAULT false,
+    added timestamp with time zone DEFAULT now()
 );
 
@@ -31 +33 @@
     s4list boolean DEFAULT false,
     added timestamp with time zone DEFAULT now(),
-    parent cidr NOT NULL
+    parent cidr NOT NULL,
+    exclude boolean DEFAULT false
 );
 
@@ -56 +59 @@
 );
 
+CREATE SEQUENCE orgs_orgid_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+ALTER SEQUENCE orgs_orgid_seq OWNED BY orgs.orgid;
+ALTER TABLE ONLY orgs ALTER COLUMN orgid SET DEFAULT nextval('orgs_orgid_seq'::regclass);
+
 
 --
@@ -78 +90 @@
     s4list boolean DEFAULT false,
     origadded timestamp with time zone DEFAULT now(),
-    delisted timestamp with time zone DEFAULT now()
+    delisted timestamp with time zone DEFAULT now(),
+    exclude boolean DEFAULT false
 );
 
@@ -162 +175 @@
 12      46
 11      50
-10      54
-9       58
-8       62
+10      56
+9       64
+8       72
 7       2147483648
 6       2147483648