From e3490449500a655f74d210b0fa5e463d4a2d2b9f Mon Sep 17 00:00:00 2001 From: alec Date: Mon, 19 Sep 2011 06:15:58 +0000 Subject: - Add lost cache_index.valid column definition git-svn-id: https://svn.roundcube.net/trunk@5234 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/SQL/mssql.upgrade.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'roundcubemail/SQL/mssql.upgrade.sql') diff --git a/roundcubemail/SQL/mssql.upgrade.sql b/roundcubemail/SQL/mssql.upgrade.sql index 3def890bd..b506e5d96 100644 --- a/roundcubemail/SQL/mssql.upgrade.sql +++ b/roundcubemail/SQL/mssql.upgrade.sql @@ -157,6 +157,7 @@ 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 @@ -201,7 +202,8 @@ ALTER TABLE [dbo].[cache_messages] WITH NOCHECK ADD GO ALTER TABLE [dbo].[cache_index] ADD - CONSTRAINT [DF_cache_index_changed] DEFAULT (getdate()) FOR [changed] + 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] -- cgit v1.2.3