Index: database.sql ================================================================== --- database.sql +++ database.sql @@ -150,13 +150,13 @@ id_site serial, site text[] NOT NULL ); ALTER TABLE ONLY site - ADD CONSTRAINT id_site PRIMARY KEY (id_site); + ADD CONSTRAINT site_pkey PRIMARY KEY (id_site); -CREATE UNIQUE INDEX site_s ON site (usort(site)); +CREATE UNIQUE INDEX site_u ON site (usort(site)); CREATE INDEX site_g ON site USING gin (site); -- table to hold tag combinations CREATE TABLE tag ( @@ -163,13 +163,13 @@ id_tag serial, tag text[] NOT NULL ); ALTER TABLE ONLY tag - ADD CONSTRAINT tag_id PRIMARY KEY (id_tag); + ADD CONSTRAINT tag_pkey PRIMARY KEY (id_tag); -CREATE UNIQUE INDEX tag_s ON tag (usort(tag)); +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 (