branch master updated: Reset database.

[Mathieu Othacehe]

This is an automated email from the git hooks/post-receive script.

mothacehe pushed a commit to branch master
in repository guix-cuirass.

The following commit(s) were added to refs/heads/master by this push:
     new 463f5cd  Reset database.
463f5cd is described below

commit 463f5cd0f1fd92fd4ef0f47b34004f8108ca7c2a
Author: Mathieu Othacehe <othacehe@gnu.org>
AuthorDate: Wed Mar 10 08:53:39 2021 +0100

    Reset database.
    
    * src/sql/upgrade-2.sql: Remove it.
    * src/sql/upgrade-3.sql: Remove it.
    * src/sql/upgrade-4.sql: Remove it.
    * src/sql/upgrade-5.sql: Remove it.
    * Makefile.am (dist_sql_DATA): Adapt it.
---
 Makefile.am           | 6 +-----
 src/sql/upgrade-2.sql | 6 ------
 src/sql/upgrade-3.sql | 5 -----
 src/sql/upgrade-4.sql | 6 ------
 src/sql/upgrade-5.sql | 5 -----
 5 files changed, 1 insertion(+), 27 deletions(-)

diff --git a/Makefile.am b/Makefile.am
index 928d201..bf3b99d 100644
--- a/Makefile.am
+++ b/Makefile.am
@@ -86,11 +86,7 @@ nodist_webobject_DATA =                              \
 dist_pkgdata_DATA = src/schema.sql
 
 dist_sql_DATA =                                \
-  src/sql/upgrade-1.sql                                \
-  src/sql/upgrade-2.sql                                \
-  src/sql/upgrade-3.sql                                \
-  src/sql/upgrade-4.sql                                \
-  src/sql/upgrade-5.sql
+  src/sql/upgrade-1.sql
 
 dist_css_DATA =                                        \
   src/static/css/cuirass.css                   \
diff --git a/src/sql/upgrade-2.sql b/src/sql/upgrade-2.sql
deleted file mode 100644
index 79f0ce9..0000000
--- a/src/sql/upgrade-2.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-BEGIN TRANSACTION;
-
-DELETE FROM Workers;
-ALTER TABLE Workers ADD COLUMN machine TEXT NOT NULL;
-
-COMMIT;
diff --git a/src/sql/upgrade-3.sql b/src/sql/upgrade-3.sql
deleted file mode 100644
index 8f01225..0000000
--- a/src/sql/upgrade-3.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-BEGIN TRANSACTION;
-
-ALTER TABLE Builds ADD COLUMN last_status INTEGER;
-
-COMMIT;
diff --git a/src/sql/upgrade-4.sql b/src/sql/upgrade-4.sql
deleted file mode 100644
index 3de1e76..0000000
--- a/src/sql/upgrade-4.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-BEGIN TRANSACTION;
-
-ALTER TABLE Builds ADD COLUMN weather INTEGER;
-CREATE INDEX Builds_weather_evaluation ON Builds (weather, evaluation);
-
-COMMIT;
diff --git a/src/sql/upgrade-5.sql b/src/sql/upgrade-5.sql
deleted file mode 100644
index 117d052..0000000
--- a/src/sql/upgrade-5.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-BEGIN TRANSACTION;
-
-ALTER TABLE Specifications ADD COLUMN notifications TEXT;
-
-COMMIT;