vendor/sabre/dav/examples/sql/pgsql.locks.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

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);