--DROP VIEW dcs_inventory;
--DROP VIEW rob_inventory;
DROP VIEW inventory CASCADE;


DROP VIEW roc_dcs;
DROP VIEW roc_summary;

DROP TRIGGER mcm_positions_valid ON mcm;
DROP FUNCTION mcm_positions_valid();

DROP TRIGGER ori_positions_valid ON ori;
DROP FUNCTION ori_positions_valid();

DROP TRIGGER dcs_positions_valid ON dcs;
DROP FUNCTION dcs_positions_valid();




DROP VIEW mcm_hist;
DROP VIEW ori_hist;
DROP VIEW dcs_hist;
DROP VIEW rob_hist;
DROP VIEW pdb_hist;
DROP VIEW roc_hist;
DROP VIEW sm_hist;

DROP TABLE mcm_old;
DROP TABLE ori_old;
DROP TABLE dcs_old;
DROP TABLE rob_old;
DROP TABLE pdb_old;
DROP TABLE roc_old;
DROP TABLE sm_old;


DROP TABLE mcm CASCADE;
DROP TABLE ori CASCADE;
DROP TABLE dcs CASCADE;
DROP TABLE rob CASCADE;
DROP TABLE pdb CASCADE;
DROP TABLE roc CASCADE;
DROP TABLE sm CASCADE;

DROP TABLE loc;
