18 lines
373 B
SQL
18 lines
373 B
SQL
SET ECHO ON
|
|
SPOOL xaasa480to481.lst
|
|
PROMPT $Revision$
|
|
|
|
drop trigger aasa_rsv_deel_a_iu;
|
|
drop table aasa_rsv_deel;
|
|
drop VIEW AAFM_V_EXPORT_LOGIN;
|
|
drop VIEW AAFM_V_RES_BY_FRONTO;
|
|
drop VIEW AAFM_V_STAT_LOGIN_USER;
|
|
|
|
insert into prs_perslidwerkplek (prs_perslid_key, prs_werkplek_key)
|
|
(select prs_perslid_key, 1 from prs_perslid);
|
|
|
|
COMMIT;
|
|
|
|
SPOOL OFF
|
|
@aasa.sql
|