/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('artists', function (Blueprint $table) { $table->dropColumn('bandcamp'); $table->dropColumn('patreon'); }); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('novels'); Schema::drop('chapters'); Schema::drop('configs'); Schema::drop('mails'); }
/** * Fetch the collection of site permissions. * * @return \Illuminate\Database\Eloquent\Collection */ protected function getPermissions() { if (!Schema::hasTable('roles')) { return new Collection(); } return Permission::with('roles')->get(); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('oauth_auth_codes', function (Blueprint $t) { $t->dropForeign('oauth_auth_codes_session_id_foreign'); }); Schema::drop('oauth_auth_codes'); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('oauth_refresh_tokens', function (Blueprint $table) { $table->dropForeign('oauth_refresh_tokens_access_token_id_foreign'); }); Schema::drop('oauth_refresh_tokens'); }
/** * Reverse the migrations. */ public function down() { Schema::drop('account_modules', function (Blueprint $table) { $table->dropForeign('account_module_to_account'); $table->dropForeign('account_module_to_module'); }); }
/** * Execute the console command. * * @return mixed */ public function handle() { if ($this->confirm("Clear database? [Yes|no]", "Yes")) { $this->info('Clear database start'); if (config('database.default') == 'mysql') { DB::statement('SET FOREIGN_KEY_CHECKS=0'); } else { if (config('database.default') == 'sqlite') { DB::statement('PRAGMA foreign_keys = OFF'); } } $tableNames = Schema::getConnection()->getDoctrineSchemaManager()->listTableNames(); foreach ($tableNames as $v) { Schema::drop($v); $this->info('Dropped: ' . $v); } $this->info('Clear database end'); if (config('database.default') == 'mysql') { DB::statement('SET FOREIGN_KEY_CHECKS=1'); } else { if (config('database.default') == 'sqlite') { DB::statement('PRAGMA foreign_keys = ON'); } } } }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('finds', function (Blueprint $table) { $table->dropColumn('icon'); $table->dropColumn('color'); }); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('artist_tracks', function (Blueprint $table) { $table->dropColumn('display_order'); $table->dropColumn('title_romanized'); }); }
/** * @return array */ public function getDatabaseConfig() { if (Schema::hasTable('options')) { $table = $this->app['db']->table('options'); return $this->changeConfigWithHelpers($table->where('type', 'config')->lists('value', 'key')); } }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('user_meta', function (Blueprint $table) { $table->dropForeign('user_meta_user_id_foreign'); }); Schema::drop('user_meta'); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('users', function (Blueprint $table) { // $table->string('password')->nullable(false)->change(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('profesor', function (Blueprint $table) { $table->integer('pro_tipo'); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { // Oh my word! Cant rename any columns in a table that has an // enum. o_0 // // Apply the hacky workaround seen here: // https://github.com/laravel/framework/issues/1186#issuecomment-248853309 Schema::getConnection()->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string'); // Define the tables and columns that need to be changed $integer_tables_and_columns = ['character_bookmarks' => ['itemID'], 'eve_conquerable_station_lists' => ['stationID'], 'character_character_sheets' => ['homeStationID'], 'character_contact_lists' => ['labelMask'], 'character_contact_list_labels' => ['labelID'], 'character_contact_list_alliances' => ['labelMask'], 'character_contact_list_alliance_labels' => ['labelID'], 'character_contact_list_corporates' => ['labelMask'], 'character_contact_list_corporate_labels' => ['labelID'], 'character_contracts' => ['startStationID', 'endStationID'], 'character_industry_jobs' => ['stationID', 'blueprintLocationID', 'outputLocationID'], 'character_market_orders' => ['stationID'], 'character_wallet_journals' => ['argID1'], 'character_wallet_transactions' => ['stationID'], 'corporation_bookmarks' => ['itemID'], 'corporation_contact_list_labels' => ['labelID'], 'corporation_contact_lists' => ['labelMask'], 'corporation_contact_list_alliances' => ['labelMask'], 'corporation_contact_list_alliance_labels' => ['labelID'], 'corporation_contracts' => ['startStationID', 'endStationID'], 'corporation_member_securities' => ['roleID'], 'corporation_sheets' => ['stationID'], 'corporation_industry_jobs' => ['stationID', 'blueprintLocationID', 'outputLocationID'], 'corporation_market_orders' => ['stationID'], 'corporation_wallet_journals' => ['argID1'], 'corporation_wallet_transactions' => ['stationID']]; // Loop over the changes defined in the above array. foreach ($integer_tables_and_columns as $table => $columns) { Schema::table($table, function (Blueprint $table) use($columns) { // Loop over the columns that are passed in and change them foreach ($columns as $column) { $table->bigInteger($column)->change(); } }); } // Fix some Wallet values for the industry jobs tables. Schema::table('character_industry_jobs', function (Blueprint $table) { $table->decimal('cost', 30, 2)->change(); }); Schema::table('corporation_industry_jobs', function (Blueprint $table) { $table->decimal('cost', 30, 2)->change(); }); }
public function search($input) { $query = BarcodeProcess::query(); $query->select('barcode_processes.*'); $query->leftJoin('shelves', 'barcode_processes.shelf_id', '=', 'shelves.id'); $columns = Schema::getColumnListing('barcode_processes'); $attributes = array(); foreach ($columns as $attribute) { $attributes[$attribute] = null; if (isset($input[$attribute]) and !empty($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } } /** * Filter */ $this->filter($input, $query); /** * Get count */ $total = $query->count(); /** * Pagination */ $this->pagination($input, $query); /** * Order */ $this->order($input, $query); return [$query->get(), $attributes, 'total' => $total]; }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('users', function (Blueprint $table) { $table->dropColumn('first_name'); $table->dropColumn('last_name'); }); }
public function search($input) { $query = User::query(); $columns = Schema::getColumnListing('users'); $attributes = array(); foreach ($columns as $attribute) { $attributes[$attribute] = null; if (isset($input[$attribute]) and !empty($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } } /* ** Filter */ $this->filter($input, $query); /* ** Get count */ $total = $query->count(); /* ** Pagination */ $this->pagination($input, $query); /* ** Order */ $this->order($input, $query); return [$query->get(), $attributes, 'total' => $total]; }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('administrators', function ($table) { $table->dropForeign('administrators_user_id_foreign'); }); Schema::drop('administrators'); }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('oauth_client_endpoints', function (Blueprint $table) { $table->dropForeign('oauth_client_endpoints_client_id_foreign'); }); Schema::drop('oauth_client_endpoints'); }
/** * Reverse the migrations. * * @return void */ public function down() { $tables = ['attached', 'attaches']; foreach ($tables as $table) { Schema::dropIfExists($table); } }
public function translate(Request $request) { $data = $request->only('word', 'src_language', 'trans_language'); $validator = Validator::make($data, array('word' => 'required', 'src_language' => 'required', 'trans_language' => 'required')); if ($validator->passes()) { $columns = Schema::getColumnListing('translation'); // users table if (!in_array($data['src_language'], $columns)) { return response()->json(array('error' => 1, 'labels' => 'Source language is not available')); } else { if (!in_array($data['trans_language'], $columns)) { return response()->json(array('error' => 1, 'labels' => 'Translation language is available')); } else { $tra = Translation::where($data['src_language'], $data['word'])->first(); if (!$tra) { return response()->json(array('error' => 1, 'labels' => 'This word is not available in our source language')); } else { $data = array('word' => $data['word'], 'source' => $data['src_language'], 'target' => $data['trans_language'], 'result' => $tra->{$data}['trans_language']); return response()->json(array('error' => 0, 'data' => $data, 'errors' => array())); } } } } else { return response()->json(array('error' => 1, 'labels' => $validator->messages())); } }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('third_party_logins', function (Blueprint $table) { $table->dropForeign('third_party_logins_user_id_foreign'); }); Schema::drop('third_party_logins'); }
/** * Ensures the migrations ran and tables exist in the database. */ public function test_tables_exist() { $expectedTables = ['users', 'password_resets', 'email_addresses', 'phone_numbers', 'addresses']; foreach ($expectedTables as $table) { $this->assertTrue(Schema::hasTable($table)); } }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('permission_role'); Schema::drop('role_user'); Schema::drop('permissions'); Schema::drop('roles'); }
public function createSchema() { if (!DbSchema::hasTable('sessions')) { try { DbSchema::create('sessions', function ($table) { $table->string('id')->unique(); $table->longText('payload'); $table->integer('last_activity'); }); } catch (QueryException $e) { } } $exec = $this->getSystemSchemas(); $builder = new DbUtils(); foreach ($exec as $data) { // Creates the schema if (!method_exists($data, 'get')) { break; } $schemaArray = $data->get(); if (!is_array($schemaArray)) { break; } foreach ($schemaArray as $table => $columns) { $builder->build_table($table, $columns); } } }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table('posts', function (Blueprint $table) { $table->dropForeign('posts_topic_id_foreign'); }); Schema::drop('topics'); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('languages', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->string('short_two'); $table->string('short_three'); $table->timestamps(); }); Schema::create('groups', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->integer('group_id')->nullable()->comment('Refer to self for multidimensional groups'); $table->timestamps(); }); Schema::create('names', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->integer('group_id'); $table->timestamps(); }); Schema::create('values', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->integer('language_id'); $table->integer('name_id'); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('administradors', function (Blueprint $table) { $table->integer('adm_tipo'); $table->timestamps(); }); }
/** * Bootstrap the application services. * * @return void */ public function boot() { if (Schema::hasTable('categories')) { $categories = Category::getAllFromCache(); view()->share('categories', $categories); } }
/** * Reverse the migrations. * * @return void */ public function down() { Schema::table("contacts", function (Blueprint $table) { $table->dropForeign("contacts_partnership_id_foreign"); }); Schema::drop("contacts"); }