view release on metacpan or  search on metacpan

bin/bgpmon_cpm_db_0_cpmTables.psql  view on Meta::CPAN

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

drop schema if exists cpm cascade;
create schema cpm;

create table cpm.lists (
  dbid SERIAL PRIMARY KEY,
  name char(255) UNIQUE NOT NULL
);

create table cpm.domains (
  dbid SERIAL PRIMARY KEY,
  domain char(255) UNIQUE NOT NULL