diff options
| author | David Heinemeier Hansson <david@loudthinking.com> | 2005-04-07 06:20:54 +0000 |
|---|---|---|
| committer | David Heinemeier Hansson <david@loudthinking.com> | 2005-04-07 06:20:54 +0000 |
| commit | bd9a81ca2d34562a140dfe9a6cfecf969a01042c (patch) | |
| tree | 966266871e2714aef19a4ebab8f639f5f6421a01 /activerecord/test/fixtures | |
| parent | 38a0b5b427371b53c0d0f159cf5b3806f16aab30 (diff) | |
| download | rails-bd9a81ca2d34562a140dfe9a6cfecf969a01042c.tar.gz rails-bd9a81ca2d34562a140dfe9a6cfecf969a01042c.tar.bz2 rails-bd9a81ca2d34562a140dfe9a6cfecf969a01042c.zip | |
Moved to new server
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1102 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
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; + |