Multiple Error IN DATABASE.PGSQL

a ";" missing line 503 in database.pgsql

Change

CREATE INDEX url_alias_src ON url_alias(src)

to

CREATE INDEX url_alias_src ON url_alias(src);

kinaï

To fix this problem, I think change below is needed :

line 703 :
CREATE INDEX users_changed_idx ON users(changed);
to
CREATE INDEX users_access_idx ON users(access);

because no column changed exist in users table. In database.mysql, Index is created on access column

--
-- Table structre for table 'contact'
--

CREATE TABLE contact (
subject varchar(255) NOT NULL default '',
recipients longtext NOT NULL default '',
reply longtext NOT NULL default ''
);

to

CREATE TABLE contact (
subject varchar(255) NOT NULL default '',
recipients text NOT NULL default '',
reply text NOT NULL default ''
);

because le longtext format don't exist on postgresql.

This change is right ?