/** * Run the migrations. * * @return void */ public function up() { if (Schema::hasColumn('012_111_product', 'price_111')) { // price_111 DBLibrary::renameColumn('012_111_product', 'price_111', 'subtotal_111', 'DECIMAL', '12,4', false, true); } }
/** * Run the migrations. * * @return void */ public function up() { // *********************** // 012_116_order // *********************** if (Schema::hasColumn('012_116_order', 'tax_amount_116')) { // tax_amount_116 DBLibrary::renameColumn('012_116_order', 'tax_amount_116', 'tax_amount_116', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_116_order', 'total_discount_amount_116')) { // total_discount_amount_116 DBLibrary::renameColumn('012_116_order', 'total_discount_amount_116', 'discount_amount_116', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_116_order', 'shipping_116')) { // shipping_116 DBLibrary::renameColumn('012_116_order', 'shipping_116', 'shipping_amount_116', 'DECIMAL', '12,4', false, false); } if (!Schema::hasColumn('012_116_order', 'subtotal_with_discounts_116')) { Schema::table('012_116_order', function (Blueprint $table) { $table->decimal('subtotal_with_discounts_116', 12, 4)->after('discount_amount_116'); }); } // *********************** // 012_117_order_row // *********************** if (Schema::hasColumn('012_117_order_row', 'gift_117')) { // gift_117 DBLibrary::renameColumn('012_117_order_row', 'gift_117', 'has_gift_117', 'TINYINT', 1, false, false); } }
/** * 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() { // rename columns // treatment_301 DBLibrary::renameColumn('009_301_customer', 'treatment_301', 'treatment_id_301', 'TINYINT', 3, true, true); // state_301 DBLibrary::renameColumn('009_301_customer', 'state_301', 'state_id_301', 'TINYINT', 3, true, true); }
/** * Run the migrations. * * @return void */ public function up() { // *********************** // 012_116_order // *********************** if (Schema::hasColumn('012_116_order', 'payment_id_116')) { DBLibrary::renameColumn('012_116_order', 'payment_id_116', 'payment_id_116', 'VARCHAR', 255, false, true); } }
public function up() { // rename columns // type_091 DBLibrary::renameColumn('006_091_todo', 'type_091', 'type_id_091', 'TINYINT', 3, true, false); // type_093 DBLibrary::renameColumn('006_093_history', 'type_093', 'type_id_093', 'TINYINT', 3, true, false); // type_094 DBLibrary::renameColumn('006_094_invoiced', 'type_094', 'type_id_094', 'TINYINT', 3, true, false); }
/** * Run the migrations. * * @return void */ public function up() { // change rate_percent_103 DBLibrary::renameColumn('012_103_tax_rate_zone', 'rate_percent_103', 'tax_rate_103', 'DECIMAL', '10,2', false, true); if (!Schema::hasColumn('012_104_tax_rule', 'translation_104')) { Schema::table('012_104_tax_rule', function (Blueprint $table) { $table->string('translation_104')->nullable()->after('name_104'); }); } }
/** * Run the migrations. * * @return void */ public function up() { // *********************** // 012_116_order // *********************** if (Schema::hasColumn('012_116_order', 'total_discount_amount_116')) { // total_discount_amount_116 DBLibrary::renameColumn('012_116_order', 'total_discount_amount_116', 'total_discount_amount_116', 'DECIMAL', '12,4', false, false, 0); } }
/** * Run the migrations. * * @return void */ public function up() { // *********************** // 012_103_tax_rate_zone // *********************** if (Schema::hasColumn('012_103_tax_rate_zone', 'tax_rate_103')) { // tax_rate_103 DBLibrary::renameColumn('012_103_tax_rate_zone', 'tax_rate_103', 'tax_rate_103', 'DECIMAL', '10,2', false, false, 0); } }
/** * Run the migrations. * * @return void */ public function up() { // *********************** // 012_117_order_row // *********************** if (Schema::hasColumn('012_117_order_row', 'discount_subtotal_percentage_117')) { DBLibrary::renameColumn('012_117_order_row', 'discount_subtotal_percentage_117', 'discount_subtotal_percentage_117', 'DECIMAL', '10,2', false, false); } if (Schema::hasColumn('012_117_order_row', 'discount_total_percentage_117')) { DBLibrary::renameColumn('012_117_order_row', 'discount_total_percentage_117', 'discount_total_percentage_117', 'DECIMAL', '10,2', false, false); } }
/** * 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() { // delete column row_discount_amount_116 if (Schema::hasColumn('012_116_order', 'row_discount_amount_116')) { Schema::table('012_116_order', function (Blueprint $table) { $table->dropColumn('row_discount_amount_116'); }); } // delete column total_discount_percentage_116 if (Schema::hasColumn('012_116_order', 'total_discount_percentage_116')) { Schema::table('012_116_order', function (Blueprint $table) { $table->dropColumn('total_discount_percentage_116'); }); } // delete column total_discount_percentage_116 if (Schema::hasColumn('012_126_customer_discount_history', 'discount_percentage_amount_126')) { // discount_percentage_amount_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'discount_percentage_amount_126', 'discount_amount_126', 'DECIMAL', '12,4', false, true); } }
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() { // rename columns // model_220 DBLibrary::renameColumn('011_220_place', 'model_220', 'model_id_220', 'SMALLINT', 5, true, 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() { // parameters_022 DBLibrary::renameColumn('001_022_advanced_search_task', 'parameters_022', 'parameters_022', 'TEXT', null, false, true); }
/** * Run the migrations. * * @return void */ public function up() { // *********************** // 012_116_order // *********************** if (Schema::hasColumn('012_116_order', 'shipping_116')) { // shipping_116 DBLibrary::renameColumn('012_116_order', 'shipping_116', 'shipping_116', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_116_order', 'subtotal_116')) { // subtotal_116 DBLibrary::renameColumn('012_116_order', 'subtotal_116', 'subtotal_116', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_116_order', 'total_116')) { // total_116 DBLibrary::renameColumn('012_116_order', 'total_116', 'total_116', 'DECIMAL', '12,4', false, false); } // *********************** // 012_117_order_row // *********************** if (Schema::hasColumn('012_117_order_row', 'price_117')) { // price_117 DBLibrary::renameColumn('012_117_order_row', 'price_117', 'price_117', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_117_order_row', 'quantity_117')) { // quantity_117 DBLibrary::renameColumn('012_117_order_row', 'quantity_117', 'quantity_117', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_117_order_row', 'subtotal_117')) { // subtotal_117 DBLibrary::renameColumn('012_117_order_row', 'subtotal_117', 'subtotal_117', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_117_order_row', 'discount_percentage_117')) { // discount_percentage_117 DBLibrary::renameColumn('012_117_order_row', 'discount_percentage_117', 'discount_subtotal_percentage_117', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_117_order_row', 'discount_amount_117')) { // discount_amount_117 DBLibrary::renameColumn('012_117_order_row', 'discount_amount_117', 'discount_amount_117', 'DECIMAL', '12,4', false, false); } if (Schema::hasColumn('012_117_order_row', 'tax_percentage_117')) { // tax_percentage_117 DBLibrary::renameColumn('012_117_order_row', 'tax_percentage_117', 'tax_rules_117', 'TEXT', null, false, false); } if (Schema::hasColumn('012_117_order_row', 'tax_amount_117')) { // tax_amount_117 DBLibrary::renameColumn('012_117_order_row', 'tax_amount_117', 'tax_amount_117', 'DECIMAL', '12,4', false, false); } // *********************** // 012_103_tax_rate_zone // *********************** if (Schema::hasColumn('012_103_tax_rate_zone', 'tax_rate_103')) { // tax_rate_103 DBLibrary::renameColumn('012_103_tax_rate_zone', 'tax_rate_103', 'tax_rate_103', 'DECIMAL', '12,4', false, false, 0); } // *********************** // 012_111_product // *********************** if (Schema::hasColumn('012_111_product', 'weight_111')) { // tax_rate_103 DBLibrary::renameColumn('012_111_product', 'weight_111', 'weight_111', 'DECIMAL', '11,3', false, false, 0); } // *********************** // 012_115_payment_method // *********************** if (Schema::hasColumn('012_115_payment_method', 'minimum_price_115')) { // minimum_price_115 DBLibrary::renameColumn('012_115_payment_method', 'minimum_price_115', 'minimum_price_115', 'DECIMAL', '12,4', false, true); } if (Schema::hasColumn('012_115_payment_method', 'maximum_price_115')) { // maximum_price_115 DBLibrary::renameColumn('012_115_payment_method', 'maximum_price_115', 'maximum_price_115', 'DECIMAL', '12,4', false, true); } // *********************** // 012_120_cart_price_rule // *********************** if (Schema::hasColumn('012_120_cart_price_rule', 'discount_fixed_amount_120')) { // discount_fixed_amount_120 DBLibrary::renameColumn('012_120_cart_price_rule', 'discount_fixed_amount_120', 'discount_fixed_amount_120', 'DECIMAL', '12,4', false, true); } if (Schema::hasColumn('012_120_cart_price_rule', 'discount_percentage_120')) { // discount_percentage_120 DBLibrary::renameColumn('012_120_cart_price_rule', 'discount_percentage_120', 'discount_percentage_120', 'DECIMAL', '12,4', false, true); } if (Schema::hasColumn('012_120_cart_price_rule', 'maximum_discount_amount_120')) { // maximum_discount_amount_120 DBLibrary::renameColumn('012_120_cart_price_rule', 'maximum_discount_amount_120', 'maximum_discount_amount_120', 'DECIMAL', '12,4', false, true); } // ********************************** // 012_126_customer_discount_history // ********************************** if (Schema::hasColumn('012_126_customer_discount_history', 'discount_fixed_amount_126')) { // discount_fixed_amount_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'discount_fixed_amount_126', 'discount_fixed_amount_126', 'DECIMAL', '12,4', false, true); } if (Schema::hasColumn('012_126_customer_discount_history', 'discount_percentage_126')) { // discount_percentage_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'discount_percentage_126', 'discount_percentage_126', 'DECIMAL', '12,4', false, true); } if (Schema::hasColumn('012_126_customer_discount_history', 'maximum_discount_amount_126')) { // maximum_discount_amount_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'maximum_discount_amount_126', 'maximum_discount_amount_126', 'DECIMAL', '12,4', false, true); } if (Schema::hasColumn('012_126_customer_discount_history', 'discount_percentage_amount_126')) { // discount_percentage_amount_126 DBLibrary::renameColumn('012_126_customer_discount_history', 'discount_percentage_amount_126', 'discount_percentage_amount_126', 'DECIMAL', '12,4', false, true); } // *********************** // create new columns // *********************** if (!Schema::hasColumn('012_116_order', 'shipping_comments_116')) { Schema::table('012_116_order', function (Blueprint $table) { $table->text('shipping_comments_116')->nullable()->after('shipping_address_116'); }); } if (!Schema::hasColumn('012_117_order_row', 'discount_total_percentage_117')) { Schema::table('012_117_order_row', function (Blueprint $table) { $table->decimal('discount_total_percentage_117', 12, 4)->after('discount_subtotal_percentage_117'); }); } if (!Schema::hasColumn('012_117_order_row', 'discount_subtotal_percentage_amount_117')) { Schema::table('012_117_order_row', function (Blueprint $table) { $table->decimal('discount_subtotal_percentage_amount_117', 12, 4)->after('discount_total_percentage_117'); }); } if (!Schema::hasColumn('012_117_order_row', 'discount_total_percentage_amount_117')) { Schema::table('012_117_order_row', function (Blueprint $table) { $table->decimal('discount_total_percentage_amount_117', 12, 4)->after('discount_subtotal_percentage_amount_117'); }); } if (!Schema::hasColumn('012_117_order_row', 'discount_subtotal_fixed_amount_117')) { Schema::table('012_117_order_row', function (Blueprint $table) { $table->decimal('discount_subtotal_fixed_amount_117', 12, 4)->after('discount_total_percentage_amount_117'); }); } if (!Schema::hasColumn('012_117_order_row', 'discount_total_fixed_amount_117')) { Schema::table('012_117_order_row', function (Blueprint $table) { $table->decimal('discount_total_fixed_amount_117', 12, 4)->after('discount_subtotal_fixed_amount_117'); }); } }
/** * Run the migrations. * * @return void */ public function up() { // editor_id_351 DBLibrary::renameColumn('013_351_article_family', 'editor_id_351', 'editor_id_351', 'TINYINT', 3, true, true); }
/** * Run the migrations. * * @return void */ public function up() { // rename columns // gender_301 DBLibrary::renameColumn('009_301_customer', 'gender_301', 'gender_id_301', 'TINYINT', 3, true, true); }
public function up() { // rename columns // birth_date_041 DBLibrary::renameColumn('005_041_contact', 'birth_date_041', 'birth_date_041', 'INT', 10, false, true); }
/** * Run the migrations. * * @return void */ public function up() { // rename columns // birth_date_301 DBLibrary::renameColumn('009_301_customer', 'birth_date_301', 'birth_date_301', 'INT', 10, false, true); }
/** * 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); }