diff options
Diffstat (limited to 'activerecord/test/fixtures')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/mysql.drop.sql | 3 | ||||
-rwxr-xr-x | activerecord/test/fixtures/db_definitions/mysql.sql | 18 |
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; + |