Models tables SQL

CREATE TABLE `my_module1_table_item` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`public` tinyint(3) unsigned NOT NULL DEFAULT '1',
`lang` char(3) NOT NULL DEFAULT 'en',
`header` varchar(255) NOT NULL,
`announce` text NOT NULL,
`body` mediumtext NOT NULL,
`date_created` datetime NOT NULL,
`date_modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `my_module1_table_item` VALUES ('1','1','en','hh','aaa','',NOW(),NULL);
CREATE TABLE `my_module2_table_cat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`public` tinyint(3) unsigned NOT NULL DEFAULT '1',
`lang` char(3) NOT NULL DEFAULT 'en',
`header` varchar(255) NOT NULL,
`announce` text NOT NULL,
`body` mediumtext NOT NULL,
`date_created` datetime NOT NULL,
`date_modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `my_module2_table_cat` VALUES ('1','1','en','First category','','',NOW(),NULL);
INSERT INTO `my_module2_table_cat` VALUES ('2','1','en','Second category','','',NOW(),NULL);
CREATE TABLE `my_module2_table_item` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_cat` int(10) unsigned NOT NULL DEFAULT '0',
`public` tinyint(3) unsigned NOT NULL DEFAULT '1',
`lang` char(3) NOT NULL DEFAULT 'en',
`header` varchar(255) NOT NULL,
`announce` text NOT NULL,
`body` mediumtext NOT NULL,
`date_created` datetime NOT NULL,
`date_modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
INSERT INTO `my_module2_table_item` VALUES ('1','1','1','en','Item 1','','',now(),now());
INSERT INTO `my_module2_table_item` VALUES ('2','2','1','en','Item 2','','',now(),now());