On 3/9/06, Keegan Quinn <keegan@thebasement.org > wrote:

On Thu, Mar 09, 2006 at 05:37:06AM -0500, Dan Ziemecki wrote:
> Can I get one of you postgre aficionados to translate this SQL statement
> into whatever works on postgre for me?

Yeah.

> DROP TABLE IF EXISTS subscriptions_holding;

Not sure about that "if exists" clause.

DROP TABLE subscriptions_holding; works though.

> 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')
> );

CREATE TABLE subscriptions_holding (
  rid SERIAL,
  content OID NOT NULL,
  type TEXT NOT NULL,
  op TEXT NOT NULL,
  uid INTEGER NOT NULL DEFAULT 0
);
COMMENT ON COLUMN subscriptions_holding.rid IS 'Unique row ID';
COMMENT ON COLUMN subscriptions_holding.content IS 'The node array';
COMMENT ON COLUMN subscriptions_holding.type IS 'New node or comment';
COMMENT ON COLUMN subscriptions_holding.op IS 'The operation on the node';
COMMENT ON COLUMN subscriptions_holding.uid IS 'The person performing the operation';

Tested on PostgreSQL 7.4.

HTH,

--
Keegan Quinn  <keegan@thebasement.org>
CEO, Producer
the basement productions
http://www.thebasement.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFEEAd1RMUr35HwZXoRAvnhAJ9GplHEFxZllWJxzkklWMdA9kEFegCdHUy+
9MqSltxpHgT7J5RvSM3c3CE=
=mfL1
-----END PGP SIGNATURE-----