Revision 7a778ade
Von Jan Büren vor fast 3 Jahren hinzugefügt
| SL/DB/MetaSetup/OrderVersion.pm | ||
|---|---|---|
|
__PACKAGE__->meta->columns(
|
||
|
email_journal_id => { type => 'integer' },
|
||
|
file_id => { type => 'integer' },
|
||
|
final_version => { type => 'boolean', default => 'false' },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
mtime => { type => 'timestamp' },
|
||
|
oe_id => { type => 'integer', not_null => 1 },
|
||
| sql/Pg-upgrade2/oe_version.sql | ||
|---|---|---|
|
-- @ignore: 0
|
||
|
CREATE TABLE oe_version (
|
||
|
oe_id integer,
|
||
|
version integer,
|
||
|
version INTEGER NOT NULL,
|
||
|
final_version BOOLEAN DEFAULT FALSE,
|
||
|
email_journal_id integer,
|
||
|
file_id integer,
|
||
|
itime TIMESTAMP DEFAULT now(),
|
||
| ... | ... | |
|
FOREIGN KEY (oe_id) REFERENCES oe (id),
|
||
|
FOREIGN KEY (email_journal_id) REFERENCES email_journal (id),
|
||
|
FOREIGN KEY (file_id) REFERENCES files (id));
|
||
|
|
||
|
CREATE TRIGGER mtime_oe_version BEFORE UPDATE ON oe_version FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|
||
Auch abrufbar als: Unified diff
Hilfstabelle oe_version erweitert