Mercurial > hg > orthanc-databases

comparison MySQL/Plugins/PrepareIndex.sql @ 16:9e419261f1c9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
mysql storage area working
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 10 Jul 2018 10:10:35 +0200
parents 7cea966b6829
children cd9521e04249
comparison
equal deleted inserted replaced
15:dfc7002add9c 16:9e419261f1c9
1 CREATE TABLE GlobalProperties( 1 CREATE TABLE GlobalProperties(
2 property INTEGER PRIMARY KEY, 2 property INTEGER PRIMARY KEY,
3 value TEXT 3 value TEXT
4 ); 4 );
5 5
6 -- Set GlobalProperty_DatabaseSchemaVersion
7 INSERT INTO GlobalProperties VALUES (1, '6');
8
9 CREATE TABLE Resources( 6 CREATE TABLE Resources(
10 internalId BIGINT NOT NULL AUTO_INCREMENT, 7 internalId BIGINT NOT NULL AUTO_INCREMENT,
11 resourceType INTEGER NOT NULL, 8 resourceType INTEGER NOT NULL,
12 publicId VARCHAR(64) NOT NULL, 9 publicId VARCHAR(64) NOT NULL,
13 parentId BIGINT, 10 parentId BIGINT,