aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKaren Arutyunov <karen@codesynthesis.com>2021-11-15 15:07:59 +0300
committerKaren Arutyunov <karen@codesynthesis.com>2021-11-15 15:07:59 +0300
commita3442288cfdfc176730e6abb7ec709a638572a59 (patch)
tree0b3bb58ce5d86020f2056af24dcd2a9bb4d2d615
parentae2acaa4d236c6b1cb9a5d8346316cd8af0c9210 (diff)
Drop all database migrations to be backward compatible with 0.13.0 and above (two minor versions behind)
-rw-r--r--bpkg/package.hxx2
-rw-r--r--bpkg/package.xml117
2 files changed, 57 insertions, 62 deletions
diff --git a/bpkg/package.hxx b/bpkg/package.hxx
index 2b833af..fe1664f 100644
--- a/bpkg/package.hxx
+++ b/bpkg/package.hxx
@@ -25,7 +25,7 @@
// Used by the data migration entries.
//
-#define DB_SCHEMA_VERSION_BASE 6
+#define DB_SCHEMA_VERSION_BASE 7
#pragma db model version(DB_SCHEMA_VERSION_BASE, 12, closed)
diff --git a/bpkg/package.xml b/bpkg/package.xml
index d454cc0..f54c902 100644
--- a/bpkg/package.xml
+++ b/bpkg/package.xml
@@ -42,67 +42,7 @@
</alter-table>
</changeset>
- <changeset version="7">
- <alter-table name="main.available_package_dependencies">
- <add-column name="type" type="TEXT" null="true"/>
- </alter-table>
- <add-table name="main.available_package_tests" kind="container">
- <column name="name" type="TEXT" null="true" options="COLLATE NOCASE"/>
- <column name="version_epoch" type="INTEGER" null="true"/>
- <column name="version_canonical_upstream" type="TEXT" null="true"/>
- <column name="version_canonical_release" type="TEXT" null="true" options="COLLATE BINARY"/>
- <column name="version_revision" type="INTEGER" null="true"/>
- <column name="version_iteration" type="INTEGER" null="true"/>
- <column name="index" type="INTEGER" null="true"/>
- <column name="test_name" type="TEXT" null="true" options="COLLATE NOCASE"/>
- <column name="test_min_version_epoch" type="INTEGER" null="true"/>
- <column name="test_min_version_canonical_upstream" type="TEXT" null="true"/>
- <column name="test_min_version_canonical_release" type="TEXT" null="true"/>
- <column name="test_min_version_revision" type="INTEGER" null="true"/>
- <column name="test_min_version_iteration" type="INTEGER" null="true"/>
- <column name="test_min_version_upstream" type="TEXT" null="true"/>
- <column name="test_min_version_release" type="TEXT" null="true"/>
- <column name="test_max_version_epoch" type="INTEGER" null="true"/>
- <column name="test_max_version_canonical_upstream" type="TEXT" null="true"/>
- <column name="test_max_version_canonical_release" type="TEXT" null="true"/>
- <column name="test_max_version_revision" type="INTEGER" null="true"/>
- <column name="test_max_version_iteration" type="INTEGER" null="true"/>
- <column name="test_max_version_upstream" type="TEXT" null="true"/>
- <column name="test_max_version_release" type="TEXT" null="true"/>
- <column name="test_min_open" type="INTEGER" null="true"/>
- <column name="test_max_open" type="INTEGER" null="true"/>
- <column name="test_type" type="TEXT" null="true"/>
- <foreign-key name="object_id_fk" on-delete="CASCADE">
- <column name="name"/>
- <column name="version_epoch"/>
- <column name="version_canonical_upstream"/>
- <column name="version_canonical_release"/>
- <column name="version_revision"/>
- <column name="version_iteration"/>
- <references table="main.available_package">
- <column name="name"/>
- <column name="version_epoch"/>
- <column name="version_canonical_upstream"/>
- <column name="version_canonical_release"/>
- <column name="version_revision"/>
- <column name="version_iteration"/>
- </references>
- </foreign-key>
- <index name="available_package_tests_object_id_i">
- <column name="name"/>
- <column name="version_epoch"/>
- <column name="version_canonical_upstream"/>
- <column name="version_canonical_release"/>
- <column name="version_revision"/>
- <column name="version_iteration"/>
- </index>
- <index name="available_package_tests_index_i">
- <column name="index"/>
- </index>
- </add-table>
- </changeset>
-
- <model version="6">
+ <model version="7">
<table name="main.repository_fragment" kind="object">
<column name="name" type="TEXT" null="true"/>
<column name="url" type="TEXT" null="true"/>
@@ -252,6 +192,7 @@
<column name="conditional" type="INTEGER" null="true"/>
<column name="buildtime" type="INTEGER" null="true"/>
<column name="comment" type="TEXT" null="true"/>
+ <column name="type" type="TEXT" null="true"/>
<foreign-key name="object_id_fk" on-delete="CASCADE">
<column name="name"/>
<column name="version_epoch"/>
@@ -403,5 +344,59 @@
<column name="id"/>
</primary-key>
</table>
+ <table name="main.available_package_tests" kind="container">
+ <column name="name" type="TEXT" null="true" options="COLLATE NOCASE"/>
+ <column name="version_epoch" type="INTEGER" null="true"/>
+ <column name="version_canonical_upstream" type="TEXT" null="true"/>
+ <column name="version_canonical_release" type="TEXT" null="true" options="COLLATE BINARY"/>
+ <column name="version_revision" type="INTEGER" null="true"/>
+ <column name="version_iteration" type="INTEGER" null="true"/>
+ <column name="index" type="INTEGER" null="true"/>
+ <column name="test_name" type="TEXT" null="true" options="COLLATE NOCASE"/>
+ <column name="test_min_version_epoch" type="INTEGER" null="true"/>
+ <column name="test_min_version_canonical_upstream" type="TEXT" null="true"/>
+ <column name="test_min_version_canonical_release" type="TEXT" null="true"/>
+ <column name="test_min_version_revision" type="INTEGER" null="true"/>
+ <column name="test_min_version_iteration" type="INTEGER" null="true"/>
+ <column name="test_min_version_upstream" type="TEXT" null="true"/>
+ <column name="test_min_version_release" type="TEXT" null="true"/>
+ <column name="test_max_version_epoch" type="INTEGER" null="true"/>
+ <column name="test_max_version_canonical_upstream" type="TEXT" null="true"/>
+ <column name="test_max_version_canonical_release" type="TEXT" null="true"/>
+ <column name="test_max_version_revision" type="INTEGER" null="true"/>
+ <column name="test_max_version_iteration" type="INTEGER" null="true"/>
+ <column name="test_max_version_upstream" type="TEXT" null="true"/>
+ <column name="test_max_version_release" type="TEXT" null="true"/>
+ <column name="test_min_open" type="INTEGER" null="true"/>
+ <column name="test_max_open" type="INTEGER" null="true"/>
+ <column name="test_type" type="TEXT" null="true"/>
+ <foreign-key name="object_id_fk" on-delete="CASCADE">
+ <column name="name"/>
+ <column name="version_epoch"/>
+ <column name="version_canonical_upstream"/>
+ <column name="version_canonical_release"/>
+ <column name="version_revision"/>
+ <column name="version_iteration"/>
+ <references table="main.available_package">
+ <column name="name"/>
+ <column name="version_epoch"/>
+ <column name="version_canonical_upstream"/>
+ <column name="version_canonical_release"/>
+ <column name="version_revision"/>
+ <column name="version_iteration"/>
+ </references>
+ </foreign-key>
+ <index name="available_package_tests_object_id_i">
+ <column name="name"/>
+ <column name="version_epoch"/>
+ <column name="version_canonical_upstream"/>
+ <column name="version_canonical_release"/>
+ <column name="version_revision"/>
+ <column name="version_iteration"/>
+ </index>
+ <index name="available_package_tests_index_i">
+ <column name="index"/>
+ </index>
+ </table>
</model>
</changelog>