awips2/deltaScripts/14.2.1/dropNcccfp.sh
2017-04-21 18:33:55 -06:00

11 lines
262 B
Bash

#!/bin/bash
# DR #2485 remove ncccfp from the database
PSQL="/awips2/psql/bin/psql"
SQL_COMMAND="
delete from plugin_info where name = 'ncccfp';
drop table if exists ncccfp;
drop sequence if exists ncccfpseq;
"
${PSQL} -U awips -d metadata -c "${SQL_COMMAND}"