From 377fb39eaa8e03f1c9796c0447f130ac299fd486 Mon Sep 17 00:00:00 2001
From: chriskl <chriskl>
Date: Mon, 10 Mar 2003 02:29:17 +0000
Subject: [PATCH] SQL script to create reports database for pgsql

---
 sql/reports-pgsql.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 sql/reports-pgsql.sql

diff --git a/sql/reports-pgsql.sql b/sql/reports-pgsql.sql
new file mode 100644
index 00000000..c683cc36
--- /dev/null
+++ b/sql/reports-pgsql.sql
@@ -0,0 +1,25 @@
+-- SQL script to create reports database for PostgreSQL
+-- 
+-- To run, type: psql template1 < reports-pgsql.sql
+--
+-- $Id: reports-pgsql.sql,v 1.1 2003/03/10 02:29:17 chriskl Exp $
+
+CREATE DATABASE phppgadmin;
+
+\c phppgadmin
+
+CREATE TABLE ppa_reports (
+	report_id SERIAL,
+	report_name varchar(255) NOT NULL,
+	db_name varchar(255) NOT NULL,
+	date_created date DEFAULT 'now' NOT NULL,
+	created_by varchar(255) NOT NULL,
+	descr text,
+	report_sql text NOT NULL,
+	PRIMARY KEY (report_id)
+);
+
+-- Allow everyone to do everything with reports.  This may
+-- or may not be what you want.
+GRANT SELECT,INSERT,UPDATE,DELETE ON ppa_reports TO PUBLIC;
+
-- 
2.39.5