Bweb: Remove Status->severity column

diff --git a/gui/bweb/script/bweb-mysql.sql b/gui/bweb/script/bweb-mysql.sql
index 6017dc8511410c906bcfd876a7da789610f296e4..90e8d1d4bab0dba7e329b3ae20dd732a9ad87df3 100644 (file)
--- a/gui/bweb/script/bweb-mysql.sql
+++ b/gui/bweb/script/bweb-mysql.sql
@@ -36,15 +36,6 @@ delimiter ;
 -- Upgrade from 2.2
 -- --------------------------------------------------
 
-ALTER TABLE Status ADD COLUMN severity int;
-UPDATE Status SET severity = 15;
-UPDATE Status SET severity = 100 where JobStatus = 'f';
-UPDATE Status SET severity = 90 where JobStatus = 'A';
-UPDATE Status SET severity = 10 where JobStatus = 'T';
-UPDATE Status SET severity = 20 where JobStatus = 'e';
-UPDATE Status SET severity = 25 where JobStatus = 'E';
-
-
 -- New tables for bresto (same as brestore)
 
 CREATE TABLE brestore_knownjobid

diff --git a/gui/bweb/script/bweb-postgresql.sql b/gui/bweb/script/bweb-postgresql.sql
index fbea337cae4b8e89e546bd42450e614281d05eb7..50f57297c96c31bce5692999b978df0ec2c0934d 100644 (file)
--- a/gui/bweb/script/bweb-postgresql.sql
+++ b/gui/bweb/script/bweb-postgresql.sql
@@ -5,14 +5,6 @@ CREATE PROCEDURAL LANGUAGE plpgsql;
 -- Upgrade from 2.2
 -- --------------------------------------------------
 
-ALTER TABLE Status ADD COLUMN severity int;
-UPDATE status SET severity = 15;
-UPDATE status SET severity = 100 where jobstatus = 'f';
-UPDATE status SET severity = 90 where jobstatus = 'A';
-UPDATE status SET severity = 10 where jobstatus = 'T';
-UPDATE status SET severity = 20 where jobstatus = 'e';
-UPDATE status SET severity = 25 where jobstatus = 'E';
-
 -- New tables for bresto (same as brestore)
 
 CREATE TABLE brestore_knownjobid