File manager - Edit - /home/linknsbh/sabel-eltaqwa.com/assets/lfm/files/shares/events/thumbs/migrations.zip
Back
PK B��\��[�~ ~ ; 2025_05_09_104218_add_partial_amount_to_purchases_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('purchases', function (Blueprint $table) { $table->double('partial_amount')->nullable()->after('paid_amount'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('purchases', function (Blueprint $table) { $table->dropColumn('partial_amount'); }); } }; PK B��\%#� . 2022_02_21_073634_create_permission_tables.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; use Spatie\Permission\PermissionRegistrar; return new class extends Migration { /** * Run the migrations. */ public function up(): void { $tableNames = config('permission.table_names'); $columnNames = config('permission.column_names'); $teams = config('permission.teams'); if (empty($tableNames)) { throw new \Exception('Error: config/permission.php not loaded. Run [php artisan config:clear] and try again.'); } if ($teams && empty($columnNames['team_foreign_key'] ?? null)) { throw new \Exception('Error: team_foreign_key on config/permission.php not loaded. Run [php artisan config:clear] and try again.'); } Schema::create($tableNames['permissions'], function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); // For MySQL 8.0 use string('name', 125); $table->string('guard_name')->default('web'); // For MySQL 8.0 use string('guard_name', 125); $table->timestamps(); // $table->unique(['name', 'guard_name']); }); Schema::create($tableNames['roles'], function (Blueprint $table) use ($teams, $columnNames) { $table->bigIncrements('id'); if ($teams || config('permission.testing')) { // permission.testing is a fix for sqlite testing $table->unsignedBigInteger($columnNames['team_foreign_key'])->nullable(); $table->index($columnNames['team_foreign_key'], 'roles_team_foreign_key_index'); } $table->string('name'); // For MySQL 8.0 use string('name', 125); $table->string('guard_name')->default('web'); // For MySQL 8.0 use string('guard_name', 125); $table->timestamps(); if ($teams || config('permission.testing')) { // $table->unique([$columnNames['team_foreign_key'], 'name', 'guard_name']); } else { // $table->unique(['name', 'guard_name']); } }); Schema::create($tableNames['model_has_permissions'], function (Blueprint $table) use ($tableNames, $columnNames, $teams) { $table->unsignedBigInteger(PermissionRegistrar::$pivotPermission); $table->string('model_type'); $table->unsignedBigInteger($columnNames['model_morph_key']); $table->index([$columnNames['model_morph_key'], 'model_type'], 'model_has_permissions_model_id_model_type_index'); $table->foreign(PermissionRegistrar::$pivotPermission) ->references('id') ->on($tableNames['permissions']) ->onDelete('cascade'); if ($teams) { $table->unsignedBigInteger($columnNames['team_foreign_key']); $table->index($columnNames['team_foreign_key'], 'model_has_permissions_team_foreign_key_index'); $table->primary([ $columnNames['team_foreign_key'], PermissionRegistrar::$pivotPermission, $columnNames['model_morph_key'], 'model_type', ], 'model_has_permissions_permission_model_type_primary'); } else { $table->primary([ PermissionRegistrar::$pivotPermission, $columnNames['model_morph_key'], 'model_type', ], 'model_has_permissions_permission_model_type_primary'); } }); Schema::create($tableNames['model_has_roles'], function (Blueprint $table) use ($tableNames, $columnNames, $teams) { $table->unsignedBigInteger(PermissionRegistrar::$pivotRole); $table->string('model_type'); $table->unsignedBigInteger($columnNames['model_morph_key']); $table->index([$columnNames['model_morph_key'], 'model_type'], 'model_has_roles_model_id_model_type_index'); $table->foreign(PermissionRegistrar::$pivotRole) ->references('id') ->on($tableNames['roles']) ->onDelete('cascade'); if ($teams) { $table->unsignedBigInteger($columnNames['team_foreign_key']); $table->index($columnNames['team_foreign_key'], 'model_has_roles_team_foreign_key_index'); $table->primary([ $columnNames['team_foreign_key'], PermissionRegistrar::$pivotRole, $columnNames['model_morph_key'], 'model_type', ], 'model_has_roles_role_model_type_primary'); } else { $table->primary([PermissionRegistrar::$pivotRole, $columnNames['model_morph_key'], 'model_type'], 'model_has_roles_role_model_type_primary'); } }); Schema::create($tableNames['role_has_permissions'], function (Blueprint $table) use ($tableNames) { $table->unsignedBigInteger(PermissionRegistrar::$pivotPermission); $table->unsignedBigInteger(PermissionRegistrar::$pivotRole); $table->foreign(PermissionRegistrar::$pivotPermission) ->references('id') ->on($tableNames['permissions']) ->onDelete('cascade'); $table->foreign(PermissionRegistrar::$pivotRole) ->references('id') ->on($tableNames['roles']) ->onDelete('cascade'); $table->primary([PermissionRegistrar::$pivotPermission, PermissionRegistrar::$pivotRole], 'role_has_permissions_permission_id_role_id_primary'); }); app('cache') ->store(config('permission.cache.store') != 'default' ? config('permission.cache.store') : null) ->forget(config('permission.cache.key')); } /** * Reverse the migrations. */ public function down(): void { $tableNames = config('permission.table_names'); if (empty($tableNames)) { throw new \Exception('Error: config/permission.php not found and defaults could not be merged. Please publish the package configuration before proceeding, or drop the tables manually.'); } Schema::drop($tableNames['role_has_permissions']); Schema::drop($tableNames['model_has_roles']); Schema::drop($tableNames['model_has_permissions']); Schema::drop($tableNames['roles']); Schema::drop($tableNames['permissions']); } }; PK B��\�Zl� * 2023_12_22_065227_fill_up_product_code.phpnu �[��� <?php use App\Models\Product; use Illuminate\Database\Migrations\Migration; return new class extends Migration { /** * Run the migrations. */ public function up(): void { $products = Product::where('product_code','')->get(); foreach ($products as $product) { $product->update([ 'product_code' => $product->code ]); } } /** * Reverse the migrations. */ public function down(): void { // } }; PK B��\2��\ : 2025_05_01_110910_create_stores_and_user_stores_tables.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Artisan; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Artisan::call('db:seed', [ '--class' => 'StoreSeeder', '--force' => true, ]); } /** * Reverse the migrations. */ public function down(): void { // } }; PK B��\��`�H H 8 2022_10_17_052105_add_is_return_field_to_sales_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales', function (Blueprint $table) { $table->boolean('is_return')->default(0)->after('date'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales', function (Blueprint $table) { // }); } }; PK B��\*�=�L L # 2022_02_18_051026_create_brands.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('brands', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->longText('description')->nullable(); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('brands'); } }; PK B��\l�I ( 2022_02_18_063507_create_media_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { public function up(): void { Schema::create('media', function (Blueprint $table) { $table->bigIncrements('id'); $table->morphs('model'); $table->uuid('uuid')->nullable()->unique(); $table->string('collection_name'); $table->string('name'); $table->string('file_name'); $table->string('mime_type')->nullable(); $table->string('disk'); $table->string('conversions_disk')->nullable(); $table->unsignedBigInteger('size'); $table->json('manipulations'); $table->json('custom_properties'); $table->json('generated_conversions'); $table->json('responsive_images'); $table->unsignedInteger('order_column')->nullable()->index(); $table->nullableTimestamps(); }); } }; PK B��\%cCxx x , 2022_09_27_103942_add_new_field_in_sales.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales', function (Blueprint $table) { $table->boolean('is_sale_created')->default(false)->after('status'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales', function (Blueprint $table) { $table->dropColumn('is_sale_created'); }); } }; PK B��\��{W W 1 2022_05_10_104622_add_language_field_in_users.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('users', function (Blueprint $table) { $table->string('language')->default('en'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { $table->dropColumn('language'); }); } }; PK B��\غ� � � , 2023_06_13_112717_add_pos_register_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('pos_register', function (Blueprint $table) { $table->id(); $table->double('cash_in_hand'); $table->datetime('closed_at')->nullable(); $table->double('cash_in_hand_while_closing')->nullable(); $table->double('bank_transfer')->nullable(); $table->double('cheque')->nullable(); $table->double('other')->nullable(); $table->double('total_sale')->nullable(); $table->double('total_return')->nullable(); $table->double('total_amount')->nullable(); $table->text('notes')->nullable(); $table->unsignedBigInteger('user_id'); $table->foreign('user_id') ->references('id')->on('users') ->onUpdate('cascade') ->onDelete('cascade'); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { // } }; PK B��\GJl�� � / 2023_07_07_064405_create_coupon_codes_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('coupon_codes', function (Blueprint $table) { $table->id(); $table->string('name'); $table->string('code')->unique(); $table->date('start_date'); $table->date('end_date'); $table->integer('how_many_time_can_use'); $table->integer('discount_type'); $table->double('discount'); $table->integer('how_many_time_used')->default(0); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('coupon_codes'); } }; PK B��\��;�+ + 5 2022_03_02_050637_create_product_categories_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('product_categories', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('product_categories'); } }; PK B��\<lT. . 5 2023_12_29_065039_fill_up_main_product_table_data.phpnu �[��� <?php use App\Models\MainProduct; use App\Models\Product; use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { DB::beginTransaction(); $products = Product::with('variationProduct')->select('id','name','product_code','product_unit')->get(); foreach($products as $product){ $mainProduct = MainProduct::where('code',$product->product_code)->first(); if(!$mainProduct){ $mainProduct = new MainProduct(); $mainProduct->name = $product->name; $mainProduct->code = $product->product_code; $mainProduct->product_unit = $product->product_unit; $mainProduct->product_type = $product->variationProduct ? MainProduct::VARIATION_PRODUCT : MainProduct::SINGLE_PRODUCT; $mainProduct->save(); } $product->update([ 'main_product_id' => $mainProduct->id ]); if($product->variationProduct){ $product->variationProduct->update([ 'main_product_id' => $mainProduct->id ]); } } DB::commit(); } /** * Reverse the migrations. */ public function down(): void { // } }; PK B��\��qTv v B 2026_01_26_105522_change_two_factor_recovery_codes_to_longtext.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('users', function (Blueprint $table) { $table->longText('two_factor_recovery_codes') ->nullable() ->change(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { // }); } }; PK B��\�p>v� � 9 2025_07_07_120230_run_generate_crud_permission_seeder.phpnu �[��� <?php use Illuminate\Support\Facades\Artisan; use Illuminate\Database\Migrations\Migration; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Artisan::call('db:seed', ['--class' => 'GenerateCrudPermissionsSeeder', '--force' => true]); } /** * Reverse the migrations. */ public function down(): void { // } }; PK B��\��h? ? 7 2025_03_21_042555_add_is_default_to_multiple_tables.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { $tables = ['product_categories', 'variations', 'brands', 'units', 'products', 'customers', 'users', 'suppliers', 'warehouses', 'mail_templates', 'sms_templates']; foreach ($tables as $table) { Schema::table($table, function (Blueprint $table) { $table->boolean('is_default')->default(false)->before('created_at'); }); } } /** * Reverse the migrations. */ public function down(): void { $tables = ['product_categories', 'variations', 'brands', 'units', 'products', 'customers', 'users', 'suppliers', 'warehouses', 'mail_templates', 'sms_templates']; foreach ($tables as $table) { Schema::table($table, function (Blueprint $table) { $table->dropColumn('is_default'); }); } } }; PK B��\n��� � , 2023_01_06_052856_create_languages_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('languages', function (Blueprint $table) { $table->id(); $table->string('name'); $table->string('iso_code', 191)->unique(); $table->boolean('is_default')->default(false); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('languages'); } }; PK B��\�-p�� � > 2025_04_10_092430_add_payment_status_to_sales_return_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales_return', function (Blueprint $table) { $table->integer('payment_status')->nullable()->after('payment_type'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales_return', function (Blueprint $table) { $table->dropColumn('payment_status'); }); } }; PK B��\J[�� � 3 2022_05_24_045822_create_purchases_return_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('purchases_return', function (Blueprint $table) { $table->id(); $table->date('date'); $table->unsignedBigInteger('supplier_id'); $table->foreign('supplier_id')->references('id') ->on('suppliers') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('tax_rate')->nullable(); $table->double('tax_amount')->nullable(); $table->double('discount')->nullable(); $table->double('shipping')->nullable(); $table->double('grand_total')->nullable(); $table->double('received_amount')->nullable(); $table->double('paid_amount')->nullable(); $table->integer('payment_type')->nullable(); $table->integer('status')->nullable(); $table->integer('payment_status')->nullable(); $table->text('notes')->nullable(); $table->string('reference_code')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('purchases_return'); } }; PK B��\��8�C C C 2022_05_31_123143_remove_warehouse_id_field_into_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('products', function (Blueprint $table) { $table->dropForeign(['warehouse_id']); $table->dropColumn('warehouse_id'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('products', function (Blueprint $table) { $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); }); } }; PK B��\��\ \ A 2022_08_04_061313_add_reference_field_to_sales_payments_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales_payments', function (Blueprint $table) { $table->string('reference')->nullable()->after('sale_id'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales_payments', function (Blueprint $table) { // }); } }; PK B��\k�&�� � , 2022_09_14_050339_create_countries_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('countries', function (Blueprint $table) { $table->increments('id'); $table->string('name', 170)->unique(); $table->string('short_code', 170)->unique()->nullable(); $table->integer('phone_code')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('countries'); } }; PK B��\*�ޤ� � 1 2022_08_29_094749_create_transfer_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('transfer_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('transfer_id'); $table->foreign('transfer_id') ->references('id')->on('transfers') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('product_price')->nullable(); $table->double('net_unit_price')->nullable(); $table->integer('tax_type'); $table->double('tax_value')->nullable(); $table->double('tax_amount')->nullable(); $table->integer('discount_type'); $table->double('discount_value')->nullable(); $table->double('discount_amount')->nullable(); $table->double('quantity')->nullable(); $table->double('sub_total')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('transfer_items'); } }; PK B��\���� � 0 2025_02_28_071756_create_plan_features_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('plan_features', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('plan_id'); $table->boolean('pos_management')->default(false); $table->boolean('reports')->default(false); $table->boolean('stock_transfer')->default(false); $table->boolean('emails_support')->default(false); $table->boolean('sms_support')->default(false); $table->boolean('inventory_management')->default(false); $table->boolean('adjustments')->default(false); $table->boolean('roles_permission')->default(false); $table->timestamps(); $table->foreign('plan_id')->references('id')->on('plans') ->onUpdate('CASCADE') ->onDelete('CASCADE'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('plan_features'); } }; PK B��\���20 0 4 2022_05_23_065104_create_sale_return_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sale_return_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('sale_return_id'); $table->foreign('sale_return_id') ->references('id')->on('sales_return') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('product_price')->nullable(); $table->double('net_unit_price')->nullable(); $table->integer('tax_type'); $table->double('tax_value')->nullable(); $table->double('tax_amount')->nullable(); $table->integer('discount_type'); $table->double('discount_value')->nullable(); $table->double('discount_amount')->nullable(); $table->integer('sale_unit'); $table->double('quantity')->nullable(); $table->double('sub_total')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sale_return_items'); } }; PK B��\�3��� � * 2022_03_03_094656_create_product_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('products', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->string('code'); $table->unsignedBigInteger('product_category_id'); $table->foreign('product_category_id')->references('id') ->on('product_categories') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('brand_id'); $table->foreign('brand_id')->references('id') ->on('brands') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('product_cost'); $table->double('product_price'); $table->string('product_unit'); $table->string('sale_unit')->nullable(); $table->string('purchase_unit')->nullable(); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->string('stock_alert')->nullable(); $table->double('order_tax')->nullable(); $table->enum('tax_type', [1, 2])->nullable(); $table->text('notes')->nullable(); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('products'); } }; PK B��\ר��s s ? 2025_05_27_114319_add_purchase_id_to_purchases_return_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('purchases_return', function (Blueprint $table) { $table->unsignedBigInteger('purchase_id')->after('reference_code')->nullable(); $table->foreign('purchase_id') ->references('id')->on('purchases') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('purchases_return', function (Blueprint $table) { $table->dropForeign(['purchase_id']); $table->dropColumn('purchase_id'); }); } }; PK B��\zN��� � / 2025_01_13_062432_create_transactions_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('transactions', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('transaction_id'); $table->double('amount'); $table->integer('type'); $table->integer('status'); $table->text('meta')->nullable(); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('transactions'); } }; PK B��\��� x x 6 2025_05_27_114530_add_is_return_to_purchases_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('purchases', function (Blueprint $table) { $table->boolean('is_return')->default(0)->after('reference_code'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('purchases', function (Blueprint $table) { $table->dropColumn('is_return'); }); } }; PK B��\���\ ) 2022_09_14_050458_create_states_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('states', function (Blueprint $table) { $table->increments('id'); $table->string('name', 170); $table->unsignedInteger('country_id'); $table->timestamps(); $table->foreign('country_id')->references('id')->on('countries') ->onDelete('cascade')->onUpdate('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('states'); } }; PK B��\]}C,Y Y : 2022_11_10_105949_add_quantity_limit_to_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('products', function (Blueprint $table) { $table->string('quantity_limit')->nullable()->after('stock_alert'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('products', function (Blueprint $table) { // }); } }; PK B��\�"&#u u 0 2022_10_03_074141_create_sms_templates_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sms_templates', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->text('template_name'); $table->longText('content'); $table->string('type'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sms_templates'); } }; PK B��\�f�w� � - 2025_03_11_090446_create_contact_us_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('contact_us', function (Blueprint $table) { $table->id(); $table->string('name'); $table->string('email'); $table->string('subject'); $table->text('message')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('contact_us'); } }; PK B��\Q�H H 6 2022_12_20_044834_add_dob_field_to_customers_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('customers', function (Blueprint $table) { $table->date('dob')->nullable()->after('phone'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('customers', function (Blueprint $table) { // }); } }; PK B��\�~�w w 7 2025_06_03_071904_add_expiry_date_to_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('products', function (Blueprint $table) { $table->date('expiry_date')->nullable()->after('barcode_symbol'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('products', function (Blueprint $table) { $table->dropColumn('expiry_date'); }); } }; PK B��\Ffr� 9 2019_12_14_000001_create_personal_access_tokens_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('personal_access_tokens', function (Blueprint $table) { $table->id(); $table->morphs('tokenable'); $table->string('name'); $table->string('token', 64)->unique(); $table->text('abilities')->nullable(); $table->timestamp('last_used_at')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('personal_access_tokens'); } }; PK B��\R�@� � 2 2023_09_16_000000_rename_password_resets_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::rename('password_resets', 'password_reset_tokens'); } /** * Reverse the migrations. */ public function down(): void { Schema::rename('password_reset_tokens', 'password_resets'); } }; PK B��\^�ć� � 9 2025_01_09_104413_add_tenant_id_field_on_pos_register.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('pos_register', function (Blueprint $table) { $table->string('tenant_id')->nullable()->after('id'); $table->foreign('tenant_id') ->references('id') ->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); Schema::table('sales', function (Blueprint $table) { $table->string('tenant_id')->nullable()->after('id'); $table->foreign('tenant_id') ->references('id') ->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('pos_register', function (Blueprint $table) { if (Schema::hasColumn('pos_register', 'tenant_id')) { $table->dropForeign(['tenant_id']); $table->dropColumn('tenant_id'); } }); Schema::table('sales', function (Blueprint $table) { if (Schema::hasColumn('sales', 'tenant_id')) { $table->dropForeign(['tenant_id']); $table->dropColumn('tenant_id'); } }); } }; PK B��\6P�ˀ � A 2022_03_01_045721_add_display_name_into_permissions_and_roles.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('permissions', function (Blueprint $table) { $table->string('display_name')->nullable()->after('name'); }); Schema::table('roles', function (Blueprint $table) { $table->string('display_name')->nullable()->after('name'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('permissions', function (Blueprint $table) { $table->dropColumn('display_name'); }); Schema::table('roles', function (Blueprint $table) { $table->dropColumn('display_name'); }); } }; PK B��\�SԲ� � + 2025_04_01_130747_create_features_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('features', function (Blueprint $table) { $table->id(); $table->string('title'); $table->text('description')->nullable(); $table->json('points')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('features'); } }; PK B��\�f�7 , 2022_03_08_055549_creat_sale_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sale_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('sale_id'); $table->foreign('sale_id') ->references('id')->on('sales') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('product_price')->nullable(); $table->double('net_unit_price')->nullable(); $table->integer('tax_type'); $table->double('tax_value')->nullable(); $table->double('tax_amount')->nullable(); $table->integer('discount_type'); $table->double('discount_value')->nullable(); $table->double('discount_amount')->nullable(); $table->integer('sale_unit'); $table->double('quantity')->nullable(); $table->double('sub_total')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sale_items'); } }; PK B��\X�$�v v > 2022_03_15_122143_add_column_barcode_symbol_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('products', function (Blueprint $table) { $table->integer('barcode_symbol')->default(1)->after('code'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('products', function (Blueprint $table) { $table->dropColumn('barcode_symbol'); }); } }; PK B��\ie"�� � , 2022_03_05_045741_create_suppliers_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('suppliers', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->string('email'); $table->string('phone'); $table->string('country'); $table->string('city'); $table->text('address'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('suppliers'); } }; PK B��\�P��" " 8 2025_01_09_073625_add_tenant_id_field_on_users_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('users', function (Blueprint $table) { $table->string('tenant_id')->nullable()->after('password'); $table->foreign('tenant_id') ->references('id') ->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { $table->dropColumn('tenant_id'); }); } }; PK B��\ڽ�� � : 2025_08_25_101815_add_new_column_discount_type_to_hold.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('holds', function (Blueprint $table) { $table->integer('discount_type')->default(2)->after('discount'); $table->integer('discount_value')->default(0)->after('discount_type'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('holds', function (Blueprint $table) { $table->dropColumn('discount_type'); $table->dropColumn('discount_value'); }); } }; PK B��\��� W W 8 2023_01_09_103904_add_is_default_to_base_units_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('base_units', function (Blueprint $table) { $table->boolean('is_default')->after('name')->default(false); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('base_units', function (Blueprint $table) { // }); } }; PK B��\s*� 7 2022_10_15_044226_add_sale_id_to_sales_return_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales_return', function (Blueprint $table) { $table->unsignedBigInteger('sale_id')->nullable()->after('date'); $table->foreign('sale_id') ->references('id')->on('sales') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales_return', function (Blueprint $table) { $table->dropColumn('sale_id'); }); } }; PK B��\�&�& & 2 2022_09_15_053604_create_quotation_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('quotation_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('quotation_id'); $table->foreign('quotation_id') ->references('id')->on('quotations') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('product_price')->nullable(); $table->double('net_unit_price')->nullable(); $table->integer('tax_type'); $table->double('tax_value')->nullable(); $table->double('tax_amount')->nullable(); $table->integer('discount_type'); $table->double('discount_value')->nullable(); $table->double('discount_amount')->nullable(); $table->integer('sale_unit'); $table->double('quantity')->nullable(); $table->double('sub_total')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('quotation_items'); } }; PK B��\�s s 2 2014_10_12_100000_create_password_resets_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('password_resets', function (Blueprint $table) { $table->string('email')->index(); $table->string('token'); $table->timestamp('created_at')->nullable(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('password_resets'); } }; PK B��\� zG# # 1 2022_03_15_072023_create_purchase_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('purchase_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('purchase_id'); $table->foreign('purchase_id') ->references('id')->on('purchases') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('product_cost')->nullable(); $table->double('net_unit_cost')->nullable(); $table->integer('tax_type'); $table->double('tax_value')->nullable(); $table->double('tax_amount')->nullable(); $table->integer('discount_type'); $table->double('discount_value')->nullable(); $table->double('discount_amount')->nullable(); $table->integer('purchase_unit'); $table->double('quantity')->nullable(); $table->double('sub_total')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('purchase_items'); } }; PK B��\�S��x x 8 2025_02_27_110353_add_is_paid_to_subscriptions_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('subscriptions', function (Blueprint $table) { $table->boolean('is_paid')->default(false)->after('status'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('subscriptions', function (Blueprint $table) { $table->dropColumn('is_paid'); }); } }; PK B��\�B�}� � * 2019_09_15_000010_create_tenants_table.phpnu �[��� <?php declare(strict_types=1); use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateTenantsTable extends Migration { /** * Run the migrations. * * @return void */ public function up(): void { Schema::create('tenants', function (Blueprint $table) { $table->string('id')->primary(); $table->string('email')->unique(); $table->timestamps(); $table->json('data')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down(): void { Schema::dropIfExists('tenants'); } } PK B��\9m�~� � ( 2014_10_12_000000_create_users_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('users', function (Blueprint $table) { $table->id(); $table->string('name'); $table->string('email')->unique(); $table->timestamp('email_verified_at')->nullable(); $table->string('password'); $table->rememberToken(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('users'); } }; PK B��\�4�7 - 2022_11_29_070305_create_base_units_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('base_units', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('base_units'); } }; PK B��\Ќ��� � , 2022_08_29_093912_create_transfers_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('transfers', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->date('date'); $table->unsignedBigInteger('from_warehouse_id'); $table->foreign('from_warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('to_warehouse_id'); $table->foreign('to_warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('tax_rate')->nullable(); $table->double('tax_amount')->nullable(); $table->double('discount')->nullable(); $table->double('shipping')->nullable(); $table->double('grand_total')->nullable(); $table->integer('status')->nullable(); $table->text('note')->nullable(); $table->string('reference_code')->nullable(); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('transfers'); } }; PK B��\�m G 2 2023_12_21_090730_add_variation_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('variation_products', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('product_id'); $table->unsignedBigInteger('variation_id'); $table->unsignedBigInteger('variation_type_id'); $table->timestamps(); $table->foreign('product_id')->references('id')->on('products')->onDelete('cascade'); $table->foreign('variation_id')->references('id')->on('variations')->onDelete('cascade'); $table->foreign('variation_type_id')->references('id')->on('variation_types')->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('variation_products'); } }; PK B��\_5=j 7 2025_03_05_055706_add_user_id_in_transactions_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('transactions', function (Blueprint $table) { $table->unsignedBigInteger('user_id')->nullable()->after('tenant_id'); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade')->onUpdate('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('transactions', function (Blueprint $table) { $table->dropForeign(['user_id']); $table->dropColumn('user_id'); }); } }; PK B��\ �� � - 2022_09_15_052207_create_quotations_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('quotations', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->date('date'); $table->unsignedBigInteger('customer_id'); $table->foreign('customer_id')->references('id') ->on('customers') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('tax_rate')->nullable(); $table->double('tax_amount')->nullable(); $table->double('discount')->nullable(); $table->double('shipping')->nullable(); $table->double('grand_total')->nullable(); $table->double('received_amount')->nullable(); $table->double('paid_amount')->nullable(); $table->integer('status')->nullable(); $table->text('note')->nullable(); $table->string('reference_code')->nullable(); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('quotations'); } }; PK B��\��x�� � ; 2025_04_23_085516_add_payment_status_to_purchases_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('purchases', function (Blueprint $table) { $table->integer('payment_status')->nullable()->after('payment_type'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('purchases', function (Blueprint $table) { $table->dropColumn('payment_status'); }); } }; PK B��\6��6� � 2 2023_11_21_123338_create_variation_types_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('variation_types', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('variation_id'); $table->foreign('variation_id')->references('id')->on('variations')->onDelete('cascade'); $table->string('name'); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('variation_types'); } }; PK B��\�F�b� � 7 2025_03_10_094242_create_business_information_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('business_information', function (Blueprint $table) { $table->id(); $table->string('title'); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('business_information'); } }; PK B��\F�u�� � 0 2022_03_05_064104_add_columns_in_users_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('users', function (Blueprint $table) { $table->renameColumn('name', 'first_name'); $table->string('last_name')->nullable()->after('name'); $table->string('phone')->nullable()->after('email'); $table->string('region')->nullable()->after('phone'); $table->boolean('status')->default(true); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { $table->renameColumn('first_name', 'name'); $table->dropColumn('last_name'); $table->dropColumn('phone'); $table->dropColumn('status'); }); } }; PK B��\�B��k k 6 2025_08_29_054502_add_notes_to_subscriptions_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('subscriptions', function (Blueprint $table) { $table->text('notes')->nullable()->after('data'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('subscriptions', function (Blueprint $table) { $table->dropColumn('notes'); }); } }; PK B��\x c�m m ( 2022_03_02_071803_create_units_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('units', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->string('short_name'); $table->enum('base_unit', [1, 2, 3]); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('units'); } }; PK B��\ɬ��� � 1 2022_07_29_085151_create_sales_payments_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sales_payments', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('sale_id'); $table->foreign('sale_id') ->references('id')->on('sales') ->onUpdate('cascade') ->onDelete('cascade'); $table->date('payment_date'); $table->integer('payment_type')->nullable(); $table->double('amount')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sales_payments'); } }; PK B��\r�=3F F 7 2022_10_08_074912_add_status_to_sms_templates_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sms_templates', function (Blueprint $table) { $table->boolean('status')->default(0); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sms_templates', function (Blueprint $table) { // }); } }; PK B��\^��f f ? 2025_04_09_120119_rename_email_to_store_id_in_tenants_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('tenants', function (Blueprint $table) { $table->renameColumn('email', 'store_id'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('tenants', function (Blueprint $table) { $table->renameColumn('store_id', 'email'); }); } }; PK B��\:��v� � 0 2023_12_22_064744_create_main_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('main_products', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->string('code'); $table->string('product_unit')->nullable(); $table->tinyInteger('product_type')->comment('1=Single, 2=Variable'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('main_products'); } }; PK B��\S�z`� � 4 2023_06_16_115153_add_new_field_into_sales_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales', function (Blueprint $table) { $table->unsignedBigInteger('user_id')->nullable(); $table->foreign('user_id') ->references('id')->on('users') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { // } }; PK B��\q�j 2 2025_02_28_101103_add_tenant_id_to_roles_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('roles', function (Blueprint $table) { $table->string('tenant_id')->nullable()->after('name'); $table->foreign('tenant_id') ->references('id') ->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('roles', function (Blueprint $table) { $table->dropColumn('tenant_id'); }); } }; PK B��\���� � 1 2022_09_27_115534_add_new_field_in_quotations.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales', function (Blueprint $table) { $table->dropColumn('is_sale_created'); }); Schema::table('quotations', function (Blueprint $table) { $table->boolean('is_sale_created')->default(false)->after('status'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('quotations', function (Blueprint $table) { // }); } }; PK B��\S큡 ) 2025_04_09_062858_create_stores_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('stores', function (Blueprint $table) { $table->id(); $table->string('name'); $table->string('tenant_id')->nullable(); $table->unsignedBigInteger('user_id'); $table->boolean('status')->default(true); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); $table->foreign('user_id') ->references('id')->on('users') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('stores'); } }; PK B��\܂�� ( 2022_11_08_050601_create_holds_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('holds', function (Blueprint $table) { $table->id(); $table->string('reference_code')->nullable(); $table->date('date'); $table->unsignedBigInteger('customer_id'); $table->foreign('customer_id')->references('id') ->on('customers') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('tax_rate')->nullable(); $table->double('tax_amount')->nullable(); $table->double('discount')->nullable(); $table->double('shipping')->nullable(); $table->double('grand_total')->nullable(); $table->double('received_amount')->nullable(); $table->double('paid_amount')->nullable(); $table->integer('status')->nullable(); $table->text('note')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('holds'); } }; PK B��\@Rl&g g ' 2025_03_10_113808_create_faqs_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('faqs', function (Blueprint $table) { $table->id(); $table->string('title'); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('faqs'); } }; PK B��\�ˎiq q 2 2022_05_20_093240_add_new_field_to_sales_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales', function (Blueprint $table) { $table->integer('status')->nullable(); $table->integer('payment_status')->nullable(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales', function (Blueprint $table) { // }); } }; PK B��\W(F�w w 1 2022_09_10_075820_create_mail_templates_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('mail_templates', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->text('template_name'); $table->longText('content'); $table->string('type'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('mail_templates'); } }; PK B��\w��� / 2022_05_23_061225_create_sales_return_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sales_return', function (Blueprint $table) { $table->id(); $table->date('date'); $table->unsignedBigInteger('customer_id'); $table->foreign('customer_id')->references('id') ->on('customers') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('tax_rate')->nullable(); $table->double('tax_amount')->nullable(); $table->double('discount')->nullable(); $table->double('shipping')->nullable(); $table->double('grand_total')->nullable(); $table->double('paid_amount')->nullable(); $table->integer('payment_type')->nullable(); $table->text('note')->nullable(); $table->string('reference_code')->nullable(); $table->integer('status')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sales_return'); } }; PK B��\��z�v v . 2022_08_05_105849_create_adjustments_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('adjustments', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->date('date'); $table->string('reference_code')->nullable(); $table->unsignedBigInteger('warehouse_id'); $table->integer('total_products')->nullable(); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('adjustments'); } }; PK B��\ĬiJH H 8 2022_10_08_074726_add_status_to_mail_templates_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('mail_templates', function (Blueprint $table) { $table->boolean('status')->default(0); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('mail_templates', function (Blueprint $table) { // }); } }; PK B��\����7 7 K 2023_12_22_065109_add_main_product_id_field_in_variation_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('variation_products', function (Blueprint $table) { $table->unsignedBigInteger('main_product_id')->nullable()->after('id'); $table->foreign('main_product_id')->references('id')->on('main_products')->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('variation_products', function (Blueprint $table) { $table->dropForeign(['main_product_id']); $table->dropColumn('main_product_id'); }); } }; PK C��\�wx = 2025_03_21_094029_add_new_setting_value_in_settings_table.phpnu �[��� <?php use App\Models\Setting; use Illuminate\Database\Migrations\Migration; return new class extends Migration { /** * Run the migrations. */ public function up(): void { $setting = new Setting(); $setting->key = 'add_stock_while_product_creation'; $setting->value = '1'; $setting->save(); } /** * Reverse the migrations. */ public function down(): void { Setting::where('key', 'add_stock_while_product_creation')->delete(); } };PK C��\�� - 2022_11_08_051309_create_hold_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('hold_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('hold_id'); $table->foreign('hold_id') ->references('id')->on('holds') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('product_price')->nullable(); $table->double('net_unit_price')->nullable(); $table->integer('tax_type'); $table->double('tax_value')->nullable(); $table->double('tax_amount')->nullable(); $table->integer('discount_type'); $table->double('discount_value')->nullable(); $table->double('discount_amount')->nullable(); $table->integer('sale_unit'); $table->double('quantity')->nullable(); $table->double('sub_total')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('hold_items'); } }; PK C��\�H I I B 2025_07_18_050720_add_new_column_add_user_id_to_expenses_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('expenses', function (Blueprint $table) { $table->unsignedBigInteger('user_id')->nullable()->after('details'); $table->foreign('user_id')->references('id') ->on('users') ->onUpdate('cascade') ->onDelete('set null'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('expenses', function (Blueprint $table) { $table->dropForeign(['user_id']); $table->dropColumn('user_id'); }); } }; PK C��\� � � + 2022_03_09_105321_create_expenses_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('expenses', function (Blueprint $table) { $table->id(); $table->date('date'); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('expense_category_id'); $table->foreign('expense_category_id')->references('id') ->on('expense_categories') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('amount'); $table->string('reference_code')->nullable(); $table->text('details')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('expenses'); } }; PK C��\ؚl l < 2025_04_21_091958_add_data_column_to_subscriptions_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('subscriptions', function (Blueprint $table) { $table->text('data')->nullable()->after('is_paid'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('subscriptions', function (Blueprint $table) { $table->dropColumn('data'); }); } }; PK C��\m�_� � D 2022_12_22_000000_add_expires_at_to_personal_access_tokens_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('personal_access_tokens', function (Blueprint $table) { $table->timestamp('expires_at')->nullable()->after('last_used_at'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('personal_access_tokens', function (Blueprint $table) { $table->dropColumn('expires_at'); }); } }; PK C��\�2� F 2025_07_09_092822_add_payment_type_foreign_keys_to_multiple_tables.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Schema; return new class extends Migration { protected array $tables = [ 'sales', 'purchases', 'sales_return', 'purchases_return', 'sales_payments', ]; /** * Run the migrations. */ public function up(): void { $validPaymentMethodIds = DB::table('payment_methods')->pluck('id')->toArray(); foreach ($this->tables as $tableName) { DB::table($tableName) ->whereNotNull('payment_type') ->whereNotIn('payment_type', $validPaymentMethodIds) ->update(['payment_type' => null]); Schema::table($tableName, function (Blueprint $table) use ($tableName) { $table->unsignedBigInteger('payment_type')->nullable()->change(); $table->foreign('payment_type', "{$tableName}_payment_type_foreign") ->references('id') ->on('payment_methods') ->onUpdate('cascade') ->onDelete('set null'); }); } } /** * Reverse the migrations. */ public function down(): void { foreach ($this->tables as $tableName) { Schema::table($tableName, function (Blueprint $table) use ($tableName) { $table->dropForeign("{$tableName}_payment_type_foreign"); }); } } }; PK C��\zFW�8 8 2 2025_07_09_091831_create_payment_methods_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('payment_methods', function (Blueprint $table) { $table->id(); $table->string('tenant_id'); $table->string('name'); $table->boolean('status')->default(true); $table->timestamps(); $table->foreign('tenant_id')->references('id')->on('tenants')->onUpdate('cascade')->onDelete('cascade'); }); $tenants = DB::table('tenants')->select('id')->get(); foreach ($tenants as $tenant) { $cashId = DB::table('payment_methods')->insertGetId([ 'tenant_id' => $tenant->id, 'name' => 'Cash', 'status' => true, 'created_at' => now(), 'updated_at' => now(), ]); $chequeId = DB::table('payment_methods')->insertGetId([ 'tenant_id' => $tenant->id, 'name' => 'Cheque', 'status' => true, 'created_at' => now(), 'updated_at' => now(), ]); $bankTransferId = DB::table('payment_methods')->insertGetId([ 'tenant_id' => $tenant->id, 'name' => 'Bank Transfer', 'status' => true, 'created_at' => now(), 'updated_at' => now(), ]); $otherId = DB::table('payment_methods')->insertGetId([ 'tenant_id' => $tenant->id, 'name' => 'Other', 'status' => true, 'created_at' => now(), 'updated_at' => now(), ]); // Update existing sales records for this tenant // Map old payment_type values to new payment_method IDs DB::table('sales') ->where('tenant_id', $tenant->id) ->where('payment_type', 1) // Old Cash ->update(['payment_type' => $cashId]); DB::table('sales') ->where('tenant_id', $tenant->id) ->where('payment_type', 2) // Old Cheque ->update(['payment_type' => $chequeId]); DB::table('sales') ->where('tenant_id', $tenant->id) ->where('payment_type', 3) // Old Bank Transfer ->update(['payment_type' => $bankTransferId]); DB::table('sales') ->where('tenant_id', $tenant->id) ->where('payment_type', 4) // Old Other ->update(['payment_type' => $otherId]); // Update existing sales_payments records for this tenant DB::table('sales_payments') ->where('payment_type', 1) // Old Cash ->whereExists(function ($query) use ($tenant) { $query->select(DB::raw(1)) ->from('sales') ->whereColumn('sales.id', 'sales_payments.sale_id') ->where('sales.tenant_id', $tenant->id); }) ->update(['payment_type' => $cashId]); DB::table('sales_payments') ->where('payment_type', 2) // Old Cheque ->whereExists(function ($query) use ($tenant) { $query->select(DB::raw(1)) ->from('sales') ->whereColumn('sales.id', 'sales_payments.sale_id') ->where('sales.tenant_id', $tenant->id); }) ->update(['payment_type' => $chequeId]); DB::table('sales_payments') ->where('payment_type', 3) // Old Bank Transfer ->whereExists(function ($query) use ($tenant) { $query->select(DB::raw(1)) ->from('sales') ->whereColumn('sales.id', 'sales_payments.sale_id') ->where('sales.tenant_id', $tenant->id); }) ->update(['payment_type' => $bankTransferId]); DB::table('sales_payments') ->where('payment_type', 4) // Old Other ->whereExists(function ($query) use ($tenant) { $query->select(DB::raw(1)) ->from('sales') ->whereColumn('sales.id', 'sales_payments.sale_id') ->where('sales.tenant_id', $tenant->id); }) ->update(['payment_type' => $otherId]); } } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('payment_methods'); } }; PK C��\���� - 2023_11_21_123327_create_variations_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('variations', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('variations'); } }; PK C��\�a�� � ( 2025_04_01_124244_create_steps_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('steps', function (Blueprint $table) { $table->id(); $table->string('sub_title'); $table->string('title'); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('steps'); } }; PK C��\���� � 0 2025_01_13_072018_create_subscriptions_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('subscriptions', function (Blueprint $table) { $table->bigIncrements('id'); $table->unsignedBigInteger('user_id'); $table->unsignedBigInteger('plan_id')->nullable(); $table->unsignedBigInteger('transaction_id')->nullable(); $table->integer('payment_type')->nullable(); $table->double('plan_amount')->default(0); $table->double('payable_amount')->default(0); $table->integer('plan_frequency')->default(1)->comment('1 = Weekly, 2 = Monthly, 3 = Yearly, 4 = Unlimited'); $table->dateTime('start_date'); $table->dateTime('end_date'); $table->dateTime('trial_ends_at')->nullable(); $table->boolean('status')->default(2)->comment('0 = Inactive, 1 = Active, 2 = Pending, 3 = Rejected'); $table->timestamps(); $table->foreign('user_id')->references('id')->on('users') ->onUpdate('CASCADE') ->onDelete('CASCADE'); $table->foreign('plan_id')->references('id')->on('plans') ->onUpdate('CASCADE') ->onDelete('CASCADE'); $table->foreign('transaction_id')->references('id')->on('transactions') ->onUpdate('CASCADE') ->onDelete('CASCADE'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('subscriptions'); } }; PK C��\�Eu[s s 5 2025_04_15_051602_add_no_of_stores_to_plans_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('plans', function (Blueprint $table) { $table->integer('no_of_stores')->default(1)->after('currency_id'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('plans', function (Blueprint $table) { $table->dropColumn('no_of_stores'); }); } }; PK C��\��q q 3 2025_07_09_040018_add_status_to_languages_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('languages', function (Blueprint $table) { $table->boolean('status')->default(true)->after('is_default'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('languages', function (Blueprint $table) { $table->dropColumn('status'); }); } }; PK C��\�@ e e > 2023_12_21_065548_add_product_code_field_in_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('products', function (Blueprint $table) { $table->string('product_code')->after('code'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('products', function (Blueprint $table) { $table->dropColumn('product_code'); }); } }; PK C��\����# # ? 2025_12_22_130803_add_two_factor_auth_fields_to_users_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('users', function (Blueprint $table) { $table->string('two_factor_secret')->nullable(); $table->string('two_factor_recovery_codes')->nullable(); $table->boolean('two_factor_enabled')->default(false); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { $table->dropColumn(['two_factor_secret', 'two_factor_recovery_codes', 'two_factor_enabled']); }); } }; PK C��\��y y 0 2025_03_10_110044_create_why_choose_us_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('why_choose_us', function (Blueprint $table) { $table->id(); $table->string('title'); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('why_choose_us'); } }; PK C��\K bo o + 2025_03_10_073004_create_services_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('services', function (Blueprint $table) { $table->id(); $table->string('title'); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('services'); } }; PK C��\�,� � . 2025_04_16_051055_create_user_stores_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('user_stores', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('user_id'); $table->unsignedBigInteger('store_id'); $table->timestamps(); $table->foreign('user_id') ->references('id')->on('users') ->onUpdate('cascade') ->onDelete('cascade'); $table->foreign('store_id') ->references('id')->on('stores') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('user_stores'); } }; PK C��\ �@a# # A 2023_12_29_064841_add_main_product_id_field_in_products_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('products', function (Blueprint $table) { $table->unsignedBigInteger('main_product_id')->nullable()->after('id'); $table->foreign('main_product_id')->references('id')->on('main_products')->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('products', function (Blueprint $table) { $table->dropForeign(['main_product_id']); $table->dropColumn('main_product_id'); }); } }; PK C��\��o+I I : 2022_07_12_102722_add_new_filed_to_manage_stocks_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('manage_stocks', function (Blueprint $table) { $table->boolean('alert')->default(false); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('manage_stocks', function (Blueprint $table) { // }); } }; PK C��\�Ǔ[� � 1 2023_07_07_083655_create_coupon_product_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('coupon_product', function (Blueprint $table) { $table->foreignId('coupon_code_id')->references('id')->on('coupon_codes')->onUpdate('cascade')->onDelete('cascade'); $table->foreignId('product_id')->references('id')->on('products')->onUpdate('cascade')->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('coupon_product'); } }; PK C��\�nH�T T 1 2022_05_13_111052_add_title_field_in_expenses.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('expenses', function (Blueprint $table) { $table->string('title')->nullable(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('expenses', function (Blueprint $table) { $table->dropColumn('title'); }); } }; PK C��\4| _N N 3 2022_08_05_110241_create_adjustment_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('adjustment_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('adjustment_id'); $table->foreign('adjustment_id') ->references('id')->on('adjustments') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('quantity')->nullable(); $table->integer('method_type'); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('adjustment_items'); } }; PK C��\Kr! . 2019_08_19_000000_create_failed_jobs_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('failed_jobs', function (Blueprint $table) { $table->id(); $table->string('uuid')->unique(); $table->text('connection'); $table->text('queue'); $table->longText('payload'); $table->longText('exception'); $table->timestamp('failed_at')->useCurrent(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('failed_jobs'); } }; PK C��\8�|� 0 2022_06_01_100610_create_manage_stocks_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('manage_stocks', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('warehouse_id'); $table->unsignedBigInteger('product_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->foreign('product_id')->references('id') ->on('products') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('quantity'); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('manage_stocks'); } }; PK C��\���R R , 2022_03_14_101110_create_purchases_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('purchases', function (Blueprint $table) { $table->id(); $table->date('date'); $table->unsignedBigInteger('supplier_id'); $table->foreign('supplier_id')->references('id') ->on('suppliers') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('tax_rate')->nullable(); $table->double('tax_amount')->nullable(); $table->double('discount')->nullable(); $table->double('shipping')->nullable(); $table->double('grand_total')->nullable(); $table->double('received_amount')->nullable(); $table->double('paid_amount')->nullable(); $table->integer('payment_type')->nullable(); $table->integer('status')->nullable(); $table->text('notes')->nullable(); $table->string('reference_code')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('purchases'); } }; PK C��\�(#T� � J 2022_03_16_050519_change_description_filed_type_expense_category_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('expense_categories', function (Blueprint $table) { $table->text('description')->nullable()->change(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('expense_categories', function (Blueprint $table) { $table->text('description')->change(); }); } }; PK C��\��8 � � 9 2024_01_12_093843_move_product_images_to_main_product.phpnu �[��� <?php use App\Models\MainProduct; use App\Models\Product; use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { $products = Product::all(); foreach ($products as $product) { $medias = $product->getMedia(Product::PATH); $mainProduct = MainProduct::where('code', $product->product_code)->first(); if ($medias->count() > 0) { foreach ($medias as $mediaItem) { $mediaItem->copy($mainProduct, MainProduct::PATH, config('app.media_disc')); } } } } /** * Reverse the migrations. */ public function down(): void { Schema::table('main_product', function (Blueprint $table) { // }); } }; PK C��\��YH H 9 2022_05_24_050431_create_purchases_return_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('purchases_return_items', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('purchase_return_id'); $table->foreign('purchase_return_id') ->references('id')->on('purchases_return') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('product_id'); $table->foreign('product_id')->references('id') ->on('products') ->onDelete('cascade') ->onUpdate('cascade'); $table->double('product_cost')->nullable(); $table->double('net_unit_cost')->nullable(); $table->integer('tax_type'); $table->double('tax_value')->nullable(); $table->double('tax_amount')->nullable(); $table->integer('discount_type'); $table->double('discount_value')->nullable(); $table->double('discount_amount')->nullable(); $table->integer('purchase_unit'); $table->double('quantity')->nullable(); $table->double('sub_total')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('purchases_return_items'); } }; PK C��\ �b� � , 2022_03_02_125151_create_warehouse_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('warehouses', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->string('phone'); $table->string('country'); $table->string('city'); $table->string('email')->nullable(); $table->string('zip_code')->nullable(); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('warehouses'); } }; PK C��\ 0�k~ ~ ( 2025_05_09_105332_create_taxes_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('taxes', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->string('number'); $table->boolean('status')->default(true); $table->timestamps(); $table->foreign('tenant_id') ->references('id') ->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('taxes'); } }; PK C��\~EKng g H 2022_10_17_062353_add_sold_quantity_field_to_sale_return_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sale_return_items', function (Blueprint $table) { $table->double('sold_quantity')->nullable()->after('quantity'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sale_return_items', function (Blueprint $table) { // }); } }; PK C��\�y \v v / 2025_03_10_111322_create_testimonials_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('testimonials', function (Blueprint $table) { $table->id(); $table->string('name'); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('testimonials'); } }; PK C��\y �eW W : 2024_09_27_052402_add_warehouse_id_in_hold_items_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('hold_items', function (Blueprint $table) { $table->unsignedBigInteger('warehouse_id')->nullable()->after('product_id'); }); } public function down(): void { Schema::table('hold_items', function (Blueprint $table) { $table->dropColumn('warehouse_id'); }); } }; PK C��\����q q = 2025_03_24_040730_modify_value_nullable_in_settings_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('settings', function (Blueprint $table) { $table->text('value')->nullable()->change(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('settings', function (Blueprint $table) { $table->text('value')->nullable(false)->change(); }); } }; PK C��\��Q� ( 2025_01_10_064051_create_plans_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('plans', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('currency_id'); $table->string('name'); $table->double('price'); $table->integer('frequency')->default(1)->comment('1 = Weekly, 2 = Monthly, 3 = Yearly, 4 = Unlimited'); $table->boolean('assign_while_register')->default(false); $table->integer('trial_days')->nullable(); $table->timestamps(); $table->foreign('currency_id')->references('id')->on('currencies') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('plans'); } }; PK C��\de�\T T 5 2022_03_09_095426_create_expense_categories_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('expense_categories', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->text('description'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('expense_categories'); } }; PK C��\�u�ju u 2 2025_01_10_095807_create_sadmin_settings_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sadmin_settings', function (Blueprint $table) { $table->id(); $table->string('key'); $table->text('value')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sadmin_settings'); } }; PK C��\!`�#� � A 2025_07_17_101815_add_new_column_discount_type_to_sales_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales', function (Blueprint $table) { $table->integer('discount_type')->nullable()->after('discount'); $table->integer('discount_value')->nullable()->after('discount_type'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales', function (Blueprint $table) { $table->dropColumn('discount_type'); $table->dropColumn('discount_value'); }); } }; PK C��\H�� � + 2022_03_04_112848_create_customer_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('customers', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('name'); $table->string('email'); $table->string('phone'); $table->string('country'); $table->string('city'); $table->text('address'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('customers'); } }; PK C��\3@�oJ J * 2019_09_15_000020_create_domains_table.phpnu �[��� <?php declare(strict_types=1); use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateDomainsTable extends Migration { /** * Run the migrations. * * @return void */ public function up(): void { Schema::create('domains', function (Blueprint $table) { $table->increments('id'); $table->string('domain', 255)->unique(); $table->string('tenant_id'); $table->timestamps(); $table->foreign('tenant_id')->references('id')->on('tenants')->onUpdate('cascade')->onDelete('cascade'); }); } /** * Reverse the migrations. * * @return void */ public function down(): void { Schema::dropIfExists('domains'); } } PK C��\�r��A A / 2022_10_03_095418_create_sms_settings_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sms_settings', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('key'); $table->text('value'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sms_settings'); } }; PK C��\����9 9 + 2025_03_10_085031_create_partners_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('partners', function (Blueprint $table) { $table->id(); $table->string('name'); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('partners'); } }; PK C��\g�[#� � - 2022_03_02_042109_create_currencies_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('currencies', function (Blueprint $table) { $table->id(); $table->string('name')->unique(); $table->string('code'); $table->string('symbol'); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('currencies'); } }; PK C��\�Я.a a G 2022_08_04_114100_add_received_amount_field_to_sales_payments_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('sales_payments', function (Blueprint $table) { $table->double('received_amount')->nullable()->after('amount'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('sales_payments', function (Blueprint $table) { // }); } }; PK C��\�>S�u u > 2025_03_06_041531_remove_stock_transfer_from_plan_features.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('plan_features', function (Blueprint $table) { $table->dropColumn('stock_transfer'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('plan_features', function (Blueprint $table) { $table->boolean('stock_transfer')->default(false); }); } }; PK C��\8}: : D 2023_01_09_112217_change_datatype_base_unit_field_to_units_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::table('units', function (Blueprint $table) { $table->bigInteger('base_unit')->change(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('units', function (Blueprint $table) { // }); } }; PK C��\!�= ( 2022_03_08_051830_create_sales_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('sales', function (Blueprint $table) { $table->id(); $table->date('date'); $table->unsignedBigInteger('customer_id'); $table->foreign('customer_id')->references('id') ->on('customers') ->onUpdate('cascade') ->onDelete('cascade'); $table->unsignedBigInteger('warehouse_id'); $table->foreign('warehouse_id')->references('id') ->on('warehouses') ->onUpdate('cascade') ->onDelete('cascade'); $table->double('tax_rate')->nullable(); $table->double('tax_amount')->nullable(); $table->double('discount')->nullable(); $table->double('shipping')->nullable(); $table->double('grand_total')->nullable(); $table->double('received_amount')->nullable(); $table->double('paid_amount')->nullable(); $table->integer('payment_type')->nullable(); $table->text('note')->nullable(); $table->string('reference_code')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('sales'); } }; PK C��\(/sk9 9 + 2022_03_10_101744_create_settings_table.phpnu �[��� <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. */ public function up(): void { Schema::create('settings', function (Blueprint $table) { $table->id(); $table->string('tenant_id')->nullable(); $table->string('key'); $table->text('value'); $table->timestamps(); $table->foreign('tenant_id') ->references('id')->on('tenants') ->onUpdate('cascade') ->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('settings'); } }; PK B��\��[�~ ~ ; 2025_05_09_104218_add_partial_amount_to_purchases_table.phpnu �[��� PK B��\%#� . � 2022_02_21_073634_create_permission_tables.phpnu �[��� PK B��\�Zl� * G 2023_12_22_065227_fill_up_product_code.phpnu �[��� PK B��\2��\ : � 2025_05_01_110910_create_stores_and_user_stores_tables.phpnu �[��� PK B��\��`�H H 8 # 2022_10_17_052105_add_is_return_field_to_sales_table.phpnu �[��� PK B��\*�=�L L # �% 2022_02_18_051026_create_brands.phpnu �[��� PK B��\l�I ( m) 2022_02_18_063507_create_media_table.phpnu �[��� PK B��\%cCxx x , �- 2022_09_27_103942_add_new_field_in_sales.phpnu �[��� PK B��\��{W W 1 �0 2022_05_10_104622_add_language_field_in_users.phpnu �[��� PK B��\غ� � � , n3 2023_06_13_112717_add_pos_register_table.phpnu �[��� PK B��\GJl�� � / �8 2023_07_07_064405_create_coupon_codes_table.phpnu �[��� PK B��\��;�+ + 5 �< 2022_03_02_050637_create_product_categories_table.phpnu �[��� PK B��\<lT. . 5 ,@ 2023_12_29_065039_fill_up_main_product_table_data.phpnu �[��� PK B��\��qTv v B �F 2026_01_26_105522_change_two_factor_recovery_codes_to_longtext.phpnu �[��� PK B��\�p>v� � 9 �I 2025_07_07_120230_run_generate_crud_permission_seeder.phpnu �[��� PK B��\��h? ? 7 �K 2025_03_21_042555_add_is_default_to_multiple_tables.phpnu �[��� PK B��\n��� � , _P 2023_01_06_052856_create_languages_table.phpnu �[��� PK B��\�-p�� � > hS 2025_04_10_092430_add_payment_status_to_sales_return_table.phpnu �[��� PK B��\J[�� � 3 \V 2022_05_24_045822_create_purchases_return_table.phpnu �[��� PK B��\��8�C C C Z] 2022_05_31_123143_remove_warehouse_id_field_into_products_table.phpnu �[��� PK B��\��\ \ A a 2022_08_04_061313_add_reference_field_to_sales_payments_table.phpnu �[��� PK B��\k�&�� � , �c 2022_09_14_050339_create_countries_table.phpnu �[��� PK B��\*�ޤ� � 1 g 2022_08_29_094749_create_transfer_items_table.phpnu �[��� PK B��\���� � 0 cm 2025_02_28_071756_create_plan_features_table.phpnu �[��� PK B��\���20 0 4 �r 2022_05_23_065104_create_sale_return_items_table.phpnu �[��� PK B��\�3��� � * 0y 2022_03_03_094656_create_product_table.phpnu �[��� PK B��\ר��s s ? I� 2025_05_27_114319_add_purchase_id_to_purchases_return_table.phpnu �[��� PK B��\zN��� � / +� 2025_01_13_062432_create_transactions_table.phpnu �[��� PK B��\��� x x 6 S� 2025_05_27_114530_add_is_return_to_purchases_table.phpnu �[��� PK B��\���\ ) 1� 2022_09_14_050458_create_states_table.phpnu �[��� PK B��\]}C,Y Y : �� 2022_11_10_105949_add_quantity_limit_to_products_table.phpnu �[��� PK B��\�"&#u u 0 P� 2022_10_03_074141_create_sms_templates_table.phpnu �[��� PK B��\�f�w� � - %� 2025_03_11_090446_create_contact_us_table.phpnu �[��� PK B��\Q�H H 6 <� 2022_12_20_044834_add_dob_field_to_customers_table.phpnu �[��� PK B��\�~�w w 7 � 2025_06_03_071904_add_expiry_date_to_products_table.phpnu �[��� PK B��\Ffr� 9 Ȟ 2019_12_14_000001_create_personal_access_tokens_table.phpnu �[��� PK B��\R�@� � 2 P� 2023_09_16_000000_rename_password_resets_table.phpnu �[��� PK B��\^�ć� � 9 r� 2025_01_09_104413_add_tenant_id_field_on_pos_register.phpnu �[��� PK B��\6P�ˀ � A ʪ 2022_03_01_045721_add_display_name_into_permissions_and_roles.phpnu �[��� PK B��\�SԲ� � + �� 2025_04_01_130747_create_features_table.phpnu �[��� PK B��\�f�7 , �� 2022_03_08_055549_creat_sale_items_table.phpnu �[��� PK B��\X�$�v v > � 2022_03_15_122143_add_column_barcode_symbol_products_table.phpnu �[��� PK B��\ie"�� � , � 2022_03_05_045741_create_suppliers_table.phpnu �[��� PK B��\�P��" " 8 1� 2025_01_09_073625_add_tenant_id_field_on_users_table.phpnu �[��� PK B��\ڽ�� � : �� 2025_08_25_101815_add_new_column_discount_type_to_hold.phpnu �[��� PK B��\��� W W 8 � 2023_01_09_103904_add_is_default_to_base_units_table.phpnu �[��� PK B��\s*� 7 �� 2022_10_15_044226_add_sale_id_to_sales_return_table.phpnu �[��� PK B��\�&�& & 2 a� 2022_09_15_053604_create_quotation_items_table.phpnu �[��� PK B��\�s s 2 �� 2014_10_12_100000_create_password_resets_table.phpnu �[��� PK B��\� zG# # 1 �� 2022_03_15_072023_create_purchase_items_table.phpnu �[��� PK B��\�S��x x 8 B� 2025_02_27_110353_add_is_paid_to_subscriptions_table.phpnu �[��� PK B��\�B�}� � * "� 2019_09_15_000010_create_tenants_table.phpnu �[��� PK B��\9m�~� � ( V� 2014_10_12_000000_create_users_table.phpnu �[��� PK B��\�4�7 - �� 2022_11_29_070305_create_base_units_table.phpnu �[��� PK B��\Ќ��� � , � 2022_08_29_093912_create_transfers_table.phpnu �[��� PK B��\�m G 2 � 2023_12_21_090730_add_variation_products_table.phpnu �[��� PK B��\_5=j 7 w� 2025_03_05_055706_add_user_id_in_transactions_table.phpnu �[��� PK B��\ �� � - �� 2022_09_15_052207_create_quotations_table.phpnu �[��� PK B��\��x�� � ; R� 2025_04_23_085516_add_payment_status_to_purchases_table.phpnu �[��� PK B��\6��6� � 2 = 2023_11_21_123338_create_variation_types_table.phpnu �[��� PK B��\�F�b� � 7 � 2025_03_10_094242_create_business_information_table.phpnu �[��� PK B��\F�u�� � 0 r 2022_03_05_064104_add_columns_in_users_table.phpnu �[��� PK B��\�B��k k 6 � 2025_08_29_054502_add_notes_to_subscriptions_table.phpnu �[��� PK B��\x c�m m ( � 2022_03_02_071803_create_units_table.phpnu �[��� PK B��\ɬ��� � 1 I 2022_07_29_085151_create_sales_payments_table.phpnu �[��� PK B��\r�=3F F 7 7 2022_10_08_074912_add_status_to_sms_templates_table.phpnu �[��� PK B��\^��f f ? � 2025_04_09_120119_rename_email_to_store_id_in_tenants_table.phpnu �[��� PK B��\:��v� � 0 � 2023_12_22_064744_create_main_products_table.phpnu �[��� PK B��\S�z`� � 4 � 2023_06_16_115153_add_new_field_into_sales_table.phpnu �[��� PK B��\q�j 2 �# 2025_02_28_101103_add_tenant_id_to_roles_table.phpnu �[��� PK B��\���� � 1 e' 2022_09_27_115534_add_new_field_in_quotations.phpnu �[��� PK B��\S큡 ) �* 2025_04_09_062858_create_stores_table.phpnu �[��� PK B��\܂�� ( / 2022_11_08_050601_create_holds_table.phpnu �[��� PK B��\@Rl&g g ' �5 2025_03_10_113808_create_faqs_table.phpnu �[��� PK B��\�ˎiq q 2 ?8 2022_05_20_093240_add_new_field_to_sales_table.phpnu �[��� PK B��\W(F�w w 1 ; 2022_09_10_075820_create_mail_templates_table.phpnu �[��� PK B��\w��� / �> 2022_05_23_061225_create_sales_return_table.phpnu �[��� PK B��\��z�v v . eE 2022_08_05_105849_create_adjustments_table.phpnu �[��� PK B��\ĬiJH H 8 9J 2022_10_08_074726_add_status_to_mail_templates_table.phpnu �[��� PK B��\����7 7 K �L 2023_12_22_065109_add_main_product_id_field_in_variation_products_table.phpnu �[��� PK C��\�wx = �P 2025_03_21_094029_add_new_setting_value_in_settings_table.phpnu �[��� PK C��\�� - S 2022_11_08_051309_create_hold_items_table.phpnu �[��� PK C��\�H I I B ~Y 2025_07_18_050720_add_new_column_add_user_id_to_expenses_table.phpnu �[��� PK C��\� � � + 9] 2022_03_09_105321_create_expenses_table.phpnu �[��� PK C��\ؚl l < >b 2025_04_21_091958_add_data_column_to_subscriptions_table.phpnu �[��� PK C��\m�_� � D e 2022_12_22_000000_add_expires_at_to_personal_access_tokens_table.phpnu �[��� PK C��\�2� F h 2025_07_09_092822_add_payment_type_foreign_keys_to_multiple_tables.phpnu �[��� PK C��\zFW�8 8 2 �n 2025_07_09_091831_create_payment_methods_table.phpnu �[��� PK C��\���� - K� 2023_11_21_123327_create_variations_table.phpnu �[��� PK C��\�a�� � ( Å 2025_04_01_124244_create_steps_table.phpnu �[��� PK C��\���� � 0 �� 2025_01_13_072018_create_subscriptions_table.phpnu �[��� PK C��\�Eu[s s 5 � 2025_04_15_051602_add_no_of_stores_to_plans_table.phpnu �[��� PK C��\��q q 3 �� 2025_07_09_040018_add_status_to_languages_table.phpnu �[��� PK C��\�@ e e > �� 2023_12_21_065548_add_product_code_field_in_products_table.phpnu �[��� PK C��\����# # ? b� 2025_12_22_130803_add_two_factor_auth_fields_to_users_table.phpnu �[��� PK C��\��y y 0 � 2025_03_10_110044_create_why_choose_us_table.phpnu �[��� PK C��\K bo o + ͞ 2025_03_10_073004_create_services_table.phpnu �[��� PK C��\�,� � . �� 2025_04_16_051055_create_user_stores_table.phpnu �[��� PK C��\ �@a# # A ¥ 2023_12_29_064841_add_main_product_id_field_in_products_table.phpnu �[��� PK C��\��o+I I : V� 2022_07_12_102722_add_new_filed_to_manage_stocks_table.phpnu �[��� PK C��\�Ǔ[� � 1 � 2023_07_07_083655_create_coupon_product_table.phpnu �[��� PK C��\�nH�T T 1 I� 2022_05_13_111052_add_title_field_in_expenses.phpnu �[��� PK C��\4| _N N 3 �� 2022_08_05_110241_create_adjustment_items_table.phpnu �[��� PK C��\Kr! . �� 2019_08_19_000000_create_failed_jobs_table.phpnu �[��� PK C��\8�|� 0 � 2022_06_01_100610_create_manage_stocks_table.phpnu �[��� PK C��\���R R , z� 2022_03_14_101110_create_purchases_table.phpnu �[��� PK C��\�(#T� � J (� 2022_03_16_050519_change_description_filed_type_expense_category_table.phpnu �[��� PK C��\��8 � � 9 "� 2024_01_12_093843_move_product_images_to_main_product.phpnu �[��� PK C��\��YH H 9 F� 2022_05_24_050431_create_purchases_return_items_table.phpnu �[��� PK C��\ �b� � , �� 2022_03_02_125151_create_warehouse_table.phpnu �[��� PK C��\ 0�k~ ~ ( C� 2025_05_09_105332_create_taxes_table.phpnu �[��� PK C��\~EKng g H � 2022_10_17_062353_add_sold_quantity_field_to_sale_return_items_table.phpnu �[��� PK C��\�y \v v / �� 2025_03_10_111322_create_testimonials_table.phpnu �[��� PK C��\y �eW W : �� 2024_09_27_052402_add_warehouse_id_in_hold_items_table.phpnu �[��� PK C��\����q q = �� 2025_03_24_040730_modify_value_nullable_in_settings_table.phpnu �[��� PK C��\��Q� ( l� 2025_01_10_064051_create_plans_table.phpnu �[��� PK C��\de�\T T 5 �� 2022_03_09_095426_create_expense_categories_table.phpnu �[��� PK C��\�u�ju u 2 �� 2025_01_10_095807_create_sadmin_settings_table.phpnu �[��� PK C��\!`�#� � A r� 2025_07_17_101815_add_new_column_discount_type_to_sales_table.phpnu �[��� PK C��\H�� � + �� 2022_03_04_112848_create_customer_table.phpnu �[��� PK C��\3@�oJ J * � 2019_09_15_000020_create_domains_table.phpnu �[��� PK C��\�r��A A / �� 2022_10_03_095418_create_sms_settings_table.phpnu �[��� PK C��\����9 9 + L 2025_03_10_085031_create_partners_table.phpnu �[��� PK C��\g�[#� � - � 2022_03_02_042109_create_currencies_table.phpnu �[��� PK C��\�Я.a a G � 2022_08_04_114100_add_received_amount_field_to_sales_payments_table.phpnu �[��� PK C��\�>S�u u > � 2025_03_06_041531_remove_stock_transfer_from_plan_features.phpnu �[��� PK C��\8}: : D � 2023_01_09_112217_change_datatype_base_unit_field_to_units_table.phpnu �[��� PK C��\!�= ( 7 2022_03_08_051830_create_sales_table.phpnu �[��� PK C��\(/sk9 9 + � 2022_03_10_101744_create_settings_table.phpnu �[��� PK � � S: 9
| ver. 1.4 |
Github
|
.
| PHP 8.2.31 | Generation time: 0.5 |
proxy
|
phpinfo
|
Settings