CREATE TABLE `test_table` ( `id` int(9) unsigned zerofill NOT NULL auto_increment, `admin_user_id` int(9) unsigned zerofill NOT NULL default '000000000', `setting_key` varchar(255) NOT NULL default '', `setting_value` varchar(255) NOT NULL default '', `updated` timestamp(14) NOT NULL, `created` timestamp(14) NOT NULL, PRIMARY KEY (`id`), KEY `FOREIGN_TEST` (`admin_user_id`) ) TYPE=MyISAM;