Skip to:
The following SQL in the 2.7->2.8 Oracle conversion script is is incorrect:
– New column for Email Template service– SAK-18532/SAK-19522alter table EMAIL_TEMPLATE_ITEM add column EMAILFROM varchar2(255);
It should be:
alter table EMAIL_TEMPLATE_ITEM add EMAILFROM varchar2(255);
Integrated in sakai trunk #447 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/447/) Fix Oracle SQL syntax
2.8.x r88694
Syntax corrected in trunk, r88643. Decision on varchar2 v. clob still under discussion.
In a virgin auto-ddl'd 2.8 database, this column is a CLOB, therefore the new statement is:
alter table EMAIL_TEMPLATE_ITEM add EMAILFROM clob;
Linking to main 2.8 Oracle conversion ticket.
The following SQL in the 2.7->2.8 Oracle conversion script is is incorrect:
– New column for Email Template service
– SAK-18532/SAK-19522
alter table EMAIL_TEMPLATE_ITEM add column EMAILFROM varchar2(255);
It should be:
alter table EMAIL_TEMPLATE_ITEM add EMAILFROM varchar2(255);