Revision ce9a5b4b
Von Tamino Steinert vor etwa 1 Jahr hinzugefügt
| SL/DB/MetaSetup/EmailJournal.pm | ||
|---|---|---|
| 19 | 19 |
id => { type => 'serial', not_null => 1 },
|
| 20 | 20 |
itime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| 21 | 21 |
mtime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| 22 |
obsolete => { type => 'boolean', default => 'false', not_null => 1 },
|
|
| 22 | 23 |
recipients => { type => 'text', not_null => 1 },
|
| 23 | 24 |
sender_id => { type => 'integer' },
|
| 24 | 25 |
sent_on => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| sql/Pg-upgrade2/email_journal_add_obsolete.sql | ||
|---|---|---|
| 1 |
-- @tag: email_journal_add_obsolete |
|
| 2 |
-- @description: E-Mail-Journal um obsolete erweitern |
|
| 3 |
-- @depends: release_3_8_0 |
|
| 4 |
|
|
| 5 |
ALTER TABLE email_journal ADD COLUMN obsolete BOOLEAN NOT NULL DEFAULT FALSE; |
|
Auch abrufbar als: Unified diff
EmailJournal: DB: um Ungültig-Feld erweitert