Revision 36f031f5
Von Tamino Steinert vor 26 Tagen hinzugefügt
| SL/DB/MetaSetup/EmailJournalAttachment.pm | ||
|---|---|---|
| 18 | 18 |
mtime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| 19 | 19 |
name => { type => 'text', not_null => 1 },
|
| 20 | 20 |
position => { type => 'integer', not_null => 1 },
|
| 21 |
processed => { type => 'boolean', default => 'false', not_null => 1 },
|
|
| 21 | 22 |
); |
| 22 | 23 |
|
| 23 | 24 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| sql/Pg-upgrade2/email_journal_attachments_add_processed_flag.sql | ||
|---|---|---|
| 1 |
-- @tag: email_journal_attachments_add_processed_flag |
|
| 2 |
-- @description: E-Mailanhänge als verarbeitet markieren |
|
| 3 |
-- @depends: release_3_8_0 |
|
| 4 |
ALTER TABLE email_journal_attachments ADD COLUMN processed BOOLEAN DEFAULT FALSE NOT NULL; |
|
| 5 |
|
|
| 6 |
-- set attachments of send emails to processed |
|
| 7 |
UPDATE email_journal_attachments |
|
| 8 |
SET processed = TRUE |
|
| 9 |
FROM email_journal |
|
| 10 |
WHERE email_journal_id = email_journal.id AND email_journal.status != 'imported' |
|
Auch abrufbar als: Unified diff
EmailJournalAttachment: SQL: Verarbeitet-Flag hinzufügen