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, index (EventId, ActionId) ); insert into PCAction set EventId = 2, Type = 'PCActionAccount';