--  E.Gallas - 
--  populate the INSTITS table in the Oracle SB database 
--  using the mSQLdump 
--  of the INSTITUTE table of the mSQL WHOD0 database.
-- 
--  List of modifications to this file:
--    Comment out the CREATE TABLE institute ...
--    Replace 'institute' with 'instit' in the inserts
--    Delete the date and bywho information (wrong date format)
--    Replace '\g' with ';'
--    replace & symbols with 'and' or nothing (Texas AM)
--    replace \' with '' 
--    replace ,'http://', with ,none,
--    add institution NONE
--       INSERT INTO instit (institute, contact, phone, fax, videophone, homepage) 
--        VALUES ('NONE','','','','','');
--    Jun 1,2k EGallas:  add some example records:
--       add proceedings,trans link to a talk in links table
--       add a gif picture to a person in whod0 table
-- --------------------------------------------------------
-- 
--  mSQL Dump  (requires mSQL-1.0.6 or better)
-- 
--  Host: localhost    Database: whod0
-- --------------------------------------------------------
--  CREATE TABLE institute (
--    institute CHAR(50) NOT NULL PRIMARY KEY,
--    contact CHAR(50),
--    phone CHAR(80),
--    fax CHAR(80),
--    videophone CHAR(80),
--    homepage CHAR(80),
--    addr CHAR(120),
--    date CHAR(12),
--    bywho CHAR(10)
--  ) \g
-- 
--  Dumping data for table 'institute'
-- 
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Boston University','John Butler','(617)353-8931 (617)353-2600','617-353-9393','','http://physics.bu.edu/','Boston University | Department of Physics | 590 Commonwealth Avenue | Boston, MA  02215');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Brookhaven National Laboratory','Howard Gordon','(631)344-3740','(631)344-5568','',null,'Physics Department, 510A | Brookhaven National Laboratory | Upton, NY 11973-5000');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Brown University','Dave Cutts','(401)863-2644  (630)840-8324','(401)863-2024','','http://het.brown.edu/','Brown University | Physics Department | Providence, RI 02912');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Universidad de Buenos Aires, Argentina','Ricardo Piegaia','011-54-11-4576-3390  ext. 828',' 011-54-11-4576-3357','','http://www.df.uba.ar','Departamento de Fisica - Pab 1 | Ciudad Universitaria | 1428 Buenos Aires | ARGENTINA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('CBPF/LAFEX, Brazil','Albert Santoro','(011-55-21)-586-7191  -586-7100','(011-55-21)-586-7556 -586-7400','','http://www.lafex.cbpf.br','CBPF/LAFEX | Rio Dr. Xavier Sigaud, 150 | 22290-180 - Rio de Janeiro | BRAZIL');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('CINVESTAV, Mexico','Heriberto Castilla-Valdez','(011-525) 7477098','(011-525) 7477098','','http://www.fis.cinvestav.mx/','Department of Physics | Apdo. Postal 14740	 | Mexico D.F. 07000 | Mexico');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Washington','Henry Lubatti','(206)543-8964','(206)685-9242 (206)685-0635','','http://www.phys.washington.edu/groups/hepl/','Dept of Physics | Univ of Washington | PO Box 351560 | Seattle WA 98195-1560 | USA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Columbia University','Mike Tuts','212-854-3366 212-854-3367 630-840-8304 ','(212)854-3379','','http://phys.columbia.edu/','Physics Department | Mailcode-5255 | 538 W. 120Th Street | New York, NY 10027');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('DAPNIA/SPP, SACLAY, France','Armand Zylberstejn','(630)840-6448/6447/6428 33-1-6908-3346','33-1-6908-6428','',null,'DAPNIA/SPP | Centre d''Etudes de Saclay | 91191 Gif-sur-Yvette CEDEX | FRANCE');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Dehli University, India','','','','',null,'CDRST, South Campus | Benito Juarez Road | New Dehli - 110 021 | INDIA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Fermi National Accelerator Laboratory','Marcel Demarteau  Ron Lipton','(630)840-2840    (630)840-8320','(630)840-8481(DAB6)    (630)840-8886(TCE-177)','','http://www-d0.fnal.gov/','Fermilab MS 357 (or 352) | PO Box 500 | Batavia IL, 60510');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Florida State University','Sharon Hagopian','(850)644-4777 (630)840-8384/8859','904-644-6735','',null,'Florida State University | Physics Department | Tallahassee, FL 32306');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('IHEP, Beijing, China','Huishun MAO','8610-6821-3344','','','http://www.ihep.ac.cn/','Institute of High Energy Physics  | Beijing  918 | P.R.China 100039');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Institute for High Energy Physics, Russia','Sergei Denisov','(630)840-8570','(095)-230-2337 ','','http://www.ihep.su/','142 284 Protvino | Moscow Region | Serpukhov, USSR');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Indiana University','Andrzej Zieminski','(812)855-4089 (630)840-5064','(812)855-0440','(812)336-0064  (812)336-0084','http://needmore.physics.indiana.edu/~iuhep/ ','Indiana University | Department of Physics | Bloomington, IN 47405');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Iowa State University','E. Walter Anderson','(515)294-2823, 8572, 6186 ','(515)294-8712','','http://www.iastate.edu','Alpha HEP Group | Department of Physics | Iowa State University | Ames, IA 50011-3160');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Korea University, Korea','','','011-82-2-922-8749','',null,'Physics Department | Seoul 136-701 | KOREA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Kyungsung University, Korea','','','','',null,'Pusan, KOREA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Lawrence Berkeley National Laboratory','Ron Madaras','(510)486-4410','(510)486-7115','','http://d0lblt.lbl.gov/wwwd0/d0.html','MS 50B-5239 | 1 Cyclotron Road | Berkeley, CA 94720');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Universidad de Los Andes, Colombia','Bernardo Gomez','(630)840-5199  [57-1]283-9514','57-1-2839514','','http://www.uniandes.edu.co','Universidad De Los Andes | Departamento de Fisica | Apartado Aereo 4976 | Bogota, Colombia');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Michigan State University','Bernard Pope','(517)353-1695 (630)840-8653','517-355-6661','517-432-2130, 2163 (video), 517-432-0469 (audio)','http://www.pa.msu.edu/people/pope/','Michigan State University | Physics Department | East Lansing, MI 48824');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Moscow State University, Russia','E. Chabalina','','011-7-095-939-5948','',null,'Nuclear Physics Institute | 119899 Moscow | RUSSIA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Langston University','Joel Snow','405-466-3328','405-466-3271','','http://physics.lunet.edu','Dept. of Math and Physics | Jones Hall | Langston University | Rt. 33 | Langston, OK 73050');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Northeastern University','Darien Wood','(617)373-2958 (630)840-8485','(617)373-2943','','http://www.physics.neu.edu/','Department of Physics | 111 Dana Research Center | Northeastern University | Boston, MA 02115');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Northwestern University','Bruno Gobbi','(630)840-2817 (630)840-2474 (847)491-5463','(847)491-9982','','http://www.nuhep.nwu.edu/','Physics Department | Northwestern University | Evanston, IL 60210');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Panjab University, India','Dr. J. M. Kohli','+91 172 541741','+91 172 783336','','http://www.puchd.ac.in/phys/','Physics Department | Panjab University | Chandigarh-160 014 | INDIA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Purdue University','David Koltick','(765)494-5557 (630)840-5261','317-494-0706','',null,'Department of Physics | 1396 Physics Bldg. | West Lafayette, IN 47907-1396');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Rice University','Paul Padley','(630)840-2406 (713)348-4703','713-348-5218','',null,'Rice University | TW Bonner Nuclear Lab | Houston, TX 77251-1892');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('State University of New York, Stony Brook','Robert Mccarthy','(631)632-8086 (630)840-5295','631-632-8101','631-246-5247/5253','http://sbhep1.physics.sunysb.edu/','');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Seoul National University, Korea','Sun Kee Kim','82-2-880-6594  (630)840-8571','','',null,'Department of Physics | Seoul National University | Seoul 151-742 | KOREA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Tata Institute of Fundamental Research, India','Vemuri Narasimham','','','',null,'Homi Bhabha Road | Colaba, Bombay - 400 005 | INDIA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Texas AM University','James White','(630)840-8028 (409)845-1479','','',null,'Texas AM University | Physics Department | College Station, TX 77845');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('NIKHEF, Netherlands','Frank Linde','011-31-20-592-5134','011-31-20-592-5155','','http://www.nikhef.nl','Kruislaan 409, 1009 DB | Amsterdam, The Netherlands');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of California, Davis','Sudhindra Mani','(630)840-2931 (530)752-8785','(530)752-2431','',null,'University of California | Physics Department | One Shields Avenue | Davis, CA 95616');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of California, Irvine','David Stoker','949-824-2933','949-824-7478','',null,'University of California, Irvine | Department of Physics and Astronomy | Irvine, CA 92697-4575');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of California, Riverside','Yvonne Ayers (staff assistant)','(909)787-5033','(909)787-3345','(909) 781-9919   (909) 781-9937','http://cnas.ucr.edu/~physics','Department of Physics | University of California | Riverside, CA 92521-0413');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Arizona','John Rutherfoord','(520)621-2657','520-621-4721','','http://www.physics.arizona.edu/eepp/','University of Arizona | Physics Department | Tucson, AZ 85721');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Illinois, Chicago','Mark Adams','(312)996-3403 (630)840-5220','312-996-9016','','http://nscp200.phy.uic.edu/kevin/hep/','Department of Physics (M/C 273) | 801 W. Taylor St. | Chicago, IL 60607-7059');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Hawaii','Mike Peters','','','',null,'Department of Physics and Astronomy | 205 Correa Road | Honolulu, HI 96822');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Maryland','Nick Hadley','(630)840-2042 (301)405-6063','301-699-9195','','http://delphi.umd.edu','University of Maryland | Physics Department | College Park, MD 20742');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Michigan','Jianming Qian','(734) 936 1033','(734) 936 6529','','http://www.umich.edu','University of Michigan | Department of Physics | Ann Arbor, MI 48109');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Nebraska','Gregory Snow','(402)472-6279 (402)472-9879 (630)840-5405 (603)840-8593','(402)472-2879','','http://www.unl.edu/physics/','Department of Physics and Astronomy | 116 Behlen Laboratory | University of Nebraska | Lincoln, NE 68588-0111');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Notre Dame','Mitchell Wayne ','(219)-631-6387','(219)-631-5952','','http://www.phys.nd.edu/physics/physics.html','225 Nieuwland Science Hall | Notre Dame, IN 46556');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Oklahoma','Phillip Gutierrez','405-325-3961','405-325-7557','','http://www.nhn.ou.edu/index.html','Department of Physics and Astronomy | 440 West Brooks | Norman, OK 73019');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Rochester','Tom Ferbel','(716)275-4396 (630)840-3111/5267','(716)275-8527','','http://pas.rochester.edu/mainpageframe.html','River Campus/Physics and Astronomy | Bausch and Lomb Bldg. | Rochester, NY 14627');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Texas, Arlington','Andrew White','(817)272-2812','(817)272-2824','','http://www-hep.uta.edu/','High Energy Group | Department of Physics | Box 19059 | Arlington, TX 76019');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Kansas State University','Bill Reay','','','',null,'');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Northern Illinois University','Dave Hedin','(815)753-6483 (630)840-8131','815-753-8565','','http://www.physics.niu.edu/','');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Universidade do Estado do Rio de Janeiro, Brazil','Jose Guilherme LIMA','5521-587-7676','5521-587-7551','','http://www.uerj.br','Instituto de Fisica | Rua Sao Francisco Xavier 524 | Maracana - Rio de Janeiro (RJ) | 20559-900 - Brazil');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Kansas','Phil Baringer','785-864-3953','785-864-5262','(785)330-0113     (785)330-0114','http://kuhep4.phsx.ukans.edu/~baringer/index.html','Department of Physics and Astronomy | University of Kansas | Lawrence KS 66045');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Louisiana Tech University','Lee Sawyer','318-257-4053   630-840-8581','318-257-4228','','http://www.phys.latech.edu/','Center for Applied Physics Studies | W. Arizona Ave. | Louisiana Tech University | Ruston, LA 71272					');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Centre de Physique des Particules de Marseille','Elemer Nagy','011-33-4-91.82.72.00','011-33-4-91.82.72.99','','http://cppm.in2p3.fr/',' CPPM - Case 907 |  Faculte des Sciences de Luminy  |  163 ave de Luminy |  F-13288 Marseille CEDEX 9 | ');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Laboratoire de l Accelerateur Lineaire, France','Pierre Petroff','33-1-64-46-84-34','','',null,'LAL bd 200 | Faculte des Sciences | ORSAY, F91405 | CEDEX, France');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Institut des Sciences Nucleaires de Grenoble','G. Sajot  (sajot@in2p3.fr)','+33.4.76.28.40.67','+33.4.76.28.40.04','','http://www-d0.fnal.gov/~sajot','Institut des Sciences Nucleaires de Grenoble  | 53 Avenue des Martyrs | 38026 GRENOBLE Cedex   France');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('LPNHE, Universites Paris VI and VII, France','Ursula Bassler','(33)-1.44.27.63.13    (630)840-8740','(33)-1.44.27.46.38','','http://www-lpnhep.in2p3.fr/','LPNHE | 4, place Jussieu | Tour 33 - Rez de Chaussee | 75252 Paris Cedex 05');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Institute of Nuclear Physics, Poland','','','','','','');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Joint Institute for Nuclear Research, Russia','Gena Alexeev','','','',null,'Dubna, Moscow, RUSSIA');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Institute for Theoretical and Exp. Physics, Russia','','','','','','');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Petersburg Nuclear Physics Insitute, Russia','','','','','','');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Institute of Physics of Czech Academy of Sciences','Vladislav SIMAK','+4202-66052145, +4202-66052666','+42028585443','','http://www-hep.fzu.cz','Na Slovance 2 | Prague 8 | CZ - 18221 | Czech Republic');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Imperial College, London','John F. Hassard','+44-207594-7823','+44-207823-8830','','http://www.hep.ph.ic.ac.uk','Imperial College | Blackett Laboratory | Prince Consort Road | London SW7 2BZ UK | ');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Manchester, United Kingdom','','','','',null,'');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Lancaster University, United Kingdom','Peter Ratoff','','44-1524-844037','',null,'Department of Physics | Lancaster University | Lancaster | LANCASHIRE | LA1 4YB | UK');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Universidad San Francisco de Quito, Ecuador','Bruce Hoeneisen','593-2-895723 ext. 250','593-2-890070','','http://www.usfq.edu.ec/','P.O. Box 17-12-841, Quito, ECUADOR');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('Stockholm University','Barbro Asman','46-8-16-42-37','','','http://www.physto.se/','Fysikum | Box 6730 | 11385 Stockholm | Sweden');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage, addr)
 VALUES ('University of Nijmegen','Sijbrand deJong','+31243652099','+31243652191','','http://www.hef.kun.nl','Toernooiveld 1 | 6546 ED Nijmegen | The Netherlands');
INSERT INTO instits (institute, contact, phone, fax, videophone, homepage) 
 VALUES ('NONE','','','','','');

-- add a URL to a talk (in sqlplus)
update links set proc_url='http://www-d0.fnal.gov/~gallas/eps99.ps',
trans_url='http://neutrino.pc.helsinki.fi/hep99/transparencies/session-01/'
where aname='GALLAS_E' and aconf='EPS99';

-- add a gif picture
select name from whod0s where name like '%GALLAS%';
update whod0s set url_picture='http://www-d0.fnal.gov/~gallas/elizabeth.gif' 
where name like '%GALLAS%';

