--- /dev/null
+<?php
+/**
+ * Table Definition for core_events_archive
+ */
+require_once 'Core_event_audit.php';
+
+class Pman_Core_DataObjects_Core_events_audit_archive extends Pman_Core_DataObjects_Core_event_audit
+{
+ ###START_AUTOCODE
+ /* the code below is auto generated do not remove the above tag */
+
+ public $__table = 'core_event_audit_archive'; // table name
+
+
+
+
+
+}
\ No newline at end of file
--- /dev/null
+
+
+-- can not delete 'sent' notifications -- trick is to 'null the sent before deleting...
+
+DROP TRIGGER IF EXISTS core_notify_trigger_after_delete;
+
+DELIMITER $$
+
+CREATE TRIGGER core_notify_trigger_after_delete AFTER DELETE on core_notify
+ FOR EACH ROW
+ BEGIN
+ if old.sent is not null THEN
+ UPDATE `Error: Can not delete core_notify after it is sent` SET x = 1;
+ END IF;
+ END;
+
+$$
+
+
+DELIMITER ;