when altering the database table error displays – 1067 – Invalid default value for ‘time’
Solution is : There might be a datetime field with Null and default value 0000-00-00 00:00:00.
change the datetime field Null uncheck and default value None
Thus you can alter the database now for other field add, remove and further operations.