diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2005-07-01 17:20:04 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2005-07-01 17:20:04 +0000 |
commit | f2a29ca43cb0de38a25bf7f68bca5c11871692ce (patch) | |
tree | 49fafc3247a77dc1b8797e4425b28923af6a51d0 /activerecord/test/fixtures/db_definitions | |
parent | 64612db7cf85aee8434e7b9b4fd8d6d0249c60e4 (diff) | |
download | rails-f2a29ca43cb0de38a25bf7f68bca5c11871692ce.tar.gz rails-f2a29ca43cb0de38a25bf7f68bca5c11871692ce.tar.bz2 rails-f2a29ca43cb0de38a25bf7f68bca5c11871692ce.zip |
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
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/sqlserver.drop.sql | 2 | ||||
-rw-r--r-- | activerecord/test/fixtures/db_definitions/sqlserver.sql | 6 |
2 files changed, 5 insertions, 3 deletions
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, |