72 lines
2.7 KiB
SQL
72 lines
2.7 KiB
SQL
|
|
USE partsltd_prod;
|
|
|
|
-- Permanent Temp Tables
|
|
DROP TABLE IF EXISTS partsltd_prod.tmp_ph_Calc_User;
|
|
DROP TABLE IF EXISTS partsltd_prod.tmp_core_Msg_Error;
|
|
DROP TABLE IF EXISTS partsltd_prod.tmp_ph_User;
|
|
DROP TABLE IF EXISTS partsltd_prod.tmp_ph_User_Role_Link;
|
|
|
|
|
|
-- Permanent Tables
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Contact_Form_Temp;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Contact_Form_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Contact_Form;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Contact_Form_Change_Set;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Calc_User_Temp;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_User_Role_Link_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_User_Role_Link;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Role_Permission_Link_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Role_Permission_Link;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Role_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Role;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_User_Temp;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_User_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_User;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Permission_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Permission;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Permission_Group_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Permission_Group;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Access_Level_Audit;
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_Access_Level;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.PH_User_Change_Set;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.CORE_Split_Key_Value_Pair_Csv_Temp;
|
|
DROP TABLE IF EXISTS partsltd_prod.CORE_Split_Temp;
|
|
|
|
DROP TABLE IF EXISTS partsltd_prod.CORE_Msg_Error_Type;
|
|
|
|
|
|
-- Stored Procedures
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_ph_test_get_many_contact_form;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_ph_get_many_contact_form;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_ph_test_save_contact_form;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_ph_save_contact_form;
|
|
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_ph_clear_calc_user;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_ph_calc_user;
|
|
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_core_clear_split_key_value_pair_csv;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_core_split_key_value_pair_csv;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_core_clear_split;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_core_split;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_clear_split_key_value_pair_csv;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_split_key_value_pair_csv;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_clear_split;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_split;
|
|
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_core_debug_timing_reporting;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_debug_timing_reporting;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_core_validate_guid;
|
|
DROP PROCEDURE IF EXISTS partsltd_prod.p_core_validate_guid_test;
|