| Server IP : 185.11.201.71 / Your IP : 192.168.7.18 Web Server : Apache/2.4.29 (Ubuntu) System : Linux tech-virtual-machine 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 User : tech ( 1000) PHP Version : 7.4.28 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/bbbdd/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;