aboutsummaryrefslogblamecommitdiffstats
path: root/vendor/examples/sql/pgsql.locks.sql
blob: 0290528cecb663337df078739130a36e94b94d8b (plain) (tree)
1
2
3
4
5
6
7
8
9





                       


                   



                                               





                                 
CREATE TABLE locks (
    id SERIAL NOT NULL,
    owner VARCHAR(100),
    timeout INTEGER,
    created INTEGER,
    token VARCHAR(100),
    scope SMALLINT,
    depth SMALLINT,
    uri TEXT
);

ALTER TABLE ONLY locks
    ADD CONSTRAINT locks_pkey PRIMARY KEY (id);

CREATE INDEX locks_token_ix
    ON locks USING btree (token);

CREATE INDEX locks_uri_ix
    ON locks USING btree (uri);