/home/mip/mip/public/vendor/laravel-filemanager/files/folder-1/821668/client.tar
2016_05_20_010746_create_roles_table.php 0000664 00000004132 15243426152 0013177 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');
}
}
2017_08_23_011601_create_posts_category_table.php 0000664 00000001261 15243426152 0015116 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');
}
}
2018_04_17_141120_create_job_applied_table.php 0000664 00000001450 15243426152 0014321 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');
}
}
2017_08_17_005015_create_product_brand_table.php 0000664 00000001175 15243426152 0014710 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');
}
}
2017_09_13_101313_create_participants_table.php 0000664 00000001506 15243426152 0014554 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');
}
}
2017_08_17_004853_create_products_table.php 0000664 00000001602 15243426152 0013731 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');
}
}
2018_04_16_113317_create_contact_us_table.php 0000664 00000001754 15243426152 0014230 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');
}
}
2017_07_31_084448_create_principal_contact_persons.php 0000664 00000001473 15243426152 0016175 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');
}
}
2017_08_23_011705_create_posts_table.php 0000664 00000002366 15243426152 0013235 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');
}
}
2017_09_13_143949_create_participants_answers_table.php 0000664 00000001546 15243426152 0016347 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');
}
}
2018_04_17_110756_create_applicants_table.php 0000664 00000002107 15243426152 0014222 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');
}
}
2017_08_15_024339_create_provinces_table.php 0000664 00000001162 15243426152 0014076 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');
}
}
2017_08_15_024638_create_municipalities_table.php 0000664 00000001201 15243426152 0015101 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');
}
}
2017_10_04_170315_add_keyword_field_in_posts_table.php 0000664 00000001204 15243426152 0016100 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']);
});
}
}
2017_08_15_024512_create_cities_table.php 0000664 00000001151 15243426152 0013335 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');
}
}
2017_08_03_082621_create_survey_subjects.php 0000664 00000002132 15243426152 0014147 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');
}
}
2016_06_14_111620_create_principals_table.php 0000664 00000002035 15243426152 0014214 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');
}
} 2017_07_31_084801_create_principal_contact_person_numbers.php 0000664 00000001406 15243426152 0017532 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');
}
}
2017_12_07_095724_add_slug_to_job_opening_table.php 0000664 00000001233 15243426152 0015401 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']);
});
}
}
2017_08_15_010613_create_directories_table.php 0000664 00000001775 15243426152 0014402 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');
}
}
2017_12_01_091106_add_country_to_job_opening_table.php 0000664 00000001301 15243426152 0016106 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']);
});
}
}
2017_11_29_101804_create_job_opening_table.php 0000664 00000002074 15243426152 0014352 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');
}
}
2017_01_27_110940_create_assigned_users_principals_table.php 0000664 00000001252 15243426152 0017316 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');
}
}
2017_07_12_065054_create_survey_templates_table.php 0000664 00000001475 15243426152 0015503 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');
}
}
2017_08_15_024759_create_affiliates_table.php 0000664 00000001166 15243426152 0014207 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');
}
}
2017_07_13_070622_create_survey_answers_table.php 0000664 00000001404 15243426152 0015155 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');
}
}
2017_08_15_023814_create_locations_table.php 0000664 00000002441 15243426152 0014057 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');
}
}
2016_06_14_155701_create_countries_table.php 0000664 00000064510 15243426152 0014101 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');
}
}
2017_08_15_024843_create_specializations_table.php 0000664 00000001204 15243426152 0015264 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');
}
}
2017_07_13_060233_create_survey_questions_table.php 0000664 00000001715 15243426152 0015527 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');
}
}
2017_08_17_005104_create_product_categories_table.php 0000664 00000001214 15243426152 0015740 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');
}
}
2018_04_10_152021_add_location_to_job_opening_table.php 0000664 00000001250 15243426152 0016212 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']);
});
}
}
2017_09_06_001933_add_sub_module_to_users_logs_table.php 0000664 00000001237 15243426152 0016457 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');
});
}
}
2017_10_10_144933_add_pageviews_field_in_posts_table.php 0000664 00000001267 15243426152 0016423 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']);
});
}
}
2016_05_20_010852_create_role_permissions_table.php 0000664 00000002316 15243426152 0015447 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');
}
}
2016_06_14_111620_create_login_logs_table.php 0000664 00000001365 15243426152 0014211 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');
}
}
2018_04_11_153027_create_faq_table.php 0000664 00000001443 15243426152 0012625 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');
}
}
2017_08_30_073310_change_expired_at_to_posts_table.php 0000664 00000001313 15243426152 0016112 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');
});
}
}
2017_08_31_012059_create_user_logs_table.php 0000664 00000001456 15243426152 0014070 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');
}
}
2018_04_12_142025_create_about_us_table.php 0000664 00000001461 15243426152 0013674 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');
}
}
