Drop all database migrations to be backward compatible with 0.13.0 and above (two minor versions behind)

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>