A problem with AUTO INCREMENT:
This
CREATE TABLE IF NOT EXISTS `table_name` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
...
PRIMARY KEY (`id`)
);
Should become
CREATE TABLE IF NOT EXISTS `table_name` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
...
);
Not
CREATE TABLE IF NOT EXISTS `table_name` (
`id` INTEGER NOT NULL,
...
PRIMARY KEY (`id`)
);