Revision 11f62590
Von Tamino Steinert vor etwa 1 Jahr hinzugefügt
| SL/DB/MetaSetup/File.pm | ||
|---|---|---|
|
mime_type => { type => 'text', not_null => 1 },
|
||
|
mtime => { type => 'timestamp' },
|
||
|
object_id => { type => 'integer', not_null => 1 },
|
||
|
object_type => { type => 'text', not_null => 1 },
|
||
|
object_type => { type => 'enum', check_in => [ 'sales_quotation', 'sales_order', 'sales_order_intake', 'request_quotation', 'purchase_quotation_intake', 'purchase_order', 'purchase_order_confirmation', 'sales_delivery_order', 'supplier_delivery_order', 'purchase_delivery_order', 'rma_delivery_order', 'invoice', 'invoice_for_advance_payment', 'final_invoice', 'credit_note', 'purchase_invoice', 'sales_reclamation', 'purchase_reclamation', 'dunning', 'dunning1', 'dunning2', 'dunning3', 'dunning_orig_invoice', 'dunning_invoice', 'customer', 'vendor', 'gl_transaction', 'part', 'shop_image', 'draft', 'letter', 'project', 'statement' ], db_type => 'file_object_types', not_null => 1 },
|
||
|
print_variant => { type => 'text' },
|
||
|
source => { type => 'text', not_null => 1 },
|
||
|
title => { type => 'varchar', length => 45 },
|
||
| sql/Pg-upgrade2/file_object_type_as_enum.sql | ||
|---|---|---|
|
-- @tag: file_object_type_as_enum
|
||
|
-- @description: Objekttype von Dateien in Enum ändern
|
||
|
-- @depends: release_3_6_0
|
||
|
|
||
|
CREATE TYPE file_object_types AS ENUM (
|
||
|
-- order
|
||
|
'sales_quotation',
|
||
|
'sales_order',
|
||
|
'sales_order_intake',
|
||
|
'request_quotation',
|
||
|
'purchase_quotation_intake',
|
||
|
'purchase_order',
|
||
|
'purchase_order_confirmation',
|
||
|
-- delivery_order
|
||
|
'sales_delivery_order',
|
||
|
'supplier_delivery_order',
|
||
|
'purchase_delivery_order',
|
||
|
'rma_delivery_order',
|
||
|
-- invoice
|
||
|
'invoice',
|
||
|
'invoice_for_advance_payment',
|
||
|
'final_invoice',
|
||
|
'credit_note',
|
||
|
'purchase_invoice',
|
||
|
-- reclamation
|
||
|
'sales_reclamation',
|
||
|
'purchase_reclamation',
|
||
|
-- dunning
|
||
|
'dunning',
|
||
|
'dunning1',
|
||
|
'dunning2',
|
||
|
'dunning3',
|
||
|
'dunning_orig_invoice',
|
||
|
'dunning_invoice',
|
||
|
-- cv
|
||
|
'customer',
|
||
|
'vendor',
|
||
|
-- other
|
||
|
'gl_transaction',
|
||
|
'part',
|
||
|
'shop_image',
|
||
|
'draft',
|
||
|
'letter',
|
||
|
'project',
|
||
|
'statement'
|
||
|
);
|
||
|
|
||
|
ALTER TABLE files ADD COLUMN object_type_new file_object_types;
|
||
|
UPDATE files SET object_type_new = object_type::file_object_types;
|
||
|
ALTER TABLE files ALTER COLUMN object_type_new SET NOT NULL;
|
||
|
ALTER TABLE files DROP COLUMN object_type;
|
||
|
ALTER TABLE files RENAME COLUMN object_type_new TO object_type;
|
||
Auch abrufbar als: Unified diff
S:D:File: Objekttype auf Type Enum setzen