Unnamed

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)