PHP Schema::create方法代码示例

 /**
  * 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();
     });
 }