~~~The table sql statments can't be edited into previous snippet, so paste here

*** table (the following tables have been splited up into 2 tables to use i18n, but the above code doesn't, so either merge these two tables into 1, or setCulture() in above action.class.php code):

-- 
-- Table structure for table `category`
-- 
 
CREATE TABLE `category` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `category_FI_1` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;
 
-- 
-- Dumping data for table `category`
-- 
 
INSERT INTO `category` VALUES (1, NULL);
INSERT INTO `category` VALUES (2, NULL);
INSERT INTO `category` VALUES (3, NULL);
INSERT INTO `category` VALUES (4, NULL);
INSERT INTO `category` VALUES (5, NULL);
INSERT INTO `category` VALUES (6, NULL);
INSERT INTO `category` VALUES (7, NULL);
INSERT INTO `category` VALUES (8, 1);
INSERT INTO `category` VALUES (9, 1);
INSERT INTO `category` VALUES (10, 1);
INSERT INTO `category` VALUES (11, 1);
INSERT INTO `category` VALUES (12, 1);
INSERT INTO `category` VALUES (13, 2);
INSERT INTO `category` VALUES (14, 2);
INSERT INTO `category` VALUES (15, 2);
INSERT INTO `category` VALUES (16, 2);
INSERT INTO `category` VALUES (17, 2);
INSERT INTO `category` VALUES (18, 3);
INSERT INTO `category` VALUES (19, 3);
INSERT INTO `category` VALUES (20, 3);
INSERT INTO `category` VALUES (21, 3);
INSERT INTO `category` VALUES (22, 3);
INSERT INTO `category` VALUES (23, 4);
INSERT INTO `category` VALUES (24, 4);
INSERT INTO `category` VALUES (25, 4);
INSERT INTO `category` VALUES (26, 4);
INSERT INTO `category` VALUES (27, 4);
INSERT INTO `category` VALUES (28, 5);
INSERT INTO `category` VALUES (29, 5);
INSERT INTO `category` VALUES (30, 5);
INSERT INTO `category` VALUES (31, 5);
INSERT INTO `category` VALUES (32, 5);
INSERT INTO `category` VALUES (33, 6);
INSERT INTO `category` VALUES (34, 6);
INSERT INTO `category` VALUES (35, 6);
INSERT INTO `category` VALUES (36, 6);
INSERT INTO `category` VALUES (37, 6);
INSERT INTO `category` VALUES (38, 7);
INSERT INTO `category` VALUES (39, 7);
INSERT INTO `category` VALUES (40, 7);
INSERT INTO `category` VALUES (41, 7);
INSERT INTO `category` VALUES (42, 7);
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `category_i18n`
-- 
 
CREATE TABLE `category_i18n` (
  `id` int(11) NOT NULL,
  `culture` varchar(7) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
  `description` varchar(500) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`,`culture`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- 
-- Dumping data for table `category_i18n`
-- 
 
INSERT INTO `category_i18n` VALUES (1, 'en', 'German', 'description of German');
INSERT INTO `category_i18n` VALUES (1, 'zh', 'DeGuo', 'DeGuo MiaoShu');
INSERT INTO `category_i18n` VALUES (2, 'en', 'France', 'description of France');
INSERT INTO `category_i18n` VALUES (2, 'zh', 'FaGuo', 'FaGuo MiaoShu');
INSERT INTO `category_i18n` VALUES (3, 'en', 'Argentina', 'description of Argentina');
INSERT INTO `category_i18n` VALUES (3, 'zh', 'AGenTing', 'AGenTing MiaoShu');
INSERT INTO `category_i18n` VALUES (4, 'en', 'Australia', 'description of Australia');
INSERT INTO `category_i18n` VALUES (4, 'zh', 'AoDaLiYa', 'AoDaLiYa MiaoShu');
INSERT INTO `category_i18n` VALUES (5, 'en', 'Brazia', 'description of Brazia');
INSERT INTO `category_i18n` VALUES (5, 'zh', 'BaXi', 'BaXi MiaoShu');
INSERT INTO `category_i18n` VALUES (6, 'en', 'Greece', 'description of Greece');
INSERT INTO `category_i18n` VALUES (6, 'zh', 'XiLa', 'XiLa MiaoShu');
INSERT INTO `category_i18n` VALUES (7, 'en', 'England', 'description of England');
INSERT INTO `category_i18n` VALUES (7, 'zh', 'YingGeLan', 'YingGeLan MiaoShu');
INSERT INTO `category_i18n` VALUES (8, 'en', 'Team1.DE', 'description of Team1.DE');
INSERT INTO `category_i18n` VALUES (8, 'zh', 'ZhuQiuDui1.DeGuo', 'MiaoShu ZhuQiuDui1.DeGuo');
INSERT INTO `category_i18n` VALUES (9, 'en', 'Team2.DE', 'description of Team2.DE');
INSERT INTO `category_i18n` VALUES (9, 'zh', 'ZhuQiuDui2.DeGuo', 'MiaoShu ZhuQiuDui2.DeGuo');
INSERT INTO `category_i18n` VALUES (10, 'en', 'Team3.DE', 'description of Team3.DE');
INSERT INTO `category_i18n` VALUES (10, 'zh', 'ZhuQiuDui3.DeGuo', 'MiaoShu ZhuQiuDui3.DeGuo');
INSERT INTO `category_i18n` VALUES (11, 'en', 'Team4.DE', 'description of Team4.DE');
INSERT INTO `category_i18n` VALUES (11, 'zh', 'ZhuQiuDui4.DeGuo', 'MiaoShu ZhuQiuDui4.DeGuo');
INSERT INTO `category_i18n` VALUES (12, 'en', 'Team5.DE', 'description of Team5.DE');
INSERT INTO `category_i18n` VALUES (12, 'zh', 'ZhuQiuDui5.DeGuo', 'MiaoShu ZhuQiuDui5.DeGuo');
INSERT INTO `category_i18n` VALUES (13, 'en', 'Team1.Fr', 'description of Team1.Fr');
INSERT INTO `category_i18n` VALUES (13, 'zh', 'ZhuQiuDui1.FaGuo', 'MiaoShu ZhuQiuDui1.FaGuo');
INSERT INTO `category_i18n` VALUES (14, 'en', 'Team2.Fr', 'description of Team2.Fr');
INSERT INTO `category_i18n` VALUES (14, 'zh', 'ZhuQiuDui2.FaGuo', 'MiaoShu ZhuQiuDui2.FaGuo');
INSERT INTO `category_i18n` VALUES (15, 'en', 'Team3.Fr', 'description of Team3.Fr');
INSERT INTO `category_i18n` VALUES (15, 'zh', 'ZhuQiuDui3.FaGuo', 'MiaoShu ZhuQiuDui3.FaGuo');
INSERT INTO `category_i18n` VALUES (16, 'en', 'Team4.Fr', 'description of Team4.Fr');
INSERT INTO `category_i18n` VALUES (16, 'zh', 'ZhuQiuDui4.FaGuo', 'MiaoShu ZhuQiuDui4.FaGuo');
INSERT INTO `category_i18n` VALUES (17, 'en', 'Team5.Fr', 'description of Team5.Fr');
INSERT INTO `category_i18n` VALUES (17, 'zh', 'ZhuQiuDui5.FaGuo', 'MiaoShu ZhuQiuDui5.FaGuo');
INSERT INTO `category_i18n` VALUES (18, 'en', 'Team1.AR', 'description of Team1.AR');
INSERT INTO `category_i18n` VALUES (18, 'zh', 'ZhuQiuDui1.AGenTing', 'MiaoShu ZhuQiuDui1.AGenTing');
INSERT INTO `category_i18n` VALUES (19, 'en', 'Team2.AR', 'description of Team2.AR');
INSERT INTO `category_i18n` VALUES (19, 'zh', 'ZhuQiuDui2.AGenTing', 'MiaoShu ZhuQiuDui2.AGenTing');
INSERT INTO `category_i18n` VALUES (20, 'en', 'Team3.AR', 'description of Team3.AR');
INSERT INTO `category_i18n` VALUES (20, 'zh', 'ZhuQiuDui3.AGenTing', 'MiaoShu ZhuQiuDui3.AGenTing');
INSERT INTO `category_i18n` VALUES (21, 'en', 'Team4.AR', 'description of Team4.AR');
INSERT INTO `category_i18n` VALUES (21, 'zh', 'ZhuQiuDui4.AGenTing', 'MiaoShu ZhuQiuDui4.AGenTing');
INSERT INTO `category_i18n` VALUES (22, 'en', 'Team5.AR', 'description of Team5.AR');
INSERT INTO `category_i18n` VALUES (22, 'zh', 'ZhuQiuDui5.AGenTing', 'MiaoShu ZhuQiuDui5.AGenTing');
INSERT INTO `category_i18n` VALUES (23, 'en', 'Team1.AU', 'description of Team1.AU');
INSERT INTO `category_i18n` VALUES (23, 'zh', 'ZhuQiuDui1.AoDaLiYa', 'MiaoShu ZhuQiuDui1.AoDaLiYa');
INSERT INTO `category_i18n` VALUES (24, 'en', 'Team2.AU', 'description of Team2.AU');
INSERT INTO `category_i18n` VALUES (24, 'zh', 'ZhuQiuDui2.AoDaLiYa', 'MiaoShu ZhuQiuDui2.AoDaLiYa');
INSERT INTO `category_i18n` VALUES (25, 'en', 'Team3.AU', 'description of Team3.AU');
INSERT INTO `category_i18n` VALUES (25, 'zh', 'ZhuQiuDui3.AoDaLiYa', 'MiaoShu ZhuQiuDui3.AoDaLiYa');
INSERT INTO `category_i18n` VALUES (26, 'en', 'Team4.AU', 'description of Team4.AU');
INSERT INTO `category_i18n` VALUES (26, 'zh', 'ZhuQiuDui4.AoDaLiYa', 'MiaoShu ZhuQiuDui4.AoDaLiYa');
INSERT INTO `category_i18n` VALUES (27, 'en', 'Team5.AU', 'description of Team5.AU');
INSERT INTO `category_i18n` VALUES (27, 'zh', 'ZhuQiuDui5.AoDaLiYa', 'MiaoShu ZhuQiuDui5.AoDaLiYa');
INSERT INTO `category_i18n` VALUES (28, 'en', 'Team1.BR', 'description of Team1.BR');
INSERT INTO `category_i18n` VALUES (28, 'zh', 'ZhuQiuDui1.BaXi', 'MiaoShu ZhuQiuDui1.BaXi');
INSERT INTO `category_i18n` VALUES (29, 'en', 'Team2.BR', 'description of Team2.BR');
INSERT INTO `category_i18n` VALUES (29, 'zh', 'ZhuQiuDui2.BaXi', 'MiaoShu ZhuQiuDui2.BaXi');
INSERT INTO `category_i18n` VALUES (30, 'en', 'Team3.BR', 'description of Team3.BR');
INSERT INTO `category_i18n` VALUES (30, 'zh', 'ZhuQiuDui3.BaXi', 'MiaoShu ZhuQiuDui3.BaXi');
INSERT INTO `category_i18n` VALUES (31, 'en', 'Team4.BR', 'description of Team4.BR');
INSERT INTO `category_i18n` VALUES (31, 'zh', 'ZhuQiuDui4.BaXi', 'MiaoShu ZhuQiuDui4.BaXi');
INSERT INTO `category_i18n` VALUES (32, 'en', 'Team5.BR', 'description of Team5.BR');
INSERT INTO `category_i18n` VALUES (32, 'zh', 'ZhuQiuDui5.BaXi', 'MiaoShu ZhuQiuDui5.BaXi');
INSERT INTO `category_i18n` VALUES (33, 'en', 'Team1.GR', 'description of Team1.GR');
INSERT INTO `category_i18n` VALUES (33, 'zh', 'ZhuQiuDui1.XiLa', 'MiaoShu ZhuQiuDui1.XiLa');
INSERT INTO `category_i18n` VALUES (34, 'en', 'Team2.GR', 'description of Team2.GR');
INSERT INTO `category_i18n` VALUES (34, 'zh', 'ZhuQiuDui2.XiLa', 'MiaoShu ZhuQiuDui2.XiLa');
INSERT INTO `category_i18n` VALUES (35, 'en', 'Team3.GR', 'description of Team3.GR');
INSERT INTO `category_i18n` VALUES (35, 'zh', 'ZhuQiuDui3.XiLa', 'MiaoShu ZhuQiuDui3.XiLa');
INSERT INTO `category_i18n` VALUES (36, 'en', 'Team4.GR', 'description of Team4.GR');
INSERT INTO `category_i18n` VALUES (36, 'zh', 'ZhuQiuDui4.XiLa', 'MiaoShu ZhuQiuDui4.XiLa');
INSERT INTO `category_i18n` VALUES (37, 'en', 'Team5.GR', 'description of Team5.GR');
INSERT INTO `category_i18n` VALUES (37, 'zh', 'ZhuQiuDui5.XiLa', 'MiaoShu ZhuQiuDui5.XiLa');
INSERT INTO `category_i18n` VALUES (38, 'en', 'Team1.EN', 'description of Team1.EN');
INSERT INTO `category_i18n` VALUES (38, 'zh', 'ZhuQiuDui1.YingGeLan', 'MiaoShu ZhuQiuDui1.YingGeLan');
INSERT INTO `category_i18n` VALUES (39, 'en', 'Team2.EN', 'description of Team2.EN');
INSERT INTO `category_i18n` VALUES (39, 'zh', 'ZhuQiuDui2.YingGeLan', 'MiaoShu ZhuQiuDui2.YingGeLan');
INSERT INTO `category_i18n` VALUES (40, 'en', 'Team3.EN', 'description of Team3.EN');
INSERT INTO `category_i18n` VALUES (40, 'zh', 'ZhuQiuDui3.YingGeLan', 'MiaoShu ZhuQiuDui3.YingGeLan');
INSERT INTO `category_i18n` VALUES (41, 'en', 'Team4.EN', 'description of Team4.EN');
INSERT INTO `category_i18n` VALUES (41, 'zh', 'ZhuQiuDui4.YingGeLan', 'MiaoShu ZhuQiuDui4.YingGeLan');
INSERT INTO `category_i18n` VALUES (42, 'en', 'Team5.EN', 'description of Team5.EN');
INSERT INTO `category_i18n` VALUES (42, 'zh', 'ZhuQiuDui5.YingGeLan', 'MiaoShu ZhuQiuDui5.YingGeLan');