From 3e202813819932ba0291479f27bf85fc83ebb65d Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Fri, 15 Jun 2018 15:41:48 +0800
Subject: [PATCH] sync

---
 DataObjects/Core_event_audit_archive.php   |  18 ++++++++++++++++++
 mysql/core_notify_trigger_after_delete.sql |  20 ++++++++++++++++++++
 templates/images/mailAddClose.gif          | Bin 0 -> 1098 bytes
 3 files changed, 38 insertions(+)
 create mode 100644 DataObjects/Core_event_audit_archive.php
 create mode 100644 mysql/core_notify_trigger_after_delete.sql
 create mode 100644 templates/images/mailAddClose.gif

diff --git a/DataObjects/Core_event_audit_archive.php b/DataObjects/Core_event_audit_archive.php
new file mode 100644
index 00000000..747a1dd2
--- /dev/null
+++ b/DataObjects/Core_event_audit_archive.php
@@ -0,0 +1,18 @@
+<?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
diff --git a/mysql/core_notify_trigger_after_delete.sql b/mysql/core_notify_trigger_after_delete.sql
new file mode 100644
index 00000000..400a4e4c
--- /dev/null
+++ b/mysql/core_notify_trigger_after_delete.sql
@@ -0,0 +1,20 @@
+
+
+-- 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 ;
diff --git a/templates/images/mailAddClose.gif b/templates/images/mailAddClose.gif
new file mode 100644
index 0000000000000000000000000000000000000000..0a05a5246327e8076a453231c9cad8210355b9a3
GIT binary patch
literal 1098
zcmZ?wbhEHb6krfwc+LO<T)YC}%6bwi2C~XJk}3vr$~sc222!d<((1;t8YZ$DrgEBQ
z%9<uBTBZux7E0RYN;(!wI+n`1)@r&Is(LnR`qpatc4`K8ng%xNMt15(_8La^N~Z4W
zX6~A1?i%Lqn&ut`=B|1cZd#UJ`WEimmY%v+K1SAF`Zj)scK(KT0mcqNrcNPdPQhkQ
zA?D7Z<}RTYE@76gkydVzPQD4w{>hF(nf|fmA*l^9navSdt&v%+Q8}Fvg_EL7XGE3F
zjH;LyT{$<kd}><7^!S>E2{j8dYUgFt%}Z%mlG3m=rD0iW!;*}al^HFoGFw&@w64f$
zUzgjyHotvUZpXU9j@5-7Yl^xy7Ibea?A}n=y|J)+Q&IPZqVA0)eVa@Bwv_d4Dev1-
z+7CqA%KEpKPuNy5VSCl29aWQdR!-hkJ!MzTls)y+_chMg*EsWF)69b{vk$e-KGZhn
zNZXvFt#gld%{|gF?^wtD<6R3*_AEHrweV!mqEo$#PxUQ1J7MX$-j!E+S6-d8;^Nem
zm-|;=pRoGI^fgy!ti3*a-K}XG?@!-!fA+S=vv<8*u=B;7U9aZudNqI7i}|}>&ENfc
z@xJ#<_Pt%a|NY8CA6Fjwvg**M<%d77IQ(VZvF~e-|5$tc=h_oLH=p{m@${cfr~hm`
z^JmkUKReF-+i~vy_6vWvUHr2hg#PZi{D1e=KYOnJJ8<p)!5e=L-UOomNACPRcK83W
zd;d;7{D1o4{|nFlUwHoi(#!u>U;e-J>i^}}{~v$*|K!{Mr+@yv{`ddW|Nr0=G=vGo
ze}c|Msfi`2DGKG8B^e6tp1uJLIv@{$G6)05KZe?mmr}c@tqEW4)%s{kXV4PIu(H3W
zj%tZ&`p?qxty;n%xIo6F;O;Bd(^FRkFR)0Q#FBY&B7;oU#-`F0eH}J6Z?-rxruK3(
zNT)5$N?kFbPpazKjRS>hzB~-#Nxea;8UgcpT-r<=l+%2;8ARhMjh-&&m$ML&ney`z
zD>pZTa9HNAE$;lX=4>1d7nM{`aWM!5#NH}#KQ~**x+-GArzM_T4E!#>heVF^@=K=d
zIJ0A7%1KTJ9xKB|N7T-6=toL8e@HyS!oWIB#4;#3?Ud*-pE?FXAtnbVuTH78p2lh1
zqUv5<9Gpx{3``#N6ZSM*Y-;TiQTM3%P{828=w!(x%^=~w?@t9|Xhy+>hJ}Y(IQS)W
OJQ@-j8u%C)8LR<6j;UJ!

literal 0
HcmV?d00001

-- 
2.39.2