From 33a0e50f21c1976b1ead5db714f5b49e4af68430 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Milo=C5=A1=20Mula=C4=8D?= Date: Tue, 29 Apr 2008 11:46:31 +0000 Subject: [PATCH] new zombie schema --- org.glite.lb.server/config/glite-lb-migrate_db2transactions | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/org.glite.lb.server/config/glite-lb-migrate_db2transactions b/org.glite.lb.server/config/glite-lb-migrate_db2transactions index 204d733..4319b5b 100644 --- a/org.glite.lb.server/config/glite-lb-migrate_db2transactions +++ b/org.glite.lb.server/config/glite-lb-migrate_db2transactions @@ -117,16 +117,16 @@ mysql -u lbserver $DB_NAME -e "ALTER TABLE notif_registrations ADD index(JDL_Vir mysql -u lbserver $DB_NAME -e "\ \ create table zombie_jobs (\ - binary_jobid binary(16) not null,\ - prefix_id binary(1) not null,\ + jobid varchar(22) not null,\ + prefix_id tinyint unsigned not null,\ \ - primary key (binary_jobid)\ + primary key (jobid)\ ) engine=innodb" mysql -u lbserver $DB_NAME -e "\ \ create table zombie_prefixes (\ - prefix_id binary(1) not null,\ + prefix_id tinyint unsigned not null auto_increment,\ prefix varchar(255) binary not null,\ \ primary key (prefix_id)\ -- 1.8.2.3