/home/mip/mip/public/img/credit/datatables/database.tar
migrations/client/2016_05_20_010746_create_roles_table.php 0000664 00000004132 15123274004 0016623 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::connection('qxcms')->table('roles')->truncate();
DB::connection('client')->table('roles')->insert([
[
'id'=>1,
'name' => 'Developer',
'display_name' => 'Developer',
'description' => 'Developer',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id'=>2,
'name' => 'Admistrator',
'display_name' => 'Admistrator',
'description' => 'Admistrator',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id'=>3,
'name' => 'Editor',
'display_name' => 'Editor',
'description' => 'Editor',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id'=>4,
'name' => 'Field Officer',
'display_name' => 'Field Officer',
'description' => 'Field Officer',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
]
]);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('roles');
}
}
migrations/client/2017_08_23_011601_create_posts_category_table.php 0000664 00000001261 15123274004 0020542 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePostsCategoryTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('posts_category', function (Blueprint $table) {
$table->mediumIncrements('id');
$table->string('name', 30);
$table->string('slug', 30);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('posts_category');
}
}
migrations/client/2018_04_17_141120_create_job_applied_table.php 0000664 00000001450 15123274004 0017745 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateJobAppliedTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('job_applied', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->integer('applicant_id')->unsigned()->index();
$table->integer('job_id')->unsigned()->index();
$table->date('apply_date');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_applied');
}
}
migrations/client/2017_08_17_005015_create_product_brand_table.php 0000664 00000001175 15123274004 0020334 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateProductBrandTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('product_brand', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('product_brand');
}
}
migrations/client/2017_09_13_101313_create_participants_table.php 0000664 00000001506 15123274004 0020200 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateParticipantsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('survey_participants', function (Blueprint $table) {
$table->increments('id');
$table->integer('template_id')->unsigned()->index();
$table->string('email');
$table->string('name');
$table->string('loc_lat');
$table->string('loc_long');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('survey_participants');
}
}
migrations/client/2017_08_17_004853_create_products_table.php 0000664 00000001602 15123274004 0017355 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateProductsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('products', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->integer('price');
$table->integer('category_id');
$table->integer('brand_id');
$table->string('year');
$table->longText('details');
$table->string('image');
$table->string('status');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('products');
}
}
migrations/client/2018_04_16_113317_create_contact_us_table.php 0000664 00000001754 15123274004 0017654 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateContactUsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('contact_us', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('name');
$table->string('email');
$table->string('contact');
$table->string('building_name');
$table->string('building_floor');
$table->string('rec_number');
$table->string('rec_street');
$table->string('rec_city');
$table->string('status');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('contact_us');
}
}
migrations/client/2017_07_31_084448_create_principal_contact_persons.php 0000664 00000001473 15123274004 0021621 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePrincipalContactPersons extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('principal_contact_persons', function (Blueprint $table) {
$table->increments('id');
$table->integer('principal_id')->unsigned()->index();
$table->string('name')->index();
$table->string('email');
$table->string('position');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('principal_contact_persons');
}
}
migrations/client/2017_08_23_011705_create_posts_table.php 0000664 00000002366 15123274004 0016661 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('posts', function (Blueprint $table) {
$table->increments('id');
$table->mediumInteger('author_id')->unsigned();
$table->mediumInteger('posts_category_id')->unsigned()->nullable();
$table->string('title');
$table->longText('content');
$table->string('featured_image');
$table->text('excerpt');
$table->string('slug');
$table->enum('status', ['Publish', 'Draft', 'Inactive']);
$table->enum('visibility', ['Public', 'Private']);
$table->enum('post_type', ['Post', 'Page']);
$table->integer('post_parent_id')->nullable()->unsigned();
$table->date('published_at');
$table->date('expired_at')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('posts');
}
}
migrations/client/2017_09_13_143949_create_participants_answers_table.php 0000664 00000001546 15123274004 0021773 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateParticipantsAnswersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('participants_answers', function (Blueprint $table) {
$table->increments('id');
$table->integer('participant_id')->unsigned()->index();
$table->integer('question_id')->unsigned()->index();
$table->integer('answer_id')->unsigned()->index();
$table->string('answer');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('participants_answers_table');
}
}
migrations/client/2018_04_17_110756_create_applicants_table.php 0000664 00000002107 15123274004 0017646 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateApplicantsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('applicants', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('first_name');
$table->string('middle_name');
$table->string('last_name');
$table->string('mobile_number');
$table->string('email');
$table->string('school');
$table->string('college_degree');
$table->string('company');
$table->string('position');
$table->string('yrs_exp');
$table->string('work_location');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('applicants');
}
}
migrations/client/2017_08_15_024339_create_provinces_table.php 0000664 00000001162 15123274004 0017522 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateProvincesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('provinces', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('provinces');
}
}
migrations/client/2017_08_15_024638_create_municipalities_table.php 0000664 00000001201 15123274004 0020525 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateMunicipalitiesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('municipalities', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('municipalities');
}
}
migrations/client/2017_10_04_170315_add_keyword_field_in_posts_table.php 0000664 00000001204 15123274004 0021524 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddKeywordFieldInPostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('posts', function (Blueprint $table) {
$table->string('keywords');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('posts', function (Blueprint $table) {
$table->dropColumn(['keywords']);
});
}
}
migrations/client/2017_08_15_024512_create_cities_table.php 0000664 00000001151 15123274004 0016761 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateCitiesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('cities', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('cities');
}
}
migrations/client/2017_08_03_082621_create_survey_subjects.php 0000664 00000002132 15123274004 0017573 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateSurveySubjects extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('survey_subjects', function (Blueprint $table) {
$table->increments('id');
$table->text('name');
$table->integer('principal_id')->unsigned()->index();
$table->integer('template_id')->unsigned()->index();
$table->integer('field_officer_assigned')->unsigned()->index();
$table->integer('editor_assigned')->unsigned()->index();
$table->date('interview_date')->index();
$table->date('completion_date')->index();
$table->enum('status', array('Open', 'Close'))->default('Open')->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('survey_subjects');
}
}
migrations/client/2016_06_14_111620_create_principals_table.php 0000664 00000002035 15123274004 0017640 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePrincipalsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('principals', function (Blueprint $table) {
$table->engine = "MYISAM";
$table->increments('id');
$table->integer('client_id')->unsigned()->index();
$table->string('name')->index();
$table->string('address');
$table->string('contact_details');
$table->enum('status', ['Active','Inactive'])->index()->default('Active');
$table->string('email');
$table->string('password');
$table->string('real_password')->index();
$table->rememberToken();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('principals');
}
} migrations/client/2017_07_31_084801_create_principal_contact_person_numbers.php 0000664 00000001406 15123274004 0023156 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePrincipalContactPersonNumbers extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('principal_contact_persons_numbers', function (Blueprint $table) {
$table->increments('id');
$table->integer('principal_contact_id')->unsigned()->index();
$table->string('contact');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('principal_contact_persons_numbers');
}
}
migrations/client/2017_12_07_095724_add_slug_to_job_opening_table.php 0000664 00000001233 15123274004 0021025 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddSlugToJobOpeningTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('job_opening', function (Blueprint $table) {
$table->string('slug')->after('job_details');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('job_opening', function (Blueprint $table) {
$table->dropColumn(['slug']);
});
}
}
migrations/client/2017_08_15_010613_create_directories_table.php 0000664 00000001775 15123274004 0020026 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateDirectoriesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('directories', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('lat');
$table->string('lng');
$table->string('tel_no');
$table->string('address_number');
$table->string('street');
$table->string('barangay');
$table->string('city');
$table->string('province');
$table->string('zip_code');
$table->longText('details');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('directories');
}
}
migrations/client/2017_12_01_091106_add_country_to_job_opening_table.php 0000664 00000001301 15123274004 0021532 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddCountryToJobOpeningTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('job_opening', function (Blueprint $table) {
$table->integer('country_id')->unsigned()->index()->after('closing_date');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('job_opening', function (Blueprint $table) {
$table->dropColumn(['country_id']);
});
}
}
migrations/client/2017_11_29_101804_create_job_opening_table.php 0000664 00000002074 15123274004 0017776 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateJobOpeningTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('job_opening', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('position');
$table->integer('no_position');
$table->string('proposed_salary');
$table->string('gender');
$table->integer('min_age');
$table->integer('max_age');
$table->date('opening_date');
$table->date('closing_date');
$table->enum('status', ['Open', 'Close', 'Draft']);
$table->longText('job_details');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_opening');
}
}
migrations/client/2017_01_27_110940_create_assigned_users_principals_table.php 0000664 00000001252 15123274004 0022742 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateAssignedUsersPrincipalsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('assigned_users_principals', function (Blueprint $table) {
$table->increments('id');
$table->integer('principal_id');
$table->integer('user_id');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('assigned_users_principals');
}
}
migrations/client/2017_07_12_065054_create_survey_templates_table.php 0000664 00000001475 15123274004 0021127 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateSurveyTemplatesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('survey_templates', function (Blueprint $table) {
$table->increments('id');
$table->integer('user_id')->index()->unsigned();
$table->string('title');
$table->text('description');
$table->enum('status', ['Open', 'Close'])->default('Open');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('survey_templates');
}
}
migrations/client/2017_08_15_024759_create_affiliates_table.php 0000664 00000001166 15123274004 0017633 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateAffiliatesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('affiliates', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('affiliates');
}
}
migrations/client/2017_07_13_070622_create_survey_answers_table.php 0000664 00000001404 15123274004 0020601 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateSurveyAnswersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('survey_answers', function (Blueprint $table) {
$table->increments('id');
$table->integer('question_id')->unsigned()->index();
$table->string('name');
$table->integer('order')->unsigned()->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('survey_answers');
}
}
migrations/client/2017_08_15_023814_create_locations_table.php 0000664 00000002441 15123274004 0017503 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateLocationsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('locations', function (Blueprint $table) {
$table->increments('id');
$table->string('category');
$table->integer('affiliate_id')->nullable();
$table->integer('specialization_id')->nullable();
$table->string('name');
$table->string('lat');
$table->string('lng');
$table->string('tel_no');
$table->string('email')->nullable();
$table->string('address_number');
$table->string('street');
$table->string('barangay');
$table->string('city_id')->nullable();
$table->integer('municipality_id')->nullable();
$table->string('province_id')->nullable();
$table->string('zip_code');
$table->longText('details');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('locations');
}
}
migrations/client/2016_06_14_155701_create_countries_table.php 0000664 00000064510 15123274004 0017525 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateCountriesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('countries', function (Blueprint $table) {
$table->engine = "MYISAM";
$table->increments('id');
$table->string('name');
$table->string('code');
$table->integer('orden_number')->index()->unsigned();
$table->timestamps();
});
DB::unprepared("
Truncate countries;
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (4, 'PHILIPPINES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (6, 'LIBERIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (7, 'PANAMA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (8, 'MALTA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (13, 'NORWAY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (12, 'MONACO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (14, 'UNITED KINGDOM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (15, 'SINGAPORE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (16, 'JAPAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (17, 'BAHAMAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (18, 'HONGKONG', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (19, 'KUWAIT', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (20, 'QATAR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (21, 'NIGERIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (22, 'ANTIGUA & BARBUDA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (23, 'MARSHALL ISLANDS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (24, 'CYPRUS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (25, 'ITALY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (26, 'DAMMAM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (27, 'SAUDI ARABIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (28, 'TAIWAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (29, 'UNITED ARAB EMIRATES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (30, 'UASC', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (31, 'NETHERLANDS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (32, 'CHINA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (33, 'INDONESIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (34, 'BELGIUM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (35, 'GERMANY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (36, 'DUBAI', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (37, 'DOMINICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (38, 'LIMASSOL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (100, 'CROATIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (40, 'MAJURO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (41, 'SOUTH KOREA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (42, 'FRANCE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (99, 'ESTONIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (44, 'TURKEY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (45, 'HONDURAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (46, 'INDIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (47, 'MOROCCO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (48, 'U.S.A.', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (49, 'TUNISIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (50, 'BANGLADESH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (98, 'RUSSIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (51, 'UKRAINE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (52, 'AUSTRALIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (53, 'GREECE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (54, 'ISRAEL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (55, 'BRAZIL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (56, 'SWITZERLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (57, 'TANZANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (58, 'EGYPT', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (59, 'CAYMAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (60, 'SOUTH AFRICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (61, 'VANUATU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (62, 'LONDON', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (63, 'GIBRALTAR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (64, 'DENMARK', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (65, 'BERMUDA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (66, 'SAINT KITTS & NEVIS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (67, 'GUINEA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (68, 'THAILAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (69, 'CANADA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (70, 'MANILA, PHILIPPINES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (71, 'GRAN CANARIAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (72, 'SPAIN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (73, 'JORDAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (74, 'URUGUAY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (75, 'VENEZUELA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (76, 'ROMANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (77, 'KENYA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (78, 'PERU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (79, 'CHILE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (80, 'PORTUGAL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (81, 'CAPE VERDE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (82, 'DOMINICAN REPUBLIC', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (83, 'SAINT VINCENT AND THE GRENADINES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (84, 'SRI LANKA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (85, 'MALAYSIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (86, 'VIETNAM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (87, 'PAKISTAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (88, 'MEXICO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (89, 'BELFAST', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (101, 'ENGLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (91, 'IVORY COAST', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (92, 'BAHRAIN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (93, 'ICELAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (94, 'LITHUANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (95, 'SWEDEN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (96, 'OMAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (97, 'SERBIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (102, 'FLORIDA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (103, 'BARBADOS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (104, 'TUVALU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (105, 'CALIFORNIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (106, 'FEDERAL STATES OF MICRONESIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (107, 'MONROVIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (108, 'NASSAU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (109, 'PAPUA NEW GUINEA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (110, 'CAMBODIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (111, 'IRELAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (112, 'LEBANON', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (113, 'SYRIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (114, 'ARGENTINA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (115, 'ECUADOR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (116, 'CAMEROON', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (117, 'ALGERIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (118, 'SIERRA LEONE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (119, 'SOLOMON ISLANDS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (120, 'BELIZE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (121, 'ST. JOHN\'S', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (122, 'COSTA RICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (123, 'JAMAICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (124, 'GEORGIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (125, 'NEW ZEALAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (126, 'VIRGINIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (127, 'CURACAO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (128, 'LATVIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (129, 'MADAGASCAR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (130, 'GIORGIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (131, 'MAURITANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (132, 'YEMEN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (133, 'FINLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (134, 'NAURU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (135, 'LIBYA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (136, 'SEYCHELLES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (137, 'GHANA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (138, 'MAURITIUS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (139, 'MAN OF ISLE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (140, 'LUXEMBOURG', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (141, 'ISLE OF MAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (142, 'TOGO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (143, 'VALLETA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (144, 'MANILA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (145, 'TOKYO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (146, 'JEDDAH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (147, 'CEBU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (148, 'COOK ISLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (149, 'CAYMAN ISLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (150, 'DANISH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (151, 'KINGSTOWN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (152, 'BATANGAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (153, 'SHARJAH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (154, 'PIRAEUS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
");
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('countries');
}
}
migrations/client/2017_08_15_024843_create_specializations_table.php 0000664 00000001204 15123274004 0020710 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateSpecializationsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('specializations', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('specializations');
}
}
migrations/client/2017_07_13_060233_create_survey_questions_table.php 0000664 00000001715 15123274004 0021153 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateSurveyQuestionsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('survey_questions', function (Blueprint $table) {
$table->increments('id');
$table->integer('template_id')->index()->unsigned();
$table->text('title');
$table->boolean('required')->nullable();
$table->boolean('multiple_select')->nullable();
$table->enum('question_type', array('1', '2'))->index()->default('1');
$table->integer('order')->unsigned()->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('survey_questions');
}
}
migrations/client/2017_08_17_005104_create_product_categories_table.php 0000664 00000001214 15123274004 0021364 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateProductCategoriesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('product_categories', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('product_categories');
}
}
migrations/client/2018_04_10_152021_add_location_to_job_opening_table.php 0000664 00000001250 15123274004 0021636 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddLocationToJobOpeningTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('job_opening', function (Blueprint $table) {
$table->string('location')->after('closing_date');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('job_opening', function (Blueprint $table) {
$table->dropColumn(['location']);
});
}
}
migrations/client/2017_09_06_001933_add_sub_module_to_users_logs_table.php 0000664 00000001237 15123274004 0022103 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddSubModuleToUsersLogsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users_logs', function (Blueprint $table) {
$table->string('sub_menu')->after('data_id');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users_logs', function (Blueprint $table) {
$table->dropColumn('sub_menu');
});
}
}
migrations/client/2017_10_10_144933_add_pageviews_field_in_posts_table.php 0000664 00000001267 15123274004 0022047 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddPageviewsFieldInPostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('posts', function (Blueprint $table) {
$table->integer('pageviews')->unsigned()->index()->after('post_parent_id');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('posts', function (Blueprint $table) {
$table->dropColumn(['pageviews']);
});
}
}
migrations/client/2016_05_20_010852_create_role_permissions_table.php 0000664 00000002316 15123274004 0021073 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();
});
DB::table('role_permissions')->truncate();
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('role_permissions');
}
}
migrations/client/2016_06_14_111620_create_login_logs_table.php 0000664 00000001365 15123274004 0017635 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateLoginLogsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('login_logs', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('name')->default('');
$table->string('username')->default('')->index();
$table->string('ipaddress')->default('');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('login_logs');
}
}
migrations/client/2018_04_11_153027_create_faq_table.php 0000664 00000001443 15123274004 0016251 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateFaqTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('faq', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('title');
$table->longText('content');
$table->enum('status', ['Publish', 'Draft', 'Inactive']);
$table->string('slug');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('faq');
}
}
migrations/client/2017_08_30_073310_change_expired_at_to_posts_table.php 0000664 00000001313 15123274004 0021536 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class ChangeExpiredAtToPostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('posts', function (Blueprint $table) {
DB::statement("ALTER TABLE posts MODIFY expired_at DATE NOT NULL");
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('posts', function (Blueprint $table) {
DB::statement('ALTER TABLE posts MODIFY expired_at DATE NULL');
});
}
}
migrations/client/2017_08_31_012059_create_user_logs_table.php 0000664 00000001456 15123274004 0017514 0 ustar 00 <?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateUserLogsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users_logs', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('action');
$table->integer('module_id')->unsigned()->index();
$table->integer('user_id')->unsigned()->index();
$table->integer('data_id')->unsigned()->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('users_logs');
}
}
migrations/client/2018_04_12_142025_create_about_us_table.php 0000664 00000001461 15123274004 0017320 0 ustar 00 <?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateAboutUsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('about_us', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('title');
$table->longText('content');
$table->enum('status', ['Publish', 'Draft', 'Inactive']);
$table->string('slug');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('about_us');
}
}
migrations/likod/2016_05_04_013101_create_modules_table.php 0000664 00000014067 15123274004 0016771 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');
}
}
migrations/likod/2016_05_16_081403_create_client_modules_table.php 0000664 00000003553 15123274004 0020342 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');
}
} migrations/likod/2017_08_24_060559_add_orderid_field_in_client_modules_table.php 0000664 00000001304 15123274004 0023174 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');
});
}
}
migrations/likod/2016_05_17_081819_create_client_users_table.php 0000664 00000002166 15123274004 0020046 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');
}
} migrations/likod/2017_08_25_032317_add_access_type_field_in_client_users_table.php 0000664 00000001345 15123274004 0023534 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');
});
}
}
migrations/likod/2017_08_24_075552_add_is_sub_user_field_in_client_users_table.php 0000664 00000001326 15123274004 0023562 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']);
});
}
}
migrations/likod/2017_08_25_033454_add_access_view_field_in_client_users_table.php 0000664 00000001340 15123274004 0023523 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');
});
}
}
migrations/likod/2017_08_25_033113_add_validity_date_field_in_client_users_table.php 0000664 00000001276 15123274004 0024052 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']);
});
}
}
migrations/likod/2014_10_12_000000_create_users_table.php 0000664 00000002440 15123274004 0016435 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');
}
} migrations/likod/2016_02_19_033610_create_roles_table.php 0000664 00000002165 15123274004 0016453 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');
}
} migrations/likod/2016_05_17_061117_create_clients_table.php 0000664 00000005371 15123274004 0016776 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');
}
} migrations/likod/2016_02_19_032140_create_role_permissions_table.php 0000664 00000002232 15123274004 0020713 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');
}
} migrations/likod/2016_06_07_052531_create_sessions_table.php 0000664 00000001444 15123274004 0017200 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');
}
}
migrations/likod/2014_10_12_100000_create_password_resets_table.php 0000664 00000001237 15123274004 0020527 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');
}
} factories/ModelFactory.php 0000664 00000001373 15123274004 0011630 0 ustar 00 <?php
/*
|--------------------------------------------------------------------------
| Model Factories
|--------------------------------------------------------------------------
|
| Here you may define all of your model factories. Model factories give
| you a convenient way to create models for testing and seeding your
| database. Just tell the factory how a default model should look.
|
*/
/** @var \Illuminate\Database\Eloquent\Factory $factory */
$factory->define(QxCMS\User::class, function (Faker\Generator $faker) {
static $password;
return [
'name' => $faker->name,
'email' => $faker->unique()->safeEmail,
'password' => $password ?: $password = bcrypt('secret'),
'remember_token' => str_random(10),
];
});
.gitignore 0000664 00000000011 15123274004 0006524 0 ustar 00 *.sqlite
seeds/RoleTableSeeder.php 0000664 00000003347 15123274004 0011370 0 ustar 00 <?php
use Illuminate\Database\Seeder;
use Illuminate\Database\Eloquent\Model;
class RoleTableSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::connection('client')->table('roles')->truncate();
DB::connection('client')->table('roles')->insert([
[
'id'=>1,
'name' => 'Developer',
'display_name' => 'Developer',
'description' => 'Developer',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id'=>2,
'name' => 'Admistrator',
'display_name' => 'Admistrator',
'description' => 'Admistrator',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id'=>3,
'name' => 'Editor',
'display_name' => 'Editor',
'description' => 'Editor',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
],
[
'id'=>4,
'name' => 'Field Officer',
'display_name' => 'Field Officer',
'description' => 'Field Officer',
'created_at' => new \Carbon\Carbon,
'updated_at' => new \Carbon\Carbon
]
]);
$this->command->info('roles table seeded!');
Model::reguard();
}
}
seeds/DatabaseSeeder.php 0000664 00000000363 15123274004 0011216 0 ustar 00 <?php
use Illuminate\Database\Seeder;
class DatabaseSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$this->call(ClientModulesTableSeeder::class);
}
}
seeds/ClientModulesTableSeeder.php 0000664 00000031464 15123274004 0013237 0 ustar 00 <?php
use Illuminate\Database\Seeder;
use Illuminate\Database\Eloquent\Model;
class ClientModulesTableSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
/*
Two Level Only
menu_group_id: always "1"
target: always "#"
parent_id: "0" if parent menu else it is child then define its parent id
is_parent: "1" if parent menu, "0" if child menu
has_parent: "0" no parent menu, "1" has parent menu
show_menu: "1" to show/active, "1" hide/inactive
has_read: always "0"
has_create: "0" if parent menu, "1" if child menu then analyze if has create function else define it "0"
has_update: "0" if parent menu, "1" if child menu then analyze if has update function else define it "0"
has_delete: "0" if parent menu, "1" if child menu then analyze if has delete function else define it "0"
has_export: "0" if parent menu, "1" if child menu then analyze if has export function else define it "0"
has_import: "0" if parent menu, "1" if child menu then analyze if has import function else define it "0"
has_print: "0" if parent menu, "1" if child menu then analyze if has print function else define it "0"
created_at: always "new \Carbon\Carbon"
updated_at: always "new \Carbon\Carbon"
*/
Model::unguard();
DB::connection('qxcms')->table('client_modules')->truncate();
DB::connection('qxcms')->table('client_modules')->insert([
//Setting
['id'=>1, 'orderid' => 1, 'title'=>'Administration', 'link_type'=>'Parent', 'module_name'=>'Administration', 'module_description'=>'Administration', 'url'=>'#', 'icon'=>'cog', 'menu_group_id'=>'1', 'target'=>'#', '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],
//Setting -> Role manager
['id'=>2, 'orderid' => 2, 'title'=>'Role Manager', 'link_type'=>'Child', 'module_name'=>'Role Manager', 'module_description'=>'Role Manager', 'url'=>'settings/roles', 'icon'=>'angle-double-right', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'1', 'is_parent'=>'0', 'has_parent'=>'1', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Setting -> User manager
['id'=>3, 'orderid' => 3, 'title'=>'User Manager', 'link_type'=>'Child', 'module_name'=>'User Manager', 'module_description'=>'List of CMS User\'s', 'url'=>'settings/users', 'icon'=>'angle-double-right', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'1', 'is_parent'=>'0', 'has_parent'=>'1', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Principal
// ['id'=>4, 'orderid' => 4, 'title'=>'Client', 'link_type'=>'Parent', 'module_name'=>'Client', 'module_description'=>'Client', 'url'=>'principals', 'icon'=>'user-o', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Questionnaire
// ['id'=>5, 'orderid' => 9, 'title'=>'Questionnaire', 'link_type'=>'Parent', 'module_name'=>'Questionnaire', 'module_description'=>'A list of previously created questionnaire template.', 'url'=>'questionnaire', 'icon'=>'question-circle-o ', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', 'has_create'=>'1', 'has_update'=>'1', 'has_delete'=>'1', 'has_export'=>'1', 'has_import'=>'0', 'has_print'=>'0', 'created_at'=> new \Carbon\Carbon, 'updated_at'=> new \Carbon\Carbon],
//Subject
// ['id'=>6, 'orderid' => 10, 'title'=>'Subjects', 'link_type'=>'Parent', 'module_name'=>'Subject', 'module_description'=>'List of subjects', 'url'=>'subject', 'icon'=>'newspaper-o ', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Directories-Stores
['id'=>7, 'orderid' => 4, 'title'=>'Directories and Stores', 'link_type'=>'Parent', 'module_name'=>'Directory/Store', 'module_description'=>'List of directory and stores', 'url'=>'directory-store', 'icon'=>'map-marker ', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Products
['id'=>8, 'orderid' => 7, 'title'=>'Products', 'link_type'=>'Parent', 'module_name'=>'Product', 'module_description'=>'List of products', 'url'=>'products', 'icon'=>'product-hunt ', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Posts
['id'=>9, 'orderid' => 6, 'title'=>'Posts', 'link_type'=>'Parent', 'module_name'=>'Post', 'module_description'=>'List of Posts', 'url'=>'posts', 'icon'=>'list-alt ', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Field Officer
// ['id'=>10, 'orderid' => 8, 'title'=>'Field Officer / Editor', 'link_type'=>'Parent', 'module_name'=>'Field Officer / Editor', 'module_description'=>'List of Field Officers & Editors', 'url'=>'officers', 'icon'=>'users', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Pages
['id'=>12, 'orderid' => 5, 'title'=>'Pages', 'link_type'=>'Parent', 'module_name'=>'Page', 'module_description'=>'List of Pages', 'url'=>'pages', 'icon'=>'book ', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Job Openings
['id'=>14, 'orderid' => 8, 'title'=>'Job Openings', 'link_type'=>'Parent', 'module_name'=>'Job Opening', 'module_description'=>'List of Job Openings.', 'url'=>'job-opening', 'icon'=>'newspaper-o ', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'0', 'is_parent'=>'1', 'has_parent'=>'0', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Pages - Parent
['id'=>15, 'orderid' => 14, 'title'=>'Pages', 'link_type'=>'Parent', 'module_name'=>'Pages', 'module_description'=>'Pages', 'url'=>'#', 'icon'=>'book', 'menu_group_id'=>'1', 'target'=>'#', '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],
//Pages -> About Us
['id'=>16, 'orderid' => 15, 'title'=>'About Us', 'link_type'=>'Child', 'module_name'=>'About Us', 'module_description'=>'Informations about the company.', 'url'=>'pages/about-us', 'icon'=>'info-circle', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'15', 'is_parent'=>'0', 'has_parent'=>'1', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Pages -> FAQ
['id'=>17, 'orderid' => 16, 'title'=>'FAQ', 'link_type'=>'Child', 'module_name'=>'FAQ', 'module_description'=>'Frequently Asked Questions.', 'url'=>'pages/faq', 'icon'=>'question-circle', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'15', 'is_parent'=>'0', 'has_parent'=>'1', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Pages -> Contact Us
['id'=>18, 'orderid' => 17, 'title'=>'Contact Us', 'link_type'=>'Child', 'module_name'=>'Contact Us', 'module_description'=>'Contact Informations.', 'url'=>'pages/contact-us', 'icon'=>'phone-square', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'15', 'is_parent'=>'0', 'has_parent'=>'1', 'show_menu'=>'1', 'has_read'=>'0', '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],
//Applicants - Parent
['id'=>19, 'orderid' => 11, 'title'=>'Applicants', 'link_type'=>'Parent', 'module_name'=>'Applicant', 'module_description'=>'List of open job opening with no. of applicants.', 'url'=>'#', 'icon'=>'users', 'menu_group_id'=>'1', 'target'=>'#', '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'=>'1', 'has_import'=>'0', 'has_print'=>'0', 'created_at'=> new \Carbon\Carbon, 'updated_at'=> new \Carbon\Carbon],
//Applicants -> Search Applicant
['id'=>20, 'orderid' => 12, 'title'=>'Search Applicant', 'link_type'=>'Child', 'module_name'=>'Search Applicant', 'module_description'=>'Search Applicant', 'url'=>'applicants/search', 'icon'=>'search', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'19', 'is_parent'=>'0', 'has_parent'=>'1', '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],
//Applicants -> Source Applicant
['id'=>21, 'orderid' => 13, 'title'=>'Source Applicant', 'link_type'=>'Child', 'module_name'=>'Source Applicant', 'module_description'=>'Source Applicant', 'url'=>'applicants/source', 'icon'=>'street-view', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'19', 'is_parent'=>'0', 'has_parent'=>'1', 'show_menu'=>'1', 'has_read'=>'0', 'has_create'=>'0', 'has_update'=>'0', 'has_delete'=>'0', 'has_export'=>'1', 'has_import'=>'0', 'has_print'=>'0', 'created_at'=> new \Carbon\Carbon, 'updated_at'=> new \Carbon\Carbon],
//Reports
['id'=>11, 'orderid' => 18, 'title'=>'Reports', 'link_type'=>'Parent', 'module_name'=>'Reports', 'module_description'=>'Reports', 'url'=>'#', 'icon'=>'file-text-o', 'menu_group_id'=>'1', 'target'=>'#', '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],
//Reports -> Audit Trail Report
['id'=>13, 'orderid' => 19, 'title'=>'Audit Trail Report', 'link_type'=>'Child', 'module_name'=>'Audit Trail Report', 'module_description'=>'Audit Trail Report', 'url'=>'reports/audittrail', 'icon'=>'file', 'menu_group_id'=>'1', 'target'=>'', 'parent_id'=>'11', 'is_parent'=>'0', 'has_parent'=>'1', 'show_menu'=>'1', 'has_read'=>'0', 'has_create'=>'1', 'has_update'=>'1', 'has_delete'=>'1', 'has_export'=>'1', 'has_import'=>'0', 'has_print'=>'0', 'created_at'=> new \Carbon\Carbon, 'updated_at'=> new \Carbon\Carbon],
]);
$this->command->info('Client Modules table seeded!');
Model::reguard();
}
}
