wombat.ch

MySQL:

ALTER TABLE #__sermon_speakers ADD COLUMN `alias` VARCHAR(255) NOT NULL;
ALTER TABLE #__sermon_series ADD COLUMN `alias` VARCHAR(255) NOT NULL;
ALTER TABLE #__sermon_speakers ADD COLUMN `metakey` TEXT NOT NULL, ADD `metadesc` TEXT NOT NULL;
ALTER TABLE #__sermon_series ADD COLUMN `metakey` TEXT NOT NULL, ADD `metadesc` TEXT NOT NULL;
ALTER TABLE #__sermon_sermons CHANGE `created_on` `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';

PHP:

 function install($parent) {
  $parent->getParent()->setRedirectURL('index.php?option=com_sermonspeaker');
 }