You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
488 B
SQL
17 lines
488 B
SQL
ALTER TABLE public."DMP"
|
|
ADD COLUMN "extraProperties" text;
|
|
|
|
ALTER TABLE public."DatasetProfile"
|
|
ADD COLUMN "Language" character varying;
|
|
|
|
UPDATE public."DMP"
|
|
SET "extraProperties"='{"language": "en"}';
|
|
|
|
UPDATE public."DatasetProfile"
|
|
SET "Language"='en';
|
|
|
|
ALTER TABLE public."DatasetProfile"
|
|
ALTER COLUMN "Language" SET NOT NULL;
|
|
|
|
INSERT INTO public."DBVersion" VALUES ('DMPDB', '00.00.004', '2020-06-03 12:00:00.000000+03', now(), 'Add language to DMP and Dataset Template');
|
|
|