githubFork/roundcubemail.git

			@@ -111,7 +111,7 @@
			DELETE FROM [dbo].[cache]
			GO

			-- Updates from version 0.6-stable
			-- Updates from version 0.6

			CREATE TABLE [dbo].[dictionary] (
			[user_id] [int] ,
			@@ -151,3 +151,101 @@
			ON DELETE CASCADE ON UPDATE CASCADE
			GO

			DROP TABLE [dbo].[messages]
			GO
			CREATE TABLE [dbo].[cache_index] (
			[user_id] [int] NOT NULL ,
			[mailbox] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
			[changed] [datetime] NOT NULL ,
			[valid] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
			[data] [text] COLLATE Latin1_General_CI_AI NOT NULL
			) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
			GO

			CREATE TABLE [dbo].[cache_thread] (
			[user_id] [int] NOT NULL ,
			[mailbox] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
			[changed] [datetime] NOT NULL ,
			[data] [text] COLLATE Latin1_General_CI_AI NOT NULL
			) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
			GO

			CREATE TABLE [dbo].[cache_messages] (
			[user_id] [int] NOT NULL ,
			[mailbox] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
			[uid] [int] NOT NULL ,
			[changed] [datetime] NOT NULL ,
			[data] [text] COLLATE Latin1_General_CI_AI NOT NULL ,
			[flags] [int] NOT NULL
			) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
			GO

			ALTER TABLE [dbo].[cache_index] WITH NOCHECK ADD
			PRIMARY KEY CLUSTERED
			(
			[user_id],[mailbox]
			) ON [PRIMARY]
			GO

			ALTER TABLE [dbo].[cache_thread] WITH NOCHECK ADD
			PRIMARY KEY CLUSTERED
			(
			[user_id],[mailbox]
			) ON [PRIMARY]
			GO

			ALTER TABLE [dbo].[cache_messages] WITH NOCHECK ADD
			PRIMARY KEY CLUSTERED
			(
			[user_id],[mailbox],[uid]
			) ON [PRIMARY]
			GO

			ALTER TABLE [dbo].[cache_index] ADD
			CONSTRAINT [DF_cache_index_changed] DEFAULT (getdate()) FOR [changed],
			CONSTRAINT [DF_cache_index_valid] DEFAULT ('0') FOR [valid]
			GO

			CREATE INDEX [IX_cache_index_user_id] ON [dbo].[cache_index]([user_id]) ON [PRIMARY]
			GO

			ALTER TABLE [dbo].[cache_thread] ADD
			CONSTRAINT [DF_cache_thread_changed] DEFAULT (getdate()) FOR [changed]
			GO

			CREATE INDEX [IX_cache_thread_user_id] ON [dbo].[cache_thread]([user_id]) ON [PRIMARY]
			GO

			ALTER TABLE [dbo].[cache_messages] ADD
			CONSTRAINT [DF_cache_messages_changed] DEFAULT (getdate()) FOR [changed],
			CONSTRAINT [DF_cache_messages_flags] DEFAULT (0) FOR [flags]
			GO

			CREATE INDEX [IX_cache_messages_user_id] ON [dbo].[cache_messages]([user_id]) ON [PRIMARY]
			GO

			ALTER TABLE [dbo].[cache_index] ADD CONSTRAINT [FK_cache_index_user_id]
			FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
			ON DELETE CASCADE ON UPDATE CASCADE
			GO

			ALTER TABLE [dbo].[cache_thread] ADD CONSTRAINT [FK_cache_thread_user_id]
			FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
			ON DELETE CASCADE ON UPDATE CASCADE
			GO

			ALTER TABLE [dbo].[cache_messages] ADD CONSTRAINT [FK_cache_messages_user_id]
			FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
			ON DELETE CASCADE ON UPDATE CASCADE
			GO

			-- Updates from version 0.7-beta

			ALTER TABLE [dbo].[session] ALTER COLUMN [sess_id] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL
			GO

			-- Updates from version 0.7

			ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [text] COLLATE Latin1_General_CI_AI NOT NULL
			GO