[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: weather/doc/examples/sql create_tables.mysql,NON
From: |
Luca - De Whiskey's - De Vitis <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: weather/doc/examples/sql create_tables.mysql,NONE,1.1 create_tables.pgsql,NONE,1.1 destroy_tables.mysql,NONE,1.1 destroy_tables.pgsql,NONE,1.1 lang.sql,NONE,1.1 states_data.sql,NONE,1.1 weather_metar_us.sql,NONE,1.1 weather_metar_world.sql,NONE,1.1 weather_region.sql,NONE,1.1 |
Date: |
Mon, 10 Jun 2002 09:01:50 -0400 |
Update of /cvsroot/phpgroupware/weather/doc/examples/sql
In directory subversions:/tmp/cvs-serv15597/weather/doc/examples/sql
Added Files:
create_tables.mysql create_tables.pgsql destroy_tables.mysql
destroy_tables.pgsql lang.sql states_data.sql
weather_metar_us.sql weather_metar_world.sql
weather_region.sql
Log Message:
Minor changes to directory structure:
- Moved old sql files to a more suitable place.
- Moved chora/docs to chora/doc
--- NEW FILE ---
CREATE TABLE phpgw_weather_admin (
admin_gdlib_e tinyint(4) DEFAULT '0' NOT NULL,
admin_gdtype tinyint(4) DEFAULT '0' NOT NULL,
admin_imgsrc tinyint(4) DEFAULT '0' NOT NULL,
admin_remote_e tinyint(4) DEFAULT '0' NOT NULL,
admin_filesize int(11) DEFAULT '120000' NOT NULL,
PRIMARY KEY (admin_gdlib_e)
);
CREATE TABLE phpgw_weather (
weather_id int(11) DEFAULT '0' NOT NULL auto_increment,
weather_owner varchar(32) DEFAULT '' NOT NULL,
weather_metar varchar(255) DEFAULT '' NOT NULL,
weather_links varchar(255) DEFAULT '' NOT NULL,
weather_title_e tinyint(4) DEFAULT '0' NOT NULL,
weather_observ_e tinyint(4) DEFAULT '0' NOT NULL,
weather_foreca_e tinyint(4) DEFAULT '0' NOT NULL,
weather_links_e tinyint(4) DEFAULT '0' NOT NULL,
weather_wunder_e tinyint(4) DEFAULT '0' NOT NULL,
weather_fpage_e tinyint(4) DEFAULT '0' NOT NULL,
weather_template tinyint(4) DEFAULT '0' NOT NULL,
weather_city varchar(50) DEFAULT '' NOT NULL,
weather_country varchar(50) DEFAULT '' NOT NULL,
weather_gstation varchar(25) DEFAULT '' NOT NULL,
weather_sticker tinyint(4) DEFAULT '0' NOT NULL,
weather_tmetar varchar(25) DEFAULT '' NOT NULL,
weather_tsize tinyint(4) DEFAULT '0' NOT NULL,
weather_fpmetar varchar(25) DEFAULT '' NOT NULL,
weather_fpsize tinyint(4) DEFAULT '1' NOT NULL,
state_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (weather_id)
);
CREATE TABLE phpgw_weather_links (
links_id int(11) DEFAULT '0' NOT NULL auto_increment,
links_name varchar(35) DEFAULT '' NOT NULL,
links_timetag int(11) DEFAULT '0' NOT NULL,
links_refresh int(11) DEFAULT '0' NOT NULL,
links_linkurl varchar(255) DEFAULT '' NOT NULL,
links_baseurl varchar(255) DEFAULT '' NOT NULL,
links_parseurl varchar(255) DEFAULT '' NOT NULL,
links_parseexpr varchar(255) DEFAULT '' NOT NULL,
links_imageurl varchar(255) DEFAULT '' NOT NULL,
links_comment varchar(255) DEFAULT '' NOT NULL,
links_type varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (links_id)
);
CREATE TABLE phpgw_weather_metar (
metar_id int(11) DEFAULT '0' NOT NULL auto_increment,
metar_weather varchar(255) DEFAULT '' NOT NULL,
metar_timestamp timestamp(14),
metar_station varchar(4) DEFAULT '' NOT NULL,
metar_city varchar(128) DEFAULT '' NOT NULL,
metar_forecast varchar(6) DEFAULT '' NOT NULL,
metar_map char(3) DEFAULT '' NOT NULL,
region_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (metar_id),
UNIQUE metar_station (metar_station)
);
CREATE TABLE phpgw_weather_region (
region_id int(11) DEFAULT '0' NOT NULL auto_increment,
region_name varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (region_id)
);
CREATE TABLE phpgw_us_states (
state_id int(11) DEFAULT '0' NOT NULL auto_increment,
state_code char(2) DEFAULT '' NOT NULL,
state_name varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (state_id)
);
--- NEW FILE ---
CREATE TABLE phpgw_weather_admin (
admin_gdlib_e int DEFAULT '0' NOT NULL,
admin_gdtype int DEFAULT '0' NOT NULL,
admin_imgsrc int DEFAULT '0' NOT NULL,
admin_remote_e int DEFAULT '0' NOT NULL,
admin_filesize int DEFAULT '120000' NOT NULL
);
CREATE TABLE phpgw_weather (
weather_id serial,
weather_owner varchar(32) DEFAULT '' NOT NULL,
weather_metar varchar(255) DEFAULT '' NOT NULL,
weather_links varchar(255) DEFAULT '' NOT NULL,
weather_title_e int DEFAULT '0' NOT NULL,
weather_observ_e int DEFAULT '0' NOT NULL,
weather_foreca_e int DEFAULT '0' NOT NULL,
weather_links_e int DEFAULT '0' NOT NULL,
weather_wunder_e int DEFAULT '0' NOT NULL,
weather_fpage_e int DEFAULT '0' NOT NULL,
weather_template int DEFAULT '0' NOT NULL,
weather_city varchar(50) DEFAULT '' NOT NULL,
weather_country varchar(50) DEFAULT '' NOT NULL,
weather_gstation varchar(25) DEFAULT '' NOT NULL,
weather_sticker int DEFAULT '0' NOT NULL,
weather_tmetar varchar(25) DEFAULT '' NOT NULL,
weather_tsize int DEFAULT '0' NOT NULL,
weather_fpmetar varchar(25) DEFAULT '' NOT NULL,
weather_fpsize int DEFAULT '1' NOT NULL,
state_id int DEFAULT '0' NOT NULL
);
CREATE TABLE phpgw_weather_links (
links_id serial,
links_name varchar(35) DEFAULT '' NOT NULL,
links_timetag int DEFAULT '0' NOT NULL,
links_refresh int DEFAULT '0' NOT NULL,
links_linkurl varchar(255) DEFAULT '' NOT NULL,
links_baseurl varchar(255) DEFAULT '' NOT NULL,
links_parseurl varchar(255) DEFAULT '' NOT NULL,
links_parseexpr varchar(255) DEFAULT '' NOT NULL,
links_imageurl varchar(255) DEFAULT '' NOT NULL,
links_comment varchar(255) DEFAULT '' NOT NULL,
links_type varchar(255) DEFAULT '' NOT NULL
);
CREATE TABLE phpgw_weather_metar (
metar_id serial,
metar_weather varchar(255) DEFAULT '' NOT NULL,
metar_timestamp int8,
metar_station varchar(4) DEFAULT '' NOT NULL,
metar_city varchar(128) DEFAULT '' NOT NULL,
metar_forecast varchar(6) DEFAULT '' NOT NULL,
metar_map char(3) DEFAULT '' NOT NULL,
region_id int DEFAULT '0' NOT NULL,
UNIQUE (metar_station)
);
CREATE TABLE phpgw_weather_region (
region_id serial,
region_name varchar(50) DEFAULT '' NOT NULL
);
CREATE TABLE phpgw_us_states (
state_id serial,
state_code char(2) DEFAULT '' NOT NULL,
state_name varchar(50) DEFAULT '' NOT NULL
);
--- NEW FILE ---
DROP TABLE IF EXISTS phpgw_weather_admin;
DROP TABLE IF EXISTS phpgw_weather;
DROP TABLE IF EXISTS phpgw_weather_links;
DROP TABLE IF EXISTS phpgw_weather_metar;
DROP TABLE IF EXISTS phpgw_weather_region;
DROP TABLE IF EXISTS phpgw_us_states;
--- NEW FILE ---
drop table phpgw_weather_admin;
drop table phpgw_weather;
drop sequence phpgw_weather_weather_id_seq;
drop table phpgw_weather_links;
drop sequence phpgw_weather_links_links_id_seq;
drop table phpgw_weather_metar;
drop sequence phpgw_weather_metar_metar_id_seq;
drop table phpgw_weather_region;
drop sequence phpgw_weather_region_region_id_seq;
drop table phpgw_us_states;
drop sequence phpgw_us_states_state_id_seq;
drop sequence phpgw_weather_link_links_id_seq;
drop sequence phpgw_weather_meta_metar_id_seq;
drop sequence phpgw_weather_reg_region_id_seq;
drop sequence phpgw_weather_weather_id_seq;
--- NEW FILE ---
LOCK TABLES lang WRITE;
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('weather','weather','en','Weather');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('center','weather','en','Center');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('recent','weather','en','Recent');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('observations','weather','en','Observations');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('global','weather','en','Global');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('metar','weather','en','Metar');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('station','weather','en','Station');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('stations','weather','en','Stations');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('region','weather','en','Region');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('regions','weather','en','Regions');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('tables','weather','en','Tables');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('city','weather','en','City');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('state','weather','en','State');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('country','weather','en','Country');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('forecast','weather','en','Forecast');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('forecasts','weather','en','Forecasts');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('zone','weather','en','Zone');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('fzone','weather','en','FZone');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('id','weather','en','ID');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('links','weather','en','Links');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('not
applicable','weather','en','Not Applicable');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('enabled','weather','en','Enabled');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('showing # x of
x','weather','en','showing # %1 of %2');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('failed to find
your station','weather','en','Failed to find your station');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('weather
center','preferences','en','Weather Center');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('weather','preferences','en','Weather');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('weather
center','admin','en','Weather Center');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('station','admin','en','Station');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('stations','admin','en','Stations');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('city','admin','en','City');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('region','admin','en','Region');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('regions','admin','en','Regions');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('metar','admin','en','Metar');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('table','admin','en','Table');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('forecast','admin','en','Forecast');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('zone','admin','en','Zone');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('forecast
zone','admin','en','Forecast Zone');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('fzone','admin','en','FZone');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('id','admin','en','ID');
UNLOCK TABLES;
--- NEW FILE ---
INSERT INTO phpgw_us_states values (1,'','Not Applicable');
INSERT INTO phpgw_us_states values (2,'AL','Alabama');
INSERT INTO phpgw_us_states values (3,'AK','Alaska');
INSERT INTO phpgw_us_states values (4,'AZ','Arizona');
INSERT INTO phpgw_us_states values (5,'AR','Arkansas');
INSERT INTO phpgw_us_states values (6,'CA','California');
INSERT INTO phpgw_us_states values (7,'CO','Colorado');
INSERT INTO phpgw_us_states values (8,'CT','Connecticut');
INSERT INTO phpgw_us_states values (9,'DE','Delaware');
INSERT INTO phpgw_us_states values (10,'FL','Florida');
INSERT INTO phpgw_us_states values (11,'GA','Georgia');
INSERT INTO phpgw_us_states values (12,'HI','Hawaii');
INSERT INTO phpgw_us_states values (13,'ID','Idaho');
INSERT INTO phpgw_us_states values (14,'IL','Illinois');
INSERT INTO phpgw_us_states values (15,'IN','Indiana');
INSERT INTO phpgw_us_states values (16,'IA','Iowa');
INSERT INTO phpgw_us_states values (17,'KS','Kansas');
INSERT INTO phpgw_us_states values (18,'KY','Kentucky');
INSERT INTO phpgw_us_states values (19,'LA','Louisiana');
INSERT INTO phpgw_us_states values (20,'ME','Maine');
INSERT INTO phpgw_us_states values (21,'MD','Maryland');
INSERT INTO phpgw_us_states values (22,'MA','Massachusetts');
INSERT INTO phpgw_us_states values (23,'MI','Michigan');
INSERT INTO phpgw_us_states values (24,'MN','Minnesota');
INSERT INTO phpgw_us_states values (25,'MS','Mississippi');
INSERT INTO phpgw_us_states values (26,'MO','Missouri');
INSERT INTO phpgw_us_states values (27,'MT','Montana');
INSERT INTO phpgw_us_states values (28,'NE','Nebraska');
INSERT INTO phpgw_us_states values (29,'NV','Nevada');
INSERT INTO phpgw_us_states values (30,'NH','New Hampshire');
INSERT INTO phpgw_us_states values (31,'NJ','New Jersey');
INSERT INTO phpgw_us_states values (32,'NM','New Mexico');
INSERT INTO phpgw_us_states values (33,'NY','New York');
INSERT INTO phpgw_us_states values (34,'NC','North Carolina');
INSERT INTO phpgw_us_states values (35,'ND','North Dakota');
INSERT INTO phpgw_us_states values (36,'OH','Ohio');
INSERT INTO phpgw_us_states values (37,'OK','Oklahoma');
INSERT INTO phpgw_us_states values (38,'OR','Oregon');
INSERT INTO phpgw_us_states values (39,'PA','Pennsylvania');
INSERT INTO phpgw_us_states values (40,'RI','Rhode Island');
INSERT INTO phpgw_us_states values (41,'SC','South Carolina');
INSERT INTO phpgw_us_states values (42,'SD','South Dakota');
INSERT INTO phpgw_us_states values (43,'TN','Tennessee');
INSERT INTO phpgw_us_states values (44,'TX','Texas');
INSERT INTO phpgw_us_states values (45,'UT','Utah');
INSERT INTO phpgw_us_states values (46,'VT','Vermont');
INSERT INTO phpgw_us_states values (47,'VA','Virginia');
INSERT INTO phpgw_us_states values (48,'WA','Washington');
INSERT INTO phpgw_us_states values (49,'DC','Washington DC');
INSERT INTO phpgw_us_states values (50,'WV','West Virginia');
INSERT INTO phpgw_us_states values (51,'WI','Wisconsin');
INSERT INTO phpgw_us_states values (52,'WY','Wyoming');
--- NEW FILE ---
INSERT INTO phpgw_weather_metar VALUES
(1455,'',20001104154906,'KABR','Aberdeen, Aberdeen Regional
Airport','SDZ006','',177);
INSERT INTO phpgw_weather_metar VALUES (1456,'',20001104154907,'KABI','Abilene,
Abilene Regional Airport','TXZ127','',177);
INSERT INTO phpgw_weather_metar VALUES
(1457,'',20001104154907,'KVJI','Abingdon','VAZ008','',177);
INSERT INTO phpgw_weather_metar VALUES (1458,'',20001104154906,'PADK','Adak,
Naval Air Station','AKZ020','',177);
INSERT INTO phpgw_weather_metar VALUES (1459,'',20001104152748,'KADG','Adrian,
Lenawee County Airport','','',177);
INSERT INTO phpgw_weather_metar VALUES
(1460,'',20001104154906,'KANW','Ainsworth Municipal','NEZ008','042',177);
INSERT INTO phpgw_weather_metar VALUES (1461,'',20001104154907,'KAFF','Air
Force Academy','COZ071','',177);
INSERT INTO phpgw_weather_metar VALUES (1462,'',20001104152748,'KAIT','Aitkin
NDB Automatic Weather Observing / Reporting','','',177);
INSERT INTO phpgw_weather_metar VALUES (1463,'',20001104154907,'KCAK','Akron,
Akron-Canton Regional Airport','OHZ021','',177);
INSERT INTO phpgw_weather_metar VALUES (1464,'',20001104154907,'KAKO','Akron,
Akron-Washington County Airport','COZ049','',177);
INSERT INTO phpgw_weather_metar VALUES
(1465,'',20001104152748,'KEET','Alabaster, Shelby County Airport','','',177);
INSERT INTO phpgw_weather_metar VALUES
(1466,'',20001104152748,'KALM','Alamogordo-White','','',177);
INSERT INTO phpgw_weather_metar VALUES (1467,'',20001104154907,'KALS','Alamosa,
San Luis Valley Regional Airport','COZ063','',177);
INSERT INTO phpgw_weather_metar VALUES (1468,'',20001104154907,'KALB','Albany,
Albany County Airport','NYZ052','048',177);
INSERT INTO phpgw_weather_metar VALUES (1469,'',20001104154907,'KABY','Albany,
Southwest Georgia Regional Airport','GAZ125','',177);
INSERT INTO phpgw_weather_metar VALUES (1470,'',20001104152748,'KAEL','Albert
Lea Automatic Weather Observing / Reporting','','',177);
INSERT INTO phpgw_weather_metar VALUES
(1471,'',20001104154906,'KABQ','Albuquerque, Albuquerque International
Airport','NMZ009','abq',177);
INSERT INTO phpgw_weather_metar VALUES
(1472,'',20001104154906,'KESF','Alexandria, Alexandria Esler Regional
Airport','LAZ028','115',177);
INSERT INTO phpgw_weather_metar VALUES
(1473,'',20001104154906,'KAEX','Alexandria, Alexandria International
Airport','LAZ028','115',177);
[...1341 lines suppressed...]
INSERT INTO phpgw_weather_metar VALUES
(2815,'',20001104154906,'KIWI','Wiscasset, Wiscasset Airport','MEZ026','',177);
INSERT INTO phpgw_weather_metar VALUES
(2816,'',20001104154907,'KISW','Wisconsin Rapids, Alexander Field South Wood
Count','WIZ035','',177);
INSERT INTO phpgw_weather_metar VALUES (2817,'',20001104154907,'KLNP','Wise /
Lonesome Pine','VAZ002','',177);
INSERT INTO phpgw_weather_metar VALUES (2818,'',20001104154906,'KOLF','Wolf
Point, Clayton Airport','MTZ020','',177);
INSERT INTO phpgw_weather_metar VALUES (2819,'',20001104154907,'KBJJ','Wooster,
Wayne County Airport','OHZ031','',177);
INSERT INTO phpgw_weather_metar VALUES
(2820,'',20001104154907,'KORH','Worcester, Worcester Regional
Airport','MAZ012','bos',177);
INSERT INTO phpgw_weather_metar VALUES (2821,'',20001104154906,'KWRL','Worland,
Worland Municipal Airport','WYZ009','026',177);
INSERT INTO phpgw_weather_metar VALUES
(2822,'',20001104154907,'KOTG','Worthington Automatic Weather Observing /
Reportin','MNZ089','',177);
INSERT INTO phpgw_weather_metar VALUES
(2823,'',20001104154906,'PAWG','Wrangell','AKZ026','',177);
INSERT INTO phpgw_weather_metar VALUES
(2824,'',20001104154907,'KOSC','Wurtsmith Air Force Base','MIZ036','',177);
INSERT INTO phpgw_weather_metar VALUES (2825,'',20001104154908,'KYKM','Yakima,
Yakima Air Terminal','WAZ025','',177);
INSERT INTO phpgw_weather_metar VALUES
(2826,'',20001104154906,'PAYA','Yakutat','AKZ022','',177);
INSERT INTO phpgw_weather_metar VALUES (2827,'',20001104154906,'KYKN','Yankton
Automatic Weather Observing / Reporting Sy','SDZ069','043',177);
INSERT INTO phpgw_weather_metar VALUES
(2828,'',20001104154906,'KP60','Yellowstone Lake','WYZ001','',177);
INSERT INTO phpgw_weather_metar VALUES (2829,'',20001104152749,'KTHV','York,
York Airport','','',177);
INSERT INTO phpgw_weather_metar VALUES
(2830,'',20001104154907,'KYNG','Youngstown, Youngstown-Warren Regional
Airport','OHZ033','',177);
INSERT INTO phpgw_weather_metar VALUES (2831,'',20001104152749,'KYUM','Yuma /
Yuma International','','',177);
INSERT INTO phpgw_weather_metar VALUES (2832,'',20001104154907,'KNYL','Yuma,
Marine Corps Air Station','AZZ025','',177);
INSERT INTO phpgw_weather_metar VALUES
(2833,'',20001104154907,'KZZV','Zanesville, Zanesville Municipal
Airport','OHZ057','',177);
--- NEW FILE ---
INSERT INTO phpgw_weather_metar VALUES
(1,'',20001104152747,'LATI','Tirana','','',1);
INSERT INTO phpgw_weather_metar VALUES
(2,'',20001104152747,'DAUA','Adrar','','',2);
INSERT INTO phpgw_weather_metar VALUES
(3,'',20001104152747,'DABB','Annaba','','',2);
INSERT INTO phpgw_weather_metar VALUES
(4,'',20001104152747,'DABC','Constantine','','',2);
INSERT INTO phpgw_weather_metar VALUES
(5,'',20001104152747,'DAAG','Dar-El-Beida','','',2);
INSERT INTO phpgw_weather_metar VALUES
(6,'',20001104152747,'DAUG','Ghardaia','','',2);
INSERT INTO phpgw_weather_metar VALUES
(7,'',20001104152747,'DAUH','Hassi-Messaoud','','',2);
INSERT INTO phpgw_weather_metar VALUES (8,'',20001104152747,'DAUZ','In
Amenas','','',2);
INSERT INTO phpgw_weather_metar VALUES (9,'',20001104152747,'DAOO','Oran / Es
Senia','','',2);
INSERT INTO phpgw_weather_metar VALUES
(10,'',20001104152747,'DAAT','Tamanrasset / Aguenna','','',2);
INSERT INTO phpgw_weather_metar VALUES
(11,'',20001104152747,'DABS','Tebessa','','',2);
INSERT INTO phpgw_weather_metar VALUES (12,'',20001104152747,'DAON','Tlemcen
Zenata','','',2);
INSERT INTO phpgw_weather_metar VALUES
(13,'',20001104152747,'FNLU','Luanda','','',3);
INSERT INTO phpgw_weather_metar VALUES (14,'',20001104152747,'NZCM','Williams
Field','','',4);
INSERT INTO phpgw_weather_metar VALUES (15,'',20001104152747,'TAPA','Vc Bird
International Airport Antigua','','',5);
INSERT INTO phpgw_weather_metar VALUES (16,'',20001104152747,'SABE','Aeroparque
Bs. As. Aerodrome','','',6);
INSERT INTO phpgw_weather_metar VALUES (17,'',20001104152747,'SAZB','Bahia
Blanca Aerodrome','','',6);
INSERT INTO phpgw_weather_metar VALUES (18,'',20001104152747,'SAZS','Bariloche
Aerodrome','','',6);
INSERT INTO phpgw_weather_metar VALUES (19,'',20001104152747,'SAVC','Comodoro
Rivadavia Aerodrome','','',6);
[...2884 lines suppressed...]
INSERT INTO phpgw_weather_metar VALUES
(2904,'',20001104152749,'OYSY','Sayun','','',186);
INSERT INTO phpgw_weather_metar VALUES
(2905,'',20001104152749,'OYSQ','Socotra','','',186);
INSERT INTO phpgw_weather_metar VALUES
(2906,'',20001104152749,'OYTZ','Taiz','','',186);
INSERT INTO phpgw_weather_metar VALUES (2907,'',20001104152749,'LYBE','Beograd
/ Surcin','','',187);
INSERT INTO phpgw_weather_metar VALUES
(2908,'',20001104152749,'LYNI','Nis','','',187);
INSERT INTO phpgw_weather_metar VALUES
(2909,'',20001104152749,'LYTI','Podgorica / Golubovci','','',187);
INSERT INTO phpgw_weather_metar VALUES
(2910,'',20001104152749,'LYPG','Podgorica Titograd','','',187);
INSERT INTO phpgw_weather_metar VALUES
(2911,'',20001104152749,'LYPR','Pristina','','',187);
INSERT INTO phpgw_weather_metar VALUES (2912,'',20001104152749,'LQSA','Sarajevo
/ Butmir','','',187);
INSERT INTO phpgw_weather_metar VALUES
(2913,'',20001104152749,'LYTV','Tivat','','',187);
INSERT INTO phpgw_weather_metar VALUES (2914,'',20001104152749,'FZAA','Kinshasa
/ N\'Djili','','',188);
INSERT INTO phpgw_weather_metar VALUES
(2915,'',20001104152749,'FLLI','Livingstone','','',189);
INSERT INTO phpgw_weather_metar VALUES (2916,'',20001104152749,'FLLS','Lusaka
Internationalairport','','',189);
INSERT INTO phpgw_weather_metar VALUES
(2917,'',20001104152749,'FLND','NdolaKinshasa / N\'Djili','','',189);
INSERT INTO phpgw_weather_metar VALUES (2918,'',20001104152749,'FVCZ','Buffalo
Range','','',190);
INSERT INTO phpgw_weather_metar VALUES (2919,'',20001104152749,'FVBU','Bulawayo
Airport','','',190);
INSERT INTO phpgw_weather_metar VALUES
(2920,'',20001104152749,'FVTL','Gweru','','',190);
INSERT INTO phpgw_weather_metar VALUES (2921,'',20001104152749,'FVHA','Harare
Kutsaga','','',190);
INSERT INTO phpgw_weather_metar VALUES
(2922,'',20001104152749,'FVMV','Masvingo','','',190);
INSERT INTO phpgw_weather_metar VALUES (2923,'',20001104152749,'FVFA','Victoria
Falls','','',190);
--- NEW FILE ---
INSERT INTO phpgw_weather_region (region_id,region_name) values (1,'Albanie');
INSERT INTO phpgw_weather_region (region_id,region_name) values (2,'Algeria');
INSERT INTO phpgw_weather_region (region_id,region_name) values (3,'Angola');
INSERT INTO phpgw_weather_region (region_id,region_name) values (4,'Antarctic');
INSERT INTO phpgw_weather_region (region_id,region_name) values (5,'Antigua and
Barbuda');
INSERT INTO phpgw_weather_region (region_id,region_name) values (6,'Argentina');
INSERT INTO phpgw_weather_region (region_id,region_name) values (7,'Armenia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (8,'Aruba');
INSERT INTO phpgw_weather_region (region_id,region_name) values (9,'Australia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (10,'Austria');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(11,'Azerbaijan');
INSERT INTO phpgw_weather_region (region_id,region_name) values (12,'Bahamas');
INSERT INTO phpgw_weather_region (region_id,region_name) values (13,'Bahrain');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(14,'Bangladesh');
INSERT INTO phpgw_weather_region (region_id,region_name) values (15,'Barbados');
INSERT INTO phpgw_weather_region (region_id,region_name) values (16,'Belarus');
INSERT INTO phpgw_weather_region (region_id,region_name) values (17,'Belgium');
INSERT INTO phpgw_weather_region (region_id,region_name) values (18,'Belize');
INSERT INTO phpgw_weather_region (region_id,region_name) values (19,'Benin');
INSERT INTO phpgw_weather_region (region_id,region_name) values (20,'Bermuda');
INSERT INTO phpgw_weather_region (region_id,region_name) values (21,'Bolivia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (22,'Botswana');
INSERT INTO phpgw_weather_region (region_id,region_name) values (23,'Brazil');
INSERT INTO phpgw_weather_region (region_id,region_name) values (24,'British
Indian Ocean Territory');
INSERT INTO phpgw_weather_region (region_id,region_name) values (25,'Brunei
Darussalam');
INSERT INTO phpgw_weather_region (region_id,region_name) values (26,'Bulgaria');
INSERT INTO phpgw_weather_region (region_id,region_name) values (27,'Burundi');
INSERT INTO phpgw_weather_region (region_id,region_name) values (28,'Cambodia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (29,'Cameroon');
INSERT INTO phpgw_weather_region (region_id,region_name) values (30,'Canada');
INSERT INTO phpgw_weather_region (region_id,region_name) values (31,'Cape
Verde');
INSERT INTO phpgw_weather_region (region_id,region_name) values (32,'Cayman
Islands');
INSERT INTO phpgw_weather_region (region_id,region_name) values (33,'Central
African Republic');
INSERT INTO phpgw_weather_region (region_id,region_name) values (34,'Chad');
INSERT INTO phpgw_weather_region (region_id,region_name) values (35,'Chile');
INSERT INTO phpgw_weather_region (region_id,region_name) values (36,'China');
INSERT INTO phpgw_weather_region (region_id,region_name) values (37,'Christmas
Island');
INSERT INTO phpgw_weather_region (region_id,region_name) values (38,'Colombia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (39,'Comoros');
INSERT INTO phpgw_weather_region (region_id,region_name) values (40,'Congo');
INSERT INTO phpgw_weather_region (region_id,region_name) values (41,'Cook
Islands');
INSERT INTO phpgw_weather_region (region_id,region_name) values (42,'Costa
Rica');
INSERT INTO phpgw_weather_region (region_id,region_name) values (43,'Cote
D\'Ivoire');
INSERT INTO phpgw_weather_region (region_id,region_name) values (44,'Croatia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (45,'Cuba');
INSERT INTO phpgw_weather_region (region_id,region_name) values (46,'Cyprus');
INSERT INTO phpgw_weather_region (region_id,region_name) values (47,'Czech
Republic');
INSERT INTO phpgw_weather_region (region_id,region_name) values (48,'Denmark');
INSERT INTO phpgw_weather_region (region_id,region_name) values (49,'Djibouti');
INSERT INTO phpgw_weather_region (region_id,region_name) values (50,'Dominica');
INSERT INTO phpgw_weather_region (region_id,region_name) values (51,'Dominican
Republic');
INSERT INTO phpgw_weather_region (region_id,region_name) values (52,'Ecuador');
INSERT INTO phpgw_weather_region (region_id,region_name) values (53,'Egypt');
INSERT INTO phpgw_weather_region (region_id,region_name) values (54,'El
Salvador');
INSERT INTO phpgw_weather_region (region_id,region_name) values (55,'Ethiopia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (56,'Fiji');
INSERT INTO phpgw_weather_region (region_id,region_name) values (57,'Finland');
INSERT INTO phpgw_weather_region (region_id,region_name) values (58,'France');
INSERT INTO phpgw_weather_region (region_id,region_name) values (59,'French
Guiana');
INSERT INTO phpgw_weather_region (region_id,region_name) values (60,'French
Polynesia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (61,'Gabon');
INSERT INTO phpgw_weather_region (region_id,region_name) values (62,'Gambia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (63,'Georgia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (64,'Germany');
INSERT INTO phpgw_weather_region (region_id,region_name) values (65,'Ghana');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(66,'Gibraltar');
INSERT INTO phpgw_weather_region (region_id,region_name) values (67,'Greece');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(68,'Greenland');
INSERT INTO phpgw_weather_region (region_id,region_name) values (69,'Grenada');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(70,'Guadeloupe');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(71,'Guatemala');
INSERT INTO phpgw_weather_region (region_id,region_name) values (72,'Guinea');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(73,'Guinea-Bissau');
INSERT INTO phpgw_weather_region (region_id,region_name) values (74,'Guyana');
INSERT INTO phpgw_weather_region (region_id,region_name) values (75,'Haiti');
INSERT INTO phpgw_weather_region (region_id,region_name) values (76,'Honduras');
INSERT INTO phpgw_weather_region (region_id,region_name) values (77,'Hong
Kong');
INSERT INTO phpgw_weather_region (region_id,region_name) values (78,'Hungary');
INSERT INTO phpgw_weather_region (region_id,region_name) values (79,'Iceland');
INSERT INTO phpgw_weather_region (region_id,region_name) values (80,'India');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(81,'Indonesia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (82,'Iran,
Islamic Republic of');
INSERT INTO phpgw_weather_region (region_id,region_name) values (83,'Ireland');
INSERT INTO phpgw_weather_region (region_id,region_name) values (84,'Israel');
INSERT INTO phpgw_weather_region (region_id,region_name) values (85,'Italy');
INSERT INTO phpgw_weather_region (region_id,region_name) values (86,'Jamaica');
INSERT INTO phpgw_weather_region (region_id,region_name) values (87,'Japan');
INSERT INTO phpgw_weather_region (region_id,region_name) values (88,'Jordan');
INSERT INTO phpgw_weather_region (region_id,region_name) values (89,'Nepal');
INSERT INTO phpgw_weather_region (region_id,region_name) values (90,'Kenya');
INSERT INTO phpgw_weather_region (region_id,region_name) values (91,'Kiribati');
INSERT INTO phpgw_weather_region (region_id,region_name) values (92,'Korea,
Democratic People\'s Republic of');
INSERT INTO phpgw_weather_region (region_id,region_name) values (93,'Korea,
Republic of');
INSERT INTO phpgw_weather_region (region_id,region_name) values (94,'Kuwait');
INSERT INTO phpgw_weather_region (region_id,region_name) values (95,'Lao
People\'s Democratic Republic');
INSERT INTO phpgw_weather_region (region_id,region_name) values (96,'Lebanon');
INSERT INTO phpgw_weather_region (region_id,region_name) values (97,'Libyan
Arab Jamahiriya');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(98,'Lithuania');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(99,'Luxembourg');
INSERT INTO phpgw_weather_region (region_id,region_name) values (100,'Macau');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(101,'Madagascar');
INSERT INTO phpgw_weather_region (region_id,region_name) values (102,'Malawi');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(103,'Malaysia');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(104,'Maldives');
INSERT INTO phpgw_weather_region (region_id,region_name) values (105,'Mali');
INSERT INTO phpgw_weather_region (region_id,region_name) values (106,'Malta');
INSERT INTO phpgw_weather_region (region_id,region_name) values (107,'Marshall
Islands');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(108,'Martinique');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(109,'Mauritania');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(110,'Mauritius');
INSERT INTO phpgw_weather_region (region_id,region_name) values (111,'Mexico');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(112,'Micronesia, Federated States of');
INSERT INTO phpgw_weather_region (region_id,region_name) values (113,'Morocco');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(114,'Mozambique');
INSERT INTO phpgw_weather_region (region_id,region_name) values (115,'Myanmar');
INSERT INTO phpgw_weather_region (region_id,region_name) values (116,'Nauru');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(117,'Netherlands');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(118,'Netherlands Antilles');
INSERT INTO phpgw_weather_region (region_id,region_name) values (119,'New
Caledonia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (120,'New
Zealand');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(121,'Nicaragua');
INSERT INTO phpgw_weather_region (region_id,region_name) values (122,'Niger');
INSERT INTO phpgw_weather_region (region_id,region_name) values (123,'Norway');
INSERT INTO phpgw_weather_region (region_id,region_name) values (124,'Oman');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(125,'Pakistan');
INSERT INTO phpgw_weather_region (region_id,region_name) values (126,'Palau');
INSERT INTO phpgw_weather_region (region_id,region_name) values (127,'Panama');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(128,'Paraguay');
INSERT INTO phpgw_weather_region (region_id,region_name) values (129,'Peru');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(130,'Philippines');
INSERT INTO phpgw_weather_region (region_id,region_name) values (131,'Poland');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(132,'Portugal');
INSERT INTO phpgw_weather_region (region_id,region_name) values (133,'Puerto
Rico');
INSERT INTO phpgw_weather_region (region_id,region_name) values (134,'Qatar');
INSERT INTO phpgw_weather_region (region_id,region_name) values (135,'Reunion');
INSERT INTO phpgw_weather_region (region_id,region_name) values (136,'Romania');
INSERT INTO phpgw_weather_region (region_id,region_name) values (137,'Russian
Federation');
INSERT INTO phpgw_weather_region (region_id,region_name) values (138,'Rwanda');
INSERT INTO phpgw_weather_region (region_id,region_name) values (139,'Saint
Helena');
INSERT INTO phpgw_weather_region (region_id,region_name) values (140,'Saint
Kitts and Nevis');
INSERT INTO phpgw_weather_region (region_id,region_name) values (141,'Saint
Lucia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (142,'Saint
Vincent and the Grenadines');
INSERT INTO phpgw_weather_region (region_id,region_name) values (143,'Samoa');
INSERT INTO phpgw_weather_region (region_id,region_name) values (144,'Sao Tome
and Principe');
INSERT INTO phpgw_weather_region (region_id,region_name) values (145,'Saudi
Arabia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (146,'Senegal');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(147,'Seychelles');
INSERT INTO phpgw_weather_region (region_id,region_name) values (148,'Sierra
Leone');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(149,'Singapore');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(150,'Slovakia');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(151,'Slovenia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (152,'Solomon
Islands');
INSERT INTO phpgw_weather_region (region_id,region_name) values (153,'Somalia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (154,'South
Africa');
INSERT INTO phpgw_weather_region (region_id,region_name) values (155,'Spain');
INSERT INTO phpgw_weather_region (region_id,region_name) values (156,'Sri
Lanka');
INSERT INTO phpgw_weather_region (region_id,region_name) values (157,'Sudan');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(158,'Suriname');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(159,'Swaziland');
INSERT INTO phpgw_weather_region (region_id,region_name) values (160,'Sweden');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(161,'Switzerland');
INSERT INTO phpgw_weather_region (region_id,region_name) values (162,'Syrian
Arab Republic');
INSERT INTO phpgw_weather_region (region_id,region_name) values (163,'Taiwan');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(164,'Tajikistan');
INSERT INTO phpgw_weather_region (region_id,region_name) values (165,'Tanzania,
United Republic of');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(166,'Thailand');
INSERT INTO phpgw_weather_region (region_id,region_name) values (167,'Togo');
INSERT INTO phpgw_weather_region (region_id,region_name) values (168,'Tonga');
INSERT INTO phpgw_weather_region (region_id,region_name) values (169,'Trinidad
and Tobago');
INSERT INTO phpgw_weather_region (region_id,region_name) values (170,'Tunisia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (171,'Turkey');
INSERT INTO phpgw_weather_region (region_id,region_name) values (172,'Tuvalu');
INSERT INTO phpgw_weather_region (region_id,region_name) values (173,'Uganda');
INSERT INTO phpgw_weather_region (region_id,region_name) values (174,'Ukraine');
INSERT INTO phpgw_weather_region (region_id,region_name) values (175,'United
Arab Emirates');
INSERT INTO phpgw_weather_region (region_id,region_name) values (176,'United
Kingdom');
INSERT INTO phpgw_weather_region (region_id,region_name) values (177,'United
States');
INSERT INTO phpgw_weather_region (region_id,region_name) values (178,'United
States Minor Outlying Islands');
INSERT INTO phpgw_weather_region (region_id,region_name) values (179,'Uruguay');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(180,'Uzbekistan');
INSERT INTO phpgw_weather_region (region_id,region_name) values (181,'Vanuatu');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(182,'Venezuela');
INSERT INTO phpgw_weather_region (region_id,region_name) values (183,'Viet
Nam');
INSERT INTO phpgw_weather_region (region_id,region_name) values (184,'Virgin
Islands, British');
INSERT INTO phpgw_weather_region (region_id,region_name) values (185,'Virgin
Islands, U.S.');
INSERT INTO phpgw_weather_region (region_id,region_name) values (186,'Yemen');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(187,'Yugoslavia');
INSERT INTO phpgw_weather_region (region_id,region_name) values (188,'Zaire');
INSERT INTO phpgw_weather_region (region_id,region_name) values (189,'Zambia');
INSERT INTO phpgw_weather_region (region_id,region_name) values
(190,'Zimbabwe');
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: weather/doc/examples/sql create_tables.mysql,NONE,1.1 create_tables.pgsql,NONE,1.1 destroy_tables.mysql,NONE,1.1 destroy_tables.pgsql,NONE,1.1 lang.sql,NONE,1.1 states_data.sql,NONE,1.1 weather_metar_us.sql,NONE,1.1 weather_metar_world.sql,NONE,1.1 weather_region.sql,NONE,1.1,
Luca - De Whiskey's - De Vitis <address@hidden> <=