migrations/Version20210510153316.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20210510153316 extends AbstractMigration
  14. {
  15.     public function getDescription() : string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema) : void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  23.         $this->addSql("INSERT INTO `std_domains` (`updated_by`, `language_code`, `created_by`, `webservice_id`, `machine_name`, `description`, `webservice_value`, `webservice_description`, `is_active`, `created_date`, `updated_date`) VALUES (1, 'en', 1, NULL, 'countries', 'Countries', NULL, NULL, 1, '2021-03-12 10:44:22', '2021-03-12 10:44:22');");
  25.         $this->addSql("SET @domain_id=(SELECT id FROM std_domains WHERE machine_name='countries' and language_code='en');");
  26.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'af','Afghanistan',1,now(),now());");
  27.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ax','Åland Islands',1,now(),now());");
  28.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'al','Albania',1,now(),now());");
  29.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'dz','Algeria',1,now(),now());");
  30.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'as','American Samoa',1,now(),now());");
  31.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ad','Andorra',1,now(),now());");
  32.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ao','Angola',1,now(),now());");
  33.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ai','Anguilla',1,now(),now());");
  34.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'aq','Antarctica',1,now(),now());");
  35.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ag','Antigua and Barbuda',1,now(),now());");
  36.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ar','Argentina',1,now(),now());");
  37.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'am','Armenia',1,now(),now());");
  38.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'aw','Aruba',1,now(),now());");
  39.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'au','Australia',1,now(),now());");
  40.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'at','Austria',1,now(),now());");
  41.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'az','Azerbaijan',1,now(),now());");
  42.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bs','Bahamas',1,now(),now());");
  43.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bh','Bahrain',1,now(),now());");
  44.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bd','Bangladesh',1,now(),now());");
  45.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bb','Barbados',1,now(),now());");
  46.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'by','Belarus',1,now(),now());");
  47.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'be','Belgium',1,now(),now());");
  48.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bz','Belize',1,now(),now());");
  49.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bj','Benin',1,now(),now());");
  50.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bm','Bermuda',1,now(),now());");
  51.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bt','Bhutan',1,now(),now());");
  52.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bo','Bolivia (Plurinational State of)',1,now(),now());");
  53.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bq','Bonaire; Sint Eustatius and Saba',1,now(),now());");
  54.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ba','Bosnia and Herzegovina',1,now(),now());");
  55.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bw','Botswana',1,now(),now());");
  56.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bv','Bouvet Island',1,now(),now());");
  57.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'br','Brazil',1,now(),now());");
  58.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'io','British Indian Ocean Territory',1,now(),now());");
  59.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bn','Brunei Darussalam',1,now(),now());");
  60.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bg','Bulgaria',1,now(),now());");
  61.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bf','Burkina Faso',1,now(),now());");
  62.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bi','Burundi',1,now(),now());");
  63.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cv','Cabo Verde',1,now(),now());");
  64.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'kh','Cambodia',1,now(),now());");
  65.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cm','Cameroon',1,now(),now());");
  66.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ca','Canada',1,now(),now());");
  67.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ky','Cayman Islands',1,now(),now());");
  68.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cf','Central African Republic',1,now(),now());");
  69.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'td','Chad',1,now(),now());");
  70.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cl','Chile',1,now(),now());");
  71.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cn','China',1,now(),now());");
  72.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cx','Christmas Island',1,now(),now());");
  73.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cc','Cocos (Keeling) Islands',1,now(),now());");
  74.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'co','Colombia',1,now(),now());");
  75.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'km','Comoros',1,now(),now());");
  76.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cg','Congo',1,now(),now());");
  77.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cd','Congo; Democratic Republic of the',1,now(),now());");
  78.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ck','Cook Islands',1,now(),now());");
  79.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cr','Costa Rica',1,now(),now());");
  80.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ci','Côte d''Ivoire',1,now(),now());");
  81.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'hr','Croatia',1,now(),now());");
  82.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cu','Cuba',1,now(),now());");
  83.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cw','Curaçao',1,now(),now());");
  84.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cy','Cyprus',1,now(),now());");
  85.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'cz','Czechia',1,now(),now());");
  86.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'dk','Denmark',1,now(),now());");
  87.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'dj','Djibouti',1,now(),now());");
  88.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'dm','Dominica',1,now(),now());");
  89.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'do','Dominican Republic',1,now(),now());");
  90.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ec','Ecuador',1,now(),now());");
  91.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'eg','Egypt',1,now(),now());");
  92.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sv','El Salvador',1,now(),now());");
  93.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gq','Equatorial Guinea',1,now(),now());");
  94.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'er','Eritrea',1,now(),now());");
  95.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ee','Estonia',1,now(),now());");
  96.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sz','Eswatini',1,now(),now());");
  97.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'et','Ethiopia',1,now(),now());");
  98.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'fk','Falkland Islands (Malvinas)',1,now(),now());");
  99.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'fo','Faroe Islands',1,now(),now());");
  100.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'fj','Fiji',1,now(),now());");
  101.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'fi','Finland',1,now(),now());");
  102.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'fr','France',1,now(),now());");
  103.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gf','French Guiana',1,now(),now());");
  104.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pf','French Polynesia',1,now(),now());");
  105.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tf','French Southern Territories',1,now(),now());");
  106.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ga','Gabon',1,now(),now());");
  107.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gm','Gambia',1,now(),now());");
  108.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ge','Georgia',1,now(),now());");
  109.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'de','Germany',1,now(),now());");
  110.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gh','Ghana',1,now(),now());");
  111.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gi','Gibraltar',1,now(),now());");
  112.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gr','Greece',1,now(),now());");
  113.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gl','Greenland',1,now(),now());");
  114.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gd','Grenada',1,now(),now());");
  115.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gp','Guadeloupe',1,now(),now());");
  116.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gu','Guam',1,now(),now());");
  117.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gt','Guatemala',1,now(),now());");
  118.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gg','Guernsey',1,now(),now());");
  119.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gn','Guinea',1,now(),now());");
  120.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gw','Guinea-Bissau',1,now(),now());");
  121.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gy','Guyana',1,now(),now());");
  122.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ht','Haiti',1,now(),now());");
  123.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'hm','Heard Island and McDonald Islands',1,now(),now());");
  124.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'va','Holy See',1,now(),now());");
  125.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'hn','Honduras',1,now(),now());");
  126.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'hk','Hong Kong',1,now(),now());");
  127.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'hu','Hungary',1,now(),now());");
  128.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'is','Iceland',1,now(),now());");
  129.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'in','India',1,now(),now());");
  130.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'id','Indonesia',1,now(),now());");
  131.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ir','Iran (Islamic Republic of)',1,now(),now());");
  132.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'iq','Iraq',1,now(),now());");
  133.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ie','Ireland',1,now(),now());");
  134.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'im','Isle of Man',1,now(),now());");
  135.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'il','Israel',1,now(),now());");
  136.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'it','Italy',1,now(),now());");
  137.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'jm','Jamaica',1,now(),now());");
  138.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'jp','Japan',1,now(),now());");
  139.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'je','Jersey',1,now(),now());");
  140.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'jo','Jordan',1,now(),now());");
  141.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'kz','Kazakhstan',1,now(),now());");
  142.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ke','Kenya',1,now(),now());");
  143.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ki','Kiribati',1,now(),now());");
  144.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'kp','Korea (Democratic People''s Republic of)',1,now(),now());");
  145.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'kr','Korea; Republic of',1,now(),now());");
  146.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'kw','Kuwait',1,now(),now());");
  147.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'kg','Kyrgyzstan',1,now(),now());");
  148.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'la','Lao People''s Democratic Republic',1,now(),now());");
  149.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'lv','Latvia',1,now(),now());");
  150.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'lb','Lebanon',1,now(),now());");
  151.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ls','Lesotho',1,now(),now());");
  152.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'lr','Liberia',1,now(),now());");
  153.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ly','Libya',1,now(),now());");
  154.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'li','Liechtenstein',1,now(),now());");
  155.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'lt','Lithuania',1,now(),now());");
  156.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'lu','Luxembourg',1,now(),now());");
  157.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mo','Macao',1,now(),now());");
  158.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mg','Madagascar',1,now(),now());");
  159.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mw','Malawi',1,now(),now());");
  160.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'my','Malaysia',1,now(),now());");
  161.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mv','Maldives',1,now(),now());");
  162.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ml','Mali',1,now(),now());");
  163.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mt','Malta',1,now(),now());");
  164.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mh','Marshall Islands',1,now(),now());");
  165.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mq','Martinique',1,now(),now());");
  166.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mr','Mauritania',1,now(),now());");
  167.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mu','Mauritius',1,now(),now());");
  168.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'yt','Mayotte',1,now(),now());");
  169.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mx','Mexico',1,now(),now());");
  170.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'fm','Micronesia (Federated States of)',1,now(),now());");
  171.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'md','Moldova; Republic of',1,now(),now());");
  172.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mc','Monaco',1,now(),now());");
  173.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mn','Mongolia',1,now(),now());");
  174.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'me','Montenegro',1,now(),now());");
  175.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ms','Montserrat',1,now(),now());");
  176.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ma','Morocco',1,now(),now());");
  177.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mz','Mozambique',1,now(),now());");
  178.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mm','Myanmar',1,now(),now());");
  179.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'na','Namibia',1,now(),now());");
  180.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'nr','Nauru',1,now(),now());");
  181.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'np','Nepal',1,now(),now());");
  182.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'nl','Netherlands',1,now(),now());");
  183.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'nc','New Caledonia',1,now(),now());");
  184.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'nz','New Zealand',1,now(),now());");
  185.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ni','Nicaragua',1,now(),now());");
  186.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ne','Niger',1,now(),now());");
  187.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ng','Nigeria',1,now(),now());");
  188.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'nu','Niue',1,now(),now());");
  189.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'nf','Norfolk Island',1,now(),now());");
  190.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mk','North Macedonia',1,now(),now());");
  191.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mp','Northern Mariana Islands',1,now(),now());");
  192.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'no','Norway',1,now(),now());");
  193.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'om','Oman',1,now(),now());");
  194.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pk','Pakistan',1,now(),now());");
  195.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pw','Palau',1,now(),now());");
  196.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ps','Palestine; State of',1,now(),now());");
  197.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pa','Panama',1,now(),now());");
  198.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pg','Papua New Guinea',1,now(),now());");
  199.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'py','Paraguay',1,now(),now());");
  200.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pe','Peru',1,now(),now());");
  201.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ph','Philippines',1,now(),now());");
  202.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pn','Pitcairn',1,now(),now());");
  203.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pl','Poland',1,now(),now());");
  204.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pt','Portugal',1,now(),now());");
  205.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pr','Puerto Rico',1,now(),now());");
  206.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'qa','Qatar',1,now(),now());");
  207.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'re','Réunion',1,now(),now());");
  208.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ro','Romania',1,now(),now());");
  209.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ru','Russian Federation',1,now(),now());");
  210.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'rw','Rwanda',1,now(),now());");
  211.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'bl','Saint Barthélemy',1,now(),now());");
  212.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sh','Saint Helena; Ascension and Tristan da Cunha',1,now(),now());");
  213.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'kn','Saint Kitts and Nevis',1,now(),now());");
  214.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'lc','Saint Lucia',1,now(),now());");
  215.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'mf','Saint Martin (French part)',1,now(),now());");
  216.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'pm','Saint Pierre and Miquelon',1,now(),now());");
  217.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'vc','Saint Vincent and the Grenadines',1,now(),now());");
  218.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ws','Samoa',1,now(),now());");
  219.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sm','San Marino',1,now(),now());");
  220.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'st','Sao Tome and Principe',1,now(),now());");
  221.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sa','Saudi Arabia',1,now(),now());");
  222.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sn','Senegal',1,now(),now());");
  223.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'rs','Serbia',1,now(),now());");
  224.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sc','Seychelles',1,now(),now());");
  225.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sl','Sierra Leone',1,now(),now());");
  226.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sg','Singapore',1,now(),now());");
  227.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sx','Sint Maarten (Dutch part)',1,now(),now());");
  228.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sk','Slovakia',1,now(),now());");
  229.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'si','Slovenia',1,now(),now());");
  230.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sb','Solomon Islands',1,now(),now());");
  231.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'so','Somalia',1,now(),now());");
  232.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'za','South Africa',1,now(),now());");
  233.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gs','South Georgia and the South Sandwich Islands',1,now(),now());");
  234.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ss','South Sudan',1,now(),now());");
  235.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'es','Spain',1,now(),now());");
  236.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'lk','Sri Lanka',1,now(),now());");
  237.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sd','Sudan',1,now(),now());");
  238.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sr','Suriname',1,now(),now());");
  239.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sj','Svalbard and Jan Mayen',1,now(),now());");
  240.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'se','Sweden',1,now(),now());");
  241.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ch','Switzerland',1,now(),now());");
  242.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'sy','Syrian Arab Republic',1,now(),now());");
  243.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tw','Taiwan; Province of China',1,now(),now());");
  244.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tj','Tajikistan',1,now(),now());");
  245.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tz','Tanzania; United Republic of',1,now(),now());");
  246.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'th','Thailand',1,now(),now());");
  247.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tl','Timor-Leste',1,now(),now());");
  248.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tg','Togo',1,now(),now());");
  249.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tk','Tokelau',1,now(),now());");
  250.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'to','Tonga',1,now(),now());");
  251.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tt','Trinidad and Tobago',1,now(),now());");
  252.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tn','Tunisia',1,now(),now());");
  253.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tr','Turkey',1,now(),now());");
  254.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tm','Turkmenistan',1,now(),now());");
  255.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tc','Turks and Caicos Islands',1,now(),now());");
  256.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'tv','Tuvalu',1,now(),now());");
  257.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ug','Uganda',1,now(),now());");
  258.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ua','Ukraine',1,now(),now());");
  259.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ae','United Arab Emirates',1,now(),now());");
  260.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'gb','United Kingdom',1,now(),now());");
  261.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'us','United States of America',1,now(),now());");
  262.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'um','United States Minor Outlying Islands',1,now(),now());");
  263.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'uy','Uruguay',1,now(),now());");
  264.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'uz','Uzbekistan',1,now(),now());");
  265.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'vu','Vanuatu',1,now(),now());");
  266.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ve','Venezuela (Bolivarian Republic of)',1,now(),now());");
  267.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'vn','Viet Nam',1,now(),now());");
  268.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'vg','Virgin Islands (British)',1,now(),now());");
  269.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'vi','Virgin Islands (U.S.)',1,now(),now());");
  270.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'wf','Wallis and Futuna',1,now(),now());");
  271.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'eh','Western Sahara',1,now(),now());");
  272.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'ye','Yemen',1,now(),now());");
  273.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'zm','Zambia',1,now(),now());");
  274.         $this->addSql("insert into std_domains_values (updated_by,created_by,language_code,domain_id,machine_name,description,is_active,created_date,updated_date) values(1,1,'en',@domain_id,'zw','Zimbabwe',1,now(),now());");
  275.                 
  276.     }
  278.     public function down(Schema $schema) : void
  279.     {
  280.         // this down() migration is auto-generated, please modify it to your needs
  281.         $this->addSql("SET @domain_id=(SELECT id FROM std_domains WHERE machine_name='countries' and language_code='en');");
  282.         $this->addSql("delete from std_domains_values where domain_id=@domain_id;");
  283.         $this->addSql("delete from std_domains where id=@domain_id;");
  285.     }
  286. }