/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('information', function (Blueprint $table) {
$table->increments('id');
//ID
$table->string('name');
//İSİM
$table->string('slug');
//SLUG
$table->text('content');
//AÇIKLAMA
$table->integer('tabs_id');
//KATEGORİ ID
$table->integer('sort_order');
//SIRA
$table->integer('status');
//DURUMU
$table->integer('viewed');
//GORUNTULENME SAYISI
$table->text('meta_title');
//META BAŞLIK
$table->text('meta_description');
//META AÇIKLAMA
$table->text('meta_keywords');
//META A.KELİMELER
$table->softDeletes();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('email')->unique();
$table->string('header');
$table->string('intro');
$table->string('password');
$table->integer('sex');
$table->string('profession');
$table->string('birthday');
$table->string('skill_tags');
$table->string('tool_tags');
$table->string('city');
$table->string('tel');
$table->string('education');
$table->string('workexps');
$table->string('works');
$table->string('job');
$table->string('website');
$table->integer('score');
$table->rememberToken();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('corporation_killmail_detail', function (Blueprint $table) {
$table->increments('id');
$table->integer('killID');
$table->integer('solarSystemID');
$table->dateTime('killTime');
$table->integer('moonID');
// Victim Information
$table->integer('characterID');
$table->string('characterName');
$table->integer('corporationID');
$table->string('corporationName');
$table->integer('allianceID')->nullable();
$table->string('allianceName')->nullable();
$table->integer('factionID')->nullable();
$table->string('factionName')->nullable();
$table->integer('damageTaken');
$table->integer('shipTypeID');
// Indexes
$table->index('killID');
$table->index('characterID');
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('fields', function (Blueprint $table) {
$table->increments('id');
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('position', function (Blueprint $table) {
$table->increments('position_id');
$table->string('postion_name');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('user_zone', function ($table) {
$table->string('user_id');
$table->integer('zone_id');
});
}
public function up()
{
Schema::create('steam_games', function (Blueprint $table) {
$table->integer('id')->primary()->unsigned();
$table->string('name')->nullable();
$table->integer('playtime_forever')->default('0');
$table->integer('playtime_2weeks')->default('0');
$table->boolean('has_community_visible_stats')->default(0);
$table->string('image_icon_url')->nullable();
$table->string('image_logo_url')->nullable();
$table->string('Image_background')->nullable();
$table->string('image_header')->nullable();
$table->boolean('is_free')->default(0);
$table->string('about_the_game')->nullable();
$table->string('legal_notice')->nullable();
$table->string('website')->nullable();
$table->integer('meta_critic_score')->default('0');
$table->string('meta_critic_url')->nullable();
$table->string('screenshot_path_thumbnail')->nullable();
$table->string('screenshot_path_full')->nullable();
$table->string('movie_thumbnail')->nullable();
$table->string('movie_full_url')->nullable();
$table->string('movie_name')->nullable();
$table->timestamp('schema_updated_at')->nullable();
$table->timestamp('player_stats_updated_at')->nullable();
$table->timestamp('game_updated_at')->nullable();
$table->timestamp('description_updated_at')->nullable();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('layers', function (Blueprint $table) {
$table->increments('id');
$table->integer('order')->default(100);
$table->string('name');
$table->integer('map_id')->unsigned();
$table->integer('source_id')->unsigned();
$table->integer('minzoom')->default(1);
$table->integer('maxzoom')->default(22);
$table->boolean('interactive')->default(false);
$table->string('type');
$table->boolean('visible')->default(true);
$table->integer('opacity')->default(10);
$table->string('color');
$table->string('outline-color');
$table->integer('width');
$table->integer('gap-width');
$table->string('dasharray');
$table->integer('radius');
$table->integer('blur');
$table->string('choropleth-source');
$table->integer('clusters');
$table->string('schema-color');
$table->boolean('schema-reverse')->default(false);
$table->integer('cluster-maxzoom')->default(15);
$table->integer('cluster-radius')->default(20);
$table->timestamps();
$table->foreign('map_id')->references('id')->on('maps')->onDelete('cascade');
$table->foreign('source_id')->references('id')->on('sources')->onDelete('cascade');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('txn_sales_order_deal', function (Blueprint $table) {
$table->integer('so_detail_deal_id');
$table->string('reference_num', 50)->index();
$table->string('deal_code', 90)->index();
$table->string('deal_description', 100)->index();
$table->string('item_code', 20)->index();
$table->string('uom_code', 20)->index();
$table->integer('deal_order_qty');
$table->integer('deal_served_qty');
$table->integer('regular_order_qty');
$table->integer('regular_served_qty');
$table->string('trade_item_code', 20)->index();
$table->string('trade_item_uom', 20)->index();
$table->integer('trade_order_qty');
$table->integer('trade_served_qty');
$table->decimal('vat_order_amount');
$table->decimal('vat_served_amount');
$table->decimal('gross_order_amount');
$table->decimal('gross_served_amount');
$table->string('remarks', 160)->nullable();
$table->string('status', 2);
$table->string('modified_by', 50)->index();
$table->dateTime('modified_date')->nullable();
$table->dateTime('sfa_modified_date')->nullable();
$table->dateTime('updated_at')->nullable();
$table->integer('updated_by')->index()->default('0');
$table->primary('so_detail_deal_id');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('unit_types', function (Blueprint $table) {
$table->increments('id');
$table->integer('project_id')->unsigned();
$table->string('name');
$table->integer('building_area');
$table->integer('land_area');
$table->bigInteger('base_price');
$table->bigInteger('added_facility_price');
$table->bigInteger('added_area_price');
$table->string('front_picture');
$table->string('left_picture');
$table->string('right_picture');
$table->string('top_picture');
$table->string('back_picture');
$table->string('brochure_picture');
//$table->integer('user_id')->unsigned();
$table->integer('created_by');
$table->integer('changed_by');
$table->string('change_reason');
$table->softDeletes();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('contact_user', function (Blueprint $table) {
$table->bigInteger('user_id');
$table->bigInteger('contact_id');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('firstName')->nullable();
$table->string('lastName')->nullable();
$table->string('username');
$table->string('cne')->unique()->nullable();
$table->string('cin')->unique()->nullable();
$table->string('email')->unique();
$table->string('level')->nullable();
$table->string('about')->nullable();
$table->string('photo')->default('noavatar.jpg');
$table->string('gender')->nullable();
$table->date('birthdate')->nullable();
$table->string('notify_email')->default(0);
$table->string('role');
$table->string('facebook')->nullable();
$table->string('linkedin')->nullable();
$table->string('twitter')->nullable();
$table->string('password', 60);
$table->string('confirmation_code')->nullable();
$table->string('confirmed')->default(0);
$table->rememberToken();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('enfermetats', function (Blueprint $table) {
$table->increments('id');
//id usuari
$table->string('nom')->unique();
//nom de l'especie
$table->boolean('cientific');
//indica si el nom que te es cientific o no
$table->string('simptomes');
//simptomes de l'enfermetat
$table->string('descripcio');
//descripcio de l'enfermetat
$table->json('imatges');
//imatges de l'enfermetat
$table->date('enfermetat_inici');
//inici epcoca enfermetat
$table->date('enfermetat_fi');
//fi epoca enfermetat
$table->boolean('ministeri');
//censat pel ministeri
$table->integer('patogen_id')->unsigned();
//classe d'agent patogen que crea l'enfermetat
$table->foreign('patogen_id')->references('id')->on('patogens');
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('marriages', function (Blueprint $table) {
$table->bigIncrements('id');
$table->integer('parish_id')->index()->unsigned();
$table->foreign('parish_id')->references('id')->on('parishes')->onDelete('cascade')->onUpdate('cascade');
$table->date('date_of_marriage');
$table->string('name_of_bride', 64);
$table->string('status_of_bride', 16)->nullable();
$table->string('age_of_bride', 4)->nullable();
$table->string('origin_of_bride', 64)->nullable();
$table->string('residence_of_bride', 128)->nullable();
$table->string('father_of_bride', 64)->nullable();
$table->string('mother_of_bride', 64)->nullable();
$table->string('name_of_groom', 64);
$table->string('status_of_groom', 16)->nullable();
$table->string('age_of_groom', 4)->nullable();
$table->string('origin_of_groom', 64)->nullable();
$table->string('residence_of_groom', 128)->nullable();
$table->string('father_of_groom', 64)->nullable();
$table->string('mother_of_groom', 64)->nullable();
$table->string('minister', 64);
$table->string('witnesses', 256)->nullable();
$table->string('remarks', 256)->nullable();
$table->string('book_no', 4);
$table->string('page_no', 4);
$table->string('line_no', 4);
$table->string('document', 128)->nullable();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('qualification_training_ojt', function ($table) {
//Training/Workshop
$table->increments('id');
$table->integer('emp_id');
$table->string('category');
//training
$table->string('type_of_training');
$table->string('training_course');
$table->string('subject');
//ojt
$table->string('training_task');
//workshop
$table->string('topic');
$table->string('major_area');
$table->string('instructor');
$table->string('institute');
$table->string('location');
$table->string('proof');
$table->string('pdf');
$table->string('certification');
$table->string('duration');
$table->string('verify', 10);
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('cursos', function (Blueprint $table) {
$table->increments('id');
$table->timestamps();
$table->string('nombre');
$table->integer('user_id')->unsigned();
$table->integer('tipo_id')->unsigned();
$table->integer('area_id')->unsigned();
$table->integer('modalidad_id')->unsigned();
$table->string('letra_referencia')->unique();
$table->integer('horas_total')->unsigned();
$table->text('objetivo')->nullable();
$table->text('dirijio_a')->nullable();
$table->text('requisitos')->nullable();
$table->text('perfil_ingreso')->nullable();
$table->text('temario')->nullable();
$table->text('introduccion')->nullable();
$table->text('conocimientos')->nullable();
$table->boolean('mostrar_web')->default(1);
$table->text('mas_info')->nullable();
$table->string('imagen_url')->nullable();
$table->string('banner_url')->nullable();
$table->string('video_url')->nullable();
$table->softDeletes();
$table->foreign('user_id')->references('id')->on('users');
//quien lo creó
$table->foreign('tipo_id')->references('id')->on('curso_tipos');
//curso, taller..
$table->foreign('area_id')->references('id')->on('curso_areas');
//ingenieria, informatica.
$table->foreign('modalidad_id')->references('id')->on('modalidades');
//presencial, distancia
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('event_tag', function (Blueprint $table) {
$table->integer('event_id')->unsigned()->references('id')->on('events');
$table->integer('tag_id')->unsigned()->references('id')->on('tags');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('loanfinancials', function (Blueprint $table) {
$table->increments('id');
$table->integer('loan_id');
$table->double('amount_requested')->nullable();
$table->double('collateral_equipment')->default(0);
$table->double('collateral_realestate')->default(0);
$table->double('collateral_other')->default(0);
$table->boolean('fee_onTotal')->default(true);
$table->boolean('dist_buyDown')->default(false);
$table->double('int_percent_arm')->default(0);
$table->double('int_percent_arm_default')->default(0);
$table->double('int_percent_arm_orig')->default(0);
$table->double('int_percent_dist')->default(0);
$table->double('int_percent_dist_default')->default(0);
$table->double('int_percent_dist_orig')->default(0);
$table->double('int_percent_other')->default(0);
$table->double('int_percent_other_default')->default(0);
$table->double('int_percent_other_orig')->default(0);
$table->double('fee_processing')->default(0);
$table->double('fee_service')->default(0);
$table->double('fee_service_dist')->default(0);
$table->double('max_loan')->default(0);
$table->double('max_rate')->default(0);
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('buy_orders', function (Blueprint $table) {
$table->increments('id');
$table->integer('company_id');
$table->string('buy_number', 12);
$table->string('invoice_number', 20);
$table->string('invoice_type', 3);
$table->integer('vendor_id');
$table->float('total_qty');
$table->decimal('total_amount');
$table->float('tax_percent');
$table->decimal('tax_amount');
$table->decimal('percent_amount')->nullable();
$table->decimal('discount_amount')->nullable();
$table->decimal('final_amount');
$table->dateTime('order_date');
$table->dateTime('invoice_date');
$table->dateTime('reciept_date');
$table->string('status');
$table->integer('site_id');
$table->string('payment_type');
$table->decimal('payment_ammount');
$table->integer('promotion_id')->nullable();
$table->timestamps();
$table->integer('created_by');
$table->integer('updated_by');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('restaurants', function (Blueprint $table) {
$table->increments('id');
$table->string('name')->unique();
$table->text('description');
$table->string('address');
$table->integer('phone')->unsigned();
$table->decimal('latitude', 10, 8);
$table->decimal('longitude', 11, 8);
$table->string('img_url_1')->nullable();
$table->string('img_url_2')->nullable();
$table->string('img_url_3')->nullable();
$table->string('img_url_4')->nullable();
$table->string('img_url_5')->nullable();
$table->string('website')->nullable();
$table->string('facebook_page')->nullable();
$table->string('twitter_account')->nullable();
$table->string('instagram_account')->nullable();
$table->string('email')->nullable();
$table->integer('user_id')->unsigned();
$table->integer('price_id')->unsigned();
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('customers', function (Blueprint $table) {
$table->increments('id');
$table->integer('provinceid')->unsigned();
$table->foreign('provinceid')->references('id')->on('provinces');
$table->boolean('isreal')->default(false);
$table->integer('statusexpect')->comment('0:ไม่มีการติดตาม, 1:กำลังติดตามอยู่, 2:ยกเลิก - ไปซื้อดีลเลอร์อื่น, 3:ยกเลิก - ไปซื้อยี่ห้ออื่น,
4:ยกเลิก - เปลี่ยนใจไม่ซื้อแล้ว, 5:ยกเลิก - ติดต่อไม่ได้');
$table->string('title', 10);
$table->string('firstname', 50);
$table->string('lastname', 50)->nullable();
$table->string('phone1', 20);
$table->string('phone2', 20)->nullable();
$table->integer('occupationid')->unsigned()->nullable();
$table->foreign('occupationid')->references('id')->on('occupations');
$table->dateTime('birthdate')->nullable();
$table->text('address')->nullable();
$table->integer('districtid')->unsigned()->nullable();
$table->foreign('districtid')->references('id')->on('districts');
$table->integer('amphurid')->unsigned()->nullable();
$table->foreign('amphurid')->references('id')->on('amphurs');
$table->integer('addprovinceid')->unsigned()->nullable();
$table->foreign('addprovinceid')->references('id')->on('provinces');
$table->string('zipcode', 5)->nullable();
$table->integer('createdby')->unsigned();
$table->foreign('createdby')->references('id')->on('employees');
$table->dateTime('createddate');
$table->integer('modifiedby')->unsigned();
$table->foreign('modifiedby')->references('id')->on('employees');
$table->dateTime('modifieddate');
$table->engine = 'InnoDB';
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('alumni', function (Blueprint $t) {
$t->increments('id');
$t->string('year_of_graduation')->nullable();
$t->string('national_id')->nullable();
$t->string('student_id')->nullable();
$t->string('title')->nullable();
$t->string('firstname')->nullable();
$t->string('lastname')->nullable();
$t->date('birthdate')->nullable();
$t->string('gpa')->nullable();
$t->string('house_no')->nullable();
$t->string('moo')->nullable();
$t->string('soi')->nullable();
$t->string('road')->nullable();
$t->string('district')->nullable();
$t->string('amphur')->nullable();
$t->string('province')->nullable();
$t->string('phone')->nullable();
$t->string('zipcode')->nullable();
$t->string('email')->nullable();
$t->string('education')->nullable();
$t->string('faculty')->nullable();
$t->string('branch')->nullable();
$t->string('course')->nullable();
$t->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('Job', function (Blueprint $table) {
$table->integer('Id')->primary();
$table->string('JobTitle');
$table->integer('ContactId');
$table->date('StartDate');
$table->date('DueDate');
$table->string('JobNotes');
$table->integer('ProductId');
$table->string('JobStatus');
$table->dateTime('DateCreated');
$table->dateTime('LastUpdated');
$table->integer('JobRecurringId');
$table->string('OrderType');
$table->integer('OrderStatus');
$table->string('ShipFirstName');
$table->string('ShipMiddleName');
$table->string('ShipLastName');
$table->string('ShipCompany');
$table->string('ShipPhone');
$table->string('ShipStreet1');
$table->string('ShipStreet2');
$table->string('ShipCity');
$table->string('ShipState');
$table->string('ShipZip');
$table->string('ShipCountry');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('universities', function (Blueprint $table) {
$table->string('university_code')->primary();
$table->string('name', 50);
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('deductions', function (Blueprint $table) {
$table->increments('id');
$table->string('dedtype');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('alumni', function (Blueprint $table) {
$table->increments('id');
$table->string('lastname');
$table->string('firstname');
$table->string('midname');
$table->integer('gender');
$table->integer('civil_stat');
$table->date('birthdate');
$table->string('address')->nullable();
$table->string('email')->nullable();
$table->char('tel_no', 15)->nullable();
$table->char('mobile_no', 15)->nullable();
$table->string('pic_path')->nullable();
$table->integer('region_id')->unsigned();
$table->foreign('region_id')->references('id')->on('regions');
$table->integer('province_id')->unsigned();
$table->foreign('province_id')->references('id')->on('provinces');
$table->boolean('is_id_released')->default(0);
$table->boolean('is_confirmed')->default(0);
$table->integer('course_id')->unsigned();
$table->foreign('course_id')->references('id')->on('course');
$table->char('year_graduated', 4);
$table->integer('account_id')->unsigned()->nullable();
$table->foreign('account_id')->references('id')->on('accounts');
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('activity_logs', function (Blueprint $table) {
$table->increments('id');
$table->integer(Config::get('activity-log-saas::key'));
$table->integer('user_id');
$table->integer('content_id');
$table->string('content_type', 72);
$table->string('action', 32);
$table->string('description');
$table->text('details');
$table->boolean('developer');
$table->string('ip_address', 64);
$table->string('user_agent');
$table->timestamps();
});
Schema::table('activity_logs', function ($table) {
// We'll need to ensure that MySQL uses the InnoDB engine to
// support the indexes, other engines aren't affected.
$table->engine = 'InnoDB';
// Useful for filters
$table->index('user_id');
$table->index('content_id');
$table->index('content_type');
$table->index('action');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('cuentas_bancarias', function (Blueprint $table) {
$table->increments('id');
$table->smallInteger('cuenta_bancaria')->unsigned()->unique();
$table->string('d_cuenta');
$table->string('no_cuenta');
$table->string('banco');
$table->string('tipo', 50);
$table->boolean('activa');
$table->integer('urg_id')->unsigned();
$table->foreign('urg_id')->references('id')->on('urgs');
$table->timestamps();
});
//Relación entre Cuentas Bancarias y Proyectos para FEXT
Schema::create('cuenta_bancaria_proyecto', function (Blueprint $table) {
$table->increments('id');
$table->integer('cuenta_bancaria_id')->unsigned();
$table->foreign('cuenta_bancaria_id')->references('id')->on('cuentas_bancarias');
$table->integer('proyecto_id')->unsigned();
$table->foreign('proyecto_id')->references('id')->on('proyectos');
});
Schema::create('cuentas', function (Blueprint $table) {
$table->increments('id');
$table->string('cuenta', 100);
$table->string('tipo', 20);
});
Schema::create('egresos', function (Blueprint $table) {
$table->increments('id');
$table->integer('cuenta_bancaria_id')->unsigned();
$table->foreign('cuenta_bancaria_id')->references('id')->on('cuentas_bancarias');
$table->integer('poliza')->unsigned();
$table->integer('cheque')->unsigned();
$table->date('fecha');
$table->integer('benef_id')->unsigned();
$table->foreign('benef_id')->references('id')->on('benefs');
$table->integer('cuenta_id')->unsigned();
$table->foreign('cuenta_id')->references('id')->on('cuentas');
$table->string('concepto');
$table->decimal('monto', 15, 3);
$table->string('estatus', 30);
$table->integer('user_id')->unsigned();
$table->date('fecha_cobro');
$table->timestamps();
$table->softDeletes();
});
Schema::create('ingresos', function (Blueprint $table) {
$table->increments('id');
$table->integer('cuenta_bancaria_id')->unsigned();
$table->foreign('cuenta_bancaria_id')->references('id')->on('cuentas_bancarias');
$table->integer('poliza')->unsigned();
$table->date('fecha');
$table->integer('cuenta_id')->unsigned();
$table->foreign('cuenta_id')->references('id')->on('cuentas');
$table->string('concepto');
$table->decimal('monto', 15, 3);
$table->timestamps();
$table->softDeletes();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('product_tag', function (Blueprint $table) {
$table->integer('product_id')->foreign('product_id')->references('id')->on('products');
$table->integer('tag_id')->foreign('tag_id')->references('id')->on('tags');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('address_province', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('name', 30);
});
}