37 lines
894 B
SQL
37 lines
894 B
SQL
SET ECHO ON
|
|
SPOOL xaasa480to481.lst
|
|
PROMPT $Revision$
|
|
|
|
|
|
drop table aasa_imp_perslid;
|
|
drop table aasa_imp_costcenter;
|
|
|
|
drop VIEW AAFM_V_EXPORT_LOGIN;
|
|
drop VIEW AASA_V_EXPORT_USAGE;
|
|
drop VIEW AAFM_V_RES_BY_FRONTO;
|
|
drop VIEW AAFM_V_STAT_LOGIN_USER;
|
|
drop VIEW AASA_V_EXPORT_LOGIN;
|
|
drop VIEW AASA_V_EXPORT_NOTIFICATIE;
|
|
drop VIEW AASA_V_PILOT_USING_FRONTO;
|
|
drop VIEW AASA_V_RES_BY_FRONTO;
|
|
drop VIEW AASA_V_RES_OVERVIEW;
|
|
drop VIEW AASA_V_RES_PILOT_INVOERDER;
|
|
drop VIEW AASA_V_RSV_RUIMTE_2_ALG_RUIMTE;
|
|
drop VIEW AASA_V_STAT_LOGIN_USER;
|
|
|
|
drop PROCEDURE AASA_EXPORT_LOGIN;
|
|
drop PROCEDURE AASA_EXPORT_NOTIFICATIE;
|
|
drop PROCEDURE AASA_IMPORT_COSTCENTER;
|
|
drop PROCEDURE AASA_SELECT_LOGIN;
|
|
drop PROCEDURE AASA_SELECT_NOTIFICATIE;
|
|
drop PROCEDURE AASA_UPDATE_COSTCENTER;
|
|
|
|
drop PACKAGE AASA;
|
|
|
|
ALTER TABLE aasa_perslid_login RENAME TO aaxx_perslid_login;
|
|
|
|
|
|
COMMIT;
|
|
|
|
SPOOL OFF
|