ALTER TABLE `client_subscriptions` ADD `package_id` INT NOT NULL AFTER `client_id`; ALTER TABLE `client_subscriptions` ADD FOREIGN KEY (`package_id`) REFERENCES `service_packages`(`id`) ON DELETE CASCADE;