On 9/15/06, Ben Avery <[EMAIL PROTECTED]> wrote:
sorry if this has already been covered, or sent to the wrong place, just trying to help.
Thanks! We're flying blind with respect to Oracle since none of the Roller committers actually use that database.
the following changes need to be made: - change datatype BIT to NUMBER(1) - change syntax 'ADD COLUMN' to 'ADD'
Why the change from BIT to NUMBER(1) -- we use BIT in the database creation script too, do we need to change that too?
and in the 240-to-300-migration.sql, the line alter table weblogentry add locale varchar(20) default null; is unnecessary, the column already exists, from Roller 2.10 at least.
Does that cause an error or does Oracle ignore it and continue to process the migration script? - Dave
this is tested on Oracle 9.2.10, although I believe it's also true of Oracle 10.
