Changeset 2829 in subversion

Timestamp:

Aug 3, 2009 7:40:04 AM (4 years ago)

Author:

alec

Message:

• Fix MS SQL DDL (#1486020)

Location:

trunk/roundcubemail

Files:

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

trunk/roundcubemail/CHANGELOG

@@ -2 +2 @@
 ===========================
 
+- Fix MS SQL DDL (#1486020)
 - Fix rcube_mdb2.php: call to setCharset not implemented in mssql driver (#1486019)
 - Added 'display_next' option

trunk/roundcubemail/SQL/mssql.initial.sql

@@ -31 +31 @@
         [reply-to] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
         [bcc] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
-        [signature] [text] COLLATE Latin1_General_CI_AI NOT NULL, 
+        [signature] [text] COLLATE Latin1_General_CI_AI NULL, 
         [html_signature] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
@@ -70 +70 @@
         [alias] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
         [created] [datetime] NOT NULL ,
-        [last_login] [datetime] NULL ,
+        [last_login] [datetime] NOT NULL ,
         [language] [varchar] (5) COLLATE Latin1_General_CI_AI NULL ,
-        [preferences] [text] COLLATE Latin1_General_CI_AI NOT NULL 
+        [preferences] [text] COLLATE Latin1_General_CI_AI NULL 
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO
@@ -156 +156 @@
         CONSTRAINT [DF_identities_reply] DEFAULT ('') FOR [reply-to],
         CONSTRAINT [DF_identities_bcc] DEFAULT ('') FOR [bcc],
+        CONSTRAINT [DF_identities_html_signature] DEFAULT ('0') FOR [html_signature],
          CHECK ([standard] = '1' or [standard] = '0'),
          CHECK ([del] = '1' or [del] = '0')
@@ -203 +204 @@
         CONSTRAINT [DF_users_mail_host] DEFAULT ('') FOR [mail_host],
         CONSTRAINT [DF_users_alias] DEFAULT ('') FOR [alias],
-        CONSTRAINT [DF_users_created] DEFAULT (getdate()) FOR [created],
+        CONSTRAINT [DF_users_created] DEFAULT (getdate()) FOR [created]
 GO