Currently my migration:
$table->string('avatar');
$table->boolean('online')->default(0);
$table->boolean('adult')->default(0);
In the schema : Generated schema for migration
Asked
Active
Viewed 4,350 times
0
user2632863
- 7
- 1
- 3
-
most of the database systems do not have `boolean` type and thus Laravel use tinyInt with a single byte of data allowing only `0` or `1` where 0 means false and 1 means true. its not an error, but the expected result. this is how many of these database system works. – Pusparaj Jan 09 '20 at 07:06
-
@Pusparaj this should be an answer – Fitzi Jan 09 '20 at 08:17
-
Does this answer your question? [Which MySQL data type to use for storing boolean values](https://stackoverflow.com/questions/289727/which-mysql-data-type-to-use-for-storing-boolean-values) – Clément Baconnier Jan 09 '20 at 08:20
-
@cbaconnier: Yeah, you are right. This make sense :). Thanks – user2632863 Jan 09 '20 at 11:04
-
@Pusparaj: Thanks for you answer – user2632863 Jan 31 '20 at 15:08
-
@cbaconnier: Thanks for answering – user2632863 Jan 31 '20 at 15:08
1 Answers
1
Schema::table('tablename', function ($table) {
$table->tinyInteger('online')->change();
});
Chinnu
- 61
- 8
-
Please put your answer always in context instead of just pasting code. See [here](https://stackoverflow.com/help/how-to-answer) for more details. – gehbiszumeis Jan 09 '20 at 10:19