aboutsummaryrefslogblamecommitdiffstats
path: root/vendor/sabre/dav/examples/sql/mysql.locks.sql
blob: cf3caf4f71789fd2b292cdb3715664c386b0f6af (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12
13












                                                            
CREATE TABLE locks (
    id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    owner VARCHAR(100),
    timeout INTEGER UNSIGNED,
    created INTEGER,
    token VARCHAR(100),
    scope TINYINT,
    depth TINYINT,
    uri VARCHAR(1000),
    INDEX(token),
    INDEX(uri)
);