PCAction | CREATE TABLE `PCAction` ( `EventId` int(11) unsigned NOT NULL, `ActionId` int(12) unsigned NOT NULL auto_increment, `Type` varchar(40) NOT NULL default 'PCAction', `SortOrder` int(5) unsigned NOT NULL default '0', `OptionMapId` int(10) unsigned default NULL, KEY `EventId` (`EventId`,`ActionId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 mysql> select * from PCAction; +---------+----------+---------------+-----------+-------------+ | EventId | ActionId | Type | SortOrder | OptionMapId | +---------+----------+---------------+-----------+-------------+ | 1 | 1 | PCActionVUser | 1 | 1 | +---------+----------+---------------+-----------+-------------+ 1 row in set (0.00 sec) mysql> insert into PCAction set EventId = 2, Type = 'PCActionAccount'; Query OK, 1 row affected (0.00 sec) mysql> select * from PCAction; +---------+----------+-----------------+-----------+-------------+ | EventId | ActionId | Type | SortOrder | OptionMapId | +---------+----------+-----------------+-----------+-------------+ | 1 | 1 | PCActionVUser | 1 | 1 | | 2 | 1 | PCActionAccount | 0 | NULL | +---------+----------+-----------------+-----------+-------------+ 2 rows in set (0.00 sec)