39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
-
+
|
CREATE UNIQUE INDEX tag_u ON tag (usort(tag));
CREATE INDEX tag_g ON tag USING gin (tag);
-- table to hold tag - site links
CREATE TABLE urls (
date_added timestamp without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
id_site smallint NOT NULL,
id_site integer NOT NULL,
id_tag smallint NOT NULL,
regexp text
);
CREATE UNIQUE INDEX urls_pkey ON urls USING btree (id_site, regexp);
CREATE INDEX urls_id_tag ON urls USING btree (id_tag);
|