aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/sqlserver.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/sqlserver.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/sqlserver.sql20
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,