29 lines
530 B
SQL
29 lines
530 B
SQL
-- Customer specific once-script to clean-up/delete all MLD-content that have been made
|
|
-- during test-period.
|
|
-- (c) 2008 SG|facilitor bv
|
|
-- $Revision$
|
|
-- $Id$
|
|
--
|
|
-- Support: +31 53 4800700
|
|
SET ECHO ON;
|
|
SPOOL xwehk_delete_mld_content.lst;
|
|
|
|
/* MLD */
|
|
DELETE FROM mld_kenmerkmelding;
|
|
|
|
DELETE FROM mld_kenmerkopdr;
|
|
|
|
DELETE FROM mld_melding_object;
|
|
|
|
DELETE FROM mld_opdr;
|
|
|
|
DELETE FROM mld_melding;
|
|
|
|
DELETE FROM fac_activiteit;
|
|
|
|
/* WEB user messages */
|
|
DELETE FROM web_user_messages;
|
|
|
|
COMMIT;
|
|
SPOOL OFF;
|