| Server IP : 104.21.37.246 / Your IP : 172.71.28.146 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/2388321/cwd/3rdparty/phpPgAdmin/plugins/Report/sql/ |
Upload File : |
-- SQL script to create reports database for PostgreSQL -- -- To run, type: psql template1 < reports-pgsql.sql -- -- $Id: reports-pgsql.sql,v 1.4 2007/04/16 11:02:36 mr-russ Exp $ CREATE DATABASE phppgadmin; \connect 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, paginate boolean 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; GRANT SELECT,UPDATE ON ppa_reports_report_id_seq TO PUBLIC;