diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2005-01-11 00:24:19 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2005-01-11 00:24:19 +0000 |
commit | 79365a0184c58def99aff4c4b213048a25179f6a (patch) | |
tree | 2a33951d6e17d9a2869da4aa6eb728a71092ff5a /activerecord/test/fixtures/db_definitions | |
parent | bcb81167960293596d44587ea237ace4d505b960 (diff) | |
download | rails-79365a0184c58def99aff4c4b213048a25179f6a.tar.gz rails-79365a0184c58def99aff4c4b213048a25179f6a.tar.bz2 rails-79365a0184c58def99aff4c4b213048a25179f6a.zip |
Fixed that foreign keys named the same as the association would cause stack overflow #437 [Eric Anderson]
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@382 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
5 files changed, 25 insertions, 1 deletions
diff --git a/activerecord/test/fixtures/db_definitions/db2.sql b/activerecord/test/fixtures/db_definitions/db2.sql index 7b98f2fa5a..033efcb088 100644 --- a/activerecord/test/fixtures/db_definitions/db2.sql +++ b/activerecord/test/fixtures/db_definitions/db2.sql @@ -122,3 +122,8 @@ CREATE TABLE binaries ( data blob(50000), PRIMARY KEY (id) ); + +CREATE TABLE computers ( + id int generated by default as identity (start with +10000), + developer int NOT NULL +); diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql index 3758f19bfa..0137cd91d5 100755 --- a/activerecord/test/fixtures/db_definitions/mysql.sql +++ b/activerecord/test/fixtures/db_definitions/mysql.sql @@ -121,4 +121,9 @@ CREATE TABLE `binaries` ( `id` int(11) NOT NULL auto_increment, `data` mediumblob, PRIMARY KEY (`id`) +); + +CREATE TABLE `computers` ( + `id` INTEGER NOT NULL PRIMARY KEY, + `developer` INTEGER NOT NULL );
\ 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 8f6587f961..7664c5e6e0 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.sql @@ -139,4 +139,9 @@ CREATE TABLE binaries ( id serial , data bytea, PRIMARY KEY (id) +); + +CREATE TABLE computers ( + id serial, + developer integer NOT NULL );
\ 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 65b24a9333..1b9a5ea932 100644 --- a/activerecord/test/fixtures/db_definitions/sqlite.sql +++ b/activerecord/test/fixtures/db_definitions/sqlite.sql @@ -108,4 +108,9 @@ CREATE TABLE 'people' ( CREATE TABLE 'binaries' ( 'id' INTEGER NOT NULL PRIMARY KEY, 'data' BLOB DEFAULT NULL +); + +CREATE TABLE 'computers' ( + 'id' INTEGER NOT NULL PRIMARY KEY, + 'developer' INTEGER NOT 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 023ab63406..95106a7b18 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql @@ -122,4 +122,8 @@ CREATE TABLE binaries ( PRIMARY KEY (id) ); - +CREATE TABLE computers ( + id int NOT NULL IDENTITY(1, 1), + developer int NOT NULL, + PRIMARY KEY (id) +); |