ALTER TABLE `microsite_microsites` 
    ADD INDEX ( `basename` );

ALTER TABLE `microsite_microsites` 
    ADD `homeTemplate`  VARCHAR( 255 ) NOT NULL AFTER `password` ,
    ADD `otherTemplate` VARCHAR( 255 ) NOT NULL AFTER `homeTemplate`;

DROP TABLE IF EXISTS `microsite_admins`;
DROP TABLE IF EXISTS `microsite_modules`;