/** * 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(); }); } }
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; } }
/** * 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'); }); } }
/** * 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'); } }
/** * 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(); }); } }
/** * 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'); }); } }
/** * 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'); } }); }
/** * 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(); }); } }
/** * 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'); }); } }
/** * 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(); }); } }
/** * 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']); }); }
/** * 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(); }); } }
/** * 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'); }); } }
/** * 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(); }); } }
/** * 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'); } }
/** * 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); }
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"; } } } }
/** * Reverse the migrations. * * @return void */ public function down() { if (Schema::hasTable('cluster')) { DB::table('cluster')->delete(); Schema::drop('cluster'); } }
/** * 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'); }); } } }
/** * 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(); }); } }
/** * 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']); }); } }
/** * 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')); }); } }
/** * 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(); }); } }
/** * 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(); }); } }
/** * 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(); } }); }
/** * 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(); }); } }
/** * 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'); }
/** * 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(); }); } }
/** * Reverse the migrations. * * @return void */ public function down() { // drop table for back to revision if (Schema::hasTable('user_info')) { Schema::drop('user_info'); } }
/** * 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(); }); } }