FM / migrations

/home/techb158/ileadtechnology.com/database/migrations/

/home/techb158/ileadtechnology.com/database/migrations

Name	Size	Mode	Actions
update2_2/	-	0755	rm
update2_3/	-	0755	rm
update2_4/	-	0755	rm
update2_5/	-	0755	rm
update2_6/	-	0755	rm
update2_7/	-	0755	rm
update2_8/	-	0755	rm
2014_10_12_100000_create_password_resets_table.php	776	0644	edit dl rm
2019_09_14_155925_create_notifications_table.php	871	0644	edit dl rm
2019_10_31_130136_create_announcements_table.php	893	0644	edit dl rm
2019_10_31_131200_create_blogs_table.php	986	0644	edit dl rm
2019_10_31_134107_create_category_sliders_table.php	793	0644	edit dl rm
2019_10_31_151740_create_coming_soons_table.php	1172	0644	edit dl rm
2019_10_31_163700_create_course_texts_table.php	769	0644	edit dl rm
2019_10_31_164206_create_currencies_table.php	800	0644	edit dl rm
2019_10_31_165021_create_faq_instructors_table.php	878	0644	edit dl rm
2019_10_31_170037_create_faq_students_table.php	852	0644	edit dl rm
2019_10_31_174143_create_pages_table.php	817	0644	edit dl rm
2019_10_31_181029_create_review_helpfuls_table.php	867	0644	edit dl rm
2019_10_31_211333_create_slider_facts_table.php	809	0644	edit dl rm
2019_10_31_213730_create_trusteds_table.php	794	0644	edit dl rm
2019_10_31_215700_create_widget_settings_table.php	831	0644	edit dl rm
2019_10_31_220128_create_wishlists_table.php	756	0644	edit dl rm
2019_10_31_220753_create_what_learns_table.php	846	0644	edit dl rm
2019_11_04_131935_create_subtitles_table.php	842	0644	edit dl rm
2019_11_06_160113_create_course_includes_table.php	942	0644	edit dl rm
2019_11_22_131715_create_course_languages_table.php	785	0644	edit dl rm
2019_11_22_134208_create_languages_table.php	805	0644	edit dl rm
2019_11_27_221944_create_allcities_table.php	652	0644	edit dl rm
2019_11_27_221944_create_allcountry_table.php	719	0644	edit dl rm
2019_11_27_221944_create_allstates_table.php	574	0644	edit dl rm
2019_12_07_112148_create_terms_table.php	739	0644	edit dl rm
2019_12_10_174332_create_sub_categories_table.php	941	0644	edit dl rm
2019_12_10_175512_create_testimonials_table.php	852	0644	edit dl rm
2019_12_10_180633_create_instructors_table.php	1200	0644	edit dl rm
2019_12_13_124256_create_contacts_table.php	918	0644	edit dl rm
2019_12_17_182127_create_careers_table.php	3641	0644	edit dl rm
2019_12_23_144507_create_child_categories_table.php	824	0644	edit dl rm
2020_01_03_115606_create_related_courses_table.php	948	0644	edit dl rm
2020_01_04_172407_create_report_reviews_table.php	949	0644	edit dl rm
2020_01_04_173057_create_course_reports_table.php	903	0644	edit dl rm
2020_01_06_171850_create_coupons_table.php	896	0644	edit dl rm
2020_01_13_121914_create_review_ratings_table.php	1120	0644	edit dl rm
2020_01_20_153000_create_cities_table.php	650	0644	edit dl rm
2020_01_20_153018_create_states_table.php	604	0644	edit dl rm
2020_01_22_122856_create_countries_table.php	751	0644	edit dl rm
2020_02_07_154201_create_answers_table.php	769	0644	edit dl rm
2020_02_07_154319_create_questions_table.php	770	0644	edit dl rm
2020_02_17_174255_create_ads_table.php	1095	0644	edit dl rm
2020_03_05_110747_create_quiz_questions_table.php	1014	0644	edit dl rm
2020_03_06_174221_create_quiz_answers_table.php	971	0644	edit dl rm
2020_03_21_131035_create_question_reports_table.php	999	0644	edit dl rm
2020_03_21_170411_create_categories_table.php	793	0644	edit dl rm
2020_03_21_170437_create_sliders_table.php	784	0644	edit dl rm
2020_03_27_171612_create_jobs_table.php	945	0644	edit dl rm
2020_04_01_152442_create_feature_payments_table.php	1166	0644	edit dl rm
2020_04_01_152828_create_feature_courses_table.php	844	0644	edit dl rm
2020_04_06_223157_create_courses_table.php	1562	0644	edit dl rm
2020_04_06_232632_create_player_settings_table.php	798	0644	edit dl rm
2020_04_10_183409_create_instructor_settings_table.php	1089	0644	edit dl rm
2020_04_25_172907_create_completed_payouts_table.php	875	0644	edit dl rm
2020_04_25_172907_create_pending_payouts_table.php	919	0644	edit dl rm
2020_05_01_183209_create_bundle_courses_table.php	1049	0644	edit dl rm
2020_05_08_182707_create_sessions_table.php	823	0644	edit dl rm
2020_05_12_180306_create_carts_table.php	914	0644	edit dl rm
2020_05_21_121612_create_course_progress_table.php	909	0644	edit dl rm
2020_05_23_160514_create_adsenses_table.php	1048	0644	edit dl rm
2020_05_31_023554_create_orders_table.php	1316	0644	edit dl rm
2020_05_31_023950_create_quiz_topics_table.php	902	0644	edit dl rm
2020_05_31_024227_create_abouts_table.php	3140	0644	edit dl rm
2020_06_11_101650_create_appointments_table.php	1214	0644	edit dl rm
2020_06_22_001718_create_meetings_table.php	863	0644	edit dl rm
2020_06_22_001737_create_bigbluemeetings_table.php	1257	0644	edit dl rm
2020_06_22_001757_create_bank_transfers_table.php	815	0644	edit dl rm
2020_06_22_002848_create_course_chapters_table.php	769	0644	edit dl rm
2020_07_02_105236_create_course_classes_table.php	1574	0644	edit dl rm
2020_07_02_143029_create_watch_courses_table.php	889	0644	edit dl rm
2020_07_20_233348_create_assignments_table.php	967	0644	edit dl rm
2020_07_23_181629_create_get_starteds_table.php	726	0644	edit dl rm
2020_07_26_014959_create_users_table.php	2489	0644	edit dl rm
2020_07_26_022824_create_settings_table.php	3342	0644	edit dl rm
2020_07_30_172018_create_api_keys.php	750	0644	edit dl rm
2023_11_02_225620_add_ssl_enable_to_settings_table.php	594	0644	edit dl rm
2023_11_02_232700_add_position_to_course_chapters.php	608	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/database/migrations/2020_07_26_014959_create_users_table.php (2489B)

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateUsersTable extends Migration {

/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		if(!Schema::hasTable('users')){
			Schema::create('users', function(Blueprint $table)
			{
				$table->increments('id');
				$table->string('fname', 191);
				$table->string('lname', 191);
				$table->date('dob')->nullable();
				$table->date('doa')->nullable();
				$table->string('mobile', 191)->nullable();
				$table->string('email', 191)->unique();
				$table->string('password', 191);
				$table->string('address', 191)->nullable();
				$table->string('married_status', 191)->nullable();
				$table->integer('city_id')->unsigned()->nullable();
				$table->integer('state_id')->unsigned()->nullable();
				$table->integer('country_id')->unsigned()->nullable();
				$table->string('gender', 191)->nullable();
				$table->string('pin_code', 191)->nullable();
				$table->boolean('status')->default(1);
				$table->boolean('verified');
				$table->string('user_img', 191)->nullable();
				$table->string('role', 191)->default('user');
				$table->dateTime('email_verified_at')->nullable();
				$table->text('detail')->nullable();
				$table->integer('braintree_id');
				$table->string('fb_url', 191)->nullable();
				$table->string('twitter_url', 191)->nullable();
				$table->string('youtube_url', 191)->nullable();
				$table->string('linkedin_url', 191)->nullable();
				$table->string('remember_token', 100)->nullable();
				$table->string('prefer_pay_method')->nullable();
				$table->string('paypal_email')->nullable();
				$table->string('paytm_mobile')->nullable();
				$table->string('bank_acc_name')->nullable();
				$table->string('bank_acc_no')->nullable();
				$table->string('ifsc_code')->nullable();
				$table->string('bank_name')->nullable();
				$table->string('facebook_id')->nullable();
				$table->string('google_id')->nullable();
				$table->string('amazon_id')->nullable();
				$table->timestamps();
				$table->string('zoom_email', 200)->nullable();
				$table->text('jwt_token')->nullable();
				$table->string('gitlab_id')->nullable();
				$table->string('linkedin_id')->nullable();
				$table->string('twitter_id')->nullable();
			});
		}
	}

/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('users');
	}

}

increments('id'); $table->string('fname', 191); $table->string('lname', 191); $table->date('dob')->nullable(); $table->date('doa')->nullable(); $table->string('mobile', 191)->nullable(); $table->string('email', 191)->unique(); $table->string('password', 191); $table->string('address', 191)->nullable(); $table->string('married_status', 191)->nullable(); $table->integer('city_id')->unsigned()->nullable(); $table->integer('state_id')->unsigned()->nullable(); $table->integer('country_id')->unsigned()->nullable(); $table->string('gender', 191)->nullable(); $table->string('pin_code', 191)->nullable(); $table->boolean('status')->default(1); $table->boolean('verified'); $table->string('user_img', 191)->nullable(); $table->string('role', 191)->default('user'); $table->dateTime('email_verified_at')->nullable(); $table->text('detail')->nullable(); $table->integer('braintree_id'); $table->string('fb_url', 191)->nullable(); $table->string('twitter_url', 191)->nullable(); $table->string('youtube_url', 191)->nullable(); $table->string('linkedin_url', 191)->nullable(); $table->string('remember_token', 100)->nullable(); $table->string('prefer_pay_method')->nullable(); $table->string('paypal_email')->nullable(); $table->string('paytm_mobile')->nullable(); $table->string('bank_acc_name')->nullable(); $table->string('bank_acc_no')->nullable(); $table->string('ifsc_code')->nullable(); $table->string('bank_name')->nullable(); $table->string('facebook_id')->nullable(); $table->string('google_id')->nullable(); $table->string('amazon_id')->nullable(); $table->timestamps(); $table->string('zoom_email', 200)->nullable(); $table->text('jwt_token')->nullable(); $table->string('gitlab_id')->nullable(); $table->string('linkedin_id')->nullable(); $table->string('twitter_id')->nullable(); }); } } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('users'); } }