view release on metacpan or  search on metacpan

bin/bgpmon_analytics_db_0_pphTables.psql  view on Meta::CPAN

/* 
To create the database, run this file through psql like so:
prompt> psql -f 0_pph_createTables.postgresql bgpmon_db bgpmon_db_user
*/

/* pph = peer, prefix history */
drop schema if exists pph cascade;
create schema pph;


CREATE TABLE pph.rib_import(
	peer INET,
	collector VARCHAR(30),
	prefix CIDR,
	ts TIMESTAMP WITHOUT TIME ZONE,
	origin INTEGER,
	lasthop INTEGER,