From 34a92d0af99714b9dcbbb6a8fa2cb2e8673c73fe Mon Sep 17 00:00:00 2001 From: =?utf8?q?Ale=C5=A1=20K=C5=99enek?= Date: Wed, 26 Mar 2008 14:09:35 +0000 Subject: [PATCH] mysql doesn't like binary blobs --- org.glite.lb.server/config/glite-lb-dbsetup.sql | 2 +- org.glite.lb.server/config/glite-lb-migrate_db2transactions | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/org.glite.lb.server/config/glite-lb-dbsetup.sql b/org.glite.lb.server/config/glite-lb-dbsetup.sql index e0c315a..5fe8f99 100644 --- a/org.glite.lb.server/config/glite-lb-dbsetup.sql +++ b/org.glite.lb.server/config/glite-lb-dbsetup.sql @@ -45,7 +45,7 @@ create table events ( create table events_flesh ( jobid char(32) binary not null, event int not null, - ulm mediumblob binary not null, + ulm mediumblob not null, primary key (jobid,event) ) engine=innodb; diff --git a/org.glite.lb.server/config/glite-lb-migrate_db2transactions b/org.glite.lb.server/config/glite-lb-migrate_db2transactions index 299e323..11ca040 100644 --- a/org.glite.lb.server/config/glite-lb-migrate_db2transactions +++ b/org.glite.lb.server/config/glite-lb-migrate_db2transactions @@ -97,7 +97,7 @@ mysql -u lbserver $DB_NAME -e "\ create table events_flesh (\ jobid char(32) binary not null,\ event int not null,\ - ulm mediumblob binary not null,\ + ulm mediumblob not null,\ \ primary key (jobid,event)\ ) engine=innodb" -- 1.8.2.3