Fossil SCM
Fix minor problems with email notification.
Commit
d7ccfb64a321da20b0f111313357dce6d1543ebe077bc421262ef36bd9841be3
Parent
1cdf6f2049f7658…
1 file changed
+1
-1
+1
-1
| --- src/email.c | ||
| +++ src/email.c | ||
| @@ -103,11 +103,11 @@ | ||
| 103 | 103 | void email_triggers_enable(void){ |
| 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 | - " INSERT INTO pending_alert(eventid,mtime)\n" | |
| 108 | + " INSERT INTO pending_alert(eventid)\n" | |
| 109 | 109 | " SELECT printf('%%.1c%%d',new.type,new.objid)," |
| 110 | 110 | " julianday('now') WHERE true\n" |
| 111 | 111 | " ON CONFLICT(eventId) DO NOTHING;\n" |
| 112 | 112 | "END;" |
| 113 | 113 | ); |
| 114 | 114 |
| --- src/email.c | |
| +++ src/email.c | |
| @@ -103,11 +103,11 @@ | |
| 103 | void email_triggers_enable(void){ |
| 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,mtime)\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 |
| --- src/email.c | |
| +++ src/email.c | |
| @@ -103,11 +103,11 @@ | |
| 103 | void email_triggers_enable(void){ |
| 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 |