aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/db2.sql
diff options
context:
space:
mode:
authorDavid Heinemeier Hansson <david@loudthinking.com>2005-04-18 07:52:58 +0000
committerDavid Heinemeier Hansson <david@loudthinking.com>2005-04-18 07:52:58 +0000
commit03097d3a6047e269641a14f4c93838598011f0b5 (patch)
treea30a49108dfffc631ee4eb652fce7b41bb4b517e /activerecord/test/fixtures/db_definitions/db2.sql
parentb8c07c0325fdfee701de1a68811c941bced606be (diff)
downloadrails-03097d3a6047e269641a14f4c93838598011f0b5.tar.gz
rails-03097d3a6047e269641a14f4c93838598011f0b5.tar.bz2
rails-03097d3a6047e269641a14f4c93838598011f0b5.zip
Fixed that fixtures were being deleted in the same order as inserts causing FK errors #890 [andrew.john.peters@gmail.com]
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1205 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/db2.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/db2.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/db2.sql b/activerecord/test/fixtures/db_definitions/db2.sql
index 35efa3f6c7..1097568ce3 100644
--- a/activerecord/test/fixtures/db_definitions/db2.sql
+++ b/activerecord/test/fixtures/db_definitions/db2.sql
@@ -164,3 +164,14 @@ CREATE TABLE categories_posts (
category_id int NOT NULL,
post_id int NOT NULL
);
+
+CREATE TABLE fk_test_has_pk (
+ id INTEGER NOT NULL PRIMARY KEY
+);
+
+CREATE TABLE fk_test_has_fk (
+ id INTEGER NOT NULL PRIMARY KEY,
+ fk_id INTEGER NOT NULL,
+
+ FOREIGN KEY (fk_id) REFERENCES fk_test_has_pk(id)
+);