/** * Run the migrations. * * @return void */ public function up() { // change custom_field_group_351 DBLibrary::renameColumnWithForeignKey('013_351_article_family', 'custom_field_group_351', 'field_group_id_351', 'INT', 10, true, true, 'fk01_013_351_article_family', '001_025_field_group', 'id_025'); // change article_family_350 DBLibrary::renameColumnWithForeignKey('013_350_section', 'article_family_350', 'article_family_id_350', 'INT', 10, true, true, 'fk01_013_350_section', '013_351_article_family', 'id_351'); // change lang_352 DBLibrary::renameColumnWithForeignKey('013_352_category', 'lang_352', 'lang_id_352', 'VARCHAR', 2, false, false, 'fk01_013_352_category', '001_001_lang', 'id_001'); // change lang_355 DBLibrary::renameColumnWithForeignKey('013_355_article', 'lang_355', 'lang_id_355', 'VARCHAR', 2, false, false, 'fk01_013_355_article', '001_001_lang', 'id_001'); // change author_355 DBLibrary::renameColumnWithForeignKey('013_355_article', 'author_355', 'author_id_355', 'INT', 10, true, false, 'fk02_013_355_article', '001_010_user', 'id_010'); // change section_355 DBLibrary::renameColumnWithForeignKey('013_355_article', 'section_355', 'section_id_355', 'VARCHAR', 30, false, false, 'fk03_013_355_article', '013_350_section', 'id_350'); // change family_355 DBLibrary::renameColumnWithForeignKey('013_355_article', 'family_355', 'family_id_355', 'INT', 10, true, true, 'fk04_013_355_article', '013_351_article_family', 'id_351'); // change lang_358 DBLibrary::renameColumnWithForeignKey('013_358_tag', 'lang_358', 'lang_id_358', 'VARCHAR', 2, false, false, 'fk01_013_358_tag', '001_001_lang', 'id_001'); // rename columns // editor_type_351 DBLibrary::renameColumn('013_351_article_family', 'editor_type_351', 'editor_id_351', 'TINYINT', 3, true, false); // status_355 DBLibrary::renameColumn('013_355_article', 'status_355', 'status_id_355', 'TINYINT', 3, true, false); // article_356 DBLibrary::renameColumn('013_356_articles_categories', 'article_356', 'article_id_356', 'INT', 10, true, false); // category_356 DBLibrary::renameColumn('013_356_articles_categories', 'category_356', 'category_id_356', 'INT', 10, true, false); // article_359 DBLibrary::renameColumn('013_359_articles_tags', 'article_359', 'article_id_359', 'INT', 10, true, false); // tag_359 DBLibrary::renameColumn('013_359_articles_tags', 'tag_359', 'tag_id_359', 'INT', 10, true, false); }
/** * Run the migrations. * * @return void */ public function up() { // change country_180 DBLibrary::renameColumnWithForeignKey('014_180_spa', 'country_180', 'country_id_180', 'VARCHAR', 2, false, false, 'fk01_014_180_spa', '001_002_country', 'id_002'); // change territorial_area_1_180 DBLibrary::renameColumnWithForeignKey('014_180_spa', 'territorial_area_1_180', 'territorial_area_1_id_180', 'VARCHAR', 6, false, true, 'fk02_014_180_spa', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_180 DBLibrary::renameColumnWithForeignKey('014_180_spa', 'territorial_area_2_180', 'territorial_area_2_id_180', 'VARCHAR', 10, false, true, 'fk03_014_180_spa', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_180 DBLibrary::renameColumnWithForeignKey('014_180_spa', 'territorial_area_3_180', 'territorial_area_3_id_180', 'VARCHAR', 10, false, true, 'fk04_014_180_spa', '001_005_territorial_area_3', 'id_005'); // change custom_field_group_180 DBLibrary::renameColumnWithForeignKey('014_180_spa', 'custom_field_group_180', 'field_group_id_180', 'INT', 10, true, true, 'fk05_014_180_spa', '001_025_field_group', 'id_025'); // change lang_181 DBLibrary::renameColumnWithForeignKey('014_181_spa_lang', 'lang_181', 'lang_id_181', 'VARCHAR', 2, false, false, 'fk02_014_181_spa_lang', '001_001_lang', 'id_001'); }
/** * Run the migrations. * * @return void */ public function up() { // change lang_150 DBLibrary::renameColumnWithForeignKey('007_150_environment', 'lang_150', 'lang_id_150', 'VARCHAR', 2, false, false, 'fk01_007_150_environment', '001_001_lang', 'id_001'); // change lang_151 DBLibrary::renameColumnWithForeignKey('007_151_decoration', 'lang_151', 'lang_id_151', 'VARCHAR', 2, false, false, 'fk01_007_151_decoration', '001_001_lang', 'id_001'); // change lang_152 DBLibrary::renameColumnWithForeignKey('007_152_relationship', 'lang_152', 'lang_id_152', 'VARCHAR', 2, false, false, 'fk01_007_152_relationship', '001_001_lang', 'id_001'); // change lang_153 DBLibrary::renameColumnWithForeignKey('007_153_service', 'lang_153', 'lang_id_153', 'VARCHAR', 2, false, false, 'fk01_007_153_service', '001_001_lang', 'id_001'); // change country_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'country_170', 'country_id_170', 'VARCHAR', 2, false, false, 'fk01_007_170_hotel', '001_002_country', 'id_002'); // change territorial_area_1_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'territorial_area_1_170', 'territorial_area_1_id_170', 'VARCHAR', 6, false, true, 'fk02_007_170_hotel', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'territorial_area_2_170', 'territorial_area_2_id_170', 'VARCHAR', 10, false, true, 'fk03_007_170_hotel', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'territorial_area_3_170', 'territorial_area_3_id_170', 'VARCHAR', 10, false, true, 'fk04_007_170_hotel', '001_005_territorial_area_3', 'id_005'); // change billing_country_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'billing_country_170', 'billing_country_id_170', 'VARCHAR', 2, false, true, 'fk05_007_170_hotel', '001_002_country', 'id_002'); // change billing_territorial_area_1_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'billing_territorial_area_1_170', 'billing_territorial_area_1_id_170', 'VARCHAR', 6, false, true, 'fk06_007_170_hotel', '001_003_territorial_area_1', 'id_003'); // change billing_territorial_area_2_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'billing_territorial_area_2_170', 'billing_territorial_area_2_id_170', 'VARCHAR', 10, false, true, 'fk07_007_170_hotel', '001_004_territorial_area_2', 'id_004'); // change billing_territorial_area_3_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'billing_territorial_area_3_170', 'billing_territorial_area_3_id_170', 'VARCHAR', 10, false, true, 'fk08_007_170_hotel', '001_005_territorial_area_3', 'id_005'); // change custom_field_group_170 DBLibrary::renameColumnWithForeignKey('007_170_hotel', 'custom_field_group_170', 'field_group_id_170', 'INT', 10, true, true, 'fk09_007_170_hotel', '001_025_field_group', 'id_025'); // change lang_171 DBLibrary::renameColumnWithForeignKey('007_171_hotel_lang', 'lang_171', 'lang_id_171', 'VARCHAR', 2, false, false, 'fk02_007_171_hotel_lang', '001_001_lang', 'id_001'); // change hotel_176 DBLibrary::renameColumnWithForeignKey('007_176_hotels_services', 'hotel_176', 'hotel_id_176', 'INT', 10, true, false, 'fk01_007_176_hotels_services', '007_170_hotel', 'id_170', 'cascade', 'cascade'); // change service_176 DBLibrary::renameColumnWithForeignKey('007_176_hotels_services', 'service_176', 'service_id_176', 'INT', 10, true, false, 'fk02_007_176_hotels_services', '007_153_service', 'id_153', 'cascade', 'cascade'); // change hotel_177 DBLibrary::renameColumnWithForeignKey('007_177_hotels_products', 'hotel_177', 'hotel_id_177', 'INT', 10, true, false, 'fk01_007_177_hotels_products', '007_170_hotel', 'id_170', 'cascade', 'cascade'); // change product_177 DBLibrary::renameColumnWithForeignKey('007_177_hotels_products', 'product_177', 'product_id_177', 'INT', 10, true, false, 'fk02_007_177_hotels_products', '012_111_product', 'id_111', 'cascade', 'cascade'); // change lang_177 DBLibrary::renameColumnWithForeignKey('007_177_hotels_products', 'lang_177', 'lang_id_177', 'VARCHAR', 2, false, false, 'fk03_007_177_hotels_products', '001_001_lang', 'id_001'); // rename columns // parent_110 DBLibrary::renameColumn('007_170_hotel', 'restaurant_type_170', 'restaurant_type_id_170', 'TINYINT', 3, true, true); // hotel_175 DBLibrary::renameColumn('007_175_hotels_publications', 'hotel_175', 'hotel_id_175', 'INT', 10, true, false); // publication_175 DBLibrary::renameColumn('007_175_hotels_publications', 'publication_175', 'publication_id_175', 'INT', 10, true, false); }
/** * Run the migrations. * * @return void */ public function up() { // change group_301 DBLibrary::renameColumnWithForeignKey('009_301_customer', 'group_301', 'group_id_301', 'INT', 10, true, false, 'fk01_012_301_customer', '009_300_group', 'id_300'); // change country_301 DBLibrary::renameColumnWithForeignKey('009_301_customer', 'country_301', 'country_id_301', 'VARCHAR', 2, false, true, 'fk02_012_301_customer', '001_002_country', 'id_002'); // change territorial_area_1_301 DBLibrary::renameColumnWithForeignKey('009_301_customer', 'territorial_area_1_301', 'territorial_area_1_id_301', 'VARCHAR', 6, false, true, 'fk03_012_301_customer', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_301 DBLibrary::renameColumnWithForeignKey('009_301_customer', 'territorial_area_2_301', 'territorial_area_2_id_301', 'VARCHAR', 10, false, true, 'fk04_012_301_customer', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_301 DBLibrary::renameColumnWithForeignKey('009_301_customer', 'territorial_area_3_301', 'territorial_area_3_id_301', 'VARCHAR', 10, false, true, 'fk05_012_301_customer', '001_005_territorial_area_3', 'id_005'); // change lang_301 DBLibrary::renameColumnWithForeignKey('009_301_customer', 'lang_301', 'lang_id_301', 'VARCHAR', 2, false, true, 'fk06_012_301_customer', '001_001_lang', 'id_001'); // change custom_field_group_301 DBLibrary::renameColumnWithForeignKey('009_301_customer', 'custom_field_group_301', 'field_group_id_301', 'INT', 10, true, true, 'fk07_012_301_customer', '001_025_field_group', 'id_025'); }
public function up() { // change country_041 DBLibrary::renameColumnWithForeignKey('005_041_contact', 'country_041', 'country_id_041', 'VARCHAR', 2, false, false, 'fk01_005_041_contact', '001_002_country', 'id_002'); // change group_042 DBLibrary::renameColumnWithForeignKey('005_042_contacts_groups', 'group_042', 'group_id_042', 'INT', 10, true, false, 'fk01_005_042_contacts_groups', '005_040_group', 'id_040', 'cascade', 'cascade'); // change contact_042 DBLibrary::renameColumnWithForeignKey('005_042_contacts_groups', 'contact_042', 'contact_id_042', 'INT', 10, true, false, 'fk02_005_042_contacts_groups', '005_041_contact', 'id_041', 'cascade', 'cascade'); // change email_account_044 DBLibrary::renameColumnWithForeignKey('005_044_email_campaign', 'email_account_044', 'email_account_id_044', 'INT', 10, true, false, 'fk01_005_044_email_campaign', '001_013_email_account', 'id_013'); // change template_044 DBLibrary::renameColumnWithForeignKey('005_044_email_campaign', 'template_044', 'template_id_044', 'INT', 10, true, true, 'fk02_005_044_email_campaign', '005_043_email_template', 'id_043'); // change campaign_045 DBLibrary::renameColumnWithForeignKey('005_045_email_campaigns_countries', 'campaign_045', 'campaign_id_045', 'INT', 10, true, false, 'fk01_005_045_email_campaigns_countries', '005_044_email_campaign', 'id_044', 'cascade', 'cascade'); // change country_045 DBLibrary::renameColumnWithForeignKey('005_045_email_campaigns_countries', 'country_045', 'country_id_045', 'VARCHAR', 2, false, false, 'fk02_005_045_email_campaigns_countries', '001_002_country', 'id_002', 'cascade', 'cascade'); // change campaign_046 DBLibrary::renameColumnWithForeignKey('005_046_email_campaigns_groups', 'campaign_046', 'campaign_id_046', 'INT', 10, true, false, 'fk01_005_046_email_campaigns_groups', '005_044_email_campaign', 'id_044', 'cascade', 'cascade'); // change group_046 DBLibrary::renameColumnWithForeignKey('005_046_email_campaigns_groups', 'group_046', 'group_id_046', 'INT', 10, true, false, 'fk02_005_046_email_campaigns_groups', '005_040_group', 'id_040', 'cascade', 'cascade'); // change campaign_047 DBLibrary::renameColumnWithForeignKey('005_047_email_send_queue', 'campaign_047', 'campaign_id_047', 'INT', 10, true, false, 'fk01_005_047_email_send_queue', '005_044_email_campaign', 'id_044', 'cascade', 'cascade'); // change contact_047 DBLibrary::renameColumnWithForeignKey('005_047_email_send_queue', 'contact_047', 'contact_id_047', 'INT', 10, true, false, 'fk02_005_047_email_send_queue', '005_041_contact', 'id_041', 'cascade', 'cascade'); // rename columns // status_047 DBLibrary::renameColumn('005_047_email_send_queue', 'status_047', 'status_id_047', 'TINYINT', 3, true, false, 0); // rename table if (Schema::hasTable('005_048_email_send_historical')) { Schema::rename('005_048_email_send_historical', '005_048_email_send_history'); } // change send_queue_048 DBLibrary::renameColumnWithForeignKey('005_048_email_send_history', 'send_queue_048', 'send_queue_id_048', 'BIGINT', 20, true, true, 'fk01_005_048_email_send_history', '005_047_email_send_queue', 'id_047', 'set null', 'cascade'); // change campaign_048 DBLibrary::renameColumnWithForeignKey('005_048_email_send_history', 'campaign_048', 'campaign_id_048', 'INT', 10, true, false, 'fk02_005_048_email_send_history', '005_044_email_campaign', 'id_044', 'cascade', 'cascade'); // change contact_048 DBLibrary::renameColumnWithForeignKey('005_048_email_send_history', 'contact_048', 'contact_id_048', 'INT', 10, true, false, 'fk03_005_048_email_send_history', '005_041_contact', 'id_041', 'cascade', 'cascade'); }
/** * Run the migrations. * * @return void */ public function up() { // change email_account_401 DBLibrary::renameColumnWithForeignKey('004_401_form', 'email_account_401', 'email_account_id_401', 'INT', 10, true, false, 'fk01_004_401_form', '001_013_email_account', 'id_013'); // change form_402 DBLibrary::renameColumnWithForeignKey('004_402_forward', 'form_402', 'form_id_402', 'INT', 10, true, false, 'fk01_004_402_forward', '004_401_form', 'id_401', 'cascade', 'cascade'); // change form_403 DBLibrary::renameColumnWithForeignKey('004_403_record', 'form_403', 'form_id_403', 'INT', 10, true, false, 'fk01_004_403_record', '004_401_form', 'id_401', 'cascade', 'cascade'); // change state_403 DBLibrary::renameColumnWithForeignKey('004_403_record', 'state_403', 'state_id_403', 'INT', 10, true, true, 'fk02_004_403_record', '004_400_state', 'id_400'); // change country_403 DBLibrary::renameColumnWithForeignKey('004_403_record', 'country_403', 'country_id_403', 'VARCHAR', 2, false, true, 'fk03_004_403_record', '001_002_country', 'id_002'); // change territorial_area_1_403 DBLibrary::renameColumnWithForeignKey('004_403_record', 'territorial_area_1_403', 'territorial_area_1_id_403', 'VARCHAR', 6, false, true, 'fk04_004_403_record', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_403 DBLibrary::renameColumnWithForeignKey('004_403_record', 'territorial_area_2_403', 'territorial_area_2_id_403', 'VARCHAR', 10, false, true, 'fk05_004_403_record', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_403 DBLibrary::renameColumnWithForeignKey('004_403_record', 'territorial_area_3_403', 'territorial_area_3_id_403', 'VARCHAR', 10, false, true, 'fk06_004_403_record', '001_005_territorial_area_3', 'id_005'); // change record_404 DBLibrary::renameColumnWithForeignKey('004_404_comment', 'record_404', 'record_id_404', 'INT', 10, true, false, 'fk01_004_404_comment', '004_403_record', 'id_403', 'cascade', 'cascade'); // change user_404 DBLibrary::renameColumnWithForeignKey('004_404_comment', 'user_404', 'user_id_404', 'INT', 10, true, false, 'fk02_004_404_comment', '001_010_user', 'id_010'); // change record_406 DBLibrary::renameColumnWithForeignKey('004_406_recipient', 'record_406', 'record_id_406', 'INT', 10, true, false, 'fk01_004_406_recipient', '004_403_record', 'id_403', 'cascade', 'cascade'); // change form_405 DBLibrary::renameColumnWithForeignKey('004_405_message', 'form_405', 'form_id_405', 'INT', 10, true, false, 'fk01_004_405_message', '004_401_form', 'id_401', 'cascade', 'cascade'); // change record_405 DBLibrary::renameColumnWithForeignKey('004_405_message', 'record_405', 'record_id_405', 'INT', 10, true, false, 'fk02_004_405_message', '004_403_record', 'id_403', 'cascade', 'cascade'); // change user_405 DBLibrary::renameColumnWithForeignKey('004_405_message', 'user_405', 'user_id_405', 'INT', 10, true, true, 'fk03_004_405_message', '001_010_user', 'id_010'); // change recipient_405 DBLibrary::renameColumnWithForeignKey('004_405_message', 'recipient_405', 'recipient_id_405', 'INT', 10, true, false, 'fk04_004_405_message', '004_406_recipient', 'id_406', 'cascade', 'cascade'); // rename columns // type_405 DBLibrary::renameColumn('004_405_message', 'type_405', 'type_id_405', 'VARCHAR', 50, false, false); }
/** * Run the migrations. * * @return void */ public function up() { // change lang_002 DBLibrary::renameColumnWithForeignKey('001_002_country', 'lang_002', 'lang_id_002', 'VARCHAR', 2, false, false, 'fk01_001_002_country', '001_001_lang', 'id_001'); // change country_003 DBLibrary::renameColumnWithForeignKey('001_003_territorial_area_1', 'country_003', 'country_id_003', 'VARCHAR', 2, false, false, 'fk01_001_003_territorial_area_1', '001_002_country', 'id_002'); // change country_004 DBLibrary::renameColumnWithForeignKey('001_004_territorial_area_2', 'country_004', 'country_id_004', 'VARCHAR', 2, false, false, 'fk01_001_004_territorial_area_2', '001_002_country', 'id_002'); // change territorial_area_1_004 DBLibrary::renameColumnWithForeignKey('001_004_territorial_area_2', 'territorial_area_1_004', 'territorial_area_1_id_004', 'VARCHAR', 6, false, false, 'fk02_001_004_territorial_area_2', '001_003_territorial_area_1', 'id_003'); // change country_005 DBLibrary::renameColumnWithForeignKey('001_005_territorial_area_3', 'country_005', 'country_id_005', 'VARCHAR', 2, false, false, 'fk01_001_005_territorial_area_3', '001_002_country', 'id_002'); // change territorial_area_1_005 DBLibrary::renameColumnWithForeignKey('001_005_territorial_area_3', 'territorial_area_1_005', 'territorial_area_1_id_005', 'VARCHAR', 6, false, false, 'fk02_001_005_territorial_area_3', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_005 DBLibrary::renameColumnWithForeignKey('001_005_territorial_area_3', 'territorial_area_2_005', 'territorial_area_2_id_005', 'VARCHAR', 10, false, false, 'fk03_001_005_territorial_area_3', '001_004_territorial_area_2', 'id_004'); // change lang_010 DBLibrary::renameColumnWithForeignKey('001_010_user', 'lang_010', 'lang_id_010', 'VARCHAR', 2, false, false, 'fk01_001_010_user', '001_001_lang', 'id_001'); // change profile_010 DBLibrary::renameColumnWithForeignKey('001_010_user', 'profile_010', 'profile_id_010', 'INT', 10, true, false, 'fk02_001_010_user', '001_006_profile', 'id_006'); // change package_007 DBLibrary::renameColumnWithForeignKey('001_007_resource', 'package_007', 'package_id_007', 'INT', 10, true, false, 'fk01_001_007_resource', '001_012_package', 'id_012'); // change profile_009 DBLibrary::renameColumnWithForeignKey('001_009_permission', 'profile_009', 'profile_id_009', 'INT', 10, true, false, 'fk01_001_009_permission', '001_006_profile', 'id_006', 'cascade', 'cascade'); // change resource_009 DBLibrary::renameColumnWithForeignKey('001_009_permission', 'resource_009', 'resource_id_009', 'VARCHAR', 30, false, false, 'fk02_001_009_permission', '001_007_resource', 'id_007', 'cascade', 'cascade'); // change action_009 DBLibrary::renameColumnWithForeignKey('001_009_permission', 'action_009', 'action_id_009', 'VARCHAR', 25, false, false, 'fk03_001_009_permission', '001_008_action', 'id_008', 'cascade', 'cascade'); // change package_011 DBLibrary::renameColumnWithForeignKey('001_011_cron_job', 'package_011', 'package_id_011', 'INT', 10, true, false, 'fk01_001_011_cron_job', '001_012_package', 'id_012'); // change package_018 DBLibrary::renameColumnWithForeignKey('001_018_preference', 'package_018', 'package_id_018', 'INT', 10, true, false, 'fk01_001_018_preference', '001_012_package', 'id_012'); // change resource_014 DBLibrary::renameColumnWithForeignKey('001_014_attachment_library', 'resource_014', 'resource_id_014', 'VARCHAR', 30, false, false, 'fk01_001_014_attachment_library', '001_007_resource', 'id_007', 'cascade', 'cascade'); // change resource_015 DBLibrary::renameColumnWithForeignKey('001_015_attachment_family', 'resource_015', 'resource_id_015', 'VARCHAR', 30, false, false, 'fk01_001_015_attachment_family', '001_007_resource', 'id_007', 'cascade', 'cascade'); // change lang_016 DBLibrary::renameColumnWithForeignKey('001_016_attachment', 'lang_016', 'lang_id_016', 'VARCHAR', 2, false, false, 'fk01_001_016_attachment', '001_001_lang', 'id_001'); // change resource_016 DBLibrary::renameColumnWithForeignKey('001_016_attachment', 'resource_016', 'resource_id_016', 'VARCHAR', 30, false, false, 'fk02_001_016_attachment', '001_007_resource', 'id_007', 'cascade', 'cascade'); // change family_016 DBLibrary::renameColumnWithForeignKey('001_016_attachment', 'family_016', 'family_id_016', 'INT', 10, true, true, 'fk03_001_016_attachment', '001_015_attachment_family', 'id_015'); // change library_016 DBLibrary::renameColumnWithForeignKey('001_016_attachment', 'library_016', 'library_id_016', 'INT', 10, true, true, 'fk04_001_016_attachment', '001_014_attachment_library', 'id_014', 'set null', 'cascade'); // change resource_025 DBLibrary::renameColumnWithForeignKey('001_025_field_group', 'resource_025', 'resource_id_025', 'VARCHAR', 30, false, false, 'fk01_001_025_field_group', '001_007_resource', 'id_007', 'cascade', 'cascade'); // change group_026 DBLibrary::renameColumnWithForeignKey('001_026_field', 'group_026', 'group_id_026', 'INT', 10, true, false, 'fk01_001_026_field', '001_025_field_group', 'id_025', 'cascade', 'cascade'); // change lang_027 DBLibrary::renameColumnWithForeignKey('001_027_field_value', 'lang_027', 'lang_id_027', 'VARCHAR', 2, false, false, 'fk01_001_027_field_value', '001_001_lang', 'id_001'); // change field_027 DBLibrary::renameColumnWithForeignKey('001_027_field_value', 'field_027', 'field_id_027', 'INT', 10, true, false, 'fk02_001_027_field_value', '001_026_field', 'id_026', 'cascade', 'cascade'); // change lang_028 DBLibrary::renameColumnWithForeignKey('001_028_field_result', 'lang_028', 'lang_id_028', 'VARCHAR', 2, false, false, 'fk01_001_028_field_result', '001_001_lang', 'id_001'); // change field_028 DBLibrary::renameColumnWithForeignKey('001_028_field_result', 'field_028', 'field_id_028', 'INT', 10, true, false, 'fk02_001_028_field_result', '001_026_field', 'id_026', 'cascade', 'cascade'); // change resource_028 DBLibrary::renameColumnWithForeignKey('001_028_field_result', 'resource_028', 'resource_id_028', 'VARCHAR', 30, false, false, 'fk03_001_028_field_result', '001_007_resource', 'id_007', 'cascade', 'cascade'); // rename columns // type_014 DBLibrary::renameColumn('001_014_attachment_library', 'type_014', 'type_id_014', 'TINYINT', 3, true, false); // type_016 DBLibrary::renameColumn('001_016_attachment', 'type_016', 'type_id_016', 'TINYINT', 3, true, false); // object_016 DBLibrary::renameColumn('001_016_attachment', 'object_016', 'object_id_016', 'INT', 10, true, true); // object_028 DBLibrary::renameColumn('001_028_field_result', 'object_028', 'object_id_028', 'INT', 10, true, false); }
/** * Run the migrations. * * @return void */ public function up() { // change brand_072 DBLibrary::renameColumnWithForeignKey('008_072_product', 'brand_072', 'brand_id_072', 'INT', 10, true, false, 'fk01_008_072_product', '008_071_brand', 'id_071', 'cascade', 'cascade'); // change country_073 DBLibrary::renameColumnWithForeignKey('008_073_laboratory', 'country_073', 'country_id_073', 'VARCHAR', 2, false, false, 'fk01_008_073_laboratory', '001_002_country', 'id_002'); // change territorial_area_1_073 DBLibrary::renameColumnWithForeignKey('008_073_laboratory', 'territorial_area_1_073', 'territorial_area_1_id_073', 'VARCHAR', 6, false, true, 'fk02_008_073_laboratory', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_073 DBLibrary::renameColumnWithForeignKey('008_073_laboratory', 'territorial_area_2_073', 'territorial_area_2_id_073', 'VARCHAR', 10, false, true, 'fk03_008_073_laboratory', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_073 DBLibrary::renameColumnWithForeignKey('008_073_laboratory', 'territorial_area_3_073', 'territorial_area_3_id_073', 'VARCHAR', 10, false, true, 'fk04_008_073_laboratory', '001_005_territorial_area_3', 'id_005'); // change country_074 DBLibrary::renameColumnWithForeignKey('008_074_company', 'country_074', 'country_id_074', 'VARCHAR', 2, false, false, 'fk01_008_074_company', '001_002_country', 'id_002'); // change territorial_area_1_074 DBLibrary::renameColumnWithForeignKey('008_074_company', 'territorial_area_1_074', 'territorial_area_1_id_074', 'VARCHAR', 6, false, true, 'fk02_008_074_company', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_074 DBLibrary::renameColumnWithForeignKey('008_074_company', 'territorial_area_2_074', 'territorial_area_2_id_074', 'VARCHAR', 10, false, true, 'fk03_008_074_company', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_074 DBLibrary::renameColumnWithForeignKey('008_074_company', 'territorial_area_3_074', 'territorial_area_3_id_074', 'VARCHAR', 10, false, true, 'fk04_008_074_company', '001_005_territorial_area_3', 'id_005'); // change country_075 DBLibrary::renameColumnWithForeignKey('008_075_customer', 'country_075', 'country_id_075', 'VARCHAR', 2, false, false, 'fk01_008_075_customer', '001_002_country', 'id_002'); // change territorial_area_1_075 DBLibrary::renameColumnWithForeignKey('008_075_customer', 'territorial_area_1_075', 'territorial_area_1_id_075', 'VARCHAR', 6, false, true, 'fk02_008_075_customer', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_075 DBLibrary::renameColumnWithForeignKey('008_075_customer', 'territorial_area_2_075', 'territorial_area_2_id_075', 'VARCHAR', 10, false, true, 'fk03_008_075_customer', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_075 DBLibrary::renameColumnWithForeignKey('008_075_customer', 'territorial_area_3_075', 'territorial_area_3_id_075', 'VARCHAR', 10, false, true, 'fk04_008_075_customer', '001_005_territorial_area_3', 'id_005'); // change customer_076 DBLibrary::renameColumnWithForeignKey('008_076_shop', 'customer_076', 'customer_id_076', 'INT', 10, true, false, 'fk01_008_076_shop', '008_075_customer', 'id_075', 'cascade', 'cascade'); // change country_076 DBLibrary::renameColumnWithForeignKey('008_076_shop', 'country_076', 'country_id_076', 'VARCHAR', 2, false, false, 'fk02_008_076_shop', '001_002_country', 'id_002'); // change territorial_area_1_076 DBLibrary::renameColumnWithForeignKey('008_076_shop', 'territorial_area_1_076', 'territorial_area_1_id_076', 'VARCHAR', 6, false, true, 'fk03_008_076_shop', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_076 DBLibrary::renameColumnWithForeignKey('008_076_shop', 'territorial_area_2_076', 'territorial_area_2_id_076', 'VARCHAR', 10, false, true, 'fk04_008_076_shop', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_076 DBLibrary::renameColumnWithForeignKey('008_076_shop', 'territorial_area_3_076', 'territorial_area_3_id_076', 'VARCHAR', 10, false, true, 'fk05_008_076_shop', '001_005_territorial_area_3', 'id_005'); // change shop_077 DBLibrary::renameColumnWithForeignKey('008_077_address', 'shop_077', 'shop_id_077', 'INT', 10, true, false, 'fk01_008_077_address', '008_076_shop', 'id_076', 'cascade', 'cascade'); // change country_077 DBLibrary::renameColumnWithForeignKey('008_077_address', 'country_077', 'country_id_077', 'VARCHAR', 2, false, false, 'fk02_008_077_address', '001_002_country', 'id_002'); // change territorial_area_1_077 DBLibrary::renameColumnWithForeignKey('008_077_address', 'territorial_area_1_077', 'territorial_area_1_id_077', 'VARCHAR', 6, false, true, 'fk03_008_077_address', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_077 DBLibrary::renameColumnWithForeignKey('008_077_address', 'territorial_area_2_077', 'territorial_area_2_id_077', 'VARCHAR', 10, false, true, 'fk04_008_077_address', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_077 DBLibrary::renameColumnWithForeignKey('008_077_address', 'territorial_area_3_077', 'territorial_area_3_id_077', 'VARCHAR', 10, false, true, 'fk05_008_077_address', '001_005_territorial_area_3', 'id_005'); // change supervisor_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'supervisor_078', 'supervisor_id_078', 'INT', 10, true, false, 'fk01_008_078_request', '001_010_user', 'id_010'); // change customer_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'customer_078', 'customer_id_078', 'INT', 10, true, true, 'fk02_008_078_request', '008_075_customer', 'id_075', 'set null', 'cascade'); // change shop_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'shop_078', 'shop_id_078', 'INT', 10, true, true, 'fk03_008_078_request', '008_076_shop', 'id_076', 'set null', 'cascade'); // change company_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'company_078', 'company_id_078', 'INT', 10, true, false, 'fk04_008_078_request', '008_074_company', 'id_074'); // change family_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'family_078', 'family_id_078', 'INT', 10, true, false, 'fk05_008_078_request', '008_070_family', 'id_070'); // change brand_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'brand_078', 'brand_id_078', 'INT', 10, true, false, 'fk06_008_078_request', '008_071_brand', 'id_071'); // change product_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'product_078', 'product_id_078', 'INT', 10, true, false, 'fk07_008_078_request', '008_072_product', 'id_072'); // change id_address_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'id_address_078', 'address_id_078', 'INT', 10, true, true, 'fk08_008_078_request', '008_077_address', 'id_077'); // change country_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'country_078', 'country_id_078', 'VARCHAR', 2, false, false, 'fk09_008_078_request', '001_002_country', 'id_002'); // change territorial_area_1_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'territorial_area_1_078', 'territorial_area_1_id_078', 'VARCHAR', 6, false, true, 'fk10_008_078_request', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'territorial_area_2_078', 'territorial_area_2_id_078', 'VARCHAR', 10, false, true, 'fk11_008_078_request', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'territorial_area_3_078', 'territorial_area_3_id_078', 'VARCHAR', 10, false, true, 'fk12_008_078_request', '001_005_territorial_area_3', 'id_005'); // order_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'order_078', 'order_id_078', 'INT', 10, true, true, 'fk13_008_078_request', '008_079_order', 'id_079', 'set null', 'cascade'); // stock_078 DBLibrary::renameColumnWithForeignKey('008_078_request', 'stock_078', 'stock_id_078', 'INT', 10, true, true, 'fk14_008_078_request', '008_080_stock', 'id_080', 'set null', 'cascade'); // change supervisor_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'supervisor_079', 'supervisor_id_079', 'INT', 10, true, false, 'fk01_008_079_order', '001_010_user', 'id_010'); // change customer_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'customer_079', 'customer_id_079', 'INT', 10, true, true, 'fk02_008_079_order', '008_075_customer', 'id_075', 'set null', 'cascade'); // change shop_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'shop_079', 'shop_id_079', 'INT', 10, true, true, 'fk03_008_079_order', '008_076_shop', 'id_076', 'set null', 'cascade'); // change company_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'company_079', 'company_id_079', 'INT', 10, true, false, 'fk04_008_079_order', '008_074_company', 'id_074'); // change family_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'family_079', 'family_id_079', 'INT', 10, true, false, 'fk05_008_079_order', '008_070_family', 'id_070'); // change brand_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'brand_079', 'brand_id_079', 'INT', 10, true, false, 'fk06_008_079_order', '008_071_brand', 'id_071'); // change product_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'product_079', 'product_id_079', 'INT', 10, true, false, 'fk07_008_079_order', '008_072_product', 'id_072'); // change id_address_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'id_address_079', 'address_id_079', 'INT', 10, true, true, 'fk08_008_079_order', '008_077_address', 'id_077', 'set null', 'cascade'); // change laboratory_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'laboratory_079', 'laboratory_id_079', 'INT', 10, true, false, 'fk09_008_079_order', '008_073_laboratory', 'id_073'); // change country_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'country_079', 'country_id_079', 'VARCHAR', 2, false, false, 'fk10_008_079_order', '001_002_country', 'id_002'); // change territorial_area_1_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'territorial_area_1_079', 'territorial_area_1_id_079', 'VARCHAR', 6, false, true, 'fk11_008_079_order', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'territorial_area_2_079', 'territorial_area_2_id_079', 'VARCHAR', 10, false, true, 'fk12_008_079_order', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'territorial_area_3_079', 'territorial_area_3_id_079', 'VARCHAR', 10, false, true, 'fk13_008_079_order', '001_005_territorial_area_3', 'id_005'); // request_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'request_079', 'request_id_079', 'INT', 10, true, true, 'fk14_008_079_order', '008_078_request', 'id_078', 'set null', 'cascade'); // stock_079 DBLibrary::renameColumnWithForeignKey('008_079_order', 'stock_079', 'stock_id_079', 'INT', 10, true, true, 'fk15_008_079_order', '008_080_stock', 'id_080', 'set null', 'cascade'); // change supervisor_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'supervisor_080', 'supervisor_id_080', 'INT', 10, true, false, 'fk01_008_080_stock', '001_010_user', 'id_010'); // change customer_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'customer_080', 'customer_id_080', 'INT', 10, true, true, 'fk02_008_080_stock', '008_075_customer', 'id_075', 'set null', 'cascade'); // change shop_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'shop_080', 'shop_id_080', 'INT', 10, true, true, 'fk03_008_080_stock', '008_076_shop', 'id_076', 'set null', 'cascade'); // change company_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'company_080', 'company_id_080', 'INT', 10, true, false, 'fk04_008_080_stock', '008_074_company', 'id_074'); // change family_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'family_080', 'family_id_080', 'INT', 10, true, false, 'fk05_008_080_stock', '008_070_family', 'id_070'); // change brand_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'brand_080', 'brand_id_080', 'INT', 10, true, false, 'fk06_008_080_stock', '008_071_brand', 'id_071'); // change product_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'product_080', 'product_id_080', 'INT', 10, true, false, 'fk07_008_080_stock', '008_072_product', 'id_072'); // change id_address_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'id_address_080', 'address_id_080', 'INT', 10, true, true, 'fk08_008_080_stock', '008_077_address', 'id_077', 'set null', 'cascade'); // change laboratory_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'laboratory_080', 'laboratory_id_080', 'INT', 10, true, false, 'fk09_008_080_stock', '008_073_laboratory', 'id_073'); // change country_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'country_080', 'country_id_080', 'VARCHAR', 2, false, false, 'fk10_008_080_stock', '001_002_country', 'id_002'); // change territorial_area_1_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'territorial_area_1_080', 'territorial_area_1_id_080', 'VARCHAR', 6, false, true, 'fk11_008_080_stock', '001_003_territorial_area_1', 'id_003'); // change territorial_area_2_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'territorial_area_2_080', 'territorial_area_2_id_080', 'VARCHAR', 10, false, true, 'fk12_008_080_stock', '001_004_territorial_area_2', 'id_004'); // change territorial_area_3_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'territorial_area_3_080', 'territorial_area_3_id_080', 'VARCHAR', 10, false, true, 'fk13_008_080_stock', '001_005_territorial_area_3', 'id_005'); // request_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'request_080', 'request_id_080', 'INT', 10, true, true, 'fk14_008_080_stock', '008_078_request', 'id_078', 'set null', 'cascade'); // order_080 DBLibrary::renameColumnWithForeignKey('008_080_stock', 'order_080', 'order_id_080', 'INT', 10, true, true, 'fk15_008_080_stock', '008_079_order', 'id_079', 'set null', 'cascade'); }
/** * Run the migrations. * * @return void */ public function up() { // change lang_110 DBLibrary::renameColumnWithForeignKey('012_110_category', 'lang_110', 'lang_id_110', 'VARCHAR', 2, false, false, 'fk01_012_110_category', '001_001_lang', 'id_001'); // change custom_field_group_111 DBLibrary::renameColumnWithForeignKey('012_111_product', 'custom_field_group_111', 'field_group_id_111', 'INT', 10, true, true, 'fk01_012_111_product', '001_025_field_group', 'id_025'); // change lang_112 DBLibrary::renameColumnWithForeignKey('012_112_product_lang', 'lang_112', 'lang_id_112', 'VARCHAR', 2, false, false, 'fk02_012_112_product_lang', '001_001_lang', 'id_001', 'cascade', 'cascade'); // change lang_114 DBLibrary::renameColumnWithForeignKey('012_114_order_status', 'lang_114', 'lang_id_114', 'VARCHAR', 2, false, false, 'fk01_012_114_order_status', '001_001_lang', 'id_001'); // change lang_115 DBLibrary::renameColumnWithForeignKey('012_115_payment_method', 'lang_115', 'lang_id_115', 'VARCHAR', 2, false, false, 'fk01_012_115_payment_method', '001_001_lang', 'id_001'); // change invoice_country_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'invoice_country_116', 'invoice_country_id_116', 'VARCHAR', 2, false, true, 'fk04_012_116_order', '001_002_country', 'id_002'); // change invoice_territorial_area_1_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'invoice_territorial_area_1_116', 'invoice_territorial_area_1_id_116', 'VARCHAR', 6, false, true, 'fk05_012_116_order', '001_003_territorial_area_1', 'id_003'); // change invoice_territorial_area_2_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'invoice_territorial_area_2_116', 'invoice_territorial_area_2_id_116', 'VARCHAR', 10, false, true, 'fk06_012_116_order', '001_004_territorial_area_2', 'id_004'); // change invoice_territorial_area_3_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'invoice_territorial_area_3_116', 'invoice_territorial_area_3_id_116', 'VARCHAR', 10, false, true, 'fk07_012_116_order', '001_005_territorial_area_3', 'id_005'); // change shipping_country_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'shipping_country_116', 'shipping_country_id_116', 'VARCHAR', 2, false, true, 'fk08_012_116_order', '001_002_country', 'id_002'); // change shipping_territorial_area_1_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'shipping_territorial_area_1_116', 'shipping_territorial_area_1_id_116', 'VARCHAR', 6, false, true, 'fk09_012_116_order', '001_003_territorial_area_1', 'id_003'); // change shipping_territorial_area_2_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'shipping_territorial_area_2_116', 'shipping_territorial_area_2_id_116', 'VARCHAR', 10, false, true, 'fk10_012_116_order', '001_004_territorial_area_2', 'id_004'); // change shipping_territorial_area_3_116 DBLibrary::renameColumnWithForeignKey('012_116_order', 'shipping_territorial_area_3_116', 'shipping_territorial_area_3_id_116', 'VARCHAR', 10, false, true, 'fk11_012_116_order', '001_005_territorial_area_3', 'id_005'); // change lang_117 DBLibrary::renameColumnWithForeignKey('012_117_order_row', 'lang_117', 'lang_id_117', 'VARCHAR', 2, false, false, 'fk01_012_117_order_row', '001_001_lang', 'id_001'); // change order_117 DBLibrary::renameColumnWithForeignKey('012_117_order_row', 'order_117', 'order_id_117', 'INT', 10, true, false, 'fk02_012_117_order_row', '012_116_order', 'id_116', 'cascade', 'cascade'); // change product_117 DBLibrary::renameColumnWithForeignKey('012_117_order_row', 'product_117', 'product_id_117', 'INT', 10, true, true, 'fk03_012_117_order_row', '012_111_product', 'id_111', 'set null', 'cascade'); // change customer_126 DBLibrary::renameColumnWithForeignKey('012_126_customer_discount_history', 'customer_126', 'customer_id_126', 'INT', 10, true, false, 'fk01_012_126_customer_discount_history', '009_301_customer', 'id_301'); // change order_126 DBLibrary::renameColumnWithForeignKey('012_126_customer_discount_history', 'order_126', 'order_id_126', 'INT', 10, true, false, 'fk02_012_126_customer_discount_history', '012_116_order', 'id_116'); // rename columns // parent_110 DBLibrary::renameColumn('012_110_category', 'parent_110', 'parent_id_110', 'INT', 10, true, true); // product_type_111 DBLibrary::renameColumn('012_111_product', 'product_type_111', 'type_id_111', 'TINYINT', 3, true, false); // price_type_111 DBLibrary::renameColumn('012_111_product', 'price_type_111', 'price_type_id_111', 'TINYINT', 3, true, false); // product_113 DBLibrary::renameColumn('012_113_products_categories', 'product_113', 'product_id_113', 'INT', 10, true, false); // category_113 DBLibrary::renameColumn('012_113_products_categories', 'category_113', 'category_id_113', 'INT', 10, true, false); // name_text_120 DBLibrary::renameColumn('012_120_cart_price_rule', 'name_text_120', 'name_text_id_120', 'INT', 10, true, false); // description_text_120 DBLibrary::renameColumn('012_120_cart_price_rule', 'description_text_120', 'description_text_id_120', 'INT', 10, true, true); // discount_type_120 DBLibrary::renameColumn('012_120_cart_price_rule', 'discount_type_120', 'discount_type_id_120', 'TINYINT', 3, true, true); // rule_family_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'rule_family_126', 'rule_family_id_126', 'TINYINT', 3, true, false); // rule_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'rule_126', 'rule_id_126', 'INT', 10, true, false); // name_text_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'name_text_126', 'name_text_id_126', 'INT', 10, true, false); // description_text_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'description_text_126', 'description_text_id_126', 'INT', 10, true, true); // discount_type_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'discount_type_126', 'discount_type_id_126', 'TINYINT', 3, true, true); }