[rt-users] 4.2.0 diffs for Oracle 10gR2

[John D Groenveld]

Below are some small diffs.

BTW my SQL is rusty but why are you converting scrips.template
to a string when its a reference to templates.id?
John
groenveld at acm.org

--- etc/upgrade/4.1.1/schema.Oracle     Sat Oct  5 15:05:15 2013
***************
*** 11,17 ****
          LastUpdatedBy   NUMBER(11,0) DEFAULT 0 NOT NULL,
          LastUpdated     DATE
  );
! ALTER TABLE Scrips ADD COLUMN Disabled int2 NOT NULL DEFAULT 0;

  INSERT INTO ObjectScrips(
      id, Scrip, Stage, ObjectId,
--- 11,17 ----
          LastUpdatedBy   NUMBER(11,0) DEFAULT 0 NOT NULL,
          LastUpdated     DATE
  );
! ALTER TABLE Scrips ADD ( Disabled NUMBER(11,0) DEFAULT 0 NOT NULL );

  INSERT INTO ObjectScrips(
      id, Scrip, Stage, ObjectId,


--- etc/upgrade/4.1.5/schema.Oracle     Sat Oct  5 15:49:16 2013
***************
*** 1,5 ****
  # Template column
  ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld;
! ALTER TABLE Scrips ADD COLUMN Template VARCHAR2(200) NOT NULL;
! UPDATE TABLE Scrips SET Template = CAST(TemplateOld AS varchar2);
  ALTER TABLE Scrips DROP COLUMN TemplateOld;
--- 1,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;


--- etc/upgrade/4.1.22/schema.Oracle    Sat Oct  5 15:34:26 2013
***************
*** 1 ****
! ALTER TABLE Users ADD COLUMN SMIMECertificate CLOB;
--- 1 ----
! ALTER TABLE Users ADD ( SMIMECertificate CLOB );