Could someone tell me the SQL for an equivalent table in PostgreSQL?
CREATE TABLE palm_addressbook (
cal_id int(11) NOT NULL default '0',
account_id int(11) NOT NULL default '0',
palm_rec_id int(11) NOT NULL default '0',
PRIMARY KEY (cal_id,account_id),
UNIQUE KEY account_id (account_id,palm_rec_id)
) TYPE=MyISAM;
I think it would be
CREATE TABLE palm_addressbook (
cal_id int4 NOT NULL default '0',
account_id int4 NOT NULL default '0',
palm_rec_id int4 NOT NULL default '0',
PRIMARY KEY (cal_id,account_id)
);