MySQL for transformer_macro and [#108830]

Here is the MySQL for the macro table.

CREATE TABLE `transformer_macro` (
  `macro_id` int(10) unsigned NOT NULL auto_increment,
  `macro_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`macro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Here is the queue table with three extras fields.

CREATE TABLE `transformer_queue` (
  `transformer_queue_id` int(10) unsigned NOT NULL default '0',
  `macro_id` int(10) unsigned NOT NULL default '0',
  `priority` int(11) NOT NULL default '0',
  `src` text NOT NULL,
  `dst` text NOT NULL,
  `attempts` smallint(5) unsigned NOT NULL default '0',
  `last_exec` int(10) unsigned NOT NULL default '0',
  `message` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I'll submit patches for 5.0 and queue changes soon.

Comments

Comment #1

sime

any/any

Melbourne

commented 12 January 2007 at 14:59

transformer_transform was missing a few as well

CREATE TABLE `transformer_transform` (
  `transform_id` int(10) unsigned NOT NULL default '0',
  `macro_id` int(10) unsigned NOT NULL default '0',
  `weight` int(10) NOT NULL default '0',
  `data` text NOT NULL,
  `base` text NOT NULL,
  `macro` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`transform_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;