Файловый менеджер - Редактировать - /home/clickysoft/public_html/jmapi5.clickysoft.net/database.tar
Назад
migrations/2024_08_23_172828_add_relationship_field_to_company_user_table.php 0000644 00000001240 15021223504 0022646 0 ustar 00 <?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('company_user', function (Blueprint $table) { $table->foreign('branch_id', 'branch_id_fk_10024453')->references('id')->on('branches')->onUpdate('CASCADE')->onDelete('CASCADE'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('company_user', function (Blueprint $table) { // }); } }; migrations/2024_08_20_000027_add_relationship_fields_to_suppliers_table.php 0000644 00000001234 15021223504 0022330 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToSuppliersTable extends Migration { public function up() { Schema::table('suppliers', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10024033')->references('id')->on('organizations'); $table->unsignedBigInteger('country_id')->nullable(); $table->foreign('country_id', 'country_fk_10024042')->references('id')->on('countries'); }); } } migrations/2024_08_20_000010_create_companies_table.php 0000644 00000000734 15021223504 0016156 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateCompaniesTable extends Migration { public function up() { Schema::create('companies', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 30); $table->string('contact_number', 20)->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_150512_create_jobs_table.php 0000644 00000001456 15021223504 0015154 0 ustar 00 <?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('jobs', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('queue')->index(); $table->longText('payload'); $table->unsignedTinyInteger('attempts'); $table->unsignedInteger('reserved_at')->nullable(); $table->unsignedInteger('available_at'); $table->unsignedInteger('created_at'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('jobs'); } }; migrations/2024_08_20_000016_create_asset_tags_table.php 0000644 00000000765 15021223504 0016347 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateAssetTagsTable extends Migration { public function up() { Schema::create('asset_tags', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('tag_name', 50); $table->string('code', 20); $table->string('serial', 30); $table->timestamps(); }); } } migrations/2024_08_23_172633_add_branch_id_field_in_company_user_table.php 0000644 00000001106 15021223504 0022035 0 ustar 00 <?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('company_user', function (Blueprint $table) { $table->unsignedBigInteger('branch_id'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('company_user', function (Blueprint $table) { // }); } }; migrations/2024_08_20_000018_create_company_user_pivot_table.php 0000644 00000001216 15021223504 0020131 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateCompanyUserPivotTable extends Migration { public function up() { Schema::create('company_user', function (Blueprint $table) { $table->unsignedBigInteger('user_id'); $table->foreign('user_id', 'user_id_fk_10023979')->references('id')->on('users')->onDelete('cascade'); $table->unsignedBigInteger('company_id'); $table->foreign('company_id', 'company_id_fk_10023979')->references('id')->on('companies')->onDelete('cascade'); }); } } migrations/2024_08_20_000019_create_role_user_pivot_table.php 0000644 00000001173 15021223504 0017427 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateRoleUserPivotTable extends Migration { public function up() { Schema::create('role_user', function (Blueprint $table) { $table->unsignedBigInteger('user_id'); $table->foreign('user_id', 'user_id_fk_10016428')->references('id')->on('users')->onDelete('cascade'); $table->unsignedBigInteger('role_id'); $table->foreign('role_id', 'role_id_fk_10016428')->references('id')->on('roles')->onDelete('cascade'); }); } } migrations/2024_08_20_000026_add_relationship_fields_to_departments_table.php 0000644 00000001503 15021223504 0022626 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToDepartmentsTable extends Migration { public function up() { Schema::table('departments', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10023981')->references('id')->on('organizations'); $table->unsignedBigInteger('company_id')->nullable(); $table->foreign('company_id', 'company_fk_10023982')->references('id')->on('companies'); $table->unsignedBigInteger('manager_id')->nullable(); $table->foreign('manager_id', 'manager_fk_10023985')->references('id')->on('users'); }); } } migrations/2024_08_20_000030_add_relationship_fields_to_asset_tags_table.php 0000644 00000001224 15021223504 0022430 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToAssetTagsTable extends Migration { public function up() { Schema::table('asset_tags', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10024071')->references('id')->on('organizations'); $table->unsignedBigInteger('asset_id')->nullable(); $table->foreign('asset_id', 'asset_fk_10024072')->references('id')->on('assets'); }); } } migrations/2024_08_20_000002_create_permissions_table.php 0000644 00000000653 15021223504 0016554 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreatePermissionsTable extends Migration { public function up() { Schema::create('permissions', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('title')->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_000001_create_media_table.php 0000644 00000002034 15021223504 0015252 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateMediaTable extends Migration { public function up() { 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(); }); } } migrations/2024_09_06_094852_add_organization_id_column_in_maintenance_schedules_table.php 0000644 00000001210 15021223504 0025337 0 ustar 00 <?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('maintenance_schedules', function (Blueprint $table) { $table->foreignId('organization_id')->constrained('organizations')->onUpdate('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('maintenance_schedules', function (Blueprint $table) { // }); } }; migrations/2024_08_20_000025_add_relationship_fields_to_branches_table.php 0000644 00000001232 15021223504 0022063 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToBranchesTable extends Migration { public function up() { Schema::table('branches', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10023970')->references('id')->on('organizations'); $table->unsignedBigInteger('company_id')->nullable(); $table->foreign('company_id', 'company_fk_10023971')->references('id')->on('companies'); }); } } migrations/2024_08_20_000011_create_branches_table.php 0000644 00000001076 15021223504 0015766 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateBranchesTable extends Migration { public function up() { Schema::create('branches', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 30); $table->string('email')->nullable(); $table->string('contact_number', 20)->nullable(); $table->string('address')->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_151026_create_failed_jobs_table.php 0000644 00000001400 15021223504 0016446 0 ustar 00 <?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'); } }; migrations/2024_08_20_000008_create_statuses_table.php 0000644 00000000634 15021223504 0016061 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateStatusesTable extends Migration { public function up() { Schema::create('statuses', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 30); $table->timestamps(); }); } } migrations/2024_08_20_000014_create_manufacturers_table.php 0000644 00000001332 15021223504 0017056 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateManufacturersTable extends Migration { public function up() { Schema::create('manufacturers', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 30); $table->string('support_url')->nullable(); $table->string('support_contact_number', 20)->nullable(); $table->string('support_email')->nullable(); $table->string('warranty_lookup_url')->nullable(); $table->unsignedTinyInteger('status')->default(1); $table->timestamps(); }); } } migrations/2024_08_20_000024_add_relationship_fields_to_companies_table.php 0000644 00000000765 15021223504 0022265 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToCompaniesTable extends Migration { public function up() { Schema::table('companies', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10023962')->references('id')->on('organizations'); }); } } migrations/2024_08_21_100322_add_password_reset_code_column_in_users_table.php 0000644 00000001102 15021223504 0023005 0 ustar 00 <?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('password_reset_code')->nullable(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { // }); } }; migrations/2024_09_06_081802_create_maintenance_schedules_table.php 0000644 00000003412 15021223504 0020544 0 ustar 00 <?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('maintenance_schedules', function (Blueprint $table) { $table->bigIncrements('id'); $table->unsignedBigInteger('asset_id'); $table->enum('maintenance_type', ['1', '2', '3'])->comment('1: Routine, 2: Corrective:, 3: Preventive')->default('1'); $table->date('scheduled_date'); $table->date('completion_date')->nullable(); $table->enum('status', ['1', '2', '3'])->default('1')->comment('1: Pending, 2: In Progress, 3: Completed'); $table->enum('frequency', ['1', '2', '3', '4', '5', '6'])->default('1')->comment('1: One-time, 2: Daily, 3: Weekly, 4, Quarterly, 5: Monthly, 6: Annually'); $table->integer('interval')->nullable(); $table->decimal('cost', 10, 2)->nullable(); $table->unsignedBigInteger('assigned_to')->nullable(); $table->date('next_scheduled_date')->nullable(); $table->text('notes')->nullable(); $table->timestamps(); // Foreign Key Constraints $table->foreign('asset_id')->references('id')->on('assets')->onDelete('cascade')->onUpdate('cascade'); // Assuming you have a `users` or `employees` table for the `assigned_to` foreign key $table->foreign('assigned_to')->references('id')->on('users')->onDelete('set null')->onUpdate('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('maintenance_schedules'); } }; migrations/.DS_Store 0000644 00000014004 15021223504 0010374 0 ustar 00 Bud1 % @ � @ � @ � @ E % DSDB ` � @ � @ � @ migrations/2024_08_20_000022_add_relationship_fields_to_statuses_table.php 0000644 00000000763 15021223504 0022156 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToStatusesTable extends Migration { public function up() { Schema::table('statuses', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10023951')->references('id')->on('organizations'); }); } } migrations/2024_08_20_000029_add_relationship_fields_to_categories_table.php 0000644 00000000767 15021223504 0022443 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToCategoriesTable extends Migration { public function up() { Schema::table('categories', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10024068')->references('id')->on('organizations'); }); } } migrations/2024_08_20_000003_create_roles_table.php 0000644 00000000637 15021223504 0015330 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateRolesTable extends Migration { public function up() { Schema::create('roles', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('title')->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_000012_create_departments_table.php 0000644 00000000740 15021223504 0016525 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateDepartmentsTable extends Migration { public function up() { Schema::create('departments', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 30); $table->string('contact_number', 20)->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_000004_create_users_table.php 0000644 00000001506 15021223504 0015342 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateUsersTable extends Migration { public function up() { Schema::create('users', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('first_name', 30)->nullable(); $table->string('last_name', 30)->nullable(); $table->string('email')->nullable()->unique(); $table->string('password')->nullable(); $table->string('contact_number', 20)->nullable(); $table->unsignedTinyInteger('status')->default(1); $table->datetime('email_verified_at')->nullable(); $table->string('remember_token')->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_000009_create_assets_table.php 0000644 00000001437 15021223504 0015513 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateAssetsTable extends Migration { public function up() { Schema::create('assets', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('asset_name'); $table->integer('qty')->nullable(); $table->longText('notes')->nullable(); $table->date('asset_expiration_date')->nullable(); $table->date('next_audit_date')->nullable(); $table->date('purchase_date')->nullable(); $table->date('eol_date')->nullable(); $table->decimal('purchase_cost', 15, 2)->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_000015_create_categories_table.php 0000644 00000000725 15021223504 0016332 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateCategoriesTable extends Migration { public function up() { Schema::create('categories', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 30); $table->text('description')->nullable(); $table->timestamps(); }); } } migrations/2014_10_12_100000_create_password_resets_table.php 0000644 00000001253 15021223504 0017415 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreatePasswordResetsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('password_resets', function (Blueprint $table) { $table->string('email')->index(); $table->string('token'); $table->timestamp('created_at')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('password_resets'); } } migrations/2024_08_20_000021_add_relationship_fields_to_users_table.php 0000644 00000000755 15021223504 0021444 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToUsersTable extends Migration { public function up() { Schema::table('users', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10023934')->references('id')->on('organizations'); }); } } migrations/2024_08_20_124720_add_user_type_field_in_users_table.php 0000644 00000001105 15021223504 0020566 0 ustar 00 <?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->unsignedTinyInteger('user_type')->default(0); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { // }); } }; migrations/2024_08_20_000017_create_permission_role_pivot_table.php 0000644 00000001237 15021223504 0020640 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreatePermissionRolePivotTable extends Migration { public function up() { Schema::create('permission_role', function (Blueprint $table) { $table->unsignedBigInteger('role_id'); $table->foreign('role_id', 'role_id_fk_10016419')->references('id')->on('roles')->onDelete('cascade'); $table->unsignedBigInteger('permission_id'); $table->foreign('permission_id', 'permission_id_fk_10016419')->references('id')->on('permissions')->onDelete('cascade'); }); } } migrations/2024_08_20_000023_add_relationship_fields_to_assets_table.php 0000644 00000003250 15021223504 0021600 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToAssetsTable extends Migration { public function up() { Schema::table('assets', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10023957')->references('id')->on('organizations'); $table->unsignedBigInteger('asset_status_id')->nullable(); $table->foreign('asset_status_id', 'asset_status_fk_10024452')->references('id')->on('statuses'); $table->unsignedBigInteger('category_id')->nullable(); $table->foreign('category_id', 'category_fk_10024453')->references('id')->on('categories'); $table->unsignedBigInteger('manufacturer_id')->nullable(); $table->foreign('manufacturer_id', 'manufacturer_fk_10024454')->references('id')->on('manufacturers'); $table->unsignedBigInteger('supplier_id')->nullable(); $table->foreign('supplier_id', 'supplier_fk_10024455')->references('id')->on('suppliers'); $table->unsignedBigInteger('company_id')->nullable(); $table->foreign('company_id', 'company_fk_10024456')->references('id')->on('companies'); $table->unsignedBigInteger('branch_id')->nullable(); $table->foreign('branch_id', 'branch_fk_10024457')->references('id')->on('branches'); $table->unsignedBigInteger('currency_id')->nullable(); $table->foreign('currency_id', 'currency_fk_10024466')->references('id')->on('currencies'); }); } } migrations/2024_08_20_000013_create_suppliers_table.php 0000644 00000001634 15021223504 0016231 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateSuppliersTable extends Migration { public function up() { Schema::create('suppliers', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('contact_name', 30); $table->string('contact_email')->nullable(); $table->string('contact_number', 20)->nullable(); $table->string('address_line_1')->nullable(); $table->string('address_line_2')->nullable(); $table->string('city', 30)->nullable(); $table->string('state')->nullable(); $table->string('zip_code', 10)->nullable(); $table->string('url')->nullable(); $table->unsignedTinyInteger('status')->default(1); $table->timestamps(); }); } } migrations/2024_08_20_000028_add_relationship_fields_to_manufacturers_table.php 0000644 00000000775 15021223504 0023173 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToManufacturersTable extends Migration { public function up() { Schema::table('manufacturers', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10024050')->references('id')->on('organizations'); }); } } migrations/2024_08_20_000005_create_organizations_table.php 0000644 00000001363 15021223504 0017072 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateOrganizationsTable extends Migration { public function up() { Schema::create('organizations', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 50); $table->string('email')->unique(); $table->string('contact_number', 20)->nullable(); $table->string('address_line_1')->nullable(); $table->string('address_line_2')->nullable(); $table->unsignedTinyInteger('status')->default(1); $table->date('date_expiration'); $table->timestamps(); }); } } migrations/2024_08_29_133545_add_organization_id_column_in_currencies_table.php 0000644 00000001162 15021223504 0023163 0 ustar 00 <?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('currencies', function (Blueprint $table) { $table->foreignId('organization_id')->constrained('organizations')->onUpdate('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('currencies', function (Blueprint $table) { // }); } }; migrations/2024_08_20_000020_add_relationship_fields_to_roles_table.php 0000644 00000000755 15021223504 0021426 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class AddRelationshipFieldsToRolesTable extends Migration { public function up() { Schema::table('roles', function (Blueprint $table) { $table->unsignedBigInteger('organization_id')->nullable(); $table->foreign('organization_id', 'organization_fk_10023933')->references('id')->on('organizations'); }); } } migrations/2024_08_20_000006_create_countries_table.php 0000644 00000000743 15021223504 0016220 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateCountriesTable extends Migration { public function up() { Schema::create('countries', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 50)->nullable(); $table->string('short_code', 3)->nullable(); $table->timestamps(); }); } } migrations/2024_08_20_000007_create_currencies_table.php 0000644 00000001016 15021223504 0016342 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateCurrenciesTable extends Migration { public function up() { Schema::create('currencies', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name', 30)->unique(); $table->string('code', 3)->unique(); $table->string('symbol', 3)->unique(); $table->timestamps(); }); } } seeders/PermissionsTableSeeder.php 0000644 00000026126 15021223504 0013323 0 ustar 00 <?php namespace Database\Seeders; use App\Models\Permission; use Illuminate\Database\Seeder; class PermissionsTableSeeder extends Seeder { public function run() { $permissions = [ [ 'id' => 1, 'title' => 'user_management_access', 'created_at' => new \DateTime, ], [ 'id' => 2, 'title' => 'permission_access', 'created_at' => new \DateTime, ], [ 'id' => 3, 'title' => 'role_create', 'created_at' => new \DateTime, ], [ 'id' => 4, 'title' => 'role_edit', 'created_at' => new \DateTime, ], [ 'id' => 5, 'title' => 'role_show', 'created_at' => new \DateTime, ], [ 'id' => 6, 'title' => 'role_delete', 'created_at' => new \DateTime, ], [ 'id' => 7, 'title' => 'role_access', 'created_at' => new \DateTime, ], [ 'id' => 8, 'title' => 'user_create', 'created_at' => new \DateTime, ], [ 'id' => 9, 'title' => 'user_edit', 'created_at' => new \DateTime, ], [ 'id' => 10, 'title' => 'user_show', 'created_at' => new \DateTime, ], [ 'id' => 11, 'title' => 'user_delete', 'created_at' => new \DateTime, ], [ 'id' => 12, 'title' => 'user_access', 'created_at' => new \DateTime, ], [ 'id' => 13, 'title' => 'organization_create', 'created_at' => new \DateTime, ], [ 'id' => 14, 'title' => 'organization_edit', 'created_at' => new \DateTime, ], [ 'id' => 15, 'title' => 'organization_show', 'created_at' => new \DateTime, ], [ 'id' => 16, 'title' => 'organization_delete', 'created_at' => new \DateTime, ], [ 'id' => 17, 'title' => 'organization_access', 'created_at' => new \DateTime, ], [ 'id' => 18, 'title' => 'country_create', 'created_at' => new \DateTime, ], [ 'id' => 19, 'title' => 'country_edit', 'created_at' => new \DateTime, ], [ 'id' => 20, 'title' => 'country_show', 'created_at' => new \DateTime, ], [ 'id' => 21, 'title' => 'country_delete', 'created_at' => new \DateTime, ], [ 'id' => 22, 'title' => 'country_access', 'created_at' => new \DateTime, ], [ 'id' => 23, 'title' => 'currency_create', 'created_at' => new \DateTime, ], [ 'id' => 24, 'title' => 'currency_edit', 'created_at' => new \DateTime, ], [ 'id' => 25, 'title' => 'currency_show', 'created_at' => new \DateTime, ], [ 'id' => 26, 'title' => 'currency_delete', 'created_at' => new \DateTime, ], [ 'id' => 27, 'title' => 'currency_access', 'created_at' => new \DateTime, ], [ 'id' => 28, 'title' => 'status_create', 'created_at' => new \DateTime, ], [ 'id' => 29, 'title' => 'status_edit', 'created_at' => new \DateTime, ], [ 'id' => 30, 'title' => 'status_show', 'created_at' => new \DateTime, ], [ 'id' => 31, 'title' => 'status_delete', 'created_at' => new \DateTime, ], [ 'id' => 32, 'title' => 'status_access', 'created_at' => new \DateTime, ], [ 'id' => 33, 'title' => 'asset_create', 'created_at' => new \DateTime, ], [ 'id' => 34, 'title' => 'asset_edit', 'created_at' => new \DateTime, ], [ 'id' => 35, 'title' => 'asset_show', 'created_at' => new \DateTime, ], [ 'id' => 36, 'title' => 'asset_delete', 'created_at' => new \DateTime, ], [ 'id' => 37, 'title' => 'asset_access', 'created_at' => new \DateTime, ], [ 'id' => 38, 'title' => 'company_create', 'created_at' => new \DateTime, ], [ 'id' => 39, 'title' => 'company_edit', 'created_at' => new \DateTime, ], [ 'id' => 40, 'title' => 'company_show', 'created_at' => new \DateTime, ], [ 'id' => 41, 'title' => 'company_delete', 'created_at' => new \DateTime, ], [ 'id' => 42, 'title' => 'company_access', 'created_at' => new \DateTime, ], [ 'id' => 43, 'title' => 'branch_create', 'created_at' => new \DateTime, ], [ 'id' => 44, 'title' => 'branch_edit', 'created_at' => new \DateTime, ], [ 'id' => 45, 'title' => 'branch_show', 'created_at' => new \DateTime, ], [ 'id' => 46, 'title' => 'branch_delete', 'created_at' => new \DateTime, ], [ 'id' => 47, 'title' => 'branch_access', 'created_at' => new \DateTime, ], [ 'id' => 48, 'title' => 'department_create', 'created_at' => new \DateTime, ], [ 'id' => 49, 'title' => 'department_edit', 'created_at' => new \DateTime, ], [ 'id' => 50, 'title' => 'department_show', 'created_at' => new \DateTime, ], [ 'id' => 51, 'title' => 'department_delete', 'created_at' => new \DateTime, ], [ 'id' => 52, 'title' => 'department_access', 'created_at' => new \DateTime, ], [ 'id' => 53, 'title' => 'supplier_create', 'created_at' => new \DateTime, ], [ 'id' => 54, 'title' => 'supplier_edit', 'created_at' => new \DateTime, ], [ 'id' => 55, 'title' => 'supplier_show', 'created_at' => new \DateTime, ], [ 'id' => 56, 'title' => 'supplier_delete', 'created_at' => new \DateTime, ], [ 'id' => 57, 'title' => 'supplier_access', 'created_at' => new \DateTime, ], [ 'id' => 58, 'title' => 'manufacturer_create', 'created_at' => new \DateTime, ], [ 'id' => 59, 'title' => 'manufacturer_edit', 'created_at' => new \DateTime, ], [ 'id' => 60, 'title' => 'manufacturer_show', 'created_at' => new \DateTime, ], [ 'id' => 61, 'title' => 'manufacturer_delete', 'created_at' => new \DateTime, ], [ 'id' => 62, 'title' => 'manufacturer_access', 'created_at' => new \DateTime, ], [ 'id' => 63, 'title' => 'category_create', 'created_at' => new \DateTime, ], [ 'id' => 64, 'title' => 'category_edit', 'created_at' => new \DateTime, ], [ 'id' => 65, 'title' => 'category_show', 'created_at' => new \DateTime, ], [ 'id' => 66, 'title' => 'category_delete', 'created_at' => new \DateTime, ], [ 'id' => 67, 'title' => 'category_access', 'created_at' => new \DateTime, ], [ 'id' => 68, 'title' => 'asset_tag_create', 'created_at' => new \DateTime, ], [ 'id' => 69, 'title' => 'asset_tag_edit', 'created_at' => new \DateTime, ], [ 'id' => 70, 'title' => 'asset_tag_show', 'created_at' => new \DateTime, ], [ 'id' => 71, 'title' => 'asset_tag_delete', 'created_at' => new \DateTime, ], [ 'id' => 72, 'title' => 'asset_tag_access', 'created_at' => new \DateTime, ], [ 'id' => 73, 'title' => 'profile_password_edit', 'created_at' => new \DateTime, ], ]; Permission::insert($permissions); } } seeders/MaintenanceSchedulePermissionSeeder.php 0000644 00000001650 15021223504 0016003 0 ustar 00 <?php namespace Database\Seeders; use App\Models\Permission; use Illuminate\Database\Seeder; class MaintenanceSchedulePermissionSeeder extends Seeder { public function run() { $countries = [ [ 'title' => 'maintenance_schedule_access', 'created_at' => new \DateTime, ], [ 'title' => 'maintenance_schedule_create', 'created_at' => new \DateTime, ], [ 'title' => 'maintenance_schedule_edit', 'created_at' => new \DateTime, ], [ 'title' => 'maintenance_schedule_show', 'created_at' => new \DateTime, ], [ 'title' => 'maintenance_schedule_delete', 'created_at' => new \DateTime, ], ]; Permission::insert($countries); } } seeders/RoleUserTableSeeder.php 0000644 00000000334 15021223504 0012541 0 ustar 00 <?php namespace Database\Seeders; use App\Models\User; use Illuminate\Database\Seeder; class RoleUserTableSeeder extends Seeder { public function run() { User::findOrFail(1)->roles()->sync(1); } } seeders/UsersTableSeeder.php 0000644 00000001126 15021223504 0012102 0 ustar 00 <?php namespace Database\Seeders; use App\Models\User; use Illuminate\Database\Seeder; class UsersTableSeeder extends Seeder { public function run() { $users = [ [ 'id' => 1, 'first_name' => 'ART', 'last_name' => 'Admin', 'email' => 'admin@al-rehman.com', 'password' => bcrypt('password'), 'user_type' => 1, // System Admin 'remember_token' => null, 'contact_number' => '', ], ]; User::insert($users); } } seeders/CountriesTableSeeder.php 0000644 00000106177 15021223504 0012770 0 ustar 00 <?php namespace Database\Seeders; use App\Models\Country; use Illuminate\Database\Seeder; class CountriesTableSeeder extends Seeder { public function run() { $countries = [ [ 'id' => 1, 'name' => 'Afghanistan', 'short_code' => 'af', ], [ 'id' => 2, 'name' => 'Albania', 'short_code' => 'al', ], [ 'id' => 3, 'name' => 'Algeria', 'short_code' => 'dz', ], [ 'id' => 4, 'name' => 'American Samoa', 'short_code' => 'as', ], [ 'id' => 5, 'name' => 'Andorra', 'short_code' => 'ad', ], [ 'id' => 6, 'name' => 'Angola', 'short_code' => 'ao', ], [ 'id' => 7, 'name' => 'Anguilla', 'short_code' => 'ai', ], [ 'id' => 8, 'name' => 'Antarctica', 'short_code' => 'aq', ], [ 'id' => 9, 'name' => 'Antigua and Barbuda', 'short_code' => 'ag', ], [ 'id' => 10, 'name' => 'Argentina', 'short_code' => 'ar', ], [ 'id' => 11, 'name' => 'Armenia', 'short_code' => 'am', ], [ 'id' => 12, 'name' => 'Aruba', 'short_code' => 'aw', ], [ 'id' => 13, 'name' => 'Australia', 'short_code' => 'au', ], [ 'id' => 14, 'name' => 'Austria', 'short_code' => 'at', ], [ 'id' => 15, 'name' => 'Azerbaijan', 'short_code' => 'az', ], [ 'id' => 16, 'name' => 'Bahamas', 'short_code' => 'bs', ], [ 'id' => 17, 'name' => 'Bahrain', 'short_code' => 'bh', ], [ 'id' => 18, 'name' => 'Bangladesh', 'short_code' => 'bd', ], [ 'id' => 19, 'name' => 'Barbados', 'short_code' => 'bb', ], [ 'id' => 20, 'name' => 'Belarus', 'short_code' => 'by', ], [ 'id' => 21, 'name' => 'Belgium', 'short_code' => 'be', ], [ 'id' => 22, 'name' => 'Belize', 'short_code' => 'bz', ], [ 'id' => 23, 'name' => 'Benin', 'short_code' => 'bj', ], [ 'id' => 24, 'name' => 'Bermuda', 'short_code' => 'bm', ], [ 'id' => 25, 'name' => 'Bhutan', 'short_code' => 'bt', ], [ 'id' => 26, 'name' => 'Bolivia', 'short_code' => 'bo', ], [ 'id' => 27, 'name' => 'Bosnia and Herzegovina', 'short_code' => 'ba', ], [ 'id' => 28, 'name' => 'Botswana', 'short_code' => 'bw', ], [ 'id' => 29, 'name' => 'Brazil', 'short_code' => 'br', ], [ 'id' => 30, 'name' => 'British Indian Ocean Territory', 'short_code' => 'io', ], [ 'id' => 31, 'name' => 'British Virgin Islands', 'short_code' => 'vg', ], [ 'id' => 32, 'name' => 'Brunei', 'short_code' => 'bn', ], [ 'id' => 33, 'name' => 'Bulgaria', 'short_code' => 'bg', ], [ 'id' => 34, 'name' => 'Burkina Faso', 'short_code' => 'bf', ], [ 'id' => 35, 'name' => 'Burundi', 'short_code' => 'bi', ], [ 'id' => 36, 'name' => 'Cambodia', 'short_code' => 'kh', ], [ 'id' => 37, 'name' => 'Cameroon', 'short_code' => 'cm', ], [ 'id' => 38, 'name' => 'Canada', 'short_code' => 'ca', ], [ 'id' => 39, 'name' => 'Cape Verde', 'short_code' => 'cv', ], [ 'id' => 40, 'name' => 'Cayman Islands', 'short_code' => 'ky', ], [ 'id' => 41, 'name' => 'Central African Republic', 'short_code' => 'cf', ], [ 'id' => 42, 'name' => 'Chad', 'short_code' => 'td', ], [ 'id' => 43, 'name' => 'Chile', 'short_code' => 'cl', ], [ 'id' => 44, 'name' => 'China', 'short_code' => 'cn', ], [ 'id' => 45, 'name' => 'Christmas Island', 'short_code' => 'cx', ], [ 'id' => 46, 'name' => 'Cocos Islands', 'short_code' => 'cc', ], [ 'id' => 47, 'name' => 'Colombia', 'short_code' => 'co', ], [ 'id' => 48, 'name' => 'Comoros', 'short_code' => 'km', ], [ 'id' => 49, 'name' => 'Cook Islands', 'short_code' => 'ck', ], [ 'id' => 50, 'name' => 'Costa Rica', 'short_code' => 'cr', ], [ 'id' => 51, 'name' => 'Croatia', 'short_code' => 'hr', ], [ 'id' => 52, 'name' => 'Cuba', 'short_code' => 'cu', ], [ 'id' => 53, 'name' => 'Curacao', 'short_code' => 'cw', ], [ 'id' => 54, 'name' => 'Cyprus', 'short_code' => 'cy', ], [ 'id' => 55, 'name' => 'Czech Republic', 'short_code' => 'cz', ], [ 'id' => 56, 'name' => 'Democratic Republic of the Congo', 'short_code' => 'cd', ], [ 'id' => 57, 'name' => 'Denmark', 'short_code' => 'dk', ], [ 'id' => 58, 'name' => 'Djibouti', 'short_code' => 'dj', ], [ 'id' => 59, 'name' => 'Dominica', 'short_code' => 'dm', ], [ 'id' => 60, 'name' => 'Dominican Republic', 'short_code' => 'do', ], [ 'id' => 61, 'name' => 'East Timor', 'short_code' => 'tl', ], [ 'id' => 62, 'name' => 'Ecuador', 'short_code' => 'ec', ], [ 'id' => 63, 'name' => 'Egypt', 'short_code' => 'eg', ], [ 'id' => 64, 'name' => 'El Salvador', 'short_code' => 'sv', ], [ 'id' => 65, 'name' => 'Equatorial Guinea', 'short_code' => 'gq', ], [ 'id' => 66, 'name' => 'Eritrea', 'short_code' => 'er', ], [ 'id' => 67, 'name' => 'Estonia', 'short_code' => 'ee', ], [ 'id' => 68, 'name' => 'Ethiopia', 'short_code' => 'et', ], [ 'id' => 69, 'name' => 'Falkland Islands', 'short_code' => 'fk', ], [ 'id' => 70, 'name' => 'Faroe Islands', 'short_code' => 'fo', ], [ 'id' => 71, 'name' => 'Fiji', 'short_code' => 'fj', ], [ 'id' => 72, 'name' => 'Finland', 'short_code' => 'fi', ], [ 'id' => 73, 'name' => 'France', 'short_code' => 'fr', ], [ 'id' => 74, 'name' => 'French Polynesia', 'short_code' => 'pf', ], [ 'id' => 75, 'name' => 'Gabon', 'short_code' => 'ga', ], [ 'id' => 76, 'name' => 'Gambia', 'short_code' => 'gm', ], [ 'id' => 77, 'name' => 'Georgia', 'short_code' => 'ge', ], [ 'id' => 78, 'name' => 'Germany', 'short_code' => 'de', ], [ 'id' => 79, 'name' => 'Ghana', 'short_code' => 'gh', ], [ 'id' => 80, 'name' => 'Gibraltar', 'short_code' => 'gi', ], [ 'id' => 81, 'name' => 'Greece', 'short_code' => 'gr', ], [ 'id' => 82, 'name' => 'Greenland', 'short_code' => 'gl', ], [ 'id' => 83, 'name' => 'Grenada', 'short_code' => 'gd', ], [ 'id' => 84, 'name' => 'Guam', 'short_code' => 'gu', ], [ 'id' => 85, 'name' => 'Guatemala', 'short_code' => 'gt', ], [ 'id' => 86, 'name' => 'Guernsey', 'short_code' => 'gg', ], [ 'id' => 87, 'name' => 'Guinea', 'short_code' => 'gn', ], [ 'id' => 88, 'name' => 'Guinea-Bissau', 'short_code' => 'gw', ], [ 'id' => 89, 'name' => 'Guyana', 'short_code' => 'gy', ], [ 'id' => 90, 'name' => 'Haiti', 'short_code' => 'ht', ], [ 'id' => 91, 'name' => 'Honduras', 'short_code' => 'hn', ], [ 'id' => 92, 'name' => 'Hong Kong', 'short_code' => 'hk', ], [ 'id' => 93, 'name' => 'Hungary', 'short_code' => 'hu', ], [ 'id' => 94, 'name' => 'Iceland', 'short_code' => 'is', ], [ 'id' => 95, 'name' => 'India', 'short_code' => 'in', ], [ 'id' => 96, 'name' => 'Indonesia', 'short_code' => 'id', ], [ 'id' => 97, 'name' => 'Iran', 'short_code' => 'ir', ], [ 'id' => 98, 'name' => 'Iraq', 'short_code' => 'iq', ], [ 'id' => 99, 'name' => 'Ireland', 'short_code' => 'ie', ], [ 'id' => 100, 'name' => 'Isle of Man', 'short_code' => 'im', ], [ 'id' => 101, 'name' => 'Israel', 'short_code' => 'il', ], [ 'id' => 102, 'name' => 'Italy', 'short_code' => 'it', ], [ 'id' => 103, 'name' => 'Ivory Coast', 'short_code' => 'ci', ], [ 'id' => 104, 'name' => 'Jamaica', 'short_code' => 'jm', ], [ 'id' => 105, 'name' => 'Japan', 'short_code' => 'jp', ], [ 'id' => 106, 'name' => 'Jersey', 'short_code' => 'je', ], [ 'id' => 107, 'name' => 'Jordan', 'short_code' => 'jo', ], [ 'id' => 108, 'name' => 'Kazakhstan', 'short_code' => 'kz', ], [ 'id' => 109, 'name' => 'Kenya', 'short_code' => 'ke', ], [ 'id' => 110, 'name' => 'Kiribati', 'short_code' => 'ki', ], [ 'id' => 111, 'name' => 'Kosovo', 'short_code' => 'xk', ], [ 'id' => 112, 'name' => 'Kuwait', 'short_code' => 'kw', ], [ 'id' => 113, 'name' => 'Kyrgyzstan', 'short_code' => 'kg', ], [ 'id' => 114, 'name' => 'Laos', 'short_code' => 'la', ], [ 'id' => 115, 'name' => 'Latvia', 'short_code' => 'lv', ], [ 'id' => 116, 'name' => 'Lebanon', 'short_code' => 'lb', ], [ 'id' => 117, 'name' => 'Lesotho', 'short_code' => 'ls', ], [ 'id' => 118, 'name' => 'Liberia', 'short_code' => 'lr', ], [ 'id' => 119, 'name' => 'Libya', 'short_code' => 'ly', ], [ 'id' => 120, 'name' => 'Liechtenstein', 'short_code' => 'li', ], [ 'id' => 121, 'name' => 'Lithuania', 'short_code' => 'lt', ], [ 'id' => 122, 'name' => 'Luxembourg', 'short_code' => 'lu', ], [ 'id' => 123, 'name' => 'Macau', 'short_code' => 'mo', ], [ 'id' => 124, 'name' => 'Macedonia', 'short_code' => 'mk', ], [ 'id' => 125, 'name' => 'Madagascar', 'short_code' => 'mg', ], [ 'id' => 126, 'name' => 'Malawi', 'short_code' => 'mw', ], [ 'id' => 127, 'name' => 'Malaysia', 'short_code' => 'my', ], [ 'id' => 128, 'name' => 'Maldives', 'short_code' => 'mv', ], [ 'id' => 129, 'name' => 'Mali', 'short_code' => 'ml', ], [ 'id' => 130, 'name' => 'Malta', 'short_code' => 'mt', ], [ 'id' => 131, 'name' => 'Marshall Islands', 'short_code' => 'mh', ], [ 'id' => 132, 'name' => 'Mauritania', 'short_code' => 'mr', ], [ 'id' => 133, 'name' => 'Mauritius', 'short_code' => 'mu', ], [ 'id' => 134, 'name' => 'Mayotte', 'short_code' => 'yt', ], [ 'id' => 135, 'name' => 'Mexico', 'short_code' => 'mx', ], [ 'id' => 136, 'name' => 'Micronesia', 'short_code' => 'fm', ], [ 'id' => 137, 'name' => 'Moldova', 'short_code' => 'md', ], [ 'id' => 138, 'name' => 'Monaco', 'short_code' => 'mc', ], [ 'id' => 139, 'name' => 'Mongolia', 'short_code' => 'mn', ], [ 'id' => 140, 'name' => 'Montenegro', 'short_code' => 'me', ], [ 'id' => 141, 'name' => 'Montserrat', 'short_code' => 'ms', ], [ 'id' => 142, 'name' => 'Morocco', 'short_code' => 'ma', ], [ 'id' => 143, 'name' => 'Mozambique', 'short_code' => 'mz', ], [ 'id' => 144, 'name' => 'Myanmar', 'short_code' => 'mm', ], [ 'id' => 145, 'name' => 'Namibia', 'short_code' => 'na', ], [ 'id' => 146, 'name' => 'Nauru', 'short_code' => 'nr', ], [ 'id' => 147, 'name' => 'Nepal', 'short_code' => 'np', ], [ 'id' => 148, 'name' => 'Netherlands', 'short_code' => 'nl', ], [ 'id' => 149, 'name' => 'Netherlands Antilles', 'short_code' => 'an', ], [ 'id' => 150, 'name' => 'New Caledonia', 'short_code' => 'nc', ], [ 'id' => 151, 'name' => 'New Zealand', 'short_code' => 'nz', ], [ 'id' => 152, 'name' => 'Nicaragua', 'short_code' => 'ni', ], [ 'id' => 153, 'name' => 'Niger', 'short_code' => 'ne', ], [ 'id' => 154, 'name' => 'Nigeria', 'short_code' => 'ng', ], [ 'id' => 155, 'name' => 'Niue', 'short_code' => 'nu', ], [ 'id' => 156, 'name' => 'North Korea', 'short_code' => 'kp', ], [ 'id' => 157, 'name' => 'Northern Mariana Islands', 'short_code' => 'mp', ], [ 'id' => 158, 'name' => 'Norway', 'short_code' => 'no', ], [ 'id' => 159, 'name' => 'Oman', 'short_code' => 'om', ], [ 'id' => 160, 'name' => 'Pakistan', 'short_code' => 'pk', ], [ 'id' => 161, 'name' => 'Palau', 'short_code' => 'pw', ], [ 'id' => 162, 'name' => 'Palestine', 'short_code' => 'ps', ], [ 'id' => 163, 'name' => 'Panama', 'short_code' => 'pa', ], [ 'id' => 164, 'name' => 'Papua New Guinea', 'short_code' => 'pg', ], [ 'id' => 165, 'name' => 'Paraguay', 'short_code' => 'py', ], [ 'id' => 166, 'name' => 'Peru', 'short_code' => 'pe', ], [ 'id' => 167, 'name' => 'Philippines', 'short_code' => 'ph', ], [ 'id' => 168, 'name' => 'Pitcairn', 'short_code' => 'pn', ], [ 'id' => 169, 'name' => 'Poland', 'short_code' => 'pl', ], [ 'id' => 170, 'name' => 'Portugal', 'short_code' => 'pt', ], [ 'id' => 171, 'name' => 'Puerto Rico', 'short_code' => 'pr', ], [ 'id' => 172, 'name' => 'Qatar', 'short_code' => 'qa', ], [ 'id' => 173, 'name' => 'Republic of the Congo', 'short_code' => 'cg', ], [ 'id' => 174, 'name' => 'Reunion', 'short_code' => 're', ], [ 'id' => 175, 'name' => 'Romania', 'short_code' => 'ro', ], [ 'id' => 176, 'name' => 'Russia', 'short_code' => 'ru', ], [ 'id' => 177, 'name' => 'Rwanda', 'short_code' => 'rw', ], [ 'id' => 178, 'name' => 'Saint Barthelemy', 'short_code' => 'bl', ], [ 'id' => 179, 'name' => 'Saint Helena', 'short_code' => 'sh', ], [ 'id' => 180, 'name' => 'Saint Kitts and Nevis', 'short_code' => 'kn', ], [ 'id' => 181, 'name' => 'Saint Lucia', 'short_code' => 'lc', ], [ 'id' => 182, 'name' => 'Saint Martin', 'short_code' => 'mf', ], [ 'id' => 183, 'name' => 'Saint Pierre and Miquelon', 'short_code' => 'pm', ], [ 'id' => 184, 'name' => 'Saint Vincent and the Grenadines', 'short_code' => 'vc', ], [ 'id' => 185, 'name' => 'Samoa', 'short_code' => 'ws', ], [ 'id' => 186, 'name' => 'San Marino', 'short_code' => 'sm', ], [ 'id' => 187, 'name' => 'Sao Tome and Principe', 'short_code' => 'st', ], [ 'id' => 188, 'name' => 'Saudi Arabia', 'short_code' => 'sa', ], [ 'id' => 189, 'name' => 'Senegal', 'short_code' => 'sn', ], [ 'id' => 190, 'name' => 'Serbia', 'short_code' => 'rs', ], [ 'id' => 191, 'name' => 'Seychelles', 'short_code' => 'sc', ], [ 'id' => 192, 'name' => 'Sierra Leone', 'short_code' => 'sl', ], [ 'id' => 193, 'name' => 'Singapore', 'short_code' => 'sg', ], [ 'id' => 194, 'name' => 'Sint Maarten', 'short_code' => 'sx', ], [ 'id' => 195, 'name' => 'Slovakia', 'short_code' => 'sk', ], [ 'id' => 196, 'name' => 'Slovenia', 'short_code' => 'si', ], [ 'id' => 197, 'name' => 'Solomon Islands', 'short_code' => 'sb', ], [ 'id' => 198, 'name' => 'Somalia', 'short_code' => 'so', ], [ 'id' => 199, 'name' => 'South Africa', 'short_code' => 'za', ], [ 'id' => 200, 'name' => 'South Korea', 'short_code' => 'kr', ], [ 'id' => 201, 'name' => 'South Sudan', 'short_code' => 'ss', ], [ 'id' => 202, 'name' => 'Spain', 'short_code' => 'es', ], [ 'id' => 203, 'name' => 'Sri Lanka', 'short_code' => 'lk', ], [ 'id' => 204, 'name' => 'Sudan', 'short_code' => 'sd', ], [ 'id' => 205, 'name' => 'Suriname', 'short_code' => 'sr', ], [ 'id' => 206, 'name' => 'Svalbard and Jan Mayen', 'short_code' => 'sj', ], [ 'id' => 207, 'name' => 'Swaziland', 'short_code' => 'sz', ], [ 'id' => 208, 'name' => 'Sweden', 'short_code' => 'se', ], [ 'id' => 209, 'name' => 'Switzerland', 'short_code' => 'ch', ], [ 'id' => 210, 'name' => 'Syria', 'short_code' => 'sy', ], [ 'id' => 211, 'name' => 'Taiwan', 'short_code' => 'tw', ], [ 'id' => 212, 'name' => 'Tajikistan', 'short_code' => 'tj', ], [ 'id' => 213, 'name' => 'Tanzania', 'short_code' => 'tz', ], [ 'id' => 214, 'name' => 'Thailand', 'short_code' => 'th', ], [ 'id' => 215, 'name' => 'Togo', 'short_code' => 'tg', ], [ 'id' => 216, 'name' => 'Tokelau', 'short_code' => 'tk', ], [ 'id' => 217, 'name' => 'Tonga', 'short_code' => 'to', ], [ 'id' => 218, 'name' => 'Trinidad and Tobago', 'short_code' => 'tt', ], [ 'id' => 219, 'name' => 'Tunisia', 'short_code' => 'tn', ], [ 'id' => 220, 'name' => 'Turkey', 'short_code' => 'tr', ], [ 'id' => 221, 'name' => 'Turkmenistan', 'short_code' => 'tm', ], [ 'id' => 222, 'name' => 'Turks and Caicos Islands', 'short_code' => 'tc', ], [ 'id' => 223, 'name' => 'Tuvalu', 'short_code' => 'tv', ], [ 'id' => 224, 'name' => 'U.S. Virgin Islands', 'short_code' => 'vi', ], [ 'id' => 225, 'name' => 'Uganda', 'short_code' => 'ug', ], [ 'id' => 226, 'name' => 'Ukraine', 'short_code' => 'ua', ], [ 'id' => 227, 'name' => 'United Arab Emirates', 'short_code' => 'ae', ], [ 'id' => 228, 'name' => 'United Kingdom', 'short_code' => 'gb', ], [ 'id' => 229, 'name' => 'United States', 'short_code' => 'us', ], [ 'id' => 230, 'name' => 'Uruguay', 'short_code' => 'uy', ], [ 'id' => 231, 'name' => 'Uzbekistan', 'short_code' => 'uz', ], [ 'id' => 232, 'name' => 'Vanuatu', 'short_code' => 'vu', ], [ 'id' => 233, 'name' => 'Vatican', 'short_code' => 'va', ], [ 'id' => 234, 'name' => 'Venezuela', 'short_code' => 've', ], [ 'id' => 235, 'name' => 'Vietnam', 'short_code' => 'vn', ], [ 'id' => 236, 'name' => 'Wallis and Futuna', 'short_code' => 'wf', ], [ 'id' => 237, 'name' => 'Western Sahara', 'short_code' => 'eh', ], [ 'id' => 238, 'name' => 'Yemen', 'short_code' => 'ye', ], [ 'id' => 239, 'name' => 'Zambia', 'short_code' => 'zm', ], [ 'id' => 240, 'name' => 'Zimbabwe', 'short_code' => 'zw', ], ]; Country::insert($countries); } } seeders/DatabaseSeeder.php 0000644 00000000546 15021223504 0011542 0 ustar 00 <?php namespace Database\Seeders; use Illuminate\Database\Seeder; class DatabaseSeeder extends Seeder { public function run() { $this->call([ PermissionsTableSeeder::class, UsersTableSeeder::class, CountriesTableSeeder::class, MaintenanceSchedulePermissionSeeder::class, ]); } } .gitignore 0000644 00000000012 15021223504 0006517 0 ustar 00 *.sqlite* .DS_Store 0000644 00000014004 15021223504 0006220 0 ustar 00 Bud1 i g n o r e . g i t i g n o r eIlocblob � .������ f a c t o r i e sIlocblob A .������ m i g r a t i o n sIlocblob � .������ m i g r a t i o n sbwspblob �bplist00� ]ShowStatusBar[ShowToolbar[ShowTabView_ContainerShowSidebar\WindowBounds[ShowSidebar _{{220, 88}, {960, 741}} #/;R_klmno� � m i g r a t i o n svSrnlong s e e d e r sIlocblob .������ s e e d e r sbwspblob �bplist00� ]ShowStatusBar[ShowToolbar[ShowTabView_ContainerShowSidebar\WindowBounds[ShowSidebar _{{220, 88}, {960, 741}} #/;R_klmno� � s e e d e r svSrnlong @ � @ � @ � @ E DSDB ` � @ � @ � @ factories/UserFactory.php 0000644 00000001730 15021223504 0011475 0 ustar 00 <?php namespace Database\Factories; use Illuminate\Database\Eloquent\Factories\Factory; use Illuminate\Support\Str; /** * @extends \Illuminate\Database\Eloquent\Factories\Factory<\App\Models\User> */ class UserFactory extends Factory { /** * Define the model's default state. * * @return array<string, mixed> */ public function definition(): array { return [ 'name' => fake()->name(), 'email' => fake()->unique()->safeEmail(), 'email_verified_at' => now(), 'password' => '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', // password 'remember_token' => Str::random(10), ]; } /** * Indicate that the model's email address should be unverified. * * @return $this */ public function unverified(): static { return $this->state(fn (array $attributes) => [ 'email_verified_at' => null, ]); } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.29 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка