ALTER TABLE `events` ADD `url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' AFTER `description`; ALTER TABLE `events` DROP `notification_sent`; ALTER TABLE `events` CHANGE `user_id` `participant_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `events` ADD INDEX `participant` ( `participant_id` ); ALTER TABLE `calendar` ADD `notification_sent` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'; RENAME TABLE `users` TO `participants`; RENAME TABLE `events_users` TO `events_participants`; ALTER TABLE `events_participants` CHANGE `user_id` `participant_id` INT( 10 ) NOT NULL DEFAULT '0'; ALTER TABLE `events_participants` DROP INDEX `user_id`, ADD INDEX `participants_id` ( `participant_id` );