mysql> show create table g2_DescendentCountsMap; +------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | g2_DescendentCountsMap | CREATE TABLE `g2_DescendentCountsMap` ( `g_userId` int(11) NOT NULL, `g_itemId` int(11) NOT NULL, `g_descendentCount` int(11) NOT NULL, PRIMARY KEY (`g_userId`,`g_itemId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | +------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)