From 7b2bf71c332563517b8f0f30c6f214913dc4169e Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Mon, 19 Sep 2011 06:15:58 +0000
Subject: - Add lost cache_index.valid column definition

---
 SQL/postgres.update.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'SQL/postgres.update.sql')

diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql
index 741495fbe..7e650af7a 100644
--- a/SQL/postgres.update.sql
+++ b/SQL/postgres.update.sql
@@ -135,6 +135,7 @@ CREATE TABLE cache_index (
     	REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
     mailbox varchar(255) NOT NULL,
     changed timestamp with time zone DEFAULT now() NOT NULL,
+    valid smallint NOT NULL DEFAULT 0,
     data text NOT NULL,
     PRIMARY KEY (user_id, mailbox)
 );
-- 
cgit v1.2.3

