sqitch/deploy/add_location_information.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

-- Deploy guix-data-service:add_location_information to pg

BEGIN;

CREATE TABLE locations (
    id integer GENERATED BY DEFAULT AS IDENTITY,
    file character varying NOT NULL,
    line integer NOT NULL,
    column_number integer NOT NULL,
    CONSTRAINT file_line_column PRIMARY KEY(file, line, column_number),
    UNIQUE (id)
);

ALTER TABLE package_metadata ADD COLUMN location_id integer REFERENCES locations(id);

ALTER TABLE package_metadata DROP CONSTRAINT synopsis_description_home_page;

ALTER TABLE package_metadata ADD CONSTRAINT synopsis_description_home_page_location_id UNIQUE (synopsis, description, home_page, location_id);

COMMIT;