From 6d57b11d8351dbce2adb38a1095d65a33f531fa6 Mon Sep 17 00:00:00 2001 From: Thomas Bruederli <thomas@roundcube.net> Date: Thu, 24 Jan 2013 08:21:27 -0500 Subject: [PATCH] Save some vertical space in message part view --- SQL/mssql.initial.sql | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql index 85b8e4e..694fe7e 100644 --- a/SQL/mssql.initial.sql +++ b/SQL/mssql.initial.sql @@ -115,6 +115,12 @@ ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +CREATE TABLE [dbo].[system] ( + [name] [varchar] (64) COLLATE Latin1_General_CI_AI NOT NULL , + [value] [text] COLLATE Latin1_General_CI_AI NOT NULL +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +GO + ALTER TABLE [dbo].[cache_index] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( @@ -182,6 +188,13 @@ CONSTRAINT [PK_searches_search_id] PRIMARY KEY CLUSTERED ( [search_id] + ) ON [PRIMARY] +GO + +ALTER TABLE [dbo].[system] WITH NOCHECK ADD + CONSTRAINT [PK_system_name] PRIMARY KEY CLUSTERED + ( + [name] ) ON [PRIMARY] GO @@ -358,3 +371,6 @@ WHERE [contact_id] IN (SELECT [contact_id] FROM deleted) GO +INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2013011700.sql') +GO + \ No newline at end of file -- Gitblit v1.9.1