Add test suite for database upgrades

[cascardo/ipsilon.git] / tests / blobs / old_dbs / v1 / openid.sqlite.dump

diff --git a/tests/blobs/old_dbs/v1/openid.sqlite.dump b/tests/blobs/old_dbs/v1/openid.sqlite.dump
new file mode 100644 (file)
index 0000000..4618785
--- /dev/null
+++ b/tests/blobs/old_dbs/v1/openid.sqlite.dump
@@ -0,0 +1,14 @@
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE dbinfo (
+       name TEXT NOT NULL, 
+       option TEXT NOT NULL, 
+       value TEXT
+);
+INSERT INTO "dbinfo" VALUES('OpenIDStore_schema','version','1');
+CREATE TABLE association (
+       uuid TEXT NOT NULL, 
+       name TEXT NOT NULL, 
+       value TEXT
+);
+COMMIT;