diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2005-07-03 08:21:22 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2005-07-03 08:21:22 +0000 |
commit | d9d22c7596118051ba8908c163c797b90cca7aa3 (patch) | |
tree | e6cab8dca303f6479aac8e1d6fe5fa010df7a5ed /activerecord/test/fixtures/db_definitions | |
parent | 703d18ea520c3def7bc677cef5fd87e2c7c3cd34 (diff) | |
download | rails-d9d22c7596118051ba8908c163c797b90cca7aa3.tar.gz rails-d9d22c7596118051ba8908c163c797b90cca7aa3.tar.bz2 rails-d9d22c7596118051ba8908c163c797b90cca7aa3.zip |
Fixed that single-table inheritance sub-classes couldn't be used to limit the result set with eager loading #1215 [Chris McGrath]
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1619 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
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 ( |