aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/mysql.sql')
-rwxr-xr-xactiverecord/test/fixtures/db_definitions/mysql.sql18
1 files changed, 18 insertions, 0 deletions
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;
+