-- Upgrade: schema_version 5 to 6
--

CREATE TABLE trusted_external_ids
(id_pattern VARCHAR(255) NOT NULL
,PRIMARY KEY (id_pattern)
) WITHOUT OIDS;

INSERT INTO trusted_external_ids VALUES ('http://');
INSERT INTO trusted_external_ids VALUES ('https://');
INSERT INTO trusted_external_ids VALUES ('https://www.google.com/accounts/o8/id?id=');

UPDATE schema_version SET version_nbr = 6;