-- Change type description length\012\012ALTER TABLE sample_types ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE data_set_types ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE experiment_types ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE material_types ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE controlled_vocabularies ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE data_types ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE file_format_types ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE locator_types ALTER COLUMN description TYPE DESCRIPTION_250;\012ALTER TABLE property_types ALTER COLUMN description TYPE DESCRIPTION_250;\012\012DROP TYPE description_80;\012\012-- Add attachment title and description\012\012CREATE DOMAIN TITLE_100 AS VARCHAR(100);\012\012ALTER TABLE attachments ADD COLUMN title TITLE_100;\012ALTER TABLE attachments ADD COLUMN description DESCRIPTION_1000;\012\012-- Add 'POWER_USER' to AUTHORIZATION_ROLE domain\012\012ALTER DOMAIN authorization_role DROP CONSTRAINT authorization_role_check;\012ALTER DOMAIN authorization_role ADD CONSTRAINT authorization_role_check CHECK (VALUE IN ('ADMIN', 'POWER_USER', 'USER', 'OBSERVER', 'ETL_SERVER'));\012