#** 
220-to-230-migration.vm: Velocity template that generates vendor-specific database scripts 

DON'T RUN THIS, IT'S NOT A DATABASE CREATION SCRIPT!!!
**#

-- Roller 2.2 schema changes

#addColumnNotNull("website" "isactive" $BOOLEAN_SQL_TYPE $BOOLEAN_TRUE)
update website set isactive=$BOOLEAN_TRUE, datecreated=datecreated;

-- Roller 2.3 schema changes

alter table weblogentry add column summary $TEXT_SQL_TYPE default null;
alter table weblogentry add column content_type varchar(48) default null;
alter table weblogentry add column content_src varchar(255) default null;