-- Upgrade script to move table naming to JIRA 3.7

alter table :schema_name.notification rename column type to notif_type;
alter table :schema_name.notification rename column parameter to notif_parameter;
alter table :schema_name.mailserver rename column type to server_type;
alter table :schema_name.jiraeventtype rename column type to event_type;
alter table :schema_name.schemepermissions rename column type to perm_type;
alter table :schema_name.schemepermissions rename column parameter to perm_parameter;
alter table :schema_name.fieldlayout rename column type to layout_type;
alter table :schema_name.schemeissuesecurities rename column type to sec_type;
alter table :schema_name.schemeissuesecurities rename column parameter to sec_parameter;
alter table :schema_name.portletconfiguration rename column position to positionseq;
alter table :schema_name.version rename to projectversion;