Thread: TBDev09 (2020)
View Single Post
  #18  
Old 11th May 2020, 21:56
iseeyoucopy iseeyoucopy is offline
VIP
 
Join Date: Jan 2011
P2P
Posts: 28
Default
Quote:
Originally Posted by Asterix View Post
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:
`birthdaydate NOT NULL DEFAULT '1920-01-01'
Reply With Quote