Changeset 79

Timestamp:

09/11/25 16:26:15 (3 days ago)

Author:

Kris Deugau

Message:

/trunk/uribl

Refresh SQL definition

File:

• trunk/uribl/uridb.sql (modified) (1 diff)

trunk/uribl/uridb.sql

@@ -4 +4 @@
 );
 
+-- Live examples have been observed for URIs over 70 characters
 CREATE TABLE urilist (
-        uri varchar(70) primary key not null,
-        list integer default 2,
-        count integer default 1,
-        added timestamp with time zone default now(),
-        comment varchar(200) not null default ''
+    uri character varying NOT NULL,
+    list integer DEFAULT 2,
+    count integer DEFAULT 1,
+    added timestamp with time zone DEFAULT now(),
+    comment character varying DEFAULT ''::character varying NOT NULL
 );
 
+ALTER TABLE ONLY urilist
+    ADD CONSTRAINT urilist_pkey PRIMARY KEY (uri);
+
 CREATE TABLE waslisted (
-        uri varchar(70) primary key not null,
-        list integer default 2,
-        count integer default 1,
-        origadded timestamp with time zone default now(),
-        comment varchar(200) not null default '',
-        delisted timestamp with time zone default now()
+    uri character varying NOT NULL,
+    list integer DEFAULT 2,
+    count integer DEFAULT 1,
+    origadded timestamp with time zone DEFAULT now() NOT NULL,
+    comment character varying DEFAULT ''::character varying NOT NULL,
+    delisted timestamp with time zone DEFAULT now()
 );
 
+ALTER TABLE ONLY waslisted
+    ADD CONSTRAINT waslisted_pkey PRIMARY KEY (uri, origadded);