-- 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.75
ALTER TABLE users ADD COLUMN anonymized boolean default false not null;
UPDATE configurations SET value='3.1.75' WHERE property='DATABASE VERSION';

3.1.74
UPDATE attr_names SET type='java.lang.String' WHERE type='java.lang.LargeString';
UPDATE attr_names SET type='java.util.ArrayList' WHERE type='java.util.LargeArrayList';
UPDATE configurations SET value='3.1.74' WHERE property='DATABASE VERSION';

3.1.73
ALTER TABLE pwdreset ADD COLUMN validity_to timestamp;
UPDATE pwdreset SET validity_to = created_at + interval '1 days';
ALTER TABLE pwdreset ALTER COLUMN validity_to SET not null;
UPDATE configurations SET value='3.1.73' WHERE property='DATABASE VERSION';

3.1.72
alter table attr_names drop constraint attnam_attnam_fk;
drop index idx_fk_attnam_attnam;
alter table attr_names drop column default_attr_id;
UPDATE configurations SET value='3.1.72' WHERE property='DATABASE VERSION';

3.1.71
alter table groups drop constraint grp_nam_vo_parentg_u;
create unique index idx_grp_nam_vo_parentg_u on groups (name,vo_id,coalesce(parent_group_id,'0'));
UPDATE configurations SET value='3.1.71' WHERE property='DATABASE VERSION';

3.1.70
ALTER TABLE members_sponsored ADD CONSTRAINT memspons_mem_usr_u unique (sponsored_id, sponsor_id);
UPDATE configurations SET value='3.1.70' WHERE property='DATABASE VERSION';

3.1.69
alter table members_sponsored ADD COLUMN validity_to timestamp default null;
UPDATE configurations SET value='3.1.69' WHERE property='DATABASE VERSION';

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';
