 --
 -- Copyright 2008 IHE International (http://www.ihe.net)
 --
 -- Licensed under the Apache License, Version 2.0 (the "License");
 -- you may not use this file except in compliance with the License.
 -- You may obtain a copy of the License at
 --
 -- http://www.apache.org/licenses/LICENSE-2.0
 --
 -- Unless required by applicable law or agreed to in writing, software
 -- distributed under the License is distributed on an "AS IS" BASIS,
 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 --


INSERT INTO usr_address (id, last_changed, last_modifier_id, address, city, zip_code, state, phone, fax, address_type, country) VALUES (0, NULL, NULL, '', '', '', '', '', '', '', 'US');
INSERT INTO usr_address (id, address, city, zip_code, country, state, phone, fax, address_type) VALUES (1, 'INRIA/IRISA, Campus Universitaire de Beaulieu', 'Rennes Cedex', '35042', 'FR', '', '+33 299 847 456 ', '+33 299 847 171', '');

-- ACME addresses for production env
--INSERT INTO usr_address (id, last_changed, last_modifier_id, address, city, zip_code, state, phone, fax, address_type, country) VALUES (2, NULL, NULL, 'Campus universitaire A', 'Rennes', '35000', '', '+32 3 444  0000', '+32 3 444 1111', 'ACME', 'FR');
--INSERT INTO usr_address (id, last_changed, last_modifier_id, address, city, zip_code, state, phone, fax, address_type, country) VALUES (3, NULL, NULL, 'Campus universitaire B', 'St Louis', '63110', '', '+32 3 444  0000', '+32 3 444 1111', 'ACME', 'US');

-- Connectathon addresses
INSERT INTO usr_address (id, last_changed, last_modifier_id, address, city, zip_code, state, phone, fax, address_type, country) VALUES (4, NULL, NULL, 'The Remise', 'Vienna', '1110', 'Vienna', '0043 0 123 45 67 89', '0043 0 123 45 67 89', 'CONNECTATHON', 'AT');
INSERT INTO usr_address (id, last_changed, last_modifier_id, address, city, zip_code, state, phone, fax, address_type, country) VALUES (5, NULL, NULL, 'Hyatt Regency, East Wacker Dr', 'Chicago', '60601', 'IL', '+1 312 565 1234', '+1 312 239 4414', 'CONNECTATHON', 'US');

SELECT pg_catalog.setval('usr_address_id_seq', 5, true);


