From e2780ee5f230022fc35ce1e72ca46d0f05b8c988 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Thu, 22 Oct 2009 18:41:15 +0200 Subject: [PATCH] Those are supposed to be TEXT/CLOB. --- kronolith/scripts/sql/kronolith.mssql.sql | 2 +- kronolith/scripts/sql/kronolith.mysql.sql | 2 +- kronolith/scripts/sql/kronolith.sql | 2 +- kronolith/scripts/upgrades/2009-08-17_add_resources.sql | 4 ++-- kronolith/scripts/upgrades/2009-10-22_fix_resource_members.sql | 1 + 5 files changed, 6 insertions(+), 5 deletions(-) create mode 100644 kronolith/scripts/upgrades/2009-10-22_fix_resource_members.sql diff --git a/kronolith/scripts/sql/kronolith.mssql.sql b/kronolith/scripts/sql/kronolith.mssql.sql index deef4fdc8..b800dc4f4 100644 --- a/kronolith/scripts/sql/kronolith.mssql.sql +++ b/kronolith/scripts/sql/kronolith.mssql.sql @@ -88,7 +88,7 @@ CREATE TABLE kronolith_resources ( resource_category VARCHAR(255), resource_response_type INT, resource_type VARCHAR(255) NOT NULL, - resource_members BLOB, + resource_members VARCHAR(MAX), PRIMARY KEY (resource_id) ); diff --git a/kronolith/scripts/sql/kronolith.mysql.sql b/kronolith/scripts/sql/kronolith.mysql.sql index d67532616..2a4f94373 100644 --- a/kronolith/scripts/sql/kronolith.mysql.sql +++ b/kronolith/scripts/sql/kronolith.mysql.sql @@ -88,7 +88,7 @@ CREATE TABLE kronolith_resources ( resource_category VARCHAR(255), resource_response_type INT, resource_type VARCHAR(255) NOT NULL, - resource_members BLOB, + resource_members TEXT, PRIMARY KEY (resource_id) ); diff --git a/kronolith/scripts/sql/kronolith.sql b/kronolith/scripts/sql/kronolith.sql index 18453a2e7..d608f8264 100644 --- a/kronolith/scripts/sql/kronolith.sql +++ b/kronolith/scripts/sql/kronolith.sql @@ -88,7 +88,7 @@ CREATE TABLE kronolith_resources ( resource_category VARCHAR(255), resource_response_type INT, resource_type VARCHAR(255) NOT NULL, - resource_members BLOB, + resource_members TEXT, PRIMARY KEY (resource_id) ); diff --git a/kronolith/scripts/upgrades/2009-08-17_add_resources.sql b/kronolith/scripts/upgrades/2009-08-17_add_resources.sql index f89b7f1cf..f4c9c23ec 100644 --- a/kronolith/scripts/upgrades/2009-08-17_add_resources.sql +++ b/kronolith/scripts/upgrades/2009-08-17_add_resources.sql @@ -8,7 +8,7 @@ CREATE TABLE kronolith_resources ( resource_category VARCHAR(255), resource_response_type INT, resource_type VARCHAR(255) NOT NULL, - resource_members BLOB, - + resource_members TEXT, +-- PRIMARY KEY (resource_id) ); diff --git a/kronolith/scripts/upgrades/2009-10-22_fix_resource_members.sql b/kronolith/scripts/upgrades/2009-10-22_fix_resource_members.sql new file mode 100644 index 000000000..6f8242792 --- /dev/null +++ b/kronolith/scripts/upgrades/2009-10-22_fix_resource_members.sql @@ -0,0 +1 @@ +ALTER TABLE kronolith_resources CHANGE resource_members resource_members TEXT -- 2.11.0