ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / vaultchip.com / platform / plugins / ecommerce / database / migrations

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class EcommerceCreateFlashSaleTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('ec_flash_sales', function (Blueprint $table) {
            $table->id();
            $table->string('name', 255);
            $table->dateTime('end_date');
            $table->string('status', 60)->default('published');
            $table->timestamps();
        });

Schema::create('ec_flash_sale_products', function (Blueprint $table) {
            $table->integer('flash_sale_id')->unsigned();
            $table->integer('product_id')->unsigned();
            $table->double('price')->unsigned()->nullable();
            $table->integer('quantity')->unsigned()->nullable();
            $table->integer('sold')->unsigned()->default(0);
        });
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('ec_flash_sale_products');
        Schema::dropIfExists('ec_flash_sales');
    }
}

[-] 2021_05_31_173037_ecommerce_create_ec_products_translations.php [edit]
[-] 2020_11_04_091510_make_column_phone_in_order_addresses_nullable.php [edit]
[-] 2021_03_10_025153_change_column_tax_amount.php [edit]
[-] 2021_03_20_033103_add_column_availability_to_table_ec_products.php [edit]
[-] 2021_01_01_044147_ecommerce_create_flash_sale_table.php [edit]
[+] ..
[-] 2020_10_01_152311_make_column_image_in_product_attributes_table_nullable.php [edit]
[-] 2021_09_01_115151_remove_unused_fields_in_ec_products.php [edit]
[-] 2021_01_17_082713_add_column_is_featured_to_product_collections_table.php [edit]
[-] 2021_08_30_142128_add_images_column_to_ec_reviews_table.php [edit]
[-] 2021_06_28_153141_correct_slugs_data.php [edit]
[-] 2020_09_22_135635_update_taxes_table.php [edit]
[-] 2021_02_18_073505_update_table_ec_reviews.php [edit]
[-] 2020_10_06_073439_improve_ecommerce_database.php [edit]
[-] 2020_11_01_040415_update_table_ec_order_addresses.php [edit]
[-] 2020_11_30_015801_update_table_ec_product_categories.php [edit]
[-] 2020_03_05_041139_create_ecommerce_tables.php [edit]
[-] 2021_04_28_074008_ecommerce_create_product_label_table.php [edit]
[-] 2021_01_18_024333_add_zip_code_into_table_customer_addresses.php [edit]
[-] 2021_08_17_105016_remove_column_currency_id_in_some_tables.php [edit]
[-] 2020_09_29_101006_add_views_into_ec_products_table.php [edit]
[-] 2021_03_10_024419_add_column_confirmed_at_to_table_ec_customers.php [edit]