diff options
Diffstat (limited to 'vendor/examples/sql/mysql.locks.sql')
-rw-r--r-- | vendor/examples/sql/mysql.locks.sql | 12 |
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; |