Revision 7a778ade
Von Jan Büren vor mehr als 2 Jahren hinzugefügt
| sql/Pg-upgrade2/oe_version.sql | ||
|---|---|---|
| 4 | 4 |
-- @ignore: 0 |
| 5 | 5 |
CREATE TABLE oe_version ( |
| 6 | 6 |
oe_id integer, |
| 7 |
version integer, |
|
| 7 |
version INTEGER NOT NULL, |
|
| 8 |
final_version BOOLEAN DEFAULT FALSE, |
|
| 8 | 9 |
email_journal_id integer, |
| 9 | 10 |
file_id integer, |
| 10 | 11 |
itime TIMESTAMP DEFAULT now(), |
| ... | ... | |
| 13 | 14 |
FOREIGN KEY (oe_id) REFERENCES oe (id), |
| 14 | 15 |
FOREIGN KEY (email_journal_id) REFERENCES email_journal (id), |
| 15 | 16 |
FOREIGN KEY (file_id) REFERENCES files (id)); |
| 17 |
|
|
| 18 |
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