/home/mip/mip/public/vendor/laravel-filemanager/files/folder-1/821668/likod.tar
2016_05_04_013101_create_modules_table.php 0000664 00000014067 15243426225 0013522 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateModulesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('modules', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('title', 100);
$table->string('link_type', 20)->default('Parent');
$table->integer('page_id')->unsigned()->index()->default('0');
$table->string('module_name', 50);
$table->string('module_description', 255);
$table->string('url', 255)->default('');
$table->string('uri', 255)->default('');
$table->string('icon', 50)->default('');
$table->integer('menu_group_id')->unsigned()->index();
$table->integer('position')->unsigned()->index()->default('0');
$table->string('target', 10)->default('');
$table->integer('parent_id')->unsigned()->index();
$table->tinyInteger('is_parent')->unsigned()->index();
$table->tinyInteger('has_parent')->unsigned()->index();
$table->enum('show_menu', ['0', '1'])->default('1');
$table->tinyInteger('has_read')->unsigned()->index();
$table->tinyInteger('has_create')->unsigned()->index();
$table->tinyInteger('has_update')->unsigned()->index();
$table->tinyInteger('has_delete')->unsigned()->index();
$table->tinyInteger('has_export')->unsigned()->index();
$table->tinyInteger('has_import')->unsigned()->index();
$table->tinyInteger('has_print')->unsigned()->index();
$table->timestamps();
});
DB::table('modules')->insert([
[
'id' => 1,
'title' => 'Settings',
'link_type' => 'Parent',
'module_name' => 'Settings',
'module_description' => 'Settings',
'url' => '#',
'icon' => 'cogs',
'menu_group_id' => 1,
'parent_id' => 0,
'is_parent' => 1,
'has_parent' => 0,
'show_menu' => 1,
'has_read' => 0,
'has_create' => 0,
'has_update' => 0,
'has_delete' => 0,
'has_export' => 0,
'has_import' => 0,
'has_print' => 0,
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id' => 2,
'title' => 'Role Manager',
'link_type' => 'Child',
'module_name' => 'Role Manager',
'module_description' => 'Role Manager',
'url' => 'settings/roles',
'icon' => 'ban',
'menu_group_id' => 1,
'parent_id' => 1,
'is_parent' => 0,
'has_parent' => 1,
'show_menu' => 1,
'has_read' => 1,
'has_create' => 1,
'has_update' => 1,
'has_delete' => 1,
'has_export' => 0,
'has_import' => 0,
'has_print' => 0,
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id' => 3,
'title' => 'User Manager',
'link_type' => 'Child',
'module_name' => 'User Manager',
'module_description' => 'User Manager',
'url' => 'settings/users',
'icon' => 'users',
'menu_group_id' => 1,
'parent_id' => 1,
'is_parent' => 0,
'has_parent' => 1,
'show_menu' => 1,
'has_read' => 1,
'has_create' => 1,
'has_update' => 1,
'has_delete' => 1,
'has_export' => 0,
'has_import' => 0,
'has_print' => 0,
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id' => 4,
'title' => 'Clients',
'link_type' => 'Parent',
'module_name' => 'Clients',
'module_description' => 'Clients',
'url' => '#',
'icon' => 'building',
'menu_group_id' => 1,
'parent_id' => 0,
'is_parent' => 1,
'has_parent' => 0,
'show_menu' => 1,
'has_read' => 0,
'has_create' => 0,
'has_update' => 0,
'has_delete' => 0,
'has_export' => 0,
'has_import' => 0,
'has_print' => 0,
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id' => 5,
'title' => 'Client Directories',
'link_type' => 'Child',
'module_name' => 'Client Directories',
'module_description' => 'Client Directories',
'url' => 'clients/client-directories',
'icon' => 'book',
'menu_group_id' => 1,
'parent_id' => 4,
'is_parent' => 0,
'has_parent' => 1,
'show_menu' => 1,
'has_read' => 1,
'has_create' => 1,
'has_update' => 1,
'has_delete' => 1,
'has_export' => 0,
'has_import' => 0,
'has_print' => 0,
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
]);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('modules');
}
}
2016_05_16_081403_create_client_modules_table.php 0000664 00000003553 15243426225 0015073 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateClientModulesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('client_modules', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('title', 100);
$table->string('link_type', 20)->default('Parent');
$table->integer('page_id')->unsigned()->index();
$table->string('module_name', 50);
$table->string('module_description', 255);
$table->string('url', 255);
$table->string('uri', 255);
$table->string('icon', 50);
$table->integer('menu_group_id')->unsigned()->index();
$table->integer('position')->unsigned()->index();
$table->string('target', 10);
$table->integer('parent_id')->unsigned()->index();
$table->tinyInteger('is_parent')->unsigned()->index();
$table->tinyInteger('has_parent')->unsigned()->index();
$table->enum('show_menu', ['0', '1'])->default('1');
$table->tinyInteger('has_read')->unsigned()->index();
$table->tinyInteger('has_create')->unsigned()->index();
$table->tinyInteger('has_update')->unsigned()->index();
$table->tinyInteger('has_delete')->unsigned()->index();
$table->tinyInteger('has_export')->unsigned()->index();
$table->tinyInteger('has_import')->unsigned()->index();
$table->tinyInteger('has_print')->unsigned()->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('client_modules');
}
} 2017_08_24_060559_add_orderid_field_in_client_modules_table.php 0000664 00000001304 15243426225 0017725 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddOrderidFieldInClientModulesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('client_modules', function (Blueprint $table) {
$table->integer('orderid')->index()->unsigned()->after('has_print');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('client_modules', function (Blueprint $table) {
$table->dropColumn('orderid');
});
}
}
2016_05_17_081819_create_client_users_table.php 0000664 00000002166 15243426225 0014577 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateClientUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('client_users', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->integer('client_id')->unsigned()->index();
$table->string('name', 100)->index();
$table->string('username', 50)->index();
$table->string('email', 50)->index();
$table->string('password')->index();
$table->smallInteger('type_id')->unsigned()->index();
$table->smallInteger('role_id')->unsigned()->index();
$table->smallInteger('status')->unsigned()->index();
$table->string('photo')->index();
$table->rememberToken();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('client_users');
}
} 2017_08_25_032317_add_access_type_field_in_client_users_table.php 0000664 00000001345 15243426225 0020265 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddAccessTypeFieldInClientUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('client_users', function (Blueprint $table) {
$table->enum('access_type', ['','Field Officer', 'Editor'])->index()->default('')->after('role_id');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('client_users', function (Blueprint $table) {
$table->dropColumn('access_type');
});
}
}
2017_08_24_075552_add_is_sub_user_field_in_client_users_table.php 0000664 00000001326 15243426225 0020313 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddIsSubUserFieldInClientUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('client_users', function (Blueprint $table) {
$table->enum('is_sub_user', ['Yes', 'No'])->default('No')->index()->after('status');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('client_users', function (Blueprint $table) {
$table->dropColumn(['is_sub_user']);
});
}
}
2017_08_25_033454_add_access_view_field_in_client_users_table.php 0000664 00000001340 15243426225 0020254 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddAccessViewFieldInClientUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('client_users', function (Blueprint $table) {
$table->enum('access_view', ['','Web', 'Mobile'])->index()->default('')->after('access_type');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('client_users', function (Blueprint $table) {
$table->dropColumn('access_view');
});
}
}
2017_08_25_033113_add_validity_date_field_in_client_users_table.php 0000664 00000001276 15243426225 0020603 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddValidityDateFieldInClientUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('client_users', function (Blueprint $table) {
$table->date('validity_date')->index()->after('photo');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('client_users', function (Blueprint $table) {
$table->dropColumn(['validity_date']);
});
}
}
2014_10_12_000000_create_users_table.php 0000664 00000002440 15243426225 0013166 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->integer('role_id')->unsigned()->index();
$table->string('name');
$table->string('display_name');
$table->string('email');
$table->string('password', 60);
$table->string('photo');
$table->rememberToken();
$table->timestamps();
});
DB::table('users')->insert([
[
'id'=> 1,
'role_id' => 1,
'name' => 'Support Team',
'display_name' => 'Support Team',
'email' => 'support@quantumx.com',
'password' => bcrypt('qx@dev'),
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
]);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('users');
}
} 2016_02_19_033610_create_roles_table.php 0000664 00000002165 15243426225 0013204 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateRolesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('roles', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('name');
$table->string('display_name');
$table->string('description');
$table->timestamps();
});
DB::table('roles')->truncate();
DB::table('role_permissions')->truncate();
DB::table('roles')->insert([
[
'id'=>1,
'name' => 'Administrator',
'display_name' => 'Administrator',
'description' => 'Administrator',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
]);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('roles');
}
} 2016_05_17_061117_create_clients_table.php 0000664 00000005371 15243426225 0013527 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateClientsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('clients', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('client_name');
$table->string('client_address');
$table->string('telephone_no', 150);
$table->string('email', 150);
$table->string('database_name')->index();
$table->string('database_host')->index();
$table->string('database_username')->index();
$table->string('database_password')->index();
$table->string('api_key')->index();
$table->string('api_secret')->index();
$table->integer('status')->unsigned()->index();
$table->integer('number_of_users')->unsigned()->index();
$table->integer('disk_size')->unsigned()->index();
$table->integer('date_picker_format')->unsigned()->index();
$table->integer('display_date_format')->unsigned()->index();
$table->integer('name_format')->unsigned()->index();
$table->integer('monthly_mail_quota')->unsigned()->index();
$table->string('root_dir')->index();
$table->string('mail_driver', 30)->index();
$table->string('mail_sender_address')->index();
$table->string('mail_sender_name')->index();
$table->string('mail_host')->index();
$table->string('mail_username')->index();
$table->string('mail_password')->index();
$table->integer('mail_port')->unsigned()->index();
$table->string('storage_type')->index();
$table->string('s3_key')->index();
$table->string('s3_secret')->index();
$table->string('s3_region')->index();
$table->string('s3_bucket_name')->index();
$table->string('cpanel_email')->index();
$table->string('cpanel_host')->index();
$table->string('cpanel_ip')->index();
$table->string('cpanel_port')->index();
$table->string('cpanel_account')->index();
$table->string('cpanel_password')->index();
$table->string('cpanel_domain')->index();
$table->string('cpanel_user_default_password')->index();
$table->string('cpanel_qouta')->index();
$table->string('cpanel_forwarder')->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('clients');
}
} 2016_02_19_032140_create_role_permissions_table.php 0000664 00000002232 15243426225 0015444 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateRolePermissionsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('role_permissions', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->integer('role_id')->unsigned()->index();
$table->integer('menu_id')->unsigned()->index();
$table->integer('can_access')->unsigned()->index();
$table->integer('can_create')->unsigned()->index();
$table->integer('can_update')->unsigned()->index();
$table->integer('can_delete')->unsigned()->index();
$table->integer('can_export')->unsigned()->index();
$table->integer('can_import')->unsigned()->index();
$table->integer('can_print')->unsigned()->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('role_permissions');
}
} 2016_06_07_052531_create_sessions_table.php 0000664 00000001444 15243426225 0013731 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateSessionsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('sessions', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->string('id')->unique();
$table->integer('user_id')->nullable();
$table->string('ip_address', 45)->nullable();
$table->text('user_agent')->nullable();
$table->text('payload');
$table->integer('last_activity');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('sessions');
}
}
2014_10_12_100000_create_password_resets_table.php 0000664 00000001237 15243426225 0015260 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePasswordResetsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('password_resets', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->string('email')->index();
$table->string('token')->index();
$table->timestamp('created_at');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('password_resets');
}
}
