diff options
| author | redmatrix <git@macgirvin.com> | 2016-05-10 17:26:44 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-05-10 17:26:44 -0700 |
| commit | 0b02a6d123b2014705998c94ddf3d460948d3eac (patch) | |
| tree | 78ff2cab9944a4f5ab3f80ec93cbe1120de90bb2 /vendor/sabre/dav/examples/sql/pgsql.locks.sql | |
| parent | 40b5b6e9d2da7ab65c8b4d38cdceac83a4d78deb (diff) | |
| download | volse-hubzilla-0b02a6d123b2014705998c94ddf3d460948d3eac.tar.gz volse-hubzilla-0b02a6d123b2014705998c94ddf3d460948d3eac.tar.bz2 volse-hubzilla-0b02a6d123b2014705998c94ddf3d460948d3eac.zip | |
initial sabre upgrade (needs lots of work - to wit: authentication, redo the browser interface, and rework event export/import)
Diffstat (limited to 'vendor/sabre/dav/examples/sql/pgsql.locks.sql')
| -rw-r--r-- | vendor/sabre/dav/examples/sql/pgsql.locks.sql | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/vendor/sabre/dav/examples/sql/pgsql.locks.sql b/vendor/sabre/dav/examples/sql/pgsql.locks.sql index ca6c82e96..0290528ce 100644 --- a/vendor/sabre/dav/examples/sql/pgsql.locks.sql +++ b/vendor/sabre/dav/examples/sql/pgsql.locks.sql @@ -4,10 +4,16 @@ CREATE TABLE locks ( timeout INTEGER, created INTEGER, token VARCHAR(100), - scope smallint, - depth smallint, - uri text + 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); |