diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/sqlserver.sql')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/sqlserver.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql index de746efb57..8e0d78bb61 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql @@ -116,6 +116,26 @@ CREATE TABLE computers ( developer int NOT NULL ); +CREATE TABLE posts ( + id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, + author_id int default NULL, + title varchar(255) default NULL, + type varchar(255) default NULL, + body text default NULL +); + +CREATE TABLE comments ( + id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, + post_id int default NULL, + type varchar(255) default NULL, + body text default NULL +); + +CREATE TABLE authors ( + id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, + name varchar(255) default NULL +); + CREATE TABLE tasks ( id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, starting datetime default NULL, |