[Patches] [PATCH] added saved_sql fields to kohastructure

[koha-patchbot at kohaaloha.com]

From: Chris Hall <chrish at catalyst.net.nz>
Date: Tue, 29 Nov 2011 10:21:44 +1300
Subject: [PATCH] added saved_sql fields to kohastructure

---
 installer/data/mysql/kohastructure.sql |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 452173d..3fe8382 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -1626,6 +1626,8 @@ CREATE TABLE saved_sql (
    `report_name` varchar(255) default NULL,
    `type` varchar(255) default NULL,
    `notes` text,
+   `cache_expiry` int NOT NULL default 300,
+   `public` boolean NOT NULL default FALSE, 
    PRIMARY KEY  (`id`),
    KEY boridx (`borrowernumber`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 
1.7.4.1