Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ vendor/bin/phinx migrate --dry-run
- Phinx by CakePHP - https://phinx.org. 0.10.6
- using config file .\phinx.php
- using config parser php
- using migration paths
- - C:\vhosts\sdelkadrom\db\migrations
- using seed paths
- - C:\vhosts\sdelkadrom\db\seeds
- warning no environment specified, defaulting to: production
- using adapter mysql
- using database sdelkadrom
- using table prefix ore_nf_
- == 20190130163158 AreasMigration: migrating
- START TRANSACTION
- ALTER TABLE `ore_nf_location_area` ADD `id` INT(11) unsigned NOT NULL AUTO_INCREMENT, ADD `country_id` INT(11) unsigned NULL, ADD `region_id` INT(11) unsigned NULL, ADD `name_ru` VARCHAR(128) NOT NULL DEFAULT '', ADD `name_en` VARCHAR(128) NOT NULL DEFAULT '', ADD `name_de` VARCHAR(128) NOT NULL DEFAULT '', ADD `name_es` VARCHAR(128) NOT NULL DEFAULT '', ADD `name_ar` VARCHAR(128) NOT NULL DEFAULT ''
- ALTER TABLE `ore_nf_location_area` ADD FOREIGN KEY (`country_id`) REFERENCES `ore_nf_location_country` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD FOREIGN KEY (`region_id`) REFERENCES `ore_nf_location_region` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
- ALTER TABLE `ore_nf_location_city` ADD `area_id` INT(11) unsigned NULL AFTER `region_id`, CHANGE `region_id` `region_id` INT(11) unsigned NULL
- ALTER TABLE `ore_nf_location_city` ADD FOREIGN KEY (`area_id`) REFERENCES `ore_nf_location_area` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
- ALTER TABLE `ore_nf_apartment` ADD `loc_area` INT(11) unsigned NULL AFTER `loc_region`
- COMMIT
- INSERT INTO `phinxlog` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES ('20190130163158', 'AreasMigration', '2019-01-30 21:41:54', '2019-01-30 21:41:54', 0);
- == 20190130163158 AreasMigration: migrated 0.0170s
- All Done. Took 0.0535s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement