aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/examples/sql/mysql.locks.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/examples/sql/mysql.locks.sql')
-rw-r--r--vendor/examples/sql/mysql.locks.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/vendor/examples/sql/mysql.locks.sql b/vendor/examples/sql/mysql.locks.sql
new file mode 100644
index 000000000..96a3a88d9
--- /dev/null
+++ b/vendor/examples/sql/mysql.locks.sql
@@ -0,0 +1,12 @@
+CREATE TABLE locks (
+ id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ owner VARCHAR(100),
+ timeout INTEGER UNSIGNED,
+ created INTEGER,
+ token VARBINARY(100),
+ scope TINYINT,
+ depth TINYINT,
+ uri VARBINARY(1000),
+ INDEX(token),
+ INDEX(uri(100))
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;