Changeset 5857 in subversion

Timestamp:

Feb 7, 2012 2:44:01 AM (16 months ago)

Author:

alec

Message:

• Applied fix from trunk

Location:

branches/release-0.7

Files:

• CHANGELOG (modified) (1 diff)
• SQL/mssql.initial.sql (modified) (3 diffs)
• SQL/mssql.upgrade.sql (modified) (1 diff)

branches/release-0.7/CHANGELOG

@@ -2 +2 @@
 ===========================
 
+- Fix parse errors in DDL files for MS SQL Server
 - Revert SORT=DISPLAY support, removed by mistake (#1488327)
 - Add lost translation label in de_DE (#1488315)

branches/release-0.7/SQL/mssql.initial.sql

@@ -30 +30 @@
         [uid] [int] NOT NULL ,
         [changed] [datetime] NOT NULL ,
-        [data] [text] COLLATE Latin1_General_CI_AI NOT NULL 
-        [flags] [int](1) NOT NULL ,
+        [data] [text] COLLATE Latin1_General_CI_AI NOT NULL ,
+        [flags] [int] NOT NULL
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO
@@ -227 +227 @@
 ALTER TABLE [dbo].[cache_messages] ADD 
         CONSTRAINT [DF_cache_messages_changed] DEFAULT (getdate()) FOR [changed],
-        CONSTRAINT [DF_cache_messages_flags] DEFAULT (0) FOR [flags],
+        CONSTRAINT [DF_cache_messages_flags] DEFAULT (0) FOR [flags]
 GO
 
@@ -311 +311 @@
 ALTER TABLE [dbo].[searches] ADD 
         CONSTRAINT [DF_searches_user] DEFAULT (0) FOR [user_id],
-        CONSTRAINT [DF_searches_type] DEFAULT (0) FOR [type],
+        CONSTRAINT [DF_searches_type] DEFAULT (0) FOR [type]
 GO
 

branches/release-0.7/SQL/mssql.upgrade.sql

@@ -176 +176 @@
         [uid] [int] NOT NULL ,
         [changed] [datetime] NOT NULL ,
-        [data] [text] COLLATE Latin1_General_CI_AI NOT NULL 
-        [flags] [int] NOT NULL ,
+        [data] [text] COLLATE Latin1_General_CI_AI NOT NULL ,
+        [flags] [int] NOT NULL
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO