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