Fossil SCM
Futher corrections to the email alert trigger.
Commit
2c3b903043c65cbf30355d7585797a140ad448e165d7d91b725ea365d5f125e8
Parent
d7ccfb64a321da2…
1 file changed
+1
-2
+1
-2
| --- src/email.c | ||
| +++ src/email.c | ||
| @@ -104,12 +104,11 @@ | ||
| 104 | 104 | if( !db_table_exists("repository","pending_alert") ) return; |
| 105 | 105 | db_multi_exec( |
| 106 | 106 | "CREATE TRIGGER IF NOT EXISTS repository.email_trigger1\n" |
| 107 | 107 | "AFTER INSERT ON event BEGIN\n" |
| 108 | 108 | " INSERT INTO pending_alert(eventid)\n" |
| 109 | - " SELECT printf('%%.1c%%d',new.type,new.objid)," | |
| 110 | - " julianday('now') WHERE true\n" | |
| 109 | + " SELECT printf('%%.1c%%d',new.type,new.objid) WHERE true\n" | |
| 111 | 110 | " ON CONFLICT(eventId) DO NOTHING;\n" |
| 112 | 111 | "END;" |
| 113 | 112 | ); |
| 114 | 113 | } |
| 115 | 114 | |
| 116 | 115 |
| --- src/email.c | |
| +++ src/email.c | |
| @@ -104,12 +104,11 @@ | |
| 104 | if( !db_table_exists("repository","pending_alert") ) return; |
| 105 | db_multi_exec( |
| 106 | "CREATE TRIGGER IF NOT EXISTS repository.email_trigger1\n" |
| 107 | "AFTER INSERT ON event BEGIN\n" |
| 108 | " INSERT INTO pending_alert(eventid)\n" |
| 109 | " SELECT printf('%%.1c%%d',new.type,new.objid)," |
| 110 | " julianday('now') WHERE true\n" |
| 111 | " ON CONFLICT(eventId) DO NOTHING;\n" |
| 112 | "END;" |
| 113 | ); |
| 114 | } |
| 115 | |
| 116 |
| --- src/email.c | |
| +++ src/email.c | |
| @@ -104,12 +104,11 @@ | |
| 104 | if( !db_table_exists("repository","pending_alert") ) return; |
| 105 | db_multi_exec( |
| 106 | "CREATE TRIGGER IF NOT EXISTS repository.email_trigger1\n" |
| 107 | "AFTER INSERT ON event BEGIN\n" |
| 108 | " INSERT INTO pending_alert(eventid)\n" |
| 109 | " SELECT printf('%%.1c%%d',new.type,new.objid) WHERE true\n" |
| 110 | " ON CONFLICT(eventId) DO NOTHING;\n" |
| 111 | "END;" |
| 112 | ); |
| 113 | } |
| 114 | |
| 115 |