Migrate.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. use Schema\Wrapper as Wrapper;
  3. use App\Core\Sanity\MigratorController as Migrator;
  4. function common_defaults_upgrade($pluginversion) {
  5. if ($pluginversion < "0.0.1") {
  6. $table = Wrapper::get_table("common_system_defaults");
  7. $table->addColumn("module", "string", Array("null" => true));
  8. $table->addColumn("table", "string", Array("null" => true));
  9. $table->addColumn("key", "string", Array("null" => false));
  10. $table->addColumn("value", "string", Array("null" => false));
  11. $table->create();
  12. $table = Wrapper::get_table("common_user_defaults");
  13. $table->addColumn("user_id", "integer", Array("null" => false));
  14. $table->addColumn("module", "string", Array("null" => true));
  15. $table->addColumn("table", "string", Array("null" => true));
  16. $table->addColumn("key", "string", Array("null" => false));
  17. $table->addColumn("value", "string", Array("null" => false));
  18. $table->addForeignKey('user_id', Wrapper::get_table('core_auth_user'));
  19. Migrator::getInstance()->update_plugin_version("common_defaults", "1.0.0");
  20. return;
  21. }
  22. //if ($pluginversion < "0.0.2") {
  23. //$table = Wrapper::get_table("common_defaultss");
  24. //Migrator::getInstance()->update_plugin_version("common_defaults", "1.0.1");
  25. //return;
  26. //}
  27. }
  28. function common_defaults_rollback($pluginversion) {
  29. if($pluginversion > "0.0.1"){
  30. $table = Wrapper::get_table("common_defaultss");
  31. $table->drop();
  32. return;
  33. }
  34. }