Revision f725711f
Von Tamino Steinert vor etwa 1 Jahr hinzugefügt
| SL/DB/MetaSetup/File.pm | ||
|---|---|---|
|
__PACKAGE__->meta->table('files');
|
||
|
|
||
|
__PACKAGE__->meta->columns(
|
||
|
backend => { type => 'text' },
|
||
|
backend => { type => 'enum', check_in => [ 'Filesystem', 'Webdav' ], db_type => 'files_backends', not_null => 1 },
|
||
|
backend_data => { type => 'text' },
|
||
|
description => { type => 'text' },
|
||
|
file_name => { type => 'text', not_null => 1 },
|
||
| sql/Pg-upgrade2/change_file_backend_to_enum.sql | ||
|---|---|---|
|
-- @tag: change_file_backend_to_enum
|
||
|
-- @description: Backend für Dateien auf Type Enum setzen
|
||
|
-- @depends: release_3_6_0
|
||
|
|
||
|
CREATE TYPE files_backends AS ENUM ('Filesystem', 'Webdav');
|
||
|
|
||
|
ALTER TABLE files ADD COLUMN backend_new files_backends;
|
||
|
UPDATE files SET backend_new = 'Filesystem' WHERE backend = 'Filesystem';
|
||
|
UPDATE files SET backend_new = 'Webdav' WHERE backend = 'Webdav';
|
||
|
ALTER TABLE files ALTER COLUMN backend_new SET NOT NULL;
|
||
|
ALTER TABLE files DROP COLUMN backend;
|
||
|
ALTER TABLE files RENAME COLUMN backend_new TO backend;
|
||
Auch abrufbar als: Unified diff
S:D:File: Backend auf Type Enum setzen