/**
* 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);
}
