660d0a648c
- Added `rejections` table to track rejection reasons and related entities. - Created `attendances` table for employee attendance records with geolocation data. - Introduced `payroll_periods`, `payrolls`, and `payroll_adjustments` tables for payroll management. - Established `leave_requests` table to manage employee leave applications. - Implemented `purchases` and `purchase_items` tables for tracking supplier purchases. - Created `media` table for file storage and management. - Added `activity_log` table for tracking system activities. - Established `orders` and `order_items` tables for managing customer orders. - Created `cuttings`, `cutting_materials`, and `cutting_results` tables for production management. - Introduced `system_configurations` table for application settings. - Added `push_subscriptions` table for managing user push notifications. - Created `homepage_configurations` table for homepage settings. - Established `product_prices` table for managing product pricing. - Added `owner_verification_requests` table for tracking ownership verification processes. - Created `notifications` table for user notifications. - Established `employee_advance_payments` table for managing advance payments to employees. - Created `retail_stock_histories` table for tracking stock changes. - Established `stok_opnames` and `stok_opname_items` tables for stock opname management. - Created `cutting_material_combinations` table for managing material combinations. - Added `restocks` and `restock_items` tables for managing stock replenishments. - Established `stock_mutations` table for tracking stock changes across various operations.
33 lines
1.0 KiB
PHP
33 lines
1.0 KiB
PHP
<?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->id();
|
|
|
|
$table->morphs('model');
|
|
$table->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();
|
|
});
|
|
}
|
|
};
|