From bc06c0562931162c775d66223cf51cec10a6aa61 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Milo=C5=A1=20Mula=C4=8D?= Date: Tue, 25 Mar 2008 12:39:09 +0000 Subject: [PATCH] original scripts glued into one --- ...oxy_server_db => glite-lb-migrate_db2transactions} | 0 .../config/glite-lb-migrate_proxy_db2proxy_server_db | 19 ------------------- 2 files changed, 19 deletions(-) rename org.glite.lb.server/config/{glite-lb-migrate_server_db2proxy_server_db => glite-lb-migrate_db2transactions} (100%) delete mode 100644 org.glite.lb.server/config/glite-lb-migrate_proxy_db2proxy_server_db diff --git a/org.glite.lb.server/config/glite-lb-migrate_server_db2proxy_server_db b/org.glite.lb.server/config/glite-lb-migrate_db2transactions similarity index 100% rename from org.glite.lb.server/config/glite-lb-migrate_server_db2proxy_server_db rename to org.glite.lb.server/config/glite-lb-migrate_db2transactions diff --git a/org.glite.lb.server/config/glite-lb-migrate_proxy_db2proxy_server_db b/org.glite.lb.server/config/glite-lb-migrate_proxy_db2proxy_server_db deleted file mode 100644 index 25fe402..0000000 --- a/org.glite.lb.server/config/glite-lb-migrate_proxy_db2proxy_server_db +++ /dev/null @@ -1,19 +0,0 @@ -# This script is intendent to be used to extend proxy database to -# to be able to hold both bkserver and lbproxy jobs. -# The operation should be non-destructive, i.e. all data should persist -# and continue to be fully usable. - -#!/bin/bash - - -# add columns for job membership (proxy/server) flags -mysql -u lbserver lbproxy -e "ALTER TABLE jobs ADD proxy bool not null" -mysql -u lbserver lbproxy -e "ALTER TABLE jobs ADD server bool not null" - -# flag all jobs as proxy jobs -mysql -u lbserver lbproxy -e "update jobs set proxy='1'" -mysql -u lbserver lbproxy -e "update jobs set server='0'" - -# something more clever should come here -# - rename DB to lbserver20 -# - or copy all fields to lbserver20 DB -- 1.8.2.3