-- This file must exist, because its highest version number is taken as Perun code version, and is compared to
-- the current DB data version from table configurations, and if they do not match, Perun will refuse to start.

-- Changelog file should have the newest version at the top, the oldest at the bottom.
-- Versions must be separated by empty lines, version number should consist of three numbers with dots between, f.e. 3.0.1 is ok, 3.1 or 3.1.1.1 is not.
-- Directly under version number should be version commands. They will be executed in the order they are written here.
-- Comments are prefixed with -- and can be written only between version blocks, that means not in the lines with commands. They have to be at the start of the line.

3.1.68
CREATE TABLE vos_bans (id integer not null, member_id integer not null, vo_id integer not null, description varchar, banned_to timestamp default '2999-01-01 00:00:00' not null, created_at timestamp default statement_timestamp() not null, created_by varchar default user not null, modified_at timestamp default statement_timestamp() not null, modified_by varchar default user not null, created_by_uid integer, modified_by_uid integer, constraint vos_bans_pk primary key (id), constraint vos_bans_u unique (member_id), constraint vos_bans_mem_fk foreign key (member_id) references members (id), constraint vos_bans_vo_fk foreign key (vo_id) references vos (id));
CREATE SEQUENCE "vos_bans_id_seq";
CREATE INDEX idx_fk_vos_ban_member ON vos_bans (member_id);
CREATE INDEX idx_fk_vos_ban_vos ON vos_bans (vo_id);
GRANT ALL ON vos_bans TO perun;
INSERT INTO vos_bans (id, description, banned_to, member_id, vo_id) SELECT nextval('vos_bans_id_seq'), 'AUTO CREATED FROM SUSPEND STATUS', members.suspended_to, members.id, members.vo_id FROM members WHERE status = 2 AND members.suspended_to IS NOT NULL;
INSERT INTO vos_bans (id, description, member_id, vo_id) SELECT nextval('vos_bans_id_seq'), 'AUTO CREATED FROM SUSPEND STATUS', members.id, members.vo_id FROM members WHERE status = 2 AND members.suspended_to IS NULL;
UPDATE members SET status=0 WHERE status = 2;
ALTER TABLE members DROP COLUMN suspended_to;
UPDATE configurations SET value='3.1.68' WHERE property='DATABASE VERSION';

3.1.67
ALTER TABLE users ADD COLUMN uu_id UUID not null default gen_random_uuid();
ALTER TABLE groups ADD COLUMN uu_id UUID not null default gen_random_uuid();
ALTER TABLE resources ADD COLUMN uu_id UUID not null default gen_random_uuid();
update configurations set value='3.1.67' where property='DATABASE VERSION';

3.1.66
ALTER TABLE tasks DROP CONSTRAINT task_stat_chk;
ALTER TABLE tasks ADD CONSTRAINT task_stat_chk check (status in ('WAITING', 'PLANNED', 'GENERATING', 'GENERROR', 'GENERATED', 'SENDING', 'DONE', 'SENDERROR', 'ERROR', 'WARNING'));
ALTER TABLE tasks_results DROP CONSTRAINT taskres_stat_chk;
ALTER TABLE tasks_results ADD CONSTRAINT taskres_stat_chk check (status in ('DONE','ERROR','DENIED', 'WARNING'));
update configurations set value='3.1.66' where property='DATABASE VERSION';

3.1.65
ALTER TABLE host_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE host_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE host_attr_values DROP COLUMN attr_value_text;
ALTER TABLE host_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE entityless_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE entityless_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE entityless_attr_values DROP COLUMN attr_value_text;
ALTER TABLE facility_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE facility_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE facility_attr_values DROP COLUMN attr_value_text;
ALTER TABLE facility_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE group_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE group_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE group_attr_values DROP COLUMN attr_value_text;
ALTER TABLE group_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE resource_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE resource_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE resource_attr_values DROP COLUMN attr_value_text;
ALTER TABLE resource_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE group_resource_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE group_resource_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE group_resource_attr_values DROP COLUMN attr_value_text;
ALTER TABLE group_resource_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE member_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE member_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE member_attr_values DROP COLUMN attr_value_text;
ALTER TABLE member_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE member_group_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE member_group_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE member_group_attr_values DROP COLUMN attr_value_text;
ALTER TABLE member_group_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE member_resource_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE member_resource_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE member_resource_attr_values DROP COLUMN attr_value_text;
ALTER TABLE member_resource_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE user_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE user_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE user_attr_values DROP COLUMN attr_value_text;
ALTER TABLE user_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE user_facility_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE user_facility_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE user_facility_attr_values DROP COLUMN attr_value_text;
ALTER TABLE user_facility_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE vo_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE vo_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE vo_attr_values DROP COLUMN attr_value_text;
ALTER TABLE vo_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE user_ext_source_attr_values ALTER COLUMN attr_value TYPE text;
UPDATE user_ext_source_attr_values set attr_value=attr_value_text where attr_value is null and attr_value_text is not null;
ALTER TABLE user_ext_source_attr_values DROP COLUMN attr_value_text;
ALTER TABLE user_ext_source_attr_u_values ALTER COLUMN attr_value TYPE text;
ALTER TABLE ext_sources_attributes ALTER COLUMN attr_value TYPE text;
update configurations set value='3.1.65' where property='DATABASE VERSION';

3.1.64
ALTER TABLE vos DROP COLUMN status;
ALTER TABLE users DROP COLUMN status;
ALTER TABLE owners DROP COLUMN status;
ALTER TABLE facilities DROP COLUMN status;
ALTER TABLE resources DROP COLUMN status;
ALTER TABLE destinations DROP COLUMN status;
ALTER TABLE facility_owners DROP COLUMN status;
ALTER TABLE groups DROP COLUMN status;
ALTER TABLE attr_names DROP COLUMN status;
ALTER TABLE hosts DROP COLUMN status;
ALTER TABLE host_attr_values DROP COLUMN status;
ALTER TABLE services DROP COLUMN status;
ALTER TABLE service_required_attrs DROP COLUMN status;
ALTER TABLE service_denials DROP COLUMN status;
ALTER TABLE resource_services DROP COLUMN status;
ALTER TABLE facility_service_destinations DROP COLUMN status;
ALTER TABLE entityless_attr_values DROP COLUMN status;
ALTER TABLE facility_attr_values DROP COLUMN status;
ALTER TABLE group_attr_values DROP COLUMN status;
ALTER TABLE resource_attr_values DROP COLUMN status;
ALTER TABLE group_resource_attr_values DROP COLUMN status;
ALTER TABLE groups_members DROP COLUMN status;
ALTER TABLE groups_resources DROP COLUMN status;
ALTER TABLE member_attr_values DROP COLUMN status;
ALTER TABLE member_group_attr_values DROP COLUMN status;
ALTER TABLE member_resource_attr_values DROP COLUMN status;
ALTER TABLE user_attr_values DROP COLUMN status;
ALTER TABLE user_facility_attr_values DROP COLUMN status;
ALTER TABLE vo_attr_values DROP COLUMN status;
ALTER TABLE ext_sources DROP COLUMN status;
ALTER TABLE ext_sources_attributes DROP COLUMN status;
ALTER TABLE vo_ext_sources DROP COLUMN status;
ALTER TABLE user_ext_sources DROP COLUMN status;
ALTER TABLE service_packages DROP COLUMN status;
ALTER TABLE service_service_packages DROP COLUMN status;
ALTER TABLE user_ext_source_attr_values DROP COLUMN status;
ALTER TABLE specific_user_users DROP CONSTRAINT specifu_u_status_chk;
ALTER TABLE specific_user_users ALTER COLUMN status drop DEFAULT;
ALTER TABLE specific_user_users ALTER COLUMN status TYPE integer USING status::int;
ALTER TABLE specific_user_users ALTER COLUMN status SET DEFAULT 0;
ALTER TABLE specific_user_users ADD CONSTRAINT specifu_u_status_chk check (status in (0,1));
update configurations set value='3.1.64' where property='DATABASE VERSION';

3.1.63
ALTER TABLE members ALTER COLUMN status drop DEFAULT;
ALTER TABLE members ALTER COLUMN status TYPE integer USING status::int;
ALTER TABLE members ALTER COLUMN status SET DEFAULT 0;
update configurations set value='3.1.63' where property='DATABASE VERSION';

3.1.62
ALTER TABLE application_form ALTER COLUMN automatic_approval TYPE boolean USING automatic_approval::boolean;
ALTER TABLE application_form ALTER COLUMN automatic_approval SET default false;
UPDATE application_form SET automatic_approval=false where automatic_approval is null;
ALTER TABLE application_form ALTER COLUMN automatic_approval SET not null;
ALTER TABLE application_form ALTER COLUMN automatic_approval_extension TYPE boolean USING automatic_approval_extension::boolean;
ALTER TABLE application_form ALTER COLUMN automatic_approval_extension SET default false;
UPDATE application_form SET automatic_approval_extension=false where automatic_approval_extension is null;
ALTER TABLE application_form ALTER COLUMN automatic_approval_extension SET not null;
ALTER TABLE application_form_items ALTER COLUMN required TYPE boolean USING required::boolean;
ALTER TABLE application_form_items ALTER COLUMN required SET default false;
UPDATE application_form_items SET required=false where required is null;
ALTER TABLE application_form_items ALTER COLUMN required SET not null;
ALTER TABLE application_mails ALTER COLUMN send TYPE boolean USING send::boolean;
ALTER TABLE application_mails ALTER COLUMN send SET default false;
ALTER TABLE application_mails ALTER COLUMN send SET not null;
ALTER TABLE cabinet_publications ALTER COLUMN locked drop DEFAULT;
ALTER TABLE cabinet_publications ALTER COLUMN locked TYPE boolean USING locked::boolean;
ALTER TABLE cabinet_publications ALTER COLUMN locked SET default false;
ALTER TABLE cabinet_publications ALTER COLUMN locked SET not null;
ALTER TABLE members_sponsored ALTER COLUMN active drop DEFAULT;
ALTER TABLE members_sponsored ALTER COLUMN active TYPE boolean USING active::boolean;
ALTER TABLE members_sponsored ALTER COLUMN active SET default true;
ALTER TABLE members_sponsored ALTER COLUMN active SET not null;
ALTER TABLE services ALTER COLUMN enabled drop DEFAULT;
ALTER TABLE services ALTER COLUMN enabled TYPE boolean USING enabled::boolean;
ALTER TABLE services ALTER COLUMN enabled SET default true;
ALTER TABLE services ALTER COLUMN enabled SET not null;
ALTER TABLE users DROP CONSTRAINT usr_srvacc_chk;
ALTER TABLE users ALTER COLUMN service_acc drop DEFAULT;
ALTER TABLE users ALTER COLUMN service_acc TYPE boolean USING service_acc::boolean;
ALTER TABLE users ALTER COLUMN service_acc SET default false;
UPDATE users SET service_acc=false where service_acc is null;
ALTER TABLE users ALTER COLUMN service_acc SET not null;
ALTER TABLE users ALTER COLUMN sponsored_acc drop DEFAULT;
ALTER TABLE users ALTER COLUMN sponsored_acc TYPE boolean USING sponsored_acc::boolean;
ALTER TABLE users ALTER COLUMN sponsored_acc SET default false;
UPDATE users SET sponsored_acc=false where sponsored_acc is null;
ALTER TABLE users ALTER COLUMN sponsored_acc SET not null;
update configurations set value='3.1.62' where property='DATABASE VERSION';

3.1.61
ALTER TABLE vos ALTER COLUMN name TYPE varchar;
ALTER TABLE vos ALTER COLUMN short_name TYPE varchar;
ALTER TABLE vos ALTER COLUMN created_by TYPE varchar;
ALTER TABLE vos ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE users ALTER COLUMN first_name TYPE varchar;
ALTER TABLE users ALTER COLUMN last_name TYPE varchar;
ALTER TABLE users ALTER COLUMN middle_name TYPE varchar;
ALTER TABLE users ALTER COLUMN title_before TYPE varchar;
ALTER TABLE users ALTER COLUMN title_after TYPE varchar;
ALTER TABLE users ALTER COLUMN created_by TYPE varchar;
ALTER TABLE users ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE owners ALTER COLUMN name TYPE varchar;
ALTER TABLE owners ALTER COLUMN contact TYPE varchar;
ALTER TABLE owners ALTER COLUMN created_by TYPE varchar;
ALTER TABLE owners ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE owners ALTER COLUMN type TYPE varchar;
ALTER TABLE cabinet_categories ALTER COLUMN name TYPE varchar;
ALTER TABLE cabinet_publication_systems ALTER COLUMN friendlyName TYPE varchar;
ALTER TABLE cabinet_publication_systems ALTER COLUMN url TYPE varchar;
ALTER TABLE cabinet_publication_systems ALTER COLUMN username TYPE varchar;
ALTER TABLE cabinet_publication_systems ALTER COLUMN password TYPE varchar;
ALTER TABLE cabinet_publication_systems ALTER COLUMN loginNamespace TYPE varchar;
ALTER TABLE cabinet_publication_systems ALTER COLUMN type TYPE varchar;
ALTER TABLE cabinet_publications ALTER COLUMN title TYPE varchar;
ALTER TABLE cabinet_publications ALTER COLUMN main TYPE varchar;
ALTER TABLE cabinet_publications ALTER COLUMN isbn TYPE varchar;
ALTER TABLE cabinet_publications ALTER COLUMN createdBy TYPE varchar;
ALTER TABLE cabinet_publications ALTER COLUMN doi TYPE varchar;
ALTER TABLE cabinet_authorships ALTER COLUMN createdBy TYPE varchar;
ALTER TABLE cabinet_thanks ALTER COLUMN createdBy TYPE varchar;
ALTER TABLE facilities ALTER COLUMN name TYPE varchar;
ALTER TABLE facilities ALTER COLUMN dsc TYPE varchar;
ALTER TABLE facilities ALTER COLUMN created_by TYPE varchar;
ALTER TABLE facilities ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE resources ALTER COLUMN name TYPE varchar;
ALTER TABLE resources ALTER COLUMN dsc TYPE varchar;
ALTER TABLE resources ALTER COLUMN created_by TYPE varchar;
ALTER TABLE resources ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE destinations ALTER COLUMN destination TYPE varchar;
ALTER TABLE destinations ALTER COLUMN type TYPE varchar;
ALTER TABLE destinations ALTER COLUMN created_by TYPE varchar;
ALTER TABLE destinations ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE facility_owners ALTER COLUMN created_by TYPE varchar;
ALTER TABLE facility_owners ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE groups ALTER COLUMN dsc TYPE varchar;
ALTER TABLE groups ALTER COLUMN created_by TYPE varchar;
ALTER TABLE groups ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE facility_contacts ALTER COLUMN name TYPE varchar;
ALTER TABLE members ALTER COLUMN created_by TYPE varchar;
ALTER TABLE members ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE roles ALTER COLUMN name TYPE varchar;
ALTER TABLE action_types ALTER COLUMN action_type TYPE varchar;
ALTER TABLE action_types ALTER COLUMN description TYPE varchar;
ALTER TABLE membership_types ALTER COLUMN membership_type TYPE varchar;
ALTER TABLE membership_types ALTER COLUMN description TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN attr_name TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN friendly_name TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN namespace TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN type TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN dsc TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN created_by TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE attr_names ALTER COLUMN display_name TYPE varchar;
ALTER TABLE hosts ALTER COLUMN hostname TYPE varchar;
ALTER TABLE hosts ALTER COLUMN dsc TYPE varchar;
ALTER TABLE hosts ALTER COLUMN created_by TYPE varchar;
ALTER TABLE hosts ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE host_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE host_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE host_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE host_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE auditer_consumers ALTER COLUMN name TYPE varchar;
ALTER TABLE auditer_consumers ALTER COLUMN created_by TYPE varchar;
ALTER TABLE auditer_consumers ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE services ALTER COLUMN name TYPE varchar;
ALTER TABLE services ALTER COLUMN description TYPE varchar;
ALTER TABLE services ALTER COLUMN script TYPE varchar;
ALTER TABLE services ALTER COLUMN created_by TYPE varchar;
ALTER TABLE services ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE service_required_attrs ALTER COLUMN created_by TYPE varchar;
ALTER TABLE service_required_attrs ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE specific_user_users ALTER COLUMN type TYPE varchar;
ALTER TABLE service_denials ALTER COLUMN created_by TYPE varchar;
ALTER TABLE service_denials ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE resource_services ALTER COLUMN created_by TYPE varchar;
ALTER TABLE resource_services ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE application ALTER COLUMN apptype TYPE varchar;
ALTER TABLE application ALTER COLUMN extSourceName TYPE varchar;
ALTER TABLE application ALTER COLUMN extSourceType TYPE varchar;
ALTER TABLE application ALTER COLUMN state TYPE varchar;
ALTER TABLE application ALTER COLUMN created_by TYPE varchar;
ALTER TABLE application ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE application_form ALTER COLUMN module_name TYPE varchar;
ALTER TABLE application_form_items ALTER COLUMN shortname TYPE varchar;
ALTER TABLE application_form_items ALTER COLUMN type TYPE varchar;
ALTER TABLE application_form_items ALTER COLUMN fed_attr TYPE varchar;
ALTER TABLE application_form_items ALTER COLUMN src_attr TYPE varchar;
ALTER TABLE application_form_items ALTER COLUMN dst_attr TYPE varchar;
ALTER TABLE application_form_items ALTER COLUMN regex TYPE varchar;
ALTER TABLE application_form_item_apptypes ALTER COLUMN apptype TYPE varchar;
ALTER TABLE application_form_item_texts ALTER COLUMN locale TYPE varchar;
ALTER TABLE application_form_item_texts ALTER COLUMN help TYPE varchar;
ALTER TABLE application_form_item_texts ALTER COLUMN error_message TYPE varchar;
ALTER TABLE application_data ALTER COLUMN shortname TYPE varchar;
ALTER TABLE application_data ALTER COLUMN value TYPE varchar;
ALTER TABLE application_data ALTER COLUMN assurance_level TYPE varchar;
ALTER TABLE application_mails ALTER COLUMN app_type TYPE varchar;
ALTER TABLE application_mails ALTER COLUMN mail_type TYPE varchar;
ALTER TABLE application_mail_texts ALTER COLUMN locale TYPE varchar;
ALTER TABLE application_mail_texts ALTER COLUMN subject TYPE varchar;
ALTER TABLE application_mail_texts ALTER COLUMN text TYPE varchar;
ALTER TABLE application_reserved_logins ALTER COLUMN login TYPE varchar;
ALTER TABLE application_reserved_logins ALTER COLUMN namespace TYPE varchar;
ALTER TABLE application_reserved_logins ALTER COLUMN created_by TYPE varchar;
ALTER TABLE facility_service_destinations ALTER COLUMN created_by TYPE varchar;
ALTER TABLE facility_service_destinations ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE facility_service_destinations ALTER COLUMN propagation_type TYPE varchar;
ALTER TABLE entityless_attr_values ALTER COLUMN subject TYPE varchar;
ALTER TABLE entityless_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE entityless_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE entityless_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE facility_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE facility_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE facility_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE facility_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE group_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE group_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE group_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE group_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE resource_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE resource_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE resource_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE resource_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE group_resource_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE group_resource_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE group_resource_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE group_resource_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE groups_members ALTER COLUMN created_by TYPE varchar;
ALTER TABLE groups_members ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE groups_resources ALTER COLUMN created_by TYPE varchar;
ALTER TABLE groups_resources ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE member_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE member_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE member_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE member_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE member_group_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE member_group_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE member_group_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE member_group_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE member_resource_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE member_resource_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE member_resource_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE member_resource_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE user_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE user_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE user_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE user_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE user_facility_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE user_facility_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE user_facility_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE user_facility_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE vo_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE vo_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE vo_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE vo_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE ext_sources ALTER COLUMN name TYPE varchar;
ALTER TABLE ext_sources ALTER COLUMN type TYPE varchar;
ALTER TABLE ext_sources ALTER COLUMN created_by TYPE varchar;
ALTER TABLE ext_sources ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE ext_sources_attributes ALTER COLUMN attr_name TYPE varchar;
ALTER TABLE ext_sources_attributes ALTER COLUMN created_by TYPE varchar;
ALTER TABLE ext_sources_attributes ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE vo_ext_sources ALTER COLUMN created_by TYPE varchar;
ALTER TABLE vo_ext_sources ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE group_ext_sources ALTER COLUMN created_by TYPE varchar;
ALTER TABLE group_ext_sources ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE user_ext_sources ALTER COLUMN login_ext TYPE varchar;
ALTER TABLE user_ext_sources ALTER COLUMN created_by TYPE varchar;
ALTER TABLE user_ext_sources ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE service_packages ALTER COLUMN name TYPE varchar;
ALTER TABLE service_packages ALTER COLUMN description TYPE varchar;
ALTER TABLE service_packages ALTER COLUMN created_by TYPE varchar;
ALTER TABLE service_packages ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE service_service_packages ALTER COLUMN created_by TYPE varchar;
ALTER TABLE service_service_packages ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE tasks ALTER COLUMN status TYPE varchar;
ALTER TABLE tasks ALTER COLUMN err_message TYPE varchar;
ALTER TABLE tasks_results ALTER COLUMN status TYPE varchar;
ALTER TABLE tasks_results ALTER COLUMN err_message TYPE varchar;
ALTER TABLE tasks_results ALTER COLUMN std_message TYPE varchar;
ALTER TABLE tasks_results ALTER COLUMN created_by TYPE varchar;
ALTER TABLE tasks_results ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE auditer_log ALTER COLUMN actor TYPE varchar;
ALTER TABLE reserved_logins ALTER COLUMN login TYPE varchar;
ALTER TABLE reserved_logins ALTER COLUMN namespace TYPE varchar;
ALTER TABLE reserved_logins ALTER COLUMN application TYPE varchar;
ALTER TABLE reserved_logins ALTER COLUMN id TYPE varchar;
ALTER TABLE pn_object ALTER COLUMN name TYPE varchar;
ALTER TABLE pn_object ALTER COLUMN properties TYPE varchar;
ALTER TABLE pn_object ALTER COLUMN class_name TYPE varchar;
ALTER TABLE pn_template ALTER COLUMN primary_properties TYPE varchar;
ALTER TABLE pn_template ALTER COLUMN notify_trigger TYPE varchar;
ALTER TABLE pn_template ALTER COLUMN name TYPE varchar;
ALTER TABLE pn_template ALTER COLUMN sender TYPE varchar;
ALTER TABLE pn_pool_message ALTER COLUMN key_attributes TYPE varchar;
ALTER TABLE pn_receiver ALTER COLUMN target TYPE varchar;
ALTER TABLE pn_receiver ALTER COLUMN type_of_receiver TYPE varchar;
ALTER TABLE pn_receiver ALTER COLUMN locale TYPE varchar;
ALTER TABLE pn_regex ALTER COLUMN note TYPE varchar;
ALTER TABLE pn_regex ALTER COLUMN regex TYPE varchar;
ALTER TABLE pn_template_message ALTER COLUMN locale TYPE varchar;
ALTER TABLE pn_template_message ALTER COLUMN message TYPE varchar;
ALTER TABLE pn_template_message ALTER COLUMN subject TYPE varchar;
ALTER TABLE groups_groups ALTER COLUMN created_by TYPE varchar;
ALTER TABLE groups_groups ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE res_tags ALTER COLUMN tag_name TYPE varchar;
ALTER TABLE res_tags ALTER COLUMN created_by TYPE varchar;
ALTER TABLE res_tags ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE configurations ALTER COLUMN property TYPE varchar;
ALTER TABLE configurations ALTER COLUMN value TYPE varchar;
ALTER TABLE mailchange ALTER COLUMN created_by TYPE varchar;
ALTER TABLE pwdreset ALTER COLUMN created_by TYPE varchar;
ALTER TABLE security_teams ALTER COLUMN name TYPE varchar;
ALTER TABLE security_teams ALTER COLUMN description TYPE varchar;
ALTER TABLE security_teams ALTER COLUMN created_by TYPE varchar;
ALTER TABLE security_teams ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE security_teams_facilities ALTER COLUMN created_by TYPE varchar;
ALTER TABLE security_teams_facilities ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE blacklists ALTER COLUMN description TYPE varchar;
ALTER TABLE blacklists ALTER COLUMN created_by TYPE varchar;
ALTER TABLE blacklists ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE resources_bans ALTER COLUMN description TYPE varchar;
ALTER TABLE resources_bans ALTER COLUMN created_by TYPE varchar;
ALTER TABLE resources_bans ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE facilities_bans ALTER COLUMN description TYPE varchar;
ALTER TABLE facilities_bans ALTER COLUMN created_by TYPE varchar;
ALTER TABLE facilities_bans ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE user_ext_source_attr_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE user_ext_source_attr_values ALTER COLUMN created_by TYPE varchar;
ALTER TABLE user_ext_source_attr_values ALTER COLUMN modified_by TYPE varchar;
ALTER TABLE user_ext_source_attr_u_values ALTER COLUMN attr_value TYPE varchar;
ALTER TABLE members_sponsored ALTER COLUMN created_by TYPE varchar;
ALTER TABLE members_sponsored ALTER COLUMN modified_by TYPE varchar;
update configurations set value='3.1.61' where property='DATABASE VERSION';

3.1.60
alter table tasks alter column engine_id set default 1;
alter table tasks_results alter column engine_id set default 1;
alter table tasks drop constraint task_eng_fk;
alter table tasks_results drop constraint taskres_eng_fk;
drop index idx_fk_task_eng;
drop index idx_fk_taskres_eng;
drop sequence routing_rules_id_seq;
drop sequence processing_rules_id_seq;
drop table engine_routing_rule;
drop table routing_rules;
drop table service_processing_rule;
drop table processing_rules;
drop table engines;
update configurations set value='3.1.60' where property='DATABASE VERSION';

3.1.59
ALTER TABLE ext_sources_attributes ALTER COLUMN attr_value TYPE varchar;
update configurations set value='3.1.59' where property='DATABASE VERSION';
