Revision d3007329
Von Kivitendo Admin vor mehr als 9 Jahren hinzugefügt
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
|
mtime => { type => 'timestamp' },
|
||
|
normalize_part_descriptions => { type => 'boolean', default => 'true' },
|
||
|
normalize_vc_names => { type => 'boolean', default => 'true' },
|
||
|
order_always_project => { type => 'boolean', default => 'false' },
|
||
|
parts_image_css => { type => 'text', default => 'border:0;float:left;max-width:250px;margin-top:20px:margin-right:10px;margin-left:10px;' },
|
||
|
parts_listing_image => { type => 'boolean', default => 'true' },
|
||
|
parts_show_image => { type => 'boolean', default => 'true' },
|
||
| ... | ... | |
|
pdonumber => { type => 'text' },
|
||
|
ponumber => { type => 'text' },
|
||
|
profit_determination => { type => 'text' },
|
||
|
project_status_id => { type => 'integer' },
|
||
|
project_type_id => { type => 'integer' },
|
||
|
purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' },
|
||
|
purchase_order_show_delete => { type => 'boolean', default => 'true' },
|
||
|
reqdate_interval => { type => 'integer', default => '0' },
|
||
| ... | ... | |
|
key_columns => { currency_id => 'id' },
|
||
|
},
|
||
|
|
||
|
project_status => {
|
||
|
class => 'SL::DB::ProjectStatus',
|
||
|
key_columns => { project_status_id => 'id' },
|
||
|
},
|
||
|
|
||
|
project_type => {
|
||
|
class => 'SL::DB::ProjectType',
|
||
|
key_columns => { project_type_id => 'id' },
|
||
|
},
|
||
|
|
||
|
requirement_spec_section_order_part => {
|
||
|
class => 'SL::DB::Part',
|
||
|
key_columns => { requirement_spec_section_order_part_id => 'id' },
|
||
| sql/Pg-upgrade2/project_defaults.sql | ||
|---|---|---|
|
-- @tag: add_project_defaults
|
||
|
-- @description: Standardprojekttyp und Standardprojectstatus
|
||
|
-- @depends: release_3_2_0
|
||
|
ALTER TABLE defaults ADD COLUMN order_always_project boolean DEFAULT false;
|
||
|
ALTER TABLE defaults ADD COLUMN project_status_id integer;
|
||
|
ALTER TABLE defaults ADD COLUMN project_type_id integer;
|
||
|
ALTER TABLE defaults ADD FOREIGN KEY (project_status_id) REFERENCES project_statuses (id);
|
||
|
ALTER TABLE defaults ADD FOREIGN KEY (project_type_id) REFERENCES project_types (id);
|
||
|
|
||
Auch abrufbar als: Unified diff
Aufträge immer mit Projektnummer speichern.
Feature kann in der Mandantenkonfiguration aktiviert werden.