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

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

hasTable() public static method

Determine if the given table exists.
public static hasTable ( string $table ) : boolean
$table string
return boolean
Example #1
Show file File: 2014_01_12_142343_create_insurance_table.php Project: carlosqueiroz/nosh-core
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('insurance')) {
         Schema::create('insurance', function ($table) {
             $table->increments('insurance_id');
             $table->bigInteger('pid')->nullable();
             $table->bigInteger('address_id')->nullable();
             $table->string('insurance_plan_name', 255)->nullable();
             $table->string('insurance_order', 255)->nullable();
             $table->string('insurance_id_num', 255)->nullable();
             $table->string('insurance_group', 255)->nullable();
             $table->string('insurance_relationship', 255)->nullable();
             $table->string('insurance_copay', 255)->nullable();
             $table->string('insurance_deductible', 255)->nullable();
             $table->longtext('insurance_comments')->nullable();
             $table->string('insurance_plan_active', 255)->nullable();
             $table->string('insurance_insu_firstname', 255)->nullable();
             $table->string('insurance_insu_lastname', 255)->nullable();
             $table->string('insurance_insu_address', 255)->nullable();
             $table->string('insurance_insu_city', 255)->nullable();
             $table->string('insurance_insu_state', 255)->nullable();
             $table->string('insurance_insu_zip', 255)->nullable();
             $table->string('insurance_insu_phone', 255)->nullable();
             $table->dateTime('insurance_insu_dob')->nullable();
             $table->string('insurance_insu_gender', 255)->nullable();
         });
     }
 }
Example #2
Show file File: 2014_01_01_100110_create_seo_table.php Project: Grapheme/amway
0
 public function up()
 {
     if (!Schema::hasTable($this->table)) {
         Schema::create($this->table, function (Blueprint $table) {
             $table->increments('id');
             $table->string('module', 32)->nullable()->index();
             $table->integer('unit_id')->unsigned()->nullable()->index();
             $table->string('language', 16)->nullable()->index();
             /*
             ALTER TABLE `seo` ADD `language` VARCHAR( 16 ) NULL AFTER `unit_id`;
             ALTER TABLE `seo` ADD INDEX ( `language` );
             */
             $table->string('title', 256)->nullable();
             $table->text('description')->nullable();
             $table->text('keywords')->nullable();
             $table->string('url', 256)->nullable()->index();
             $table->string('h1', 256)->nullable();
             $table->timestamps();
             $table->index('module', 'unit_id');
         });
         echo ' + ' . $this->table . PHP_EOL;
     } else {
         echo '...' . $this->table . PHP_EOL;
     }
 }
Example #3
Show file File: 2003_01_01_000050_comunik_create_table_email_campaign.php Project: syscover/comunik
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('005_044_email_campaign')) {
         Schema::create('005_044_email_campaign', function ($table) {
             $table->engine = 'InnoDB';
             $table->increments('id_044')->unsigned();
             $table->string('name_044');
             $table->integer('email_account_id_044')->unsigned();
             $table->integer('template_id_044')->unsigned()->nullable();
             $table->string('subject_044');
             $table->string('theme_044');
             $table->text('header_044');
             $table->text('body_044');
             $table->text('footer_044');
             $table->text('text_044');
             $table->text('data_044');
             $table->integer('shipping_date_044')->nullable()->unsigned()->default(0);
             $table->string('shipping_date_text_044')->nullable();
             $table->integer('persistence_date_044')->nullable()->unsigned()->default(0);
             $table->string('persistence_date_text_044')->nullable();
             $table->smallInteger('sorting_044')->nullable()->unsigned()->default(0);
             // estado en true, cuando estamos enviando los emails correspondientes a la campaña a cola de envíos
             $table->boolean('processing_044')->default(false);
             // estado en true, cuando todos los correos que tienen que ser enviados a cola de envíos se han enviado
             $table->boolean('created_044')->default(false);
             $table->integer('viewed_044')->unsigned()->default(0);
             $table->foreign('email_account_id_044', 'fk01_005_044_email_campaign')->references('id_013')->on('001_013_email_account')->onDelete('restrict')->onUpdate('cascade');
             $table->foreign('template_id_044', 'fk02_005_044_email_campaign')->references('id_043')->on('005_043_email_template')->onDelete('restrict')->onUpdate('cascade');
         });
     }
 }
Example #4
Show file File: 2015_08_24_000000_create_order_pricelist_table.php Project: redooor/redminportal
0
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     // Create the old table
     if (!Schema::hasTable('user_pricelists')) {
         Schema::create('user_pricelists', function (Blueprint $table) {
             $table->increments('id');
             $table->integer('user_id')->unsigned();
             $table->foreign('user_id')->references('id')->on('users');
             $table->integer('pricelist_id')->unsigned();
             $table->foreign('pricelist_id')->references('id')->on('pricelists');
             $table->unique(array('user_id', 'pricelist_id'));
             $table->decimal('paid', 8, 2)->default(0);
             $table->string('transaction_id')->default('Unknown')->nullable();
             $table->string('payment_status')->default('Completed')->nullable();
             $table->text('options')->nullable();
             $table->timestamps();
         });
     }
     // Transfer existing data to old table, at the end of it drop table order_pricelist
     if (Schema::hasTable('user_pricelists') and Schema::hasTable('order_pricelist')) {
         $orders = DB::table('orders')->join('order_pricelist', 'orders.id', '=', 'order_pricelist.order_id')->select('orders.*', 'order_pricelist.pricelist_id')->get();
         foreach ($orders as $item) {
             // Check if user exists
             if (DB::table('users')->where('id', $item->user_id)->count() > 0) {
                 $order_id = DB::table('user_pricelists')->insertGetId(['user_id' => $item->user_id, 'paid' => $item->paid, 'transaction_id' => $item->transaction_id, 'payment_status' => $item->payment_status, 'options' => $item->options, 'created_at' => $item->created_at, 'updated_at' => $item->updated_at, 'pricelist_id' => $item->pricelist_id]);
             }
         }
         Schema::dropIfExists('order_pricelist');
     }
 }
Example #5
Show file File: 2015_02_09_154251_create_posts_table.php Project: vanderlin/halp
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (Schema::hasTable('post_types') == false) {
         Schema::create('post_types', function (Blueprint $table) {
             $table->increments('id');
             $table->timestamps();
             $table->string('name');
         });
     }
     if (Schema::hasTable('posts') == false) {
         Schema::create('posts', function (Blueprint $table) {
             $table->increments('id');
             $table->string('title');
             $table->string('slug');
             $table->string('hero_url')->nullable()->default(NULL);
             $table->text('body');
             $table->text('excerpt')->nullable()->default(NULL);
             $table->integer('user_id');
             $table->integer('post_type_id');
             $table->string('status');
             $table->softDeletes();
             $table->timestamps();
         });
     }
 }
Example #6
Show file File: 2015_09_06_172535_create_staffs_timetable_table.php Project: razikallayi/peaceschools
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('staffs_timetable')) {
         Schema::create('staffs_timetable', function (Blueprint $table) {
             $table->increments('id');
             $table->string('period');
             $table->integer('mon')->unsigned()->nullable()->default(null);
             $table->integer('tue')->unsigned()->nullable()->default(null);
             $table->integer('wed')->unsigned()->nullable()->default(null);
             $table->integer('thu')->unsigned()->nullable()->default(null);
             $table->integer('fri')->unsigned()->nullable()->default(null);
             $table->integer('sat')->unsigned()->nullable()->default(null);
             $table->integer('staff_id')->unsigned();
             $table->timestamps();
         });
         Schema::table('staffs_timetable', function (Blueprint $table) {
             $table->foreign('mon')->references('id')->on('courses');
             $table->foreign('tue')->references('id')->on('courses');
             $table->foreign('wed')->references('id')->on('courses');
             $table->foreign('thu')->references('id')->on('courses');
             $table->foreign('fri')->references('id')->on('courses');
             $table->foreign('sat')->references('id')->on('courses');
             $table->foreign('staff_id')->references('id')->on('users')->onDelete('cascade');
         });
     }
 }
Example #7
Show file File: 2014_07_22_171929_create_usuarios_table.php Project: bowl13/FB_Base_Laravel_AngularJS
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('usuarios', function (Blueprint $table) {
         $table->increments('id');
         $table->string('fbuid', 20);
         $table->string('rut', 20);
         $table->string('firstname', 100);
         $table->string('lastname', 100);
         $table->string('genero', 20);
         $table->string('phone', 20);
         $table->string('address', 200);
         $table->string('email', 200);
         $table->integer('comuna_id')->unsigned();
         $table->string('ip', 20);
         $table->char('complete', 1);
         $table->text('meta', 20);
         $table->text('access_token', 20);
         $table->text('expire_token', 20);
         $table->timestamps();
         #Indices
         $table->index('comuna_id');
         #FK
         if (Schema::hasTable('comunas')) {
             $table->foreign('comuna_id')->references('id')->on('comunas');
         }
     });
 }
Example #8
Show file File: 2014_01_12_142343_create_immunizations_table.php Project: carlosqueiroz/nosh-core
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('immunizations')) {
         Schema::create('immunizations', function ($table) {
             $table->increments('imm_id');
             $table->bigInteger('pid')->nullable();
             $table->bigInteger('eid')->nullable();
             $table->string('cpt', 255)->nullable();
             $table->dateTime('imm_date')->nullable();
             $table->string('imm_immunization', 255)->nullable();
             $table->string('imm_sequence', 255)->nullable();
             $table->string('imm_body_site', 255)->nullable();
             $table->string('imm_dosage', 255)->nullable();
             $table->string('imm_dosage_unit', 255)->nullable();
             $table->string('imm_route', 255)->nullable();
             $table->string('imm_elsewhere', 255)->nullable();
             $table->string('imm_vis', 255)->nullable();
             $table->string('imm_lot', 255)->nullable();
             $table->string('imm_manufacturer', 255)->nullable();
             $table->dateTime('imm_expiration')->nullable();
             $table->string('imm_brand', 255)->nullable();
             $table->string('imm_cvxcode', 255)->nullable();
             $table->string('imm_provider', 255)->nullable();
         });
     }
 }
Example #9
Show file File: 2004_01_01_000040_forms_create_table_record.php Project: syscover/forms
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('004_403_record')) {
         Schema::create('004_403_record', function (Blueprint $table) {
             $table->engine = 'InnoDB';
             $table->increments('id_403')->unsigned();
             $table->integer('form_id_403')->unsigned();
             $table->integer('date_403')->unsigned();
             $table->string('date_text_403', 25);
             $table->integer('state_id_403')->unsigned()->nullable();
             $table->string('subject_403', 255)->nullable();
             $table->string('company_403', 100)->nullable();
             $table->string('name_403', 50)->nullable();
             $table->string('surname_403', 50)->nullable();
             $table->string('email_403', 100)->nullable();
             $table->string('country_id_403', 2)->nullable();
             $table->string('territorial_area_1_id_403', 6)->nullable();
             $table->string('territorial_area_2_id_403', 10)->nullable();
             $table->string('territorial_area_3_id_403', 10)->nullable();
             $table->boolean('opened_403')->default(false);
             $table->boolean('dispatched_403')->default(false);
             $table->text('data_403');
             $table->foreign('form_id_403', 'fk01_004_403_record')->references('id_401')->on('004_401_form')->onDelete('cascade')->onUpdate('cascade');
             $table->foreign('state_id_403', 'fk02_004_403_record')->references('id_400')->on('004_400_state')->onDelete('restrict')->onUpdate('cascade');
             $table->foreign('country_id_403', 'fk03_004_403_record')->references('id_002')->on('001_002_country')->onDelete('restrict')->onUpdate('cascade');
             $table->foreign('territorial_area_1_id_403', 'fk04_004_403_record')->references('id_003')->on('001_003_territorial_area_1')->onDelete('restrict')->onUpdate('cascade');
             $table->foreign('territorial_area_2_id_403', 'fk05_004_403_record')->references('id_004')->on('001_004_territorial_area_2')->onDelete('restrict')->onUpdate('cascade');
             $table->foreign('territorial_area_3_id_403', 'fk06_004_403_record')->references('id_005')->on('001_005_territorial_area_3')->onDelete('restrict')->onUpdate('cascade');
         });
     }
 }
Example #10
Show file File: 2015_05_11_181912_create_sexoffenders_table.php Project: kirantcyquent/LaravelOffenders
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('sexoffenders')) {
         Schema::create('sexoffenders', function (Blueprint $table) {
             $table->increments('id');
             $table->string('state_name')->index();
             $table->string('state_code')->index();
             $table->string('state_url');
             $table->string('status');
             $table->integer('records_crawled')->unsigned()->default(0);
             $table->integer('records_expected')->unsigned()->default(0);
             $table->enum('crawl_state', ['running', 'stopped', 'paused', 'completed', 'incomplete'])->default('incomplete')->index();
             $table->enum('paused', ['0', '1'])->default('0')->comment = '0-normal, 1-paused';
             $table->timestamp('expected_time')->nullable();
             $table->timestamp('started_at')->nullable();
             $table->timestamp('completed_at')->nullable();
         });
     }
     if (!Schema::hasTable('sexoffenders_stats')) {
         Schema::create('sexoffenders_stats', function (Blueprint $table) {
             $table->increments('id');
             $table->integer('sexoffender_id')->unsigned();
             $table->foreign('sexoffender_id')->references('id')->on('sexoffenders');
             $table->integer('records_crawled')->unsigned()->default(0);
             $table->time('crawl_time');
             $table->time('record_time');
             $table->timestamp('started_at')->nullable();
             $table->timestamp('completed_at')->nullable();
         });
     }
 }
Example #11
Show file File: 2014_07_25_115118_notify_create_table_notifications.php Project: ipunkt/laravel-notify
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (Schema::hasTable('notifications') || Schema::hasTable('notification_activities')) {
         return;
     }
     /**
      * Create Table Notifications
      */
     Schema::create('notifications', function (Blueprint $table) {
         $table->increments('id');
         $table->text('job');
         $table->text('data');
         $table->timestamps();
         $table->softDeletes();
     });
     /**
      * Create Table for Activities
      */
     Schema::create('notification_activities', function (Blueprint $table) {
         $table->increments('id');
         $table->unsignedInteger('notification_id');
         $table->foreign('notification_id')->references('id')->on('notifications')->onDelete('cascade');
         /**
          * There is no foreign key set, so one can use his own database structure for UserInterface
          */
         $table->unsignedInteger('user_id')->nullable()->default(null)->index();
         $table->string('activity');
         $table->timestamps();
         $table->index(['notification_id', 'user_id']);
     });
 }
Example #12
Show file File: 2016_01_14_174846_create_table_users.php Project: Abdulhmid/wecando
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable($this->table)) {
         Schema::create($this->table, function (Blueprint $table) {
             $table->engine = 'InnoDB';
             /* Primary Key */
             $table->increments('id');
             /* Main Data*/
             $table->string('fullname');
             $table->string('email')->unique();
             $table->string('no_telp')->nullable();
             $table->string('username')->unique();
             $table->string('password', 255);
             $table->string('image', 255)->nullable();
             $table->text('address')->nullable();
             $table->tinyInteger('status')->default(0);
             $table->rememberToken();
             /* Foreign Key */
             $table->integer('id_group')->unsigned();
             $table->foreign('id_group')->references('id')->on('groups')->onDelete('cascade')->onUpdate('cascade');
             /* Action Data */
             $table->string('created_by')->nullable()->default('system');
             $table->timestamps();
         });
     }
 }
Example #13
Show file File: 2016_01_21_151634_karloleary_users_initial_migration.php Project: karloleary/users
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('users_list')) {
         Schema::create('users_list', function (Blueprint $table) {
             $table->increments('id');
             $table->timestamps();
             $table->softDeletes();
             $table->string('fullname');
             $table->string('email', 40)->unique();
             $table->string('password', 100);
             $table->string('remember_token', 100);
         });
     }
     if (!Schema::hasTable('users_groups')) {
         Schema::create("users_groups", function (Blueprint $table) {
             $table->increments('id');
             $table->timestamps();
             $table->softDeletes();
             $table->string('title', 30);
             $table->integer('level');
         });
     }
     if (!Schema::hasTable('users_per_groups')) {
         Schema::create("users_per_groups", function (Blueprint $table) {
             $table->integer('user_id');
             $table->integer('group_id');
         });
     }
 }
Example #14
Show file File: 2014_01_12_142343_create_orders_table.php Project: carlosqueiroz/nosh-core
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('orders')) {
         Schema::create('orders', function ($table) {
             $table->bigIncrements('orders_id');
             $table->bigInteger('address_id')->nullable();
             $table->bigInteger('eid')->nullable();
             $table->bigInteger('t_messages_id')->nullable();
             $table->bigInteger('pid')->nullable();
             $table->string('encounter_provider', 255)->nullable();
             $table->timestamp('orders_date')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
             $table->string('orders_insurance', 255)->nullable();
             $table->longtext('orders_referrals')->nullable();
             $table->longtext('orders_labs')->nullable();
             $table->longtext('orders_radiology')->nullable();
             $table->longtext('orders_cp')->nullable();
             $table->string('orders_referrals_icd', 255)->nullable();
             $table->string('orders_labs_icd', 255)->nullable();
             $table->string('orders_radiology_icd', 255)->nullable();
             $table->string('orders_cp_icd', 255)->nullable();
             $table->string('orders_labs_obtained', 255)->nullable();
             $table->boolean('orders_completed')->nullable();
             $table->bigInteger('id')->nullable();
         });
     }
 }
Example #15
Show file File: 2016_04_11_025340_create-freelancer-info.php Project: sagaekakristi/ppla02
0
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     // drop all table to back to revision
     if (Schema::hasTable('freelancer_info_skill')) {
         Schema::drop('freelancer_info_skill');
     }
     if (Schema::hasTable('freelancer_info')) {
         if (Schema::hasTable('accepted_job_links')) {
             Schema::drop('accepted_job_links');
         }
         if (Schema::hasTable('accepted_job')) {
             Schema::drop('accepted_job');
         }
         if (Schema::hasTable('job_category')) {
             Schema::drop('job_category');
         }
         if (Schema::hasTable('job')) {
             Schema::drop('job');
         }
         if (Schema::hasTable('category')) {
             Schema::drop('category');
         }
         Schema::drop('freelancer_info');
     }
 }
Example #16
Show file File: SeedGen.php Project: adamgoose/seed-gen
0
 /**
  * Generates a seed file.
  *
  * @param  string  $table
  * @return void
  * @throws Adamgoose\SeedGen\TableNotFoundException
  */
 public function generateSeed($table)
 {
     // Check if table exists
     if (!\Schema::hasTable($table)) {
         throw new TableNotFoundException("Table {$table} was not found.");
     }
     // Get the data
     $data = \DB::table($table)->get();
     $dataArray = array();
     foreach ($data as $row) {
         $rowArray = array();
         foreach ($row as $columnName => $columnValue) {
             $rowArray[$columnName] = $columnValue;
         }
         $dataArray[] = $rowArray;
     }
     // Generate class name
     $className = $this->generateClassName($table);
     // Get template for a seed file contents
     $stub = $this->files->get($this->getStubPath() . '/seed.stub');
     // Get a seed folder path
     $seedPath = app_path() . \Config::get('seedgen::path');
     // Save a populated stub
     $this->files->put($this->getPath($className, $seedPath), $this->populateStub($className, $stub, $table, $this->prettifyArray($dataArray)));
     // Update the DatabaseSeeder.php file
     $this->updateDatabaseSeederRunMethod($className);
 }
Example #17
Show file File: 2013_12_18_185812_create_crawled_content.php Project: kylekatarnls/insearch
0
 protected function createTable($tableName)
 {
     if (!Schema::hasTable($tableName)) {
         Schema::create($tableName, function (Blueprint $table) {
             $table->increments('id');
             $table->string('url')->unique();
             $table->string('title');
             $table->longtext('content');
             $table->string('language')->nullable();
             $table->timestamps();
             $table->softDeletes();
         });
         try {
             DB::statement("ALTER TABLE " . self::TABLE_NAME . " ADD COLUMN searchtext TSVECTOR");
             DB::statement("UPDATE " . self::TABLE_NAME . "\n\t\t\t\t\tSET searchtext = to_tsvector('english', url || '' || title || '' || content)");
             DB::statement("CREATE INDEX searchtext_gin ON " . self::TABLE_NAME . " USING GIN(searchtext)");
             DB::statement("CREATE TRIGGER ts_searchtext\n\t\t\t\t\tBEFORE INSERT OR UPDATE ON " . self::TABLE_NAME . "\n\t\t\t\t\tFOR EACH ROW EXECUTE PROCEDURE\n\t\t\t\t\ttsvector_update_trigger('searchtext', 'pg_catalog.english', 'url', 'title', 'content')");
             echo "TSVECTOR used.\n";
         } catch (QueryException $e) {
             try {
                 DB::statement('ALTER TABLE `' . $tableName . '` ADD FULLTEXT search(url, title, content)');
                 echo "FULLTEXT used.\n";
             } catch (QueryException $e) {
                 echo "FULLTEXT is not supported.\n";
             }
         }
     }
 }
Example #18
Show file File: 2013_11_23_163257_create_cluster_table.php Project: tallcoder/Reservations
0
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     if (Schema::hasTable('cluster')) {
         DB::table('cluster')->delete();
         Schema::drop('cluster');
     }
 }
Example #19
Show file File: 2013_10_13_134447_create_user_table.php Project: tallcoder/Reservations
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     // checking the existence of the user table before adding
     if (!Schema::hasTable('user')) {
         Schema::create('user', function (Blueprint $table) {
             $table->increments('id');
             $table->timestamps();
             $table->string('username');
             $table->string('password');
             $table->integer('rights');
         });
     } else {
         if (!Schema::hasColumn('user', 'username')) {
             Schema::table('user', function ($table) {
                 $table->string('username');
             });
         }
         if (!Schema::hasColumn('user', 'password')) {
             Schema::table('user', function ($table) {
                 $table->string('password');
             });
         }
         if (!Schema::hasColumn('user', 'rights')) {
             Schema::table('user', function ($table) {
                 $table->integer('rights');
             });
         }
     }
 }
Example #20
Show file File: 2014_01_12_142343_create_labs_table.php Project: carlosqueiroz/nosh-core
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('labs')) {
         Schema::create('labs', function ($table) {
             $table->bigInteger('eid')->primary();
             $table->bigInteger('pid')->nullable();
             $table->string('encounter_provider', 255)->nullable();
             $table->timestamp('labs_date')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
             $table->string('labs_ua_urobili', 100)->nullable();
             $table->string('labs_ua_bilirubin', 100)->nullable();
             $table->string('labs_ua_ketones', 100)->nullable();
             $table->string('labs_ua_glucose', 100)->nullable();
             $table->string('labs_ua_protein', 100)->nullable();
             $table->string('labs_ua_nitrites', 100)->nullable();
             $table->string('labs_ua_leukocytes', 100)->nullable();
             $table->string('labs_ua_blood', 100)->nullable();
             $table->string('labs_ua_ph', 100)->nullable();
             $table->string('labs_ua_spgr', 100)->nullable();
             $table->string('labs_ua_color', 100)->nullable();
             $table->string('labs_ua_clarity', 100)->nullable();
             $table->string('labs_upt', 100)->nullable();
             $table->string('labs_strep', 100)->nullable();
             $table->string('labs_mono', 100)->nullable();
             $table->string('labs_flu', 100)->nullable();
             $table->string('labs_microscope', 100)->nullable();
             $table->string('labs_glucose', 100)->nullable();
             $table->longtext('labs_other')->nullable();
         });
     }
 }
Example #21
Show file File: 2015_12_23_040444_create_translations_tables.php Project: bernardomacedo/laravel-db-translator
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     /**
      * Create the variables table
      */
     if (!Schema::hasTable('translations_variables')) {
         Schema::create('translations_variables', function (Blueprint $table) {
             $table->increments('id');
             $table->text('text');
             $table->text('group');
             $table->string('md5sha1', 255);
             $table->boolean('dynamic')->default(0);
             $table->timestamps();
         });
     }
     /**
      * Create the translated table
      */
     if (!Schema::hasTable('translations_translated')) {
         Schema::create('translations_translated', function (Blueprint $table) {
             $table->integer('variable_id')->unsigned();
             $table->integer('language_id')->unsigned();
             $table->text('translation');
             $table->timestamps();
             $table->foreign('variable_id')->references('id')->on('translations_variables')->onUpdate('cascade')->onDelete('cascade');
             $table->foreign('language_id')->references('id')->on('languages')->onUpdate('cascade')->onDelete('cascade');
             $table->primary(['variable_id', 'language_id']);
         });
     }
 }
Example #22
Show file File: 2014_06_30_0010000_create_supplier_table.php Project: johnny-human/uhlelo
0
 /**
  * Run the migrations.
  */
 public function up()
 {
     if (!Schema::hasTable('suppliers')) {
         Schema::create('suppliers', function (Blueprint $table) {
             $table->increments('id');
             $table->string('name');
             $table->string('shortname');
             $table->string('address')->nullable();
             $table->string('postal_code')->nullable();
             $table->string('zip_code')->nullable();
             $table->string('region')->nullable();
             $table->string('city')->nullable();
             $table->string('country')->nullable();
             $table->string('contact_title')->nullable();
             $table->string('contact_name')->nullable();
             $table->string('contact_phone')->nullable();
             $table->string('contact_fax')->nullable();
             $table->string('contact_email')->nullable();
             $table->text('website')->nullable();
             $table->boolean('producer')->default(0);
             $table->integer('supplied_by')->default(0);
             $table->timestamp('created_at')->default(\DB::raw('CURRENT_TIMESTAMP'));
             $table->timestamp('updated_at')->default(\DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
         });
     }
 }
Example #23
Show file File: 2014_01_12_142343_create_rx_list_table.php Project: carlosqueiroz/nosh-core
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('rx_list')) {
         Schema::create('rx_list', function ($table) {
             $table->increments('rxl_id');
             $table->bigInteger('pid')->nullable();
             $table->dateTime('rxl_date_active')->nullable();
             $table->dateTime('rxl_date_prescribed')->nullable();
             $table->string('rxl_medication', 255)->nullable();
             $table->string('rxl_dosage', 255)->nullable();
             $table->string('rxl_dosage_unit', 255)->nullable();
             $table->string('rxl_sig', 255)->nullable();
             $table->string('rxl_route', 255)->nullable();
             $table->string('rxl_frequency', 255)->nullable();
             $table->string('rxl_instructions', 255)->nullable();
             $table->string('rxl_quantity', 255)->nullable();
             $table->string('rxl_refill', 255)->nullable();
             $table->string('rxl_reason', 255)->nullable();
             $table->dateTime('rxl_date_inactive')->nullable();
             $table->dateTime('rxl_date_old')->nullable();
             $table->string('rxl_provider', 255)->nullable();
             $table->bigInteger('id')->nullable();
             $table->string('rxl_dea', 255)->nullable();
             $table->string('rxl_daw', 255)->nullable();
             $table->string('rxl_license', 255)->nullable();
             $table->integer('rxl_days')->nullable();
             $table->dateTime('rxl_due_date')->nullable();
             $table->string('rcopia_sync', 4)->nullable();
             $table->string('rxl_ndcid', 11)->nullable();
         });
     }
 }
Example #24
Show file File: 2014_01_12_142343_create_encounters_table.php Project: carlosqueiroz/nosh-core
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('encounters')) {
         Schema::create('encounters', function ($table) {
             $table->bigIncrements('eid');
             $table->bigInteger('pid')->nullable();
             $table->bigInteger('appt_id')->nullable();
             $table->string('encounter_provider', 255)->nullable();
             $table->timestamp('encounter_date')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
             $table->string('encounter_signed', 4)->nullable();
             $table->timestamp('date_signed')->default("0000-00-00 00:00:00");
             $table->dateTime('encounter_DOS')->nullable();
             $table->string('encounter_age', 100)->nullable();
             $table->string('encounter_type', 100)->nullable();
             $table->string('encounter_location', 100)->nullable();
             $table->string('encounter_activity', 100)->nullable();
             $table->longtext('encounter_cc')->nullable();
             $table->string('encounter_condition', 255)->nullable();
             $table->string('encounter_condition_work', 4)->nullable();
             $table->string('encounter_condition_auto', 4)->nullable();
             $table->string('encounter_condition_auto_state', 2)->nullable();
             $table->string('encounter_condition_other', 4)->nullable();
             $table->string('bill_submitted', 4)->nullable();
             $table->string('addendum', 4)->nullable();
             $table->bigInteger('addendum_eid')->nullable();
             $table->integer('user_id')->nullable();
             $table->string('encounter_role', 255)->nullable();
             $table->string('referring_provider', 255)->nullable();
             $table->integer('practice_id')->nullable();
             $table->string('referring_provider_npi', 255)->nullable();
         });
     }
 }
Example #25
Show file File: 2015_06_21_000001_update_users_table.php Project: talv86/easel
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     // When unit testing we need to create a table for users since there will be no users table to alter
     if (!Schema::hasTable('users')) {
         Schema::create('users', function (Blueprint $table) {
             $table->increments('id');
             $table->string('email')->unique()->nullable();
             $table->string('password')->nullable();
             $table->rememberToken();
             $table->timestamps();
         });
     }
     Schema::table('users', function (Blueprint $table) {
         if (Schema::hasColumn('users', 'name')) {
             $table->string('name')->nullable()->change();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('first_name')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('last_name')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('display_name')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('url')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->json('social_media')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('address')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('city')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('country')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->text('bio')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('job')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('phone')->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('gender', 140)->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->string('relationship', 140)->nullable();
         }
         if (!Schema::hasColumn('users', 'first_name')) {
             $table->date('birthday')->nullable();
         }
     });
 }
Example #26
Show file File: 2015_12_23_142719_create_patients_table.php Project: acelumaad/laravel-cliniq
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (Schema::hasTable('patients')) {
         DB::statement('ALTER TABLE patients ENGINE = InnoDB');
     }
     if (!Schema::hasTable('patients')) {
         Schema::create('patients', function (Blueprint $table) {
             $table->engine = 'InnoDB';
             $table->increments('id');
             $table->integer('patient_no');
             $table->string('lastname');
             $table->string('firstname');
             $table->string('address')->nullable();
             $table->string('contact')->nullable();
             $table->string('email')->nullable();
             $table->string('gender')->nullable();
             $table->date('birthday')->nullable();
             $table->string('bloodtype')->nullable();
             $table->string('occupancy')->nullable();
             $table->string('status')->nullable();
             $table->string('contact_person')->nullable();
             $table->timestamps();
             $table->softDeletes();
         });
     }
 }
Example #27
Show file File: 2016_08_16_101048_create_sessions_table.php Project: ppy/osu-web
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (Schema::hasTable('phpbb_sessions')) {
         return;
     }
     Schema::create('phpbb_sessions', function ($table) {
         $table->collation = 'utf8_bin';
         $table->charset = 'utf8';
         $table->string('session_id', 32)->default('');
         $table->mediumInteger('session_user_id')->unsigned()->default(0);
         $table->integer('session_last_visit')->unsigned()->default(0);
         $table->integer('session_start')->unsigned()->default(0);
         $table->integer('session_time')->unsigned()->default(0);
         $table->string('session_ip', 40)->default('');
         $table->string('session_forwarded_for')->default('');
         $table->string('session_page')->default('');
         $table->boolean('session_viewonline')->unsigned()->default(1);
         $table->boolean('session_autologin')->unsigned()->default(0);
         $table->boolean('session_admin')->unsigned()->default(0);
         $table->boolean('verified')->default(0);
         $table->primary('session_id');
         $table->index(['session_time', 'session_page'], 'time_page');
         $table->index(['session_autologin', 'session_time'], 'autologin_time_purge');
         $table->index(['session_user_id', 'session_time'], 'session_user_id_time');
     });
     DB::statement('ALTER TABLE phpbb_sessions ROW_FORMAT=DYNAMIC');
 }
Example #28
Show file File: 2014_01_12_142343_create_assessment_table.php Project: carlosqueiroz/nosh-core
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('assessment')) {
         Schema::create('assessment', function ($table) {
             $table->bigInteger('eid')->primary();
             $table->bigInteger('pid')->nullable();
             $table->string('encounter_provider', 255)->nullable();
             $table->timestamp('assessment_date')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
             $table->string('assessment_icd1', 20)->nullable();
             $table->string('assessment_icd2', 20)->nullable();
             $table->string('assessment_icd3', 20)->nullable();
             $table->string('assessment_icd4', 20)->nullable();
             $table->string('assessment_icd5', 20)->nullable();
             $table->string('assessment_icd6', 20)->nullable();
             $table->string('assessment_icd7', 20)->nullable();
             $table->string('assessment_icd8', 20)->nullable();
             $table->longtext('assessment_1')->nullable();
             $table->longtext('assessment_2')->nullable();
             $table->longtext('assessment_3')->nullable();
             $table->longtext('assessment_4')->nullable();
             $table->longtext('assessment_5')->nullable();
             $table->longtext('assessment_6')->nullable();
             $table->longtext('assessment_7')->nullable();
             $table->longtext('assessment_8')->nullable();
             $table->longtext('assessment_other')->nullable();
             $table->longtext('assessment_ddx')->nullable();
             $table->longtext('assessment_notes')->nullable();
         });
     }
 }
Example #29
Show file File: 2016_04_11_022111_create-user-info.php Project: sagaekakristi/ppla02
0
 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     // drop table for back to revision
     if (Schema::hasTable('user_info')) {
         Schema::drop('user_info');
     }
 }
Example #30
Show file File: 2014_10_12_210000_create_teams_tables_for_spark.php Project: spaceonline/laravel-sparkinstaller
0
 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     if (!Schema::hasTable('teams')) {
         // Create Teams Table...
         Schema::create('teams', function (Blueprint $table) {
             $table->increments('id');
             $table->integer('owner_id')->index();
             $table->string('name');
             $table->timestamps();
         });
     }
     if (!Schema::hasTable('user_teams')) {
         // Create User Teams Intermediate Table...
         Schema::create('user_teams', function (Blueprint $table) {
             $table->integer('team_id');
             $table->integer('user_id');
             $table->string('role', 25);
             $table->unique(['team_id', 'user_id']);
         });
     }
     if (!Schema::hasTable('user_teams')) {
         // Create Invitations Table...
         Schema::create('user_teams', function (Blueprint $table) {
             $table->increments('id');
             $table->integer('team_id')->index();
             $table->integer('user_id')->nullable()->index();
             $table->string('email');
             $table->string('token', 40)->unique();
             $table->timestamps();
         });
     }
 }