Revision 1168e9c9
Von Kivitendo Admin vor fast 11 Jahren hinzugefügt
| SL/DB/MetaSetup/GLTransaction.pm | ||
|---|---|---|
| 37 | 37 |
key_columns => { department_id => 'id' },
|
| 38 | 38 |
}, |
| 39 | 39 |
|
| 40 |
employee => {
|
|
| 41 |
class => 'SL::DB::Employee', |
|
| 42 |
key_columns => { employee_id => 'id' },
|
|
| 43 |
}, |
|
| 44 |
|
|
| 40 | 45 |
storno_obj => {
|
| 41 | 46 |
class => 'SL::DB::GLTransaction', |
| 42 | 47 |
key_columns => { storno_id => 'id' },
|
| sql/Pg-upgrade2/gl_add_employee_foreign_key.sql | ||
|---|---|---|
| 1 |
-- @tag: gl_add_employee_foreign_key |
|
| 2 |
-- @description: Dialogbuchungen mit Bearbeiter verknüpfen |
|
| 3 |
-- @depends: release_3_0_0 |
|
| 4 |
-- @ignore: 0 |
|
| 5 |
ALTER TABLE gl ADD FOREIGN KEY (employee_id) REFERENCES employee(id); |
|
Auch abrufbar als: Unified diff
Fremdschlüssel für Bearbeiter in gl einführen