From d424674f1b95c958adb9e7235218135793c1a71f Mon Sep 17 00:00:00 2001
From: Jeremy Kemper <jeremy@bitsweat.net>
Date: Thu, 9 Feb 2006 19:41:32 +0000
Subject: SQL Server cannot sort on type text. This causes three errors in the
 activerecord test suite, where tests sort on the comments.body or posts.body
 columns. This patch changes these columns from text to varchar(4096),
 allowing these tests to proceed (and pass). All activerecord tests now pass
 under sqlserver.  References #3581. [Tom Ward]

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3559 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
---
 activerecord/test/fixtures/db_definitions/sqlserver.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'activerecord/test/fixtures/db_definitions/sqlserver.sql')

diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql
index 15a0d5fd76..81399b7d26 100644
--- a/activerecord/test/fixtures/db_definitions/sqlserver.sql
+++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql
@@ -134,14 +134,14 @@ CREATE TABLE posts (
   author_id int default NULL,
   title varchar(255) default NULL,
   type varchar(255) default NULL,
-  body text default NULL
+  body varchar(4096) 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
+  body varchar(4096) default NULL
 );
 
 CREATE TABLE authors (
-- 
cgit v1.2.3

