[development] A little pgsql help

Dan Ziemecki dan at ziemecki.com
Thu Mar 9 10:37:06 UTC 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20060309/1c1c39fb/attachment.htm


More information about the development mailing list