ALTER TABLE `Post`
CHANGE COLUMN `creationDate` `creationDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `postStatusId`;

ALTER TABLE `PostStatus`
ADD COLUMN `isPublished` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `show`;

set FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `PostCategory`
CHANGE COLUMN `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;
set FOREIGN_KEY_CHECKS = 1;

set FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `PostTag`
CHANGE COLUMN `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;
set FOREIGN_KEY_CHECKS = 1;