SQLite format 3@   .jÐûûƒ =  d › ç # [H‡R1Žktriggerfoo_a__crsql_utrigfooCREATE TRIGGER "foo_a__crsql_utrig" AFTER UPDATE OF "a" ON "foo" WHEN crsql_internal_sync_bit() = 0 AND NEW."a" IS NOT OLD."a" BEGIN INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT OLD."a", '-1', 2, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL WHERE true ON CONFLICT DO UPDATE SET __crsql_col_version = 1 + __crsql_col_version, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; DELETE FROM "foo__crsql_clock" WHERE "a" IS OLD."a" AND __crsql_col_name != '-1'; ENDˆ; -Atriggerfoo__crsql_itrigfooCREATE TRIGGER "foo__crsql_itrig" AFTER INSERT ON "foo" WHEN crsql_internal_sync_bit() = 0 BEGIN UPDATE "foo__crsql_clock" SET __crsql_col_version = CASE __crsql_col_version % 2 WHEN 0 THEN __crsql_col_version + 1 ELSE __crsql_col_version + 2 END, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL WHERE "a" IS NEW."a" AND __crsql_col_name = '-1'; INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT NEW."a", 'b', 1, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL ON CONFLICT DO UPDATE SET __crsql_col_version = __crsql_col_version + 1, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; END =-5indexfoo__crsql_clock_dbv_idxfoo__crsql_clock CREATE INDEX "foo__crsql_clock_dbv_idx" ON "foo__crsql_clock" ("__crsql_db_version")‚9 --„%tablefoo__crsql_clockfoo__crsql_clock CREATE TABLE "foo__crsql_clock" ( "a", __crsql_col_name TEXT NOT NULL, __crsql_col_version INT NOT NULL, __crsql_db_version INT NOT NULL, __crsql_site_id INT, __crsql_seq INT NOT NULL, PRIMARY KEY ("a", __crsql_col_name) )? S-indexsqlite_autoindex_foo__crsql_clock_1foo__crsql_clock 5Stablefoofoo CREATE TABLE foo (a primary key, b)% 9indexsqlite_autoindex_foo_1foo y9)index__crsql_siteid_site_id__crsql_siteidCREATE UNIQUE INDEX __crsql_siteid_site_id ON "__crsql_siteid" (site_id)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) ))Mtable__crsql_siteid__crsql_siteidCREATE TABLE "__crsql_siteid" (site_id BLOB NOT NULL, ordinal INTEGER PRIMARY KEY AUTOINCREMENT)f%%tablecrsql_mastercrsql_masterCREATE TABLE "crsql_master" ("key" TEXT PRIMARY KEY, "value" ANY)7K%indexsqlite_autoindex_crsql_master_1crsql_masterr33ƒ tablecrsql_tracked_peerscrsql_tracked_peersCREATE TABLE crsql_tracked_peers ("site_id" BLOB NOT NULL, "version" INTEGER NOT NULL, "seq" INTEGER DEFAULT 0, "tag" INTEGER, "event" INTEGER, PRIMARY KEY ("site_id", "tag", "event")) STRICTEY3indexsqlite_autoindex_crsql_tracked_peers_1crsql_tracked_peers   èè-crsqlite_versionIð ìì- crsqlite_version ëë,¾Õ‡E~tK€F6·¡½Ôf íí)__crsql_siteid ìì,¾Õ‡E~tK€F6·¡½Ôf úìóìì üðöðð öÒëßÒÒ  -1  b  b  b úââòêê -1bb b üì÷òìì   ø ¼±ƒ =  d › ç # [H‡R1Žktriggerfoo_a__crsql_utrigfooCREATE TRIGGER "foo_a__crsql_utrig" AFTER UPDATE OF "a" ON "foo" WHEN crsql_internal_sync_bit() = 0 AND NEW."a" IS NOT OLD."a" BEGIN INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT OLD."a", '-1', 2, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL WHERE true ON CONFLICT DO UPDATE SET __crsql_col_version = 1 + __crsql_col_version, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; DELETE FROM "foo__crsql_clock" WHERE "a" IS OLD."a" AND __crsql_col_name != '-1'; ENDˆ; -Atriggerfoo__crsql_itrigfooCREATE TRIGGER "foo__crsql_itrig" AFTER INSERT ON "foo" WHEN crsql_internal_sync_bit() = 0 BEGIN UPDATE "foo__crsql_clock" SET __crsql_col_version = CASE __crsql_col_version % 2 WHEN 0 THEN __crsql_col_version + 1 ELSE __crsql_col_version + 2 END, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL WHERE "a" IS NEW."a" AND __crsql_col_name = '-1'; INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT NEW."a", 'b', 1, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL ON CONFLICT DO UPDATE SET __crsql_col_version = __crsql_col_version + 1, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; END =-5indexfoo__crsql_clock_dbv_idxfoo__crsql_clock CREATE INDEX "foo__crsql_clock_dbv_idx" ON "foo__crsql_clock" ("__crsql_db_version")‚9 --„%tablefoo__crsql_clockfoo__crsql_clock CREATE TABLE "foo__crsql_clock" ( "a", __crsql_col_name TEXT NOT NULL, __crsql_col_version INT NOT NULL, __crsql_db_version INT NOT NULL, __crsql_site_id INT, __crsql_seq INT NOT NULL, PRIMARY KEY ("a", __crsql_col_name) )? S-indexsqlite_autoindex_foo__crsql_clock_1foo__crsql_clock 5Stablefoofoo CREATE TABLE foo (a primary key, b)% 9indexsqlite_autoindex_foo_1foo y9)index__crsql_siteid_site_id__crsql_siteidCREATE UNIQUE INDEX __crsql_siteid_site_id ON "__crsql_siteid" (site_id)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) ))Mtable__crsql_siteid__crsql_siteidCREATE TABLE "__crsql_siteid" (site_id BLOB NOT NULL, ordinal INTEGER PRIMARY KEY AUTOINCREMENT)f%%tablecrsql_mastercrsql_masterCREATE TABLE "crsql_master" ("key" TEXT PRIMARY KEY, "value" ANY)7K%indexsqlite_autoindex_crsql_master_1crsql_masterr33ƒ tablecrsql_tracked_peerscrsql_tracked_peersCREATE TABLE crsql_tracked_peers ("site_id" BLOB NOT NULL, "version" INTEGER NOT NULL, "seq" INTEGER DEFAULT 0, "tag" INTEGER, "event" INTEGER, PRIMARY KEY ("site_id", "tag", "event")) STRICTEY3indexsqlite_autoindex_crsql_tracked_peers_1crsql_tracked_peers y +Žy†-‹otriggerfoo__crsql_dtrigfooCREATE TRIGGER "foo__crsql_dtrig" AFTER DELETE ON "foo" WHEN crsql_internal_sync_bit() = 0 BEGIN INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT OLD."a", '-1', 2, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL WHERE true ON CONFLICT DO UPDATE SET __crsql_col_version = 1 + __crsql_col_version, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; DELETE FROM "foo__crsql_clock" WHERE "a" IS OLD."a" AND __crsql_col_name != '-1'; END‹-•triggerfoo__crsql_utrigfooCREATE TRIGGER "foo__crsql_utrig" AFTER UPDATE ON "foo" WHEN crsql_internal_sync_bit() = 0 BEGIN INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT NEW."a", '-1', 1, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL WHERE NEW."a" IS NOT OLD."a" ON CONFLICT DO UPDATE SET __crsql_col_version = CASE __crsql_col_version % 2 WHEN 0 THEN __crsql_col_version + 1 ELSE __crsql_col_version + 2 END, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT NEW."a", 'b', 1, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL WHERE NEW."b" IS NOT OLD."b" ON CONFLICT DO UPDATE SET __crsql_col_version = __crsql_col_version + 1, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; END‡R1Žktriggerfoo_a__crsql_utrigfooCREATE TRIGGER "foo_a__crsql_utrig" AFTER UPDATE OF "a" ON "foo" WHEN crsql_internal_sync_bit() = 0 AND NEW."a" IS NOT OLD."a" BEGIN INSERT INTO "foo__crsql_clock" ( "a", __crsql_col_name, __crsql_col_version, __crsql_db_version, __crsql_seq, __crsql_site_id ) SELECT OLD."a", '-1', 2, crsql_nextdbversion(), crsql_increment_and_get_seq(), NULL WHERE true ON CONFLICT DO UPDATE SET __crsql_col_version = 1 + __crsql_col_version, __crsql_db_version = crsql_nextdbversion(), __crsql_seq = crsql_get_seq() - 1, __crsql_site_id = NULL; DELETE FROM "foo__crsql_clock" WHERE "a" IS OLD."a" AND __crsql_col_name != '-1'; END