Change tinyint default value into 1 mysql

You can do so

ALTER TABLE `table_name` CHANGE `column_name` `column_name` TINYINT(4) DEFAULT 1 NOT NULL;

mysql database tinyint

ALTER TABLE MyTable MODIFY COLUMN col TINYINT NOT NULL DEFAULT 1;

mysql database tinyint

Try this

ALTER TABLE `Type` CHANGE `status` `status` tinyint(4) NOT NULL DEFAULT '1'

CodeHunter