diff options
author | Aleksander Machniak <alec@alec.pl> | 2013-11-15 14:56:07 (GMT) |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2013-11-15 14:56:07 (GMT) |
commit | d69fc78e4175e1bc8e5921f0124ae5f0571d9bb3 (patch) | |
tree | 5863f31e9ca6bcd7971f40bf1b32e8d159d6c6e8 /doc/SQL/mysql.initial.sql | |
parent | b5fe149a3c903f13cb0a14000d4f1ba2f6edf94e (diff) | |
download | kolab-chwala-d69fc78e4175e1bc8e5921f0124ae5f0571d9bb3.tar.gz |
Implemented file locking API. Fixed error code in API response.
Diffstat (limited to 'doc/SQL/mysql.initial.sql')
-rw-r--r-- | doc/SQL/mysql.initial.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/doc/SQL/mysql.initial.sql b/doc/SQL/mysql.initial.sql new file mode 100644 index 0000000..d8fc11e --- /dev/null +++ b/doc/SQL/mysql.initial.sql @@ -0,0 +1,14 @@ +CREATE TABLE IF NOT EXISTS `locks` ( + `uri` varchar(512) BINARY NOT NULL, + `owner` varchar(256), + `timeout` integer unsigned, + `expires` datetime DEFAULT NULL, + `token` varchar(256), + `scope` tinyint, + `depth` tinyint, + INDEX `uri_index` (`uri`, `depth`), + INDEX `expires_index` (`expires`), + INDEX `token_index` (`token`) +) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; + +INSERT INTO `system` (`name`, `value`) VALUES ('chwala-version', '2013111300'); |