packages feed

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 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