From f2a29ca43cb0de38a25bf7f68bca5c11871692ce Mon Sep 17 00:00:00 2001 From: David Heinemeier Hansson Date: Fri, 1 Jul 2005 17:20:04 +0000 Subject: Added support for ODBC connections to MS SQL Server so you can connect from a non-Windows machine #1569 [Mark Imbriaco/DeLynn Berry] Added support for limit/offset with the MS SQL Server driver so that pagination will now work #1569 [DeLynn Berry] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1583 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- activerecord/test/fixtures/db_definitions/sqlserver.drop.sql | 2 ++ activerecord/test/fixtures/db_definitions/sqlserver.sql | 6 +++--- 2 files changed, 5 insertions(+), 3 deletions(-) (limited to 'activerecord/test/fixtures') diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql b/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql index efa98fe500..226544392d 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql @@ -21,3 +21,5 @@ DROP TABLE authors; DROP TABLE tasks; DROP TABLE categories; DROP TABLE categories_posts; +DROP TABLE fk_test_has_pd; +DROP TABLE fk_test_has_fk; diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql index 9c5658e387..1177b37035 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql @@ -2,7 +2,7 @@ CREATE TABLE accounts ( id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, firm_id int default NULL, credit_limit int default NULL -) +); CREATE TABLE companies ( id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, @@ -12,7 +12,7 @@ CREATE TABLE companies ( name varchar(50) default NULL, client_of int default NULL, rating int default 1 -) +); CREATE TABLE topics ( id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, @@ -27,7 +27,7 @@ CREATE TABLE topics ( replies_count int default 0, parent_id int default NULL, type varchar(50) default NULL -) +); CREATE TABLE developers ( id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, -- cgit v1.2.3