diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/db2.sql')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/db2.sql | 11 |
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) +); |