Hi,
I have to create mysql table for extension I'm working on. First I defined table in database.sql file and contao created table without any problems but after creating table it reports that all fields in the table need to be altered. But all changes it suggest wouldn't change anything.
I got suggestion to try defining table in dca but everytinhg stayed the same.
This is the sample code from dca:
Code:
$GLOBALS['TL_DCA']['tl_table']['fields']['userId'] = array
(
'sql' => "INT(11) NOT NULL default 0"
);
This is what I get when I go to extension manager -> update database:
Code:
ALTER TABLE `tl_table` CHANGE `userId` `userId` INT(11) NOT NULL default 0;
Any suggestions what am I doing wrong?
Bookmarks