-- Replace founded date with founding year (integer).
ALTER TABLE `Hospital` DROP COLUMN `foundedDate`;
ALTER TABLE `Hospital` ADD COLUMN `foundedYear` INTEGER NULL;