/home/mip/mip/public/vendor/laravel-filemanager/files/folder-1/821668/migrations.zip
PK r@]�o�Z Z / client/2016_05_20_010746_create_roles_table.phpnu �Iw�� <?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');
}
}
PK r@]��ڋ� � 8 client/2017_08_23_011601_create_posts_category_table.phpnu �Iw�� <?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');
}
}
PK r@]�oE}( ( 5 client/2018_04_17_141120_create_job_applied_table.phpnu �Iw�� <?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');
}
}
PK r@]nV�!} } 7 client/2017_08_17_005015_create_product_brand_table.phpnu �Iw�� <?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');
}
}
PK r@]�d��F F 6 client/2017_09_13_101313_create_participants_table.phpnu �Iw�� <?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');
}
}
PK r@]M �� � 2 client/2017_08_17_004853_create_products_table.phpnu �Iw�� <?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');
}
}
PK r@]��G� � 4 client/2018_04_16_113317_create_contact_us_table.phpnu �Iw�� <?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');
}
}
PK r@]�T�C; ; = client/2017_07_31_084448_create_principal_contact_persons.phpnu �Iw�� <?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');
}
}
PK r@]ṉ�� � / client/2017_08_23_011705_create_posts_table.phpnu �Iw�� <?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');
}
}
PK r@]o_�f f > client/2017_09_13_143949_create_participants_answers_table.phpnu �Iw�� <?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');
}
}
PK r@]��PG G 4 client/2018_04_17_110756_create_applicants_table.phpnu �Iw�� <?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');
}
}
PK r@]��k�r r 3 client/2017_08_15_024339_create_provinces_table.phpnu �Iw�� <?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');
}
}
PK r@]Վ�E� � 8 client/2017_08_15_024638_create_municipalities_table.phpnu �Iw�� <?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');
}
}
PK r@]��$ � � = client/2017_10_04_170315_add_keyword_field_in_posts_table.phpnu �Iw�� <?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']);
});
}
}
PK r@]�;�ui i 0 client/2017_08_15_024512_create_cities_table.phpnu �Iw�� <?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');
}
}
PK r@]
���Z Z 3 client/2017_08_03_082621_create_survey_subjects.phpnu �Iw�� <?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');
}
}
PK r@]&
lm 4 client/2016_06_14_111620_create_principals_table.phpnu �Iw�� <?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');
}
}PK r@]�;�n D client/2017_07_31_084801_create_principal_contact_person_numbers.phpnu �Iw�� <?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');
}
}
PK r@]��7� � : client/2017_12_07_095724_add_slug_to_job_opening_table.phpnu �Iw�� <?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']);
});
}
}
PK r@]@;�� � 5 client/2017_08_15_010613_create_directories_table.phpnu �Iw�� <?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');
}
}
PK r@]s��A� � = client/2017_12_01_091106_add_country_to_job_opening_table.phpnu �Iw�� <?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']);
});
}
}
PK r@]����< < 5 client/2017_11_29_101804_create_job_opening_table.phpnu �Iw�� <?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');
}
}
PK r@]�M��� � C client/2017_01_27_110940_create_assigned_users_principals_table.phpnu �Iw�� <?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');
}
}
PK r@]�ڵ�= = : client/2017_07_12_065054_create_survey_templates_table.phpnu �Iw�� <?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');
}
}
PK r@]^ �v v 4 client/2017_08_15_024759_create_affiliates_table.phpnu �Iw�� <?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');
}
}
PK r@]H0� 8 client/2017_07_13_070622_create_survey_answers_table.phpnu �Iw�� <?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');
}
}
PK r@]|�fO! ! 3 client/2017_08_15_023814_create_locations_table.phpnu �Iw�� <?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');
}
}
PK r@]>"�Hi Hi 3 client/2016_06_14_155701_create_countries_table.phpnu �Iw�� <?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');
}
}
PK r@] ��_� � 9 client/2017_08_15_024843_create_specializations_table.phpnu �Iw�� <?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');
}
}
PK r@]-�T�� � : client/2017_07_13_060233_create_survey_questions_table.phpnu �Iw�� <?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');
}
}
PK r@]3�A�� � < client/2017_08_17_005104_create_product_categories_table.phpnu �Iw�� <?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');
}
}
PK r@] &�g� � > client/2018_04_10_152021_add_location_to_job_opening_table.phpnu �Iw�� <?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']);
});
}
}
PK r@]�o�� � ? client/2017_09_06_001933_add_sub_module_to_users_logs_table.phpnu �Iw�� <?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');
});
}
}
PK r@]x0O�� � ? client/2017_10_10_144933_add_pageviews_field_in_posts_table.phpnu �Iw�� <?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']);
});
}
}
PK r@]* �f� � : client/2016_05_20_010852_create_role_permissions_table.phpnu �Iw�� <?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');
}
}
PK r@]��p�� � 4 client/2016_06_14_111620_create_login_logs_table.phpnu �Iw�� <?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');
}
}
PK r@]q��# # - client/2018_04_11_153027_create_faq_table.phpnu �Iw�� <?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');
}
}
PK r@]` d�� � = client/2017_08_30_073310_change_expired_at_to_posts_table.phpnu �Iw�� <?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');
});
}
}
PK r@]�g
�. . 3 client/2017_08_31_012059_create_user_logs_table.phpnu �Iw�� <?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');
}
}
PK r@]�ȇ�1 1 2 client/2018_04_12_142025_create_about_us_table.phpnu �Iw�� <?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');
}
}
PK r@]p�P�7 7 0 likod/2016_05_04_013101_create_modules_table.phpnu �Iw�� <?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');
}
}
PK r@]{ķ�k k 7 likod/2016_05_16_081403_create_client_modules_table.phpnu �Iw�� <?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');
}
}PK r@]Zu�T� � E likod/2017_08_24_060559_add_orderid_field_in_client_modules_table.phpnu �Iw�� <?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');
});
}
}
PK r@]
�ٵv v 5 likod/2016_05_17_081819_create_client_users_table.phpnu �Iw�� <?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');
}
}PK r@]� ��� � G likod/2017_08_25_032317_add_access_type_field_in_client_users_table.phpnu �Iw�� <?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');
});
}
}
PK r@]�{ �� � G likod/2017_08_24_075552_add_is_sub_user_field_in_client_users_table.phpnu �Iw�� <?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']);
});
}
}
PK r@]�.��� � G likod/2017_08_25_033454_add_access_view_field_in_client_users_table.phpnu �Iw�� <?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');
});
}
}
PK r@]Sh � � I likod/2017_08_25_033113_add_validity_date_field_in_client_users_table.phpnu �Iw�� <?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']);
});
}
}
PK r@]�kZT . likod/2014_10_12_000000_create_users_table.phpnu �Iw�� <?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');
}
}PK r@]�u u . likod/2016_02_19_033610_create_roles_table.phpnu �Iw�� <?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');
}
}PK r@] 㻜�
�
0 likod/2016_05_17_061117_create_clients_table.phpnu �Iw�� <?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');
}
}PK r@]���� � 9 likod/2016_02_19_032140_create_role_permissions_table.phpnu �Iw�� <?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');
}
}PK r@]*�B�$ $ 1 likod/2016_06_07_052531_create_sessions_table.phpnu �Iw�� <?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');
}
}
PK r@]�
}ޟ � 8 likod/2014_10_12_100000_create_password_resets_table.phpnu �Iw�� <?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');
}
}PK r@]�o�Z Z / client/2016_05_20_010746_create_roles_table.phpnu �Iw�� PK r@]��ڋ� � 8 � client/2017_08_23_011601_create_posts_category_table.phpnu �Iw�� PK r@]�oE}( ( 5 � client/2018_04_17_141120_create_job_applied_table.phpnu �Iw�� PK r@]nV�!} } 7 _ client/2017_08_17_005015_create_product_brand_table.phpnu �Iw�� PK r@]�d��F F 6 C client/2017_09_13_101313_create_participants_table.phpnu �Iw�� PK r@]M �� � 2 � client/2017_08_17_004853_create_products_table.phpnu �Iw�� PK r@]��G� � 4 � client/2018_04_16_113317_create_contact_us_table.phpnu �Iw�� PK r@]�T�C; ; = # client/2017_07_31_084448_create_principal_contact_persons.phpnu �Iw�� PK r@]ṉ�� � / �! client/2017_08_23_011705_create_posts_table.phpnu �Iw�� PK r@]o_�f f > ' client/2017_09_13_143949_create_participants_answers_table.phpnu �Iw�� PK r@]��PG G 4 �* client/2018_04_17_110756_create_applicants_table.phpnu �Iw�� PK r@]��k�r r 3 �/ client/2017_08_15_024339_create_provinces_table.phpnu �Iw�� PK r@]Վ�E� � 8 t2 client/2017_08_15_024638_create_municipalities_table.phpnu �Iw�� PK r@]��$ � � = ]5 client/2017_10_04_170315_add_keyword_field_in_posts_table.phpnu �Iw�� PK r@]�;�ui i 0 N8 client/2017_08_15_024512_create_cities_table.phpnu �Iw�� PK r@]
���Z Z 3 ; client/2017_08_03_082621_create_survey_subjects.phpnu �Iw�� PK r@]&
lm 4 �? client/2016_06_14_111620_create_principals_table.phpnu �Iw�� PK r@]�;�n D UD client/2017_07_31_084801_create_principal_contact_person_numbers.phpnu �Iw�� PK r@]��7� � : �G client/2017_12_07_095724_add_slug_to_job_opening_table.phpnu �Iw�� PK r@]@;�� � 5 �J client/2017_08_15_010613_create_directories_table.phpnu �Iw�� PK r@]s��A� � = 6O client/2017_12_01_091106_add_country_to_job_opening_table.phpnu �Iw�� PK r@]����< < 5 dR client/2017_11_29_101804_create_job_opening_table.phpnu �Iw�� PK r@]�M��� � C W client/2017_01_27_110940_create_assigned_users_principals_table.phpnu �Iw�� PK r@]�ڵ�= = : "Z client/2017_07_12_065054_create_survey_templates_table.phpnu �Iw�� PK r@]^ �v v 4 �] client/2017_08_15_024759_create_affiliates_table.phpnu �Iw�� PK r@]H0� 8 �` client/2017_07_13_070622_create_survey_answers_table.phpnu �Iw�� PK r@]|�fO! ! 3 d client/2017_08_15_023814_create_locations_table.phpnu �Iw�� PK r@]>"�Hi Hi 3 �i client/2016_06_14_155701_create_countries_table.phpnu �Iw�� PK r@] ��_� � 9 >� client/2017_08_15_024843_create_specializations_table.phpnu �Iw�� PK r@]-�T�� � : +� client/2017_07_13_060233_create_survey_questions_table.phpnu �Iw�� PK r@]3�A�� � < b� client/2017_08_17_005104_create_product_categories_table.phpnu �Iw�� PK r@] &�g� � > Z� client/2018_04_10_152021_add_location_to_job_opening_table.phpnu �Iw�� PK r@]�o�� � ? p� client/2017_09_06_001933_add_sub_module_to_users_logs_table.phpnu �Iw�� PK r@]x0O�� � ? ~� client/2017_10_10_144933_add_pageviews_field_in_posts_table.phpnu �Iw�� PK r@]* �f� � : �� client/2016_05_20_010852_create_role_permissions_table.phpnu �Iw�� PK r@]��p�� � 4 �� client/2016_06_14_111620_create_login_logs_table.phpnu �Iw�� PK r@]q��# # - 5� client/2018_04_11_153027_create_faq_table.phpnu �Iw�� PK r@]` d�� � = �� client/2017_08_30_073310_change_expired_at_to_posts_table.phpnu �Iw�� PK r@]�g
�. . 3 � client/2017_08_31_012059_create_user_logs_table.phpnu �Iw�� PK r@]�ȇ�1 1 2 ~� client/2018_04_12_142025_create_about_us_table.phpnu �Iw�� PK r@]p�P�7 7 0 � likod/2016_05_04_013101_create_modules_table.phpnu �Iw�� PK r@]{ķ�k k 7 � likod/2016_05_16_081403_create_client_modules_table.phpnu �Iw�� PK r@]Zu�T� � E z likod/2017_08_24_060559_add_orderid_field_in_client_modules_table.phpnu �Iw�� PK r@]
�ٵv v 5 � likod/2016_05_17_081819_create_client_users_table.phpnu �Iw�� PK r@]� ��� � G �% likod/2017_08_25_032317_add_access_type_field_in_client_users_table.phpnu �Iw�� PK r@]�{ �� � G �( likod/2017_08_24_075552_add_is_sub_user_field_in_client_users_table.phpnu �Iw�� PK r@]�.��� � G 7, likod/2017_08_25_033454_add_access_view_field_in_client_users_table.phpnu �Iw�� PK r@]Sh � � I �/ likod/2017_08_25_033113_add_validity_date_field_in_client_users_table.phpnu �Iw�� PK r@]�kZT . �2 likod/2014_10_12_000000_create_users_table.phpnu �Iw�� PK r@]�u u . C8 likod/2016_02_19_033610_create_roles_table.phpnu �Iw�� PK r@] 㻜�
�
0 = likod/2016_05_17_061117_create_clients_table.phpnu �Iw�� PK r@]���� � 9 oH likod/2016_02_19_032140_create_role_permissions_table.phpnu �Iw�� PK r@]*�B�$ $ 1 rM likod/2016_06_07_052531_create_sessions_table.phpnu �Iw�� PK r@]�
}ޟ � 8 �P likod/2014_10_12_100000_create_password_resets_table.phpnu �Iw�� PK 6 6 U �S
