postgresql patch for accounttypes.install

Here are the install commands for postgresql. They work for me so far. (Not a postgresql expert)

$query1 = db_query("CREATE TABLE {accounttypes} (
atid SERIAL PRIMARY KEY,
name varchar(64) NOT NULL,
UNIQUE (name)
)");

$query2 = db_query("CREATE TABLE {accounttypes_roles} (
atid int NOT NULL default '0',
rid int NOT NULL default '0',
initial smallint NOT NULL default '0',
PRIMARY KEY (atid, rid)
)");

$query3 = db_query("CREATE TABLE {accounttypes_users} (
uid int NOT NULL default '0',
atid int NOT NULL default '0',
PRIMARY KEY (uid)
)");