Details
Details
- Reviewers
dereckson - Maniphest Tasks
- T830: Start user accounts ID with a large value
- Commits
- rGROVE8de37f6f70c0: Start user accounts ID with a large value
- php artisan migrate
- Ensure auto increment value is now gigantic
- Rollback
- Ensure auto increment value is the last user id value + 1.
Diff Detail
Diff Detail
- Repository
- rGROVE Auth Grove
- Lint
Lint Not Applicable - Unit
Tests Not Applicable
Event Timeline
Comment Actions
Migrate test
$ php artisan migrate Migrated: 2016_05_21_224200_set_users_table_auto_increment $ php artisan tinker >>> DB::select("SHOW CREATE TABLE users"); => [ {#698 +"Table": "users" +"Create Table": """ CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `fullname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=1000000000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci""" } ]
Rollback test
$ composer dump-autoload $ php artisan migrate:rollback Rolled back: 2016_05_21_224200_set_users_table_auto_increment $ php artisan tinker >>> DB::select("SHOW CREATE TABLE users"); => [ {#696 +"Table": "users" +"Create Table": """ CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `fullname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci""" } ]