2 files changed, 21 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/mysql.drop.sql b/activerecord/test/fixtures/db_definitions/mysql.drop.sql
index 1f611c8d5a..99b391ea16 100644
--- a/activerecord/test/fixtures/db_definitions/mysql.drop.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql.drop.sql
@@ -15,4 +15,7 @@ DROP TABLE mixins;
 DROP TABLE people;
 DROP TABLE binaries;
 DROP TABLE computers;
+DROP TABLE posts;
+DROP TABLE comments;
+DROP TABLE authors;
 
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql
index ca61159b74..8c919ff4ca 100755
--- a/activerecord/test/fixtures/db_definitions/mysql.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql.sql
@@ -129,3 +129,21 @@ CREATE TABLE `computers` (
   `developer` INTEGER NOT NULL
 ) TYPE=InnoDB;
 
+CREATE TABLE `posts` (
+  `id` INTEGER NOT NULL PRIMARY KEY,
+  `author_id` INTEGER NOT NULL,
+  `title` VARCHAR(255) NOT NULL,
+  `body` TEXT NOT NULL
+) TYPE=InnoDB;
+
+CREATE TABLE `comments` (
+  `id` INTEGER NOT NULL PRIMARY KEY,
+  `post_id` INTEGER NOT NULL,
+  `body` TEXT NOT NULL
+) TYPE=InnoDB;
+
+CREATE TABLE `authors` (
+  `id` INTEGER NOT NULL PRIMARY KEY,
+  `name` VARCHAR(255) NOT NULL
+) TYPE=InnoDB;
+