cleanup.sql

java开源的企业总线.xmlBlaster

-- ---------------------------------------------------------------------------- 
-- Written by Michele Laghi ([e-mail]) 2005-08-09                    
-- Cleanup sql script to clean up the system resources for the master part of   
-- the replication with xmlBlaster for Postgres                                 
-- ---------------------------------------------------------------------------- 

DROP PROCEDURE ${replPrefix}debug
-- FLUSH (dropped ${replPrefix}debug)                                           
DROP TABLE ${replPrefix}debug_table
-- FLUSH (dropped ${replPrefix}debug_table)                                     
DROP TABLE ${replPrefix}longs_table
-- FLUSH (dropped ${replPrefix}longs_table)                                     
DROP FUNCTION ${replPrefix}add_table
-- FLUSH (dropped ${replPrefix}add_table)                                       
DROP FUNCTION ${replPrefix}base64_enc_blob
-- FLUSH (dropped ${replPrefix}base64_enc_blob)                                 
DROP FUNCTION ${replPrefix}base64_enc_clob
-- FLUSH (dropped ${replPrefix}base64_enc_clob)                                 
DROP FUNCTION ${replPrefix}base64_enc_raw
-- FLUSH (dropped ${replPrefix}base64_enc_raw)                                  
DROP FUNCTION ${replPrefix}base64_enc_varchar2
-- FLUSH (dropped ${replPrefix}base64_enc_varchar2)                             
DROP FUNCTION ${replPrefix}base64_helper
-- FLUSH (dropped ${replPrefix}base64_helper)                                   
DROP FUNCTION ${replPrefix}check_tables
-- FLUSH (dropped ${replPrefix}check_tables)                                    
DROP TRIGGER ${replPrefix}tables_trigger
-- FLUSH (dropped ${replPrefix}tables_trigger)                                  
DROP TRIGGER ${replPrefix}scheduler_trigger
-- FLUSH (dropped ${replPrefix}scheduler_trigger)                               
DROP TABLE ${replPrefix}tables
-- FLUSH (dropped ${replPrefix}tables)                                          
DROP TABLE ${replPrefix}current_tables
-- FLUSH (dropped ${replPrefix}current_tables)                                  
DROP SEQUENCE ${replPrefix}seq
-- FLUSH (dropped ${replPrefix}seq)                                             
DROP TABLE ${replPrefix}items
-- FLUSH (dropped ${replPrefix}items)                                           
DROP FUNCTION ${replPrefix}schema_funct
-- FLUSH (dropped ${replPrefix}schema_funct)                                    
DROP FUNCTION ${replPrefix}col2xml
-- FLUSH (dropped ${replPrefix}col2xml)                                         
DROP FUNCTION ${replPrefix}col2xml_base64
-- FLUSH (dropped ${replPrefix}col2xml_base64)                                  
DROP FUNCTION ${replPrefix}col2xml_cdata
-- FLUSH (dropped ${replPrefix}col2xml_cdata)                                   
DROP FUNCTION ${replPrefix}check_structure
-- FLUSH (dropped ${replPrefix}check_structure)                                 
DROP FUNCTION ${replPrefix}needs_prot
-- FLUSH (dropped ${replPrefix}needs_prot)                                      
DROP FUNCTION ${replPrefix}increment
-- FLUSH (dropped ${replPrefix}increment)                                       
DROP FUNCTION ${replPrefix}check_tables
-- FLUSH (dropped ${replPrefix}check_tables)                                    
DROP FUNCTION ${replPrefix}test_blob
-- FLUSH (dropped ${replPrefix}test_blob)                                       
DROP FUNCTION ${replPrefix}test_clob
-- FLUSH (dropped ${replPrefix}test_clob)                                       
DROP FUNCTION ${replPrefix}prepare_broadcast
-- FLUSH (dropped ${replPrefix}prepare_broadcast)                               
PURGE RECYCLEBIN
-- FLUSH (purged recyclebin)