| 1 |
|
| 2 | ALTER TABLE `apps` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 3 | ALTER TABLE `collaborators` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 4 | ALTER TABLE `deployments` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 5 | ALTER TABLE `deployments_history` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 6 | ALTER TABLE `deployments_versions` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 7 | ALTER TABLE `packages_diff` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 8 | ALTER TABLE `packages_metrics` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 9 | ALTER TABLE `user_tokens` CHANGE `expires_at` `expires_at` TIMESTAMP NULL,CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 10 | ALTER TABLE `users` CHANGE `created_at` `created_at` TIMESTAMP NULL;
|
| 11 |
|
| 12 | DROP PROCEDURE IF EXISTS schema_change;
|
| 13 | CREATE PROCEDURE schema_change()
|
| 14 | BEGIN
|
| 15 | DECLARE CurrentDatabase VARCHAR(100);
|
| 16 | SELECT DATABASE() INTO CurrentDatabase;
|
| 17 | IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema=CurrentDatabase AND table_name = 'packages' AND column_name = 'is_mandatory') THEN
|
| 18 | ALTER TABLE `packages` ADD `is_mandatory` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
|
| 19 | END IF;
|
| 20 | END;
|
| 21 | CALL schema_change();
|
| 22 | DROP PROCEDURE IF EXISTS schema_change;
|
| 23 |
|
| 24 | ALTER TABLE `deployments_versions` DROP INDEX idx_did_appversion, ADD INDEX `idx_did_appversion` (`deployment_id`, `app_version`),ADD `deleted_at` TIMESTAMP NULL;
|
| 25 | ALTER TABLE `packages` ADD `deleted_at` TIMESTAMP NULL;
|
| 26 | ALTER TABLE `packages_metrics` DROP INDEX `udx_packageid`,ADD INDEX `idx_packageid` (`package_id`),ADD `deleted_at` TIMESTAMP NULL;
|
| 27 | ALTER TABLE `packages_diff` ADD `deleted_at` TIMESTAMP NULL;
|
| 28 | UPDATE `versions` SET `version` = '0.2.15' WHERE `type` = '1';
|