diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
4 files changed, 26 insertions, 2 deletions
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) +); + + |