Revision 36f031f5
Von Tamino Steinert vor 2 Monaten 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