Advertisement
Sdelkadrom

Untitled

Jan 30th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. $ vendor/bin/phinx migrate --dry-run
  2. Phinx by CakePHP - https://phinx.org. 0.10.6
  3.  
  4. using config file .\phinx.php
  5. using config parser php
  6. using migration paths
  7. - C:\vhosts\sdelkadrom\db\migrations
  8. using seed paths
  9. - C:\vhosts\sdelkadrom\db\seeds
  10. warning no environment specified, defaulting to: production
  11. using adapter mysql
  12. using database sdelkadrom
  13. using table prefix ore_nf_
  14.  
  15. == 20190130163158 AreasMigration: migrating
  16. START TRANSACTION
  17. 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 ''
  18. 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
  19. 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
  20. ALTER TABLE `ore_nf_location_city` ADD FOREIGN KEY (`area_id`) REFERENCES `ore_nf_location_area` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  21. ALTER TABLE `ore_nf_apartment` ADD `loc_area` INT(11) unsigned NULL AFTER `loc_region`
  22. COMMIT
  23. 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);
  24. == 20190130163158 AreasMigration: migrated 0.0170s
  25.  
  26. All Done. Took 0.0535s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement