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.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql
index 8e0d78bb61..3d93dffe20 100644
--- a/activerecord/test/fixtures/db_definitions/sqlserver.sql
+++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql
@@ -141,3 +141,13 @@ CREATE TABLE tasks (
starting datetime default NULL,
ending datetime default NULL
);
+
+CREATE TABLE categories (
+ id int NOT NULL IDENTITY(1, 1) PRIMARY KEY,
+ name varchar(255)
+);
+
+CREATE TABLE categories_posts (
+ category_id int NOT NULL,
+ post_id int int NOT NULL
+);