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