[development] A little pgsql help

9 Mar 2006

      Can I get one of you postgre aficionados to translate this SQL statement
into whatever works on postgre for me?

DROP TABLE IF EXISTS subscriptions_holding;
CREATE TABLE subscriptions_holding (
  rid int(11) NOT NULL auto_increment COMMENT 'Unique row ID',
  content blob NOT NULL COMMENT 'The node array',
  type tinytext NOT NULL COMMENT 'New node or comment',
  op tinytext NOT NULL COMMENT 'The operation on the node',
  uid int(11) NOT NULL default '0' COMMENT 'The person performing the
operation',
  PRIMARY KEY  ('rid')
);

I'm implementing cron initiated mailings for the Subscriptions module.

Thanks,

--
Dan Ziemecki