PHP Method Schema::create, someline-starter Code Examples

This page contains top rated real world PHP examples of method Schema::create from package someline-starter extracted from open source projects. You can rate examples to help us improve the quality of examples
Frequently Used Methods

create() public static method

Create a new table on the schema.
public static create ( string $table, Closure $callback ) : Illuminate\Database\Schema\Blueprint
$table string
$callback Closure
return Illuminate\Database\Schema\Blueprint
Example #1
Show file File: 2014_10_12_000000_create_users_table.php Project: Panfen/mango
0
 /**
  * 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();
     });
 }
Example #2
Show file File: 2015_10_06_181923_create_fields_table.php Project: JJacobi13/jcAiBattle
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('fields', function (Blueprint $table) {
         $table->increments('id');
         $table->timestamps();
     });
 }
Example #3
Show file File: 2014_12_05_062934_CreateEveCorporationKillMailDetail.php Project: boweiliu/seat
0
 /**
  * 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();
     });
 }
Example #4
Show file File: 2014_09_18_114007_create_user_zone_table.php Project: atefth/remote_access_system
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('user_zone', function ($table) {
         $table->string('user_id');
         $table->integer('zone_id');
     });
 }
Example #5
Show file File: 2015_10_14_053843_create_position_table.php Project: AlbertLabarento/BRAMS-Project
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('position', function (Blueprint $table) {
         $table->increments('position_id');
         $table->string('postion_name');
     });
 }
Example #6
Show file File: 2016_03_27_183122_create_layers_table.php Project: jaumesala/opendata-maps
0
 /**
  * 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');
     });
 }
Example #7
Show file File: 2016_02_20_000113_create_steam_games_table.php Project: Bogstag/bogstag.se
0
 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();
     });
 }
Example #8
Show file File: 2015_07_18_080042_create_unit_types_table.php Project: syafdia/PAS
0
 /**
  * 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();
     });
 }
Example #9
Show file File: 2015_11_23_152432_txn_sales_order_deal.php Project: atudz/SFAReport
0
 /**
  * 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');
     });
 }
Example #10
Show file File: 2014_10_12_000000_create_users_table.php Project: otsaan/e-blog
0
 /**
  * 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();
     });
 }
Example #11
Show file File: 2015_05_28_120239_add_contacts_table.php Project: SenhorBardell/yol
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('contact_user', function (Blueprint $table) {
         $table->bigInteger('user_id');
         $table->bigInteger('contact_id');
     });
 }
Example #12
Show file File: 2015_07_04_162031_create_enfermetats_table.php Project: vi1004t/pfg
0
 /**
  * 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();
     });
 }
Example #13
Show file File: 2014_10_15_052422_create_marriages_table.php Project: rdrubis/books-of-register
0
 /**
  * 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();
     });
 }
Example #14
Show file File: 2015_02_11_193321_qualification_training_ojt.php Project: strangerAshik/AIMS
0
 /**
  * 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();
     });
 }
Example #15
Show file File: 2016_01_05_224454_create_information_table.php Project: ercancavusoglu/laravel-ecommerce
0
 /**
  * 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();
     });
 }
Example #16
Show file File: 2015_10_22_205716_create_cursos_table.php Project: antoniopacheco/CECINTRANET-API
0
 /**
  * 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
     });
 }
Example #17
Show file File: 2015_04_09_221229_create_event_tag_table.php Project: sethetter/wichitawesome
0
 /**
  * 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');
     });
 }
Example #18
Show file File: 2015_07_15_172953_create_loanfinancials_table.php Project: wyrover/lenda-api
0
 /**
  * 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();
     });
 }
Example #19
Show file File: 2015_03_21_10000_create_buy_orders_table.php Project: pvthanh38/dms
0
 /**
  * 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');
     });
 }
Example #20
Show file File: 2014_28_07_300000_create_restaurants_table.php Project: absis/EsmorzarsIBenzina
0
 /**
  * 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();
     });
 }
Example #21
Show file File: 2015_06_06_231113_create_customers_table.php Project: x-Zyte/nissanhippro
0
 /**
  * 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';
     });
 }
Example #22
Show file File: 2016_01_18_121819_create_alumni_table.php Project: pchaow/alumni-spss
0
 /**
  * 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();
     });
 }
Example #23
Show file File: 2013_12_24_195519_create_jobs_table.php Project: sairiz/larafuse
0
 /**
  * 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');
     });
 }
Example #24
Show file File: 2015_07_25_071745_create_universities_table.php Project: rohan1309/studyhere
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('universities', function (Blueprint $table) {
         $table->string('university_code')->primary();
         $table->string('name', 50);
     });
 }
Example #25
Show file File: 2016_01_19_165122_create_deductions_table.php Project: kithslither/payrollSystem
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('deductions', function (Blueprint $table) {
         $table->increments('id');
         $table->string('dedtype');
     });
 }
Example #26
Show file File: 2014_12_17_034012_create_alumni.php Project: patocjurel/capstone-project
0
 /**
  * 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();
     });
 }
Example #27
Show file File: 2014_01_01_000000_create_activity_log_table.php Project: mvpasarel/activity-log-saas
0
 /**
  * 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');
     });
 }
Example #28
Show file File: 2015_02_10_050358_crear_tablas_bancos.php Project: armandolazarte/guia
0
 /**
  * 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();
     });
 }
Example #29
Show file File: 2016_01_26_200545_ProductTag.php Project: houstonfernandes/curso_laravel
0
 /**
  * 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');
     });
 }
Example #30
Show file File: 2016_01_26_123049_create_provinces_table.php Project: xincap/erp
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('address_province', function (Blueprint $table) {
         $table->bigIncrements('id');
         $table->string('name', 30);
     });
 }