Highlights:
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 3d53374a-bb19-35fe-ac23-1e9b72bdf813 |
|---|
| key | AAM-1152 |
|---|
|
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 3d53374a-bb19-35fe-ac23-1e9b72bdf813 |
|---|
| key | AAM-1165 |
|---|
|
Story:
Tasks:
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 3d53374a-bb19-35fe-ac23-1e9b72bdf813 |
|---|
| key | AAM-1152 |
|---|
|
...
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 3d53374a-bb19-35fe-ac23-1e9b72bdf813 |
|---|
| key | AAM-1163 |
|---|
|
Bug Fixes:
SQL Fixes:
...
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 3d53374a-bb19-35fe-ac23-1e9b72bdf813 |
|---|
| key | AAM- |
|---|
|
...
| Code Block |
|---|
|
alter table organization add code varchar;
update organization set code = replace(upper(name), ' ', '_');
alter table organization alter column code set not null;
create unique index organization_code_uindex on organization (code); |
2
Bug Fixes:
SQL Fixes:
1. For
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 3d53374a-bb19-35fe-ac23-1e9b72bdf813 |
|---|
| key | AAM-1163 |
|---|
|
issue run the following sql fixes:
| Code Block |
|---|
|
DO $$
BEGIN
IF EXISTS(SELECT *
FROM information_schema.columns
WHERE table_name='field' and column_name='initial_value')
THEN
ALTER TABLE public.field DROP COLUMN IF EXISTS text_placeholder;
ELSE
IF EXISTS(SELECT *
FROM information_schema.columns
WHERE table_name='field' and column_name='text_placeholder')
THEN
ALTER TABLE public.field RENAME COLUMN text_placeholder TO initial_value;
END IF;
END IF;
END $$; |
How to upgrade:
Upgrade to 1.5051
Go to the asta7 directory and run the following script
...