Creation of mysql table for extension

[mgabud]

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:

$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:

ALTER TABLE `tl_table` CHANGE `userId` `userId` INT(11) NOT NULL default 0;

Any suggestions what am I doing wrong?

[lucina]

Probably you have to enter it this way:

int(11)NOTNULLdefault'0',

For specific examples how to create your SQL statements you may have a look at the (german) wiki.

[BugBuster]

I use this:

    'sql'           => "int(10) unsigned NOT NULL default '0'"