diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/sqlite.sql')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/sqlite.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/sqlite.sql b/activerecord/test/fixtures/db_definitions/sqlite.sql index d57c3889e0..a6f2efcbfe 100644 --- a/activerecord/test/fixtures/db_definitions/sqlite.sql +++ b/activerecord/test/fixtures/db_definitions/sqlite.sql @@ -116,3 +116,21 @@ CREATE TABLE 'computers' ( 'developer' INTEGER NOT NULL ); +CREATE TABLE 'posts' ( + 'id' INTEGER NOT NULL PRIMARY KEY, + 'title' VARCHAR(255) NOT NULL, + 'body' TEXT NOT NULL +); + +CREATE TABLE 'comments' ( + 'id' INTEGER NOT NULL PRIMARY KEY, + 'post_id' INTEGER NOT NULL, + 'body' TEXT NOT NULL +); + +CREATE TABLE 'authors' ( + 'id' INTEGER NOT NULL PRIMARY KEY, + 'post_id' INTEGER NOT NULL, + 'name' VARCHAR(255) NOT NULL +); + |