Quote:
Originally Posted by Asterix
True.
but on tbdev database on table users column
`birthday` date DEFAULT '0000-00-00',
when insert the database it gives a column with null=yes default 000-00-00.
i suposse corect will be
`birthday` date NOT NULL DEFAULT '1920-01-01',
|
sorry forgot to mention but in my case and in that database it was already set to not null, and i just change default value, it doesn't have to touch NOT NULL because already was set
and yes you have right , the line in sql need to be changed with that
PHP Code:
`birthday` date NOT NULL DEFAULT '1920-01-01',