Migrate.php 973 B

1234567891011121314151617181920212223242526272829303132
  1. <?php
  2. use Schema\Wrapper as Wrapper;
  3. use App\Core\Sanity\MigratorController as Migrator;
  4. function geo_zone_upgrade($pluginversion) {
  5. if ($pluginversion < "0.0.1") {
  6. $table = Wrapper::get_table("geo_zones");
  7. $table->addColumn("name", "string", Array("null" => false));
  8. $table->addColumn("city_id", "integer", Array("null" => false));
  9. $table->addSoftDelete();
  10. $table->addForeignKey('city_id', Wrapper::get_table('geo_cities'));
  11. $table->create();
  12. Migrator::getInstance()->update_plugin_version("geo_zone", "1.0.0");
  13. return;
  14. }
  15. //if ($pluginversion < "0.0.2") {
  16. //$table = Wrapper::get_table("geo_zones");
  17. //Migrator::getInstance()->update_plugin_version("geo_zone", "1.0.1");
  18. //return;
  19. //}
  20. }
  21. function geo_zone_rollback($pluginversion) {
  22. if($pluginversion > "0.0.1"){
  23. $table = Wrapper::get_table("geo_zones");
  24. $table->drop();
  25. return;
  26. }
  27. }