ALTER TABLE `#__icagenda_payment_orders`
  MODIFY `id` int unsigned NOT NULL AUTO_INCREMENT,
  MODIFY `registration_id` int unsigned NOT NULL,
  MODIFY `user_id` int unsigned NOT NULL DEFAULT 0,
  MODIFY `created` datetime NOT NULL;

ALTER TABLE `#__icagenda_payment_tickets`
  MODIFY `id` int unsigned NOT NULL AUTO_INCREMENT,
  MODIFY `order_id` int unsigned NOT NULL,
  MODIFY `ticket_id` int unsigned NOT NULL,
  MODIFY `created` datetime NOT NULL;