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