summaryrefslogtreecommitdiff
path: root/doc/SQL/mysql.initial.sql
blob: d8fc11effd5143ca09f7a1cc4882ee81955ebd40 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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');