rt/etc/upgrade/4.1.5/schema.Oracle


1
2
3
4
5
6

# Template column
ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld;
ALTER TABLE Scrips ADD Template VARCHAR2(200);
UPDATE Scrips SET Template = CAST(TemplateOld AS varchar2(200));
ALTER TABLE Scrips MODIFY Template VARCHAR2(200) NOT NULL;
ALTER TABLE Scrips DROP COLUMN TemplateOld;