CREATE TABLE `operation` (
  `id` int( 10 ) unsigned NOT NULL auto_increment,
  `class` char( 16 ) NOT NULL default '',   // это название второй таблицы (egold, webmoney, ...)
  `payer` char( 128 ) NOT NULL default '',
  `payee` char( 128 ) NOT NULL default '',
  `amount` decimal( 8 , 2 ) NOT NULL default '0.00',
  `stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `batch` char( 128 ) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;
CREATE TABLE `operationEgold` (
  `id` int( 10 ) unsigned NOT NULL default '0',
  `metal` char( 16 ) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `operation` (
  `id` int( 10 ) unsigned NOT NULL auto_increment,
  `payer` char( 128 ) NOT NULL default '',
  `payee` char( 128 ) NOT NULL default '',
  `amount` decimal( 8 , 2 ) NOT NULL default '0.00',
  `stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `batch` char( 128 ) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;
CREATE TABLE `operationExtra` (
  `id` int( 10 ) unsigned NOT NULL auto_increment,
  `operation` int( 10 ) unsigned NOT NULL default '0',
  `name` char( 32 ) NOT NULL default '',
  `value` char( 128 ) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `operation` (`operation`)
) TYPE=MyISAM;