· 5 years ago · Oct 21, 2020, 08:18 AM
1BEGIN EXCLUSIVE TRANSACTION;
2
3CREATE TABLE IF NOT EXISTS property(
4 id INTEGER PRIMARY KEY AUTOINCREMENT,
5 key TEXT NOT NULL UNIQUE,
6 value TEXT NOT NULL
7);
8
9INSERT OR IGNORE INTO property(key, value) VALUES ('molko.create-date', strftime('%s','now'));
10INSERT OR IGNORE INTO property(key, value) VALUES ('molko.update-date', strftime('%s','now'));
11
12COMMIT