All pastes #835049 Raw Edit

Unnamed

public text v1 · immutable
#835049 ·published 2007-12-28 17:33 UTC
rendered paste body
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

insert into PCAction set EventId = 2, Type = 'PCActionAccount';