summaryrefslogtreecommitdiff
path: root/etc/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'etc/init.sql')
-rw-r--r--etc/init.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/etc/init.sql b/etc/init.sql
new file mode 100644
index 0000000..5c5ef49
--- /dev/null
+++ b/etc/init.sql
@@ -0,0 +1,15 @@
+PRAGMA foreign_keys = ON;
+PRAGMA journal_mode = WAL;
+PRAGMA synchronous = NORMAL;
+PRAGMA mmap_size = 134217728; -- 128 megabytes
+PRAGMA journal_size_limit = 67108864; -- 64 megabytes
+PRAGMA cache_size = 2000;
+
+-- datomic schema
+CREATE TABLE IF NOT EXISTS datomic_kvs (
+ id TEXT NOT NULL,
+ rev INTEGER,
+ map TEXT,
+ val BYTEA,
+ CONSTRAINT pk_id PRIMARY KEY (id)
+);