From f03a6046ede07f61339d250abdb4d499531d4682 Mon Sep 17 00:00:00 2001 From: Chris Hall 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