From 3e0077f54dc451a551360f7af9b5a9c96b3253af Mon Sep 17 00:00:00 2001
From: David Heinemeier Hansson <david@loudthinking.com>
Date: Sat, 1 Jan 2005 18:34:39 +0000
Subject: Fixed a bug in the Ruby/MySQL that caused binary content to be
 escaped badly and come back mangled #405 [Tobias Luetke]

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@301 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
---
 activerecord/test/fixtures/db_definitions/mysql.sql      |  6 ++++++
 activerecord/test/fixtures/db_definitions/postgresql.sql |  6 ++++++
 activerecord/test/fixtures/db_definitions/sqlite.sql     |  5 +++++
 activerecord/test/fixtures/db_definitions/sqlserver.sql  | 11 +++++++++--
 4 files changed, 26 insertions(+), 2 deletions(-)

(limited to 'activerecord/test/fixtures/db_definitions')

diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql
index ec27a52445..3758f19bfa 100755
--- a/activerecord/test/fixtures/db_definitions/mysql.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql.sql
@@ -115,4 +115,10 @@ CREATE TABLE `people` (
   `id` INTEGER NOT NULL PRIMARY KEY,
   `first_name` VARCHAR(40) NOT NULL,
   `lock_version` INTEGER NOT NULL DEFAULT 0
+);
+
+CREATE TABLE `binaries` (
+  `id` int(11) NOT NULL auto_increment,
+  `data` mediumblob,
+  PRIMARY KEY  (`id`)
 );
\ No newline at end of file
diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql
index 6d8222cfd6..8f6587f961 100644
--- a/activerecord/test/fixtures/db_definitions/postgresql.sql
+++ b/activerecord/test/fixtures/db_definitions/postgresql.sql
@@ -133,4 +133,10 @@ CREATE TABLE people (
   first_name text,
   lock_version integer default 0,
   PRIMARY KEY  (id)
+);
+
+CREATE TABLE binaries ( 
+  id serial , 
+  data bytea,
+  PRIMARY KEY (id)
 );
\ No newline at end of file
diff --git a/activerecord/test/fixtures/db_definitions/sqlite.sql b/activerecord/test/fixtures/db_definitions/sqlite.sql
index 5c27832056..65b24a9333 100644
--- a/activerecord/test/fixtures/db_definitions/sqlite.sql
+++ b/activerecord/test/fixtures/db_definitions/sqlite.sql
@@ -103,4 +103,9 @@ CREATE TABLE 'people' (
   'id' INTEGER NOT NULL PRIMARY KEY,
   'first_name' VARCHAR(40) DEFAULT NULL,
   'lock_version' INTEGER NOT NULL DEFAULT 0
+);
+
+CREATE TABLE 'binaries' (
+  'id' INTEGER NOT NULL PRIMARY KEY,
+  'data' BLOB DEFAULT NULL
 );
\ No newline at end of file
diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql
index 74cd381ba3..023ab63406 100644
--- a/activerecord/test/fixtures/db_definitions/sqlserver.sql
+++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql
@@ -109,10 +109,17 @@ CREATE TABLE mixins (
   PRIMARY KEY (id)    
 );
 
-
 CREATE TABLE people (
   id int NOT NULL IDENTITY(1, 1),
   first_name varchar(40) NULL,
   lock_version int default 0,
   PRIMARY KEY (id)
-);
\ No newline at end of file
+);
+
+CREATE TABLE binaries (
+  id int NOT NULL IDENTITY(1, 1),
+  data blob NULL,
+  PRIMARY KEY (id)
+);
+
+
-- 
cgit v1.2.3