From 524954a215a36af0978610510fee26ec13e789be Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 22 Jan 2010 10:21:28 +0100 Subject: [PATCH] Bweb: Remove Status->severity column --- gui/bweb/script/bweb-mysql.sql | 9 --------- gui/bweb/script/bweb-postgresql.sql | 8 -------- 2 files changed, 17 deletions(-) diff --git a/gui/bweb/script/bweb-mysql.sql b/gui/bweb/script/bweb-mysql.sql index 6017dc8511..90e8d1d4ba 100644 --- 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 fbea337cae..50f57297c9 100644 --- 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 -- 2.39.5