kioku-migrations 0.13.0.0 → 0.14.0.0
raw patch · 4 files changed
+119/−35 lines, 4 filesdep ~keiro-migrationsdep ~keiro-test-supportdep ~kioku-migrationsPVP ok
version bump matches the API change (PVP)
Dependency ranges changed: keiro-migrations, keiro-test-support, kioku-migrations
API changes (from Hackage documentation)
Files
- CHANGELOG.md +7/−0
- kioku-migrations.cabal +7/−6
- test/Main.hs +73/−29
- test/fixtures/keiro-0.24.0.0/SHA256SUMS +32/−0
CHANGELOG.md view
@@ -1,5 +1,12 @@ # Changelog +## 0.14.0.0 — 2026-11-21++### Changed++- Compose 65 migrations (17 Store, 33 Keiro, 15 Kioku). On a fully migrated Kioku 0.13 database, `keiro/0033` adds nullable trace fields to timers and workflows.+- Check the released Keiro migration checksums and test the incremental upgrade from a complete Kioku 0.13 database.+ ## 0.13.0.0 — 2026-11-08 ### Changed
kioku-migrations.cabal view
@@ -1,6 +1,6 @@ cabal-version: 3.0 name: kioku-migrations-version: 0.13.0.0+version: 0.14.0.0 synopsis: Schema migrations for kioku description: Owns kioku schema evolution as a native pg-migrate component and composes@@ -27,6 +27,7 @@ migrations/*.sql migrations/manifest test/fixtures/*.sql+ test/fixtures/keiro-0.24.0.0/SHA256SUMS test/fixtures/kiroku-0.6.0.0/*.sql test/fixtures/kiroku-0.6.0.0/README.md test/fixtures/kiroku-0.6.0.0/SHA256SUMS@@ -80,7 +81,7 @@ containers >=0.6 && <0.8, hasql >=1.10 && <1.11, hasql-transaction >=1.2 && <1.3,- keiro-migrations ^>=0.24.0.0,+ keiro-migrations ^>=0.26.0.0, kiroku-store-migrations ^>=0.7.3.0, pg-migrate ^>=1.2.0.0, pg-migrate-embed ^>=1.2.0.0,@@ -97,8 +98,8 @@ base >=4.18 && <5, directory >=1.3 && <1.4, ephemeral-pg >=0.3.1 && <0.4,- keiro-test-support ^>=0.24.0.0,- kioku-migrations ^>=0.13.0.0,+ keiro-test-support ^>=0.26.0.0,+ kioku-migrations ^>=0.14.0.0, text >=2.0 && <2.2, unix >=2.8 && <2.9, @@ -120,8 +121,8 @@ bytestring >=0.11 && <0.13, containers >=0.6 && <0.8, hasql >=1.6,- keiro-migrations ^>=0.24.0.0,- kioku-migrations ^>=0.13.0.0,+ keiro-migrations ^>=0.26.0.0,+ kioku-migrations ^>=0.14.0.0, kioku-migrations:test-support, kiroku-store-migrations ^>=0.7.3.0, pg-migrate ^>=1.2.0.0,
test/Main.hs view
@@ -30,6 +30,7 @@ HistoryImportOutcome (AlreadyImported, Imported), HistoryImportReport (..), HistoryImportResult (..),+ MigrationComponent, MigrationId, MigrationOutcome (AlreadyApplied, AppliedNow), MigrationPlan,@@ -89,9 +90,10 @@ ], testCase "the full migration chain applies to a fresh database" testFreshDatabase, testCase "0.10.0.0 upgrades with one recency index and unchanged rows" testRecencyUpgrade,- testCase "the released previous cohort preserves data and checkpoints through 0013–0017" testPreviousCohortUpgrade,- testCase "the 62-entry Keiro 0.21 cohort adds Kiroku 0016 and 0017" testKeiro021Upgrade,- testCase "the 63-entry Keiro 0.22 cohort adds only Kiroku 0017" testKeiro022Upgrade,+ testCase "the released previous cohort preserves data and checkpoints through the store and timer upgrades" testPreviousCohortUpgrade,+ testCase "the 62-entry Keiro 0.21 cohort adds Kiroku 0016/0017 and Keiro 0033" testKeiro021Upgrade,+ testCase "the 63-entry Keiro 0.22 cohort adds Kiroku 0017 and Keiro 0033" testKeiro022Upgrade,+ testCase "the 64-entry Keiro 0.24 cohort preserves a pending timer through 0033" testKeiro024Upgrade, testCase "a changed previous checksum refuses before migration writes" testKeiro021ChecksumRefusal, testGroup "migration-session isolation"@@ -450,8 +452,7 @@ Nothing -> fail ("no manifest migration named " <> name) Just bytes -> pure (Text.Encoding.decodeUtf8 bytes) --- | A genuine released 12-entry Kiroku manifest, composed with the unchanged--- Keiro and Kioku payloads. No current SQL is sliced to simulate old history.+-- | Upgrade a released 12-entry Kiroku manifest with the historical framework component. testPreviousCohortUpgrade :: Assertion testPreviousCohortUpgrade = withBareDatabase $ \connStr -> do let fixtureRoot = "test/fixtures/kiroku-0.6.0.0/"@@ -461,7 +462,7 @@ [(name, checksumHex bytes) | (name, bytes) <- toList entries] @?= frozen length entries @?= 12 oldKiroku <- either (assertFailure . show) pure (migrationComponentFromEmbeddedSql "kiroku" Set.empty entries)- keiro <- either (assertFailure . show) pure KeiroMigrations.keiroMigrations+ keiro <- previousKeiroComponent kioku <- either (assertFailure . show) pure kiokuMigrations old <- either (assertFailure . show) pure (migrationPlan (oldKiroku :| [keiro, kioku])) current <- either (assertFailure . show) pure kiokuMigrationPlan@@ -476,7 +477,7 @@ checkpointsBefore <- query connStr previousCheckpointSnapshot query connStr previousCohortIsLegacy >>= (@?= True) migrated <- runMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure- appliedNow migrated @?= [expectRight (migrationId "kiroku" n) | n <- ["0013", "0014", "0015", "0016", "0017"]]+ appliedNow migrated @?= [expectRight (migrationId "kiroku" n) | n <- ["0013", "0014", "0015", "0016", "0017"]] <> [timerTraceMigration] query connStr previousCohortSnapshot >>= (@?= before) query connStr previousCohortLedger >>= (@?= ledgerBefore) query connStr previousCheckpointSnapshot >>= (@?= checkpointsBefore)@@ -484,12 +485,12 @@ verification <- verifyMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure let VerificationReport {issues, appliedMigrations, pendingMigrations, unknownMigrations} = verification issues @?= []- length appliedMigrations @?= 64+ length appliedMigrations @?= 65 pendingMigrations @?= [] unknownMigrations @?= [] repeated <- runMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure let MigrationReport {results} = repeated- length [() | MigrationResult {outcome = AlreadyApplied} <- toList results] @?= 64+ length [() | MigrationResult {outcome = AlreadyApplied} <- toList results] @?= 65 appliedNow repeated @?= [] query connStr previousCohortSnapshot >>= (@?= before) query connStr previousCheckpointSnapshot >>= (@?= checkpointsBefore)@@ -549,6 +550,7 @@ SELECT jsonb_agg(to_jsonb(t) ORDER BY component, migration)::text FROM pgmigrate.migrations t WHERE NOT (component = 'kiroku' AND migration IN ('0013', '0014', '0015', '0016', '0017'))+ AND NOT (component = 'keiro' AND migration = '0033') """ E.noParams (D.singleRow (D.column (D.nonNullable D.text)))@@ -587,7 +589,7 @@ entries <- checkMigrationManifest "test/fixtures/kiroku-0.7.1.0/manifest" >>= either (assertFailure . show) pure [(Text.dropEnd 4 (Text.pack name), checksumHex bytes) | (name, bytes) <- toList entries] @?= previous021Checksums oldKiroku <- either (assertFailure . show) pure (migrationComponentFromEmbeddedSql "kiroku" Set.empty entries)- keiro <- either (assertFailure . show) pure KeiroMigrations.keiroMigrations+ keiro <- previousKeiroComponent kioku <- either (assertFailure . show) pure kiokuMigrations either (assertFailure . show) pure (migrationPlan (oldKiroku :| [keiro, kioku])) @@ -629,7 +631,7 @@ ledgerWithout0016And0017 :: Statement () Text ledgerWithout0016And0017 = preparable- "SELECT jsonb_agg(to_jsonb(t) ORDER BY component,migration)::text FROM pgmigrate.migrations t WHERE NOT (component='kiroku' AND migration IN ('0016','0017'))"+ "SELECT jsonb_agg(to_jsonb(t) ORDER BY component,migration)::text FROM pgmigrate.migrations t WHERE NOT (component='kiroku' AND migration IN ('0016','0017')) AND NOT (component='keiro' AND migration='0033')" E.noParams (D.singleRow (D.column (D.nonNullable D.text))) @@ -649,7 +651,7 @@ checkpoints <- query connStr previousCheckpointSnapshot current <- either (assertFailure . show) pure kiokuMigrationPlan migrated <- runMigrationPlan defaultRunOptions (Settings.connectionString connStr) current >>= either (assertFailure . show) pure- appliedNow migrated @?= [expectRight (migrationId "kiroku" n) | n <- ["0016", "0017"]]+ appliedNow migrated @?= [expectRight (migrationId "kiroku" n) | n <- ["0016", "0017"]] <> [timerTraceMigration] query connStr previousCohortSnapshot >>= (@?= rows) query connStr ledgerWithout0016And0017 >>= (@?= ledger) query connStr bindingsSnapshot >>= (@?= bindings)@@ -657,14 +659,14 @@ verification <- verifyMigrationPlan defaultRunOptions (Settings.connectionString connStr) current >>= either (assertFailure . show) pure let VerificationReport {issues, appliedMigrations, pendingMigrations, unknownMigrations} = verification issues @?= []- length appliedMigrations @?= 64+ length appliedMigrations @?= 65 pendingMigrations @?= [] unknownMigrations @?= [] beforeRepeat <- query connStr fullLedgerSnapshot repeated <- runMigrationPlan defaultRunOptions (Settings.connectionString connStr) current >>= either (assertFailure . show) pure appliedNow repeated @?= [] let MigrationReport {results} = repeated- length [() | MigrationResult {outcome = AlreadyApplied} <- toList results] @?= 64+ length [() | MigrationResult {outcome = AlreadyApplied} <- toList results] @?= 65 query connStr fullLedgerSnapshot >>= (@?= beforeRepeat) query connStr previousCohortSnapshot >>= (@?= rows) query connStr bindingsSnapshot >>= (@?= bindings)@@ -680,7 +682,7 @@ [(Text.dropEnd 4 (Text.pack name), checksumHex bytes) | (name, bytes) <- toList frozen] @?= previous021Checksums <> [("0016", "53b22f14e20af7af0f444877544217a2433939be6a9a245295485e2f87228ee4")] oldKiroku <- either (assertFailure . show) pure (migrationComponentFromEmbeddedSql "kiroku" Set.empty frozen)- keiro <- either (assertFailure . show) pure KeiroMigrations.keiroMigrations+ keiro <- previousKeiroComponent kioku <- either (assertFailure . show) pure kiokuMigrations either (assertFailure . show) pure (migrationPlan (oldKiroku :| [keiro, kioku])) @@ -701,9 +703,9 @@ before <- verifyMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure let VerificationReport {appliedMigrations = previousApplied, pendingMigrations = pending} = before length previousApplied @?= 63- pending @?= [expectRight (migrationId "kiroku" "0017")]+ pending @?= [expectRight (migrationId "kiroku" "0017"), timerTraceMigration] migrated <- runMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure- appliedNow migrated @?= [expectRight (migrationId "kiroku" "0017")]+ appliedNow migrated @?= [expectRight (migrationId "kiroku" "0017"), timerTraceMigration] query connStr previousCohortSnapshot >>= (@?= rows) query connStr ledgerWithout0017 >>= (@?= ledger) query connStr bindingsSnapshot >>= (@?= bindings)@@ -713,24 +715,65 @@ verification <- verifyMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure let VerificationReport {issues, appliedMigrations, pendingMigrations, unknownMigrations} = verification issues @?= []- length appliedMigrations @?= 64+ length appliedMigrations @?= 65 pendingMigrations @?= [] unknownMigrations @?= [] after <- query connStr fullLedgerSnapshot repeated <- runMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure appliedNow repeated @?= [] let MigrationReport {results} = repeated- length [() | MigrationResult {outcome = AlreadyApplied} <- toList results] @?= 64+ length [() | MigrationResult {outcome = AlreadyApplied} <- toList results] @?= 65 query connStr fullLedgerSnapshot >>= (@?= after) query connStr storeIdentitySnapshot >>= (@?= identity) query connStr previousCohortSnapshot >>= (@?= rows) query connStr bindingsSnapshot >>= (@?= bindings) query connStr previousCheckpointSnapshot >>= (@?= checkpoints) +-- The lock from mori://shinzui/keiro/packages/keiro-migrations 0.24.0.0+-- identifies the exact filenames, order and bytes shared by the older plans.+previousKeiroComponent :: IO MigrationComponent+previousKeiroComponent = do+ frozen <- Text.IO.readFile "test/fixtures/keiro-0.24.0.0/SHA256SUMS" >>= either assertFailure pure . parseMigrationLock+ let first :| rest = KeiroMigrations.embeddedMigrationEntries+ entries = first :| take 31 rest+ [(name, checksumHex bytes) | (name, bytes) <- toList entries] @?= frozen+ either (assertFailure . show) pure (migrationComponentFromEmbeddedSql "keiro" (Set.singleton "kiroku") entries)++timerTraceMigration :: MigrationId+timerTraceMigration = expectRight (migrationId "keiro" "0033")++testKeiro024Upgrade :: Assertion+testKeiro024Upgrade = withBareDatabase $ \connStr -> do+ let settings = Settings.connectionString connStr+ kiroku <- either (assertFailure . show) pure KirokuMigrations.kirokuMigrations+ keiro <- previousKeiroComponent+ kioku <- either (assertFailure . show) pure kiokuMigrations+ old <- either (assertFailure . show) pure (migrationPlan (kiroku :| [keiro, kioku]))+ installed <- runMigrationPlan defaultRunOptions settings old >>= either (assertFailure . show) pure+ length (appliedNow installed) @?= 64+ withConnection connStr $ \conn ->+ run conn (Session.script "INSERT INTO keiro.keiro_timers (timer_id,process_manager_name,correlation_id,fire_at,payload) VALUES ('00000000-0000-0000-0000-000000000001','upgrade','legacy',now(),'{}')")+ current <- either (assertFailure . show) pure kiokuMigrationPlan+ migrated <- runMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure+ appliedNow migrated @?= [timerTraceMigration]+ query connStr legacyTimerPreserved >>= (@?= True)+ verification <- verifyMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure+ let VerificationReport {issues, appliedMigrations, pendingMigrations, unknownMigrations} = verification+ (issues, length appliedMigrations, pendingMigrations, unknownMigrations) @?= ([], 65, [], [])+ repeated <- runMigrationPlan defaultRunOptions settings current >>= either (assertFailure . show) pure+ appliedNow repeated @?= []++legacyTimerPreserved :: Statement () Bool+legacyTimerPreserved =+ preparable+ "SELECT EXISTS (SELECT 1 FROM keiro.keiro_timers WHERE correlation_id='legacy' AND status='scheduled' AND payload='{}' AND traceparent IS NULL AND tracestate IS NULL)"+ E.noParams+ (D.singleRow (D.column (D.nonNullable D.bool)))+ ledgerWithout0017 :: Statement () Text ledgerWithout0017 = preparable- "SELECT jsonb_agg(to_jsonb(t) ORDER BY component,migration)::text FROM pgmigrate.migrations t WHERE NOT (component='kiroku' AND migration='0017')"+ "SELECT jsonb_agg(to_jsonb(t) ORDER BY component,migration)::text FROM pgmigrate.migrations t WHERE NOT (component='kiroku' AND migration='0017') AND NOT (component='keiro' AND migration='0033')" E.noParams (D.singleRow (D.column (D.nonNullable D.text))) @@ -790,7 +833,7 @@ runMigrationPlan defaultRunOptions (Settings.connectionString connStr) plan >>= either (assertFailure . show) pure let MigrationReport {results = repeatedResults} = repeated- length [() | MigrationResult {outcome = AlreadyApplied} <- toList repeatedResults] @?= 64+ length [() | MigrationResult {outcome = AlreadyApplied} <- toList repeatedResults] @?= 65 length [() | MigrationResult {outcome = AppliedNow} <- toList repeatedResults] @?= 0 verification <- verifyMigrationPlan defaultRunOptions (Settings.connectionString connStr) plan@@ -909,10 +952,10 @@ plan <- either (fail . show) pure kiokuMigrationPlan let settings = Settings.connectionString connStr initial <- runMigrationPlan defaultRunOptions settings plan >>= either (assertFailure . show) pure- length (appliedNow initial) @?= 64+ length (appliedNow initial) @?= 65 baselineLedger <- query connStr fullLedgerSnapshot- fst baselineLedger @?= 64+ fst baselineLedger @?= 65 baselineSchema <- query connStr cohortSchemaSnapshotStatement fixup <- Text.IO.readFile ledgerFixupPath @@ -938,7 +981,7 @@ repeated <- runMigrationPlan defaultRunOptions settings plan >>= either (assertFailure . show) pure let MigrationReport {results = repeatedResults} = repeated- length [() | MigrationResult {outcome = AlreadyApplied} <- toList repeatedResults] @?= 64+ length [() | MigrationResult {outcome = AlreadyApplied} <- toList repeatedResults] @?= 65 length [() | MigrationResult {outcome = AppliedNow} <- toList repeatedResults] @?= 0 withConnection connStr \conn -> run conn (Session.script fixup)@@ -1409,7 +1452,7 @@ adoption <- runMigrationPlan defaultRunOptions settings full >>= either (assertFailure . show) pure let MigrationReport {results = adoptionResults} = adoption length [() | MigrationResult {outcome = AlreadyApplied} <- toList adoptionResults] @?= 17- length [() | MigrationResult {outcome = AppliedNow} <- toList adoptionResults] @?= 47+ length [() | MigrationResult {outcome = AppliedNow} <- toList adoptionResults] @?= 48 -- Verified and skipped, never re-executed: the stored rows keep their checksums and their -- original application timestamps.@@ -1422,7 +1465,7 @@ verification <- verifyMigrationPlan defaultRunOptions settings full >>= either (assertFailure . show) pure let VerificationReport {issues = adoptionIssues, appliedMigrations, pendingMigrations, unknownMigrations} = verification adoptionIssues @?= []- length appliedMigrations @?= 64+ length appliedMigrations @?= 65 pendingMigrations @?= [] unknownMigrations @?= [] @@ -1773,13 +1816,13 @@ verification <- verifyMigrationPlan defaultRunOptions settings plan >>= either (assertFailure . show) pure let VerificationReport {issues = verificationIssues, appliedMigrations, pendingMigrations, unknownMigrations} = verification verificationIssues @?= []- length appliedMigrations @?= 64+ length appliedMigrations @?= 65 pendingMigrations @?= [] unknownMigrations @?= [] repeated <- runMigrationPlan defaultRunOptions settings plan >>= either (assertFailure . show) pure let MigrationReport {results = repeatedResults} = repeated- length [() | MigrationResult {outcome = AlreadyApplied} <- toList repeatedResults] @?= 64+ length [() | MigrationResult {outcome = AlreadyApplied} <- toList repeatedResults] @?= 65 length [() | MigrationResult {outcome = AppliedNow} <- toList repeatedResults] @?= 0 testSchemaConvergence :: Assertion@@ -1968,6 +2011,7 @@ migrationId "keiro" "0030", migrationId "keiro" "0031", migrationId "keiro" "0032",+ migrationId "keiro" "0033", migrationId "kioku" "0011-kioku-memory-space-partition", migrationId "kioku" "0012-relocate-projections-to-kioku-schema", migrationId "kioku" "0013-partition-aware-fts-index",@@ -2064,7 +2108,7 @@ old <- either (assertFailure . show) pure (migrationPlan (kiroku :| [keiro, oldKioku])) current <- either (assertFailure . show) pure kiokuMigrationPlan initial <- runMigrationPlan defaultRunOptions settings old >>= either (assertFailure . show) pure- length (appliedNow initial) @?= 63+ length (appliedNow initial) @?= 64 withConnection connStr $ \conn -> run conn
+ test/fixtures/keiro-0.24.0.0/SHA256SUMS view
@@ -0,0 +1,32 @@+1d15faa7cfb474455c3a1193b454ce493d49589b0f9f62b0b8beff65a00f6403 0001-keiro-bootstrap.sql+4c9c645e7ac9ebc9228638a89580613bd0058444e20047486d4bd7696b9ddb0a 0002-keiro-outbox.sql+71aabbfd93e66b324691ca856ca73245d62d84d984ca162e1388726127daa5e5 0003-keiro-inbox.sql+42f1bbd4fb23b27b2be434f25b559b2e17870f1d8c6efbcf2ae6a702c6136f98 0004-keiro-timer-recovery.sql+e967d41342cddc8cfe8381e5f562603dbc9a10e61232458e24c5cb291cfe9047 0005-keiro-workflow-steps.sql+3b20ba3981ae718cfbb9ed68318131a50ca5ad715b459868b79ac1f4c138fc5c 0006-keiro-awakeables.sql+975c0e6480fa01f2af1e2c45a4396e2588af4560c9803b55e8b574ea2e69b5b2 0007-keiro-workflow-children.sql+f05e8254de4c328f9319db4db8b9a78d6fba552c245acf0e24c6c450d8d71559 0008-keiro-workflow-generation.sql+1a93b4fdad24624b168a0aeeb12c659c59764660cc11fa564e77aa4b32a54fca 0009-keiro-subscription-shards.sql+49a963745a637c8e0248b5b958a719ccc772dbd02ca77cf706fee5de8d8d1a85 0010-keiro-messaging-crash-recovery.sql+7c329c9f439d2bab927debf5dc8b96acb438b4e240ef16292723398ddf005fea 0011-keiro-workflows-instances.sql+77c394334c64ff0631eb1c831f60629123ae255f1be7fb1716748b6ff9d0b701 0012-keiro-workflow-gc-index.sql+a2ea08ce3debec078e89490403241d9fd4e5d4ff3ea64b2c01ab236fb2dda313 0013-keiro-workflows-wake-after.sql+ed5bef75d195df0335b86d36256fd4f1dab30cb1eab4e05f0a321bf8d989503a 0014-keiro-projection-dedup.sql+fd65320576b06e8d30a8308ac790be463c09906e74d81a6fd535e7745ef943c5 0015-keiro-outbox-claim-order-index.sql+50b169c9bc98e7ab6845c74b105d13990af3cdb2e587445fd869e942c28df81d 0016-keiro-inbox-drop-received-idx.sql+e2690e1e2517d28e596330d3bdfcc07f6a8d7e1b6e87b94f726630d221663900 0017-schema-management-comment.sql+be7e510421f983ac2e446ae655d000b810b19cf2667f328dd7caf41a2101d0b6 0018.sql+7a0d0280d8d54f811c33b4bec525d78fe8f172de92b62e4745dcdd217c656209 0019-keiro-snapshots-state-shape-hash.sql+c125e8c32a0848854d94bce1245f349cf7f479326a1bf540e9dba9e222b75a4f 0020-keiro-workflow-children-failure-reason.sql+fa59bb3930e541b55b92f22b4662b800f560a48c65af9edbb43089b33ba43cb2 0021-keiro-workflows-exact-discovery.sql+f06ed6b5a3de431f3f9de55f7776eb86549432317bc728ef848fd246db67c0ce 0022.sql+04cbd376eb9509cb202ec0caa43e6646957d10c241511829b225d072cfd92641 0023.sql+faad6bd740cda45378645be1d3fe0b1754c4f1e9ac6a02e9e935bb5f6e304f95 0024.sql+343f0852de6cddf85ab7a69bbba7d07396427877a78b0f7f97f9835d86c4deaf 0025.sql+cc167230c3765bd2de986cc1dc0db447d4f186a3e6b2dbbdac7ea2cabe6cb2b3 0026.sql+bb725945d567c9446e67db65535daf2017dd1b6facb3277c2b85e7429b4e95f7 0027.sql+524e90271704112722bbfe0fc54f1c8dcc06b1f9e2ce1821e54dc232d434104f 0028.sql+40f62a18adf0457fc6d35e880eca8be1922f22a2fd8c893c13d59537fe941719 0029.sql+0e0b847088d178290e77913224df82435b86c00062feb47c79351ed014a605a1 0030.sql+d78b8400638b3a9005f4e964f2cb10d3863d60d1038735ed6fa09507a912a26e 0031.sql+b0fd734dde0a23d13f844a5e137fe92859f726ded171e14ca531c3e10f3dcf47 0032.sql