Mercurial > molko

comparison libmlk-core/assets/sql/init.sql @ 243:71b3b7036de7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: lot of cleanups, - prefix libraries with libmlk, - move assets from source directories closes #2520, - prefix header guards closes #2519
author David Demelier <markand@malikania.fr>
date Sat, 28 Nov 2020 22:37:30 +0100
parents libcore/core/assets/sql/init.sql@cd69c8791dac
children
comparison
equal deleted inserted replaced
242:4c24604efcab 243:71b3b7036de7
1 --
2 -- init.sql -- initialize database
3 --
4 -- Copyright (c) 2020 David Demelier <markand@malikania.fr>
5 --
6 -- Permission to use, copy, modify, and/or distribute this software for any
7 -- purpose with or without fee is hereby granted, provided that the above
8 -- copyright notice and this permission notice appear in all copies.
9 --
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
17 --
18
19 BEGIN EXCLUSIVE TRANSACTION;
20
21 CREATE TABLE IF NOT EXISTS property(
22 id INTEGER PRIMARY KEY AUTOINCREMENT,
23 key TEXT NOT NULL UNIQUE,
24 value TEXT NOT NULL
25 );
26
27 INSERT OR IGNORE INTO property(key, value) VALUES ('molko.create-date', strftime('%s','now'));
28 INSERT OR IGNORE INTO property(key, value) VALUES ('molko.update-date', strftime('%s','now'));
29
30 COMMIT;