Revision d3007329
Von Kivitendo Admin vor etwa 9 Jahren hinzugefügt
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
| 69 | 69 |
mtime => { type => 'timestamp' },
|
| 70 | 70 |
normalize_part_descriptions => { type => 'boolean', default => 'true' },
|
| 71 | 71 |
normalize_vc_names => { type => 'boolean', default => 'true' },
|
| 72 |
order_always_project => { type => 'boolean', default => 'false' },
|
|
| 72 | 73 |
parts_image_css => { type => 'text', default => 'border:0;float:left;max-width:250px;margin-top:20px:margin-right:10px;margin-left:10px;' },
|
| 73 | 74 |
parts_listing_image => { type => 'boolean', default => 'true' },
|
| 74 | 75 |
parts_show_image => { type => 'boolean', default => 'true' },
|
| ... | ... | |
| 76 | 77 |
pdonumber => { type => 'text' },
|
| 77 | 78 |
ponumber => { type => 'text' },
|
| 78 | 79 |
profit_determination => { type => 'text' },
|
| 80 |
project_status_id => { type => 'integer' },
|
|
| 81 |
project_type_id => { type => 'integer' },
|
|
| 79 | 82 |
purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' },
|
| 80 | 83 |
purchase_order_show_delete => { type => 'boolean', default => 'true' },
|
| 81 | 84 |
reqdate_interval => { type => 'integer', default => '0' },
|
| ... | ... | |
| 132 | 135 |
key_columns => { currency_id => 'id' },
|
| 133 | 136 |
}, |
| 134 | 137 |
|
| 138 |
project_status => {
|
|
| 139 |
class => 'SL::DB::ProjectStatus', |
|
| 140 |
key_columns => { project_status_id => 'id' },
|
|
| 141 |
}, |
|
| 142 |
|
|
| 143 |
project_type => {
|
|
| 144 |
class => 'SL::DB::ProjectType', |
|
| 145 |
key_columns => { project_type_id => 'id' },
|
|
| 146 |
}, |
|
| 147 |
|
|
| 135 | 148 |
requirement_spec_section_order_part => {
|
| 136 | 149 |
class => 'SL::DB::Part', |
| 137 | 150 |
key_columns => { requirement_spec_section_order_part_id => 'id' },
|
| sql/Pg-upgrade2/project_defaults.sql | ||
|---|---|---|
| 1 |
-- @tag: add_project_defaults |
|
| 2 |
-- @description: Standardprojekttyp und Standardprojectstatus |
|
| 3 |
-- @depends: release_3_2_0 |
|
| 4 |
ALTER TABLE defaults ADD COLUMN order_always_project boolean DEFAULT false; |
|
| 5 |
ALTER TABLE defaults ADD COLUMN project_status_id integer; |
|
| 6 |
ALTER TABLE defaults ADD COLUMN project_type_id integer; |
|
| 7 |
ALTER TABLE defaults ADD FOREIGN KEY (project_status_id) REFERENCES project_statuses (id); |
|
| 8 |
ALTER TABLE defaults ADD FOREIGN KEY (project_type_id) REFERENCES project_types (id); |
|
| 9 |
|
|
Auch abrufbar als: Unified diff
Aufträge immer mit Projektnummer speichern.
Feature kann in der Mandantenkonfiguration aktiviert werden.