aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/sabre/dav/examples/sql/mysql.locks.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/sabre/dav/examples/sql/mysql.locks.sql')
-rw-r--r--vendor/sabre/dav/examples/sql/mysql.locks.sql9
1 files changed, 4 insertions, 5 deletions
diff --git a/vendor/sabre/dav/examples/sql/mysql.locks.sql b/vendor/sabre/dav/examples/sql/mysql.locks.sql
index cf3caf4f7..96a3a88d9 100644
--- a/vendor/sabre/dav/examples/sql/mysql.locks.sql
+++ b/vendor/sabre/dav/examples/sql/mysql.locks.sql
@@ -3,11 +3,10 @@ CREATE TABLE locks (
owner VARCHAR(100),
timeout INTEGER UNSIGNED,
created INTEGER,
- token VARCHAR(100),
+ token VARBINARY(100),
scope TINYINT,
depth TINYINT,
- uri VARCHAR(1000),
+ uri VARBINARY(1000),
INDEX(token),
- INDEX(uri)
-);
-
+ INDEX(uri(100))
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;