6 files changed, 11 insertions, 5 deletions
diff --git a/activerecord/test/fixtures/db_definitions/db2.sql b/activerecord/test/fixtures/db_definitions/db2.sql
index bd1696d546..40faf53269 100644
--- a/activerecord/test/fixtures/db_definitions/db2.sql
+++ b/activerecord/test/fixtures/db_definitions/db2.sql
@@ -160,7 +160,8 @@ CREATE TABLE tasks (
 
 CREATE TABLE categories (
   id int generated by default as identity (start with +10000),
-  name varchar(255) NOT NULL
+  name varchar(255) NOT NULL,
+  type varchar(40) default NULL
 );
 
 CREATE TABLE categories_posts (
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql
index 6fa1a38615..cb589bec6f 100755
--- a/activerecord/test/fixtures/db_definitions/mysql.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql.sql
@@ -162,6 +162,7 @@ CREATE TABLE `tasks` (
 CREATE TABLE `categories` (
   `id` int(11) NOT NULL auto_increment,
   `name` VARCHAR(255) NOT NULL,
+  `type` VARCHAR(255) NOT NULL,
   PRIMARY KEY  (`id`)
 ) TYPE=InnoDB;
 
diff --git a/activerecord/test/fixtures/db_definitions/oci.sql b/activerecord/test/fixtures/db_definitions/oci.sql
index be6872a26a..0170215c41 100644
--- a/activerecord/test/fixtures/db_definitions/oci.sql
+++ b/activerecord/test/fixtures/db_definitions/oci.sql
@@ -198,7 +198,8 @@ create table tasks (
 
 create table categories (
   id integer not null primary key,
-  name varchar(255) default null
+  name varchar(255) default null,
+  type varchar(255) default null
 );
 
 create table categories_posts (
diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql
index 60623e5a48..aec5bd64c3 100644
--- a/activerecord/test/fixtures/db_definitions/postgresql.sql
+++ b/activerecord/test/fixtures/db_definitions/postgresql.sql
@@ -177,7 +177,8 @@ CREATE TABLE tasks (
 
 CREATE TABLE categories (
   id serial,
-  name varchar(255)
+  name varchar(255),
+  type varchar(255)
 );
 
 CREATE TABLE categories_posts (
diff --git a/activerecord/test/fixtures/db_definitions/sqlite.sql b/activerecord/test/fixtures/db_definitions/sqlite.sql
index 08a515e67b..1e3b4769f2 100644
--- a/activerecord/test/fixtures/db_definitions/sqlite.sql
+++ b/activerecord/test/fixtures/db_definitions/sqlite.sql
@@ -147,7 +147,8 @@ CREATE TABLE 'tasks' (
 
 CREATE TABLE 'categories' (
   'id' INTEGER NOT NULL PRIMARY KEY,
-  'name' VARCHAR(255) NOT NULL
+  'name' VARCHAR(255) NOT NULL,
+  'type' VARCHAR(255) DEFAULT NULL
 );
 
 CREATE TABLE 'categories_posts' (
diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql
index 1177b37035..2280bc80ea 100644
--- a/activerecord/test/fixtures/db_definitions/sqlserver.sql
+++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql
@@ -147,7 +147,8 @@ CREATE TABLE tasks (
 
 CREATE TABLE categories (
   id int NOT NULL IDENTITY(1, 1) PRIMARY KEY,
-  name varchar(255)
+  name varchar(255),
+  type varchar(255) default NULL
 );
 
 CREATE TABLE categories_posts (