summaryrefslogtreecommitdiff
path: root/doc/SQL/mysql.initial.sql
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2013-11-15 14:56:07 (GMT)
committerAleksander Machniak <alec@alec.pl>2013-11-15 14:56:07 (GMT)
commitd69fc78e4175e1bc8e5921f0124ae5f0571d9bb3 (patch)
tree5863f31e9ca6bcd7971f40bf1b32e8d159d6c6e8 /doc/SQL/mysql.initial.sql
parentb5fe149a3c903f13cb0a14000d4f1ba2f6edf94e (diff)
downloadkolab-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.sql14
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');