Convert from Mysql to Postgresql - Mailing list pgsql-novice

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