# HG changeset patch
# User David Demelier <markand@malikania.fr>
# Date 1603277411 -7200
# Node ID cd69c8791dacbbee95fb2367ad43c2e9bc9c8373
# Parent  6250883b81f0fb95cd4337de0f8db244daf80392
core: forgot to add .sql files

diff -r 6250883b81f0 -r cd69c8791dac libcore/core/assets/sql/init.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libcore/core/assets/sql/init.sql	Wed Oct 21 12:50:11 2020 +0200
@@ -0,0 +1,30 @@
+--
+-- init.sql -- initialize database
+--
+-- Copyright (c) 2020 David Demelier <markand@malikania.fr>
+--
+-- Permission to use, copy, modify, and/or distribute this software for any
+-- purpose with or without fee is hereby granted, provided that the above
+-- copyright notice and this permission notice appear in all copies.
+--
+-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
+-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
+-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
+-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
+-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
+-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
+-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
+--
+
+BEGIN EXCLUSIVE TRANSACTION;
+
+CREATE TABLE IF NOT EXISTS property(
+	id      INTEGER PRIMARY KEY AUTOINCREMENT,
+	key     TEXT NOT NULL UNIQUE,
+	value   TEXT NOT NULL
+);
+
+INSERT OR IGNORE INTO property(key, value) VALUES ('molko.create-date', strftime('%s','now'));
+INSERT OR IGNORE INTO property(key, value) VALUES ('molko.update-date', strftime('%s','now'));
+
+COMMIT;
diff -r 6250883b81f0 -r cd69c8791dac libcore/core/assets/sql/property-get.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libcore/core/assets/sql/property-get.sql	Wed Oct 21 12:50:11 2020 +0200
@@ -0,0 +1,21 @@
+--
+-- property-get.sql -- get a property
+--
+-- Copyright (c) 2020 David Demelier <markand@malikania.fr>
+--
+-- Permission to use, copy, modify, and/or distribute this software for any
+-- purpose with or without fee is hereby granted, provided that the above
+-- copyright notice and this permission notice appear in all copies.
+--
+-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
+-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
+-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
+-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
+-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
+-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
+-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
+--
+
+SELECT value
+  FROM property
+ WHERE key = ?
diff -r 6250883b81f0 -r cd69c8791dac libcore/core/assets/sql/property-remove.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libcore/core/assets/sql/property-remove.sql	Wed Oct 21 12:50:11 2020 +0200
@@ -0,0 +1,21 @@
+--
+-- property-remove.sql -- remove a property
+--
+-- Copyright (c) 2020 David Demelier <markand@malikania.fr>
+--
+-- Permission to use, copy, modify, and/or distribute this software for any
+-- purpose with or without fee is hereby granted, provided that the above
+-- copyright notice and this permission notice appear in all copies.
+--
+-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
+-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
+-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
+-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
+-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
+-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
+-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
+--
+
+DELETE
+  FROM property
+ WHERE key = ?
diff -r 6250883b81f0 -r cd69c8791dac libcore/core/assets/sql/property-set.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libcore/core/assets/sql/property-set.sql	Wed Oct 21 12:50:11 2020 +0200
@@ -0,0 +1,26 @@
+--
+-- property-set.sql -- set a property
+--
+-- Copyright (c) 2020 David Demelier <markand@malikania.fr>
+--
+-- Permission to use, copy, modify, and/or distribute this software for any
+-- purpose with or without fee is hereby granted, provided that the above
+-- copyright notice and this permission notice appear in all copies.
+--
+-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
+-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
+-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
+-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
+-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
+-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
+-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
+--
+
+INSERT OR REPLACE INTO property(
+	key,
+	value
+)
+VALUES(
+	?,
+	?
+)