-- $Id:


/*************************************************************************************/
 
DELETE FROM DistributionArea;
INSERT INTO DistributionArea VALUES ('0','??','','Unresolved','');
INSERT INTO DistributionArea VALUES ('1','AE','','East Aegean Islands','');
INSERT INTO DistributionArea VALUES ('2','Ag','','Algeria','');
INSERT INTO DistributionArea VALUES ('3','Al','','Albania','');
INSERT INTO DistributionArea VALUES ('4','An','','Asiatic Turkey','');
INSERT INTO DistributionArea VALUES ('5','Bl','','Balearic Islands','');
INSERT INTO DistributionArea VALUES ('6','Bu','','Bulgaria','');
INSERT INTO DistributionArea VALUES ('7','Co','','Corsica','');
INSERT INTO DistributionArea VALUES ('8','Cr','','Crete and Karpathos','');
INSERT INTO DistributionArea VALUES ('9','Cy','','Cyprus','');
INSERT INTO DistributionArea VALUES ('10','Eg','','Egypt','');
INSERT INTO DistributionArea VALUES ('11','Ga','','France','');
INSERT INTO DistributionArea VALUES ('12','Gr','','Greece','');
INSERT INTO DistributionArea VALUES ('13','Hs','','Spain','');
INSERT INTO DistributionArea VALUES ('14','IJ','','Israel and Jordan','');
INSERT INTO DistributionArea VALUES ('15','It','','Italy','');
INSERT INTO DistributionArea VALUES ('16','Ju','','Jugoslavia','');
INSERT INTO DistributionArea VALUES ('17','Li','','Libya','');
INSERT INTO DistributionArea VALUES ('18','LS','','Lebanon and Syria','');
INSERT INTO DistributionArea VALUES ('19','Lu','','Portugal','');
INSERT INTO DistributionArea VALUES ('20','Ma','','Marocco','');
INSERT INTO DistributionArea VALUES ('21','Me','','Malta','');
INSERT INTO DistributionArea VALUES ('22','RK','','Crimea','');
INSERT INTO DistributionArea VALUES ('23','Sa','','Sradinia','');
INSERT INTO DistributionArea VALUES ('24','Si','','Sicily','');
INSERT INTO DistributionArea VALUES ('25','Sn','','Sinai','');
INSERT INTO DistributionArea VALUES ('26','Tn','','Tunisia','');
INSERT INTO DistributionArea VALUES ('27','Tu','','Turkey in Europe','');

/*************************************************************************************/

DELETE FROM DistributionArea;
INSERT INTO DistributionAreaFloras VALUES ('1','14','100306','94');
INSERT INTO DistributionAreaFloras VALUES ('1','48','101225','92');
INSERT INTO DistributionAreaFloras VALUES ('1','49','101236','90');
INSERT INTO DistributionAreaFloras VALUES ('1','69','101269','96');
INSERT INTO DistributionAreaFloras VALUES ('1','72','101273','98');
INSERT INTO DistributionAreaFloras VALUES ('1','79','101280','100');
INSERT INTO DistributionAreaFloras VALUES ('2','34','100700','98');
INSERT INTO DistributionAreaFloras VALUES ('2','37','100722','90');
INSERT INTO DistributionAreaFloras VALUES ('2','41','100758','92');
INSERT INTO DistributionAreaFloras VALUES ('2','46','101208','96');
INSERT INTO DistributionAreaFloras VALUES ('2','47','101214','94');
INSERT INTO DistributionAreaFloras VALUES ('2','67','101267','100');
INSERT INTO DistributionAreaFloras VALUES ('3','26','100387','96');
INSERT INTO DistributionAreaFloras VALUES ('3','58','101257','98');
INSERT INTO DistributionAreaFloras VALUES ('3','70','101271','100');
INSERT INTO DistributionAreaFloras VALUES ('4','14','100306','94');
INSERT INTO DistributionAreaFloras VALUES ('4','3','100394','92');
INSERT INTO DistributionAreaFloras VALUES ('4','4','100756','90');
INSERT INTO DistributionAreaFloras VALUES ('4','48','101225','86');
INSERT INTO DistributionAreaFloras VALUES ('4','49','101236','88');
INSERT INTO DistributionAreaFloras VALUES ('4','69','101269','96');
INSERT INTO DistributionAreaFloras VALUES ('4','72','101273','98');
INSERT INTO DistributionAreaFloras VALUES ('4','79','101280','100');
INSERT INTO DistributionAreaFloras VALUES ('5','15','100336','96');
INSERT INTO DistributionAreaFloras VALUES ('5','31','100396','94');
INSERT INTO DistributionAreaFloras VALUES ('5','5','101247','98');
INSERT INTO DistributionAreaFloras VALUES ('5','54','101252','92');
INSERT INTO DistributionAreaFloras VALUES ('5','58','101257','90');
INSERT INTO DistributionAreaFloras VALUES ('5','66','101266','100');
INSERT INTO DistributionAreaFloras VALUES ('5','68','101268','88');
INSERT INTO DistributionAreaFloras VALUES ('6','26','100387','92');
INSERT INTO DistributionAreaFloras VALUES ('6','28','100392','96');
INSERT INTO DistributionAreaFloras VALUES ('6','55','101253','94');
INSERT INTO DistributionAreaFloras VALUES ('6','58','101257','98');
INSERT INTO DistributionAreaFloras VALUES ('6','65','101265','100');
INSERT INTO DistributionAreaFloras VALUES ('7','10','100001','86');
INSERT INTO DistributionAreaFloras VALUES ('7','11','100002','88');
INSERT INTO DistributionAreaFloras VALUES ('7','18','100354','80');
INSERT INTO DistributionAreaFloras VALUES ('7','19','100365','84');
INSERT INTO DistributionAreaFloras VALUES ('7','21','100381','96');
INSERT INTO DistributionAreaFloras VALUES ('7','43','100960','94');
INSERT INTO DistributionAreaFloras VALUES ('7','58','101257','98');
INSERT INTO DistributionAreaFloras VALUES ('7','6','101259','92');
INSERT INTO DistributionAreaFloras VALUES ('7','63','101263','82');
INSERT INTO DistributionAreaFloras VALUES ('7','74','101275','100');
INSERT INTO DistributionAreaFloras VALUES ('7','75','101276','78');
INSERT INTO DistributionAreaFloras VALUES ('7','8','101281','90');
INSERT INTO DistributionAreaFloras VALUES ('8','22','100382','90');
INSERT INTO DistributionAreaFloras VALUES ('8','23','100383','88');
INSERT INTO DistributionAreaFloras VALUES ('8','24','100384','86');
INSERT INTO DistributionAreaFloras VALUES ('8','26','100387','84');
INSERT INTO DistributionAreaFloras VALUES ('8','3','100394','82');
INSERT INTO DistributionAreaFloras VALUES ('8','4','100756','80');
INSERT INTO DistributionAreaFloras VALUES ('8','48','101225','94');
INSERT INTO DistributionAreaFloras VALUES ('8','49','101236','92');
INSERT INTO DistributionAreaFloras VALUES ('8','58','101257','96');
INSERT INTO DistributionAreaFloras VALUES ('8','73','101274','100');
INSERT INTO DistributionAreaFloras VALUES ('8','77','101278','98');
INSERT INTO DistributionAreaFloras VALUES ('9','3','100394','94');
INSERT INTO DistributionAreaFloras VALUES ('9','36','100716','98');
INSERT INTO DistributionAreaFloras VALUES ('9','4','100756','92');
INSERT INTO DistributionAreaFloras VALUES ('9','40','100757','96');
INSERT INTO DistributionAreaFloras VALUES ('9','79','101280','100');
INSERT INTO DistributionAreaFloras VALUES ('10','3','100394','92');
INSERT INTO DistributionAreaFloras VALUES ('10','4','100756','90');
INSERT INTO DistributionAreaFloras VALUES ('10','56','101254','96');
INSERT INTO DistributionAreaFloras VALUES ('10','57','101256','94');
INSERT INTO DistributionAreaFloras VALUES ('10','79','101280','98');
INSERT INTO DistributionAreaFloras VALUES ('10','80','101283','100');
INSERT INTO DistributionAreaFloras VALUES ('11','10','100001','94');
INSERT INTO DistributionAreaFloras VALUES ('11','11','100002','96');
INSERT INTO DistributionAreaFloras VALUES ('11','19','100365','92');
INSERT INTO DistributionAreaFloras VALUES ('11','21','100381','98');
INSERT INTO DistributionAreaFloras VALUES ('11','58','101257','100');
INSERT INTO DistributionAreaFloras VALUES ('11','75','101276','90');
INSERT INTO DistributionAreaFloras VALUES ('12','22','100382','90');
INSERT INTO DistributionAreaFloras VALUES ('12','23','100383','88');
INSERT INTO DistributionAreaFloras VALUES ('12','24','100384','86');
INSERT INTO DistributionAreaFloras VALUES ('12','26','100387','96');
INSERT INTO DistributionAreaFloras VALUES ('12','3','100394','84');
INSERT INTO DistributionAreaFloras VALUES ('12','4','100756','82');
INSERT INTO DistributionAreaFloras VALUES ('12','48','101225','94');
INSERT INTO DistributionAreaFloras VALUES ('12','49','101236','92');
INSERT INTO DistributionAreaFloras VALUES ('12','58','101257','98');
INSERT INTO DistributionAreaFloras VALUES ('12','77','101278','100');
INSERT INTO DistributionAreaFloras VALUES ('13','54','101252','96');
INSERT INTO DistributionAreaFloras VALUES ('13','58','101257','98');
INSERT INTO DistributionAreaFloras VALUES ('13','61','101261','90');
INSERT INTO DistributionAreaFloras VALUES ('13','62','101262','88');
INSERT INTO DistributionAreaFloras VALUES ('13','66','101266','100');
INSERT INTO DistributionAreaFloras VALUES ('13','68','101268','86');
INSERT INTO DistributionAreaFloras VALUES ('13','78','101279','92');
INSERT INTO DistributionAreaFloras VALUES ('13','9','101284','94');
INSERT INTO DistributionAreaFloras VALUES ('14','3','100394','94');
INSERT INTO DistributionAreaFloras VALUES ('14','4','100756','92');
INSERT INTO DistributionAreaFloras VALUES ('14','44','101061','96');
INSERT INTO DistributionAreaFloras VALUES ('14','64','101264','98');
INSERT INTO DistributionAreaFloras VALUES ('14','79','101280','100');
INSERT INTO DistributionAreaFloras VALUES ('15','18','100354','94');
INSERT INTO DistributionAreaFloras VALUES ('15','43','100960','98');
INSERT INTO DistributionAreaFloras VALUES ('15','58','101257','100');
INSERT INTO DistributionAreaFloras VALUES ('15','63','101263','96');
INSERT INTO DistributionAreaFloras VALUES ('16','18','100354','92');
INSERT INTO DistributionAreaFloras VALUES ('16','2','100376','90');
INSERT INTO DistributionAreaFloras VALUES ('16','26','100387','96');
INSERT INTO DistributionAreaFloras VALUES ('16','29','100393','88');
INSERT INTO DistributionAreaFloras VALUES ('16','30','100395','86');
INSERT INTO DistributionAreaFloras VALUES ('16','35','100715','94');
INSERT INTO DistributionAreaFloras VALUES ('16','58','101257','98');
INSERT INTO DistributionAreaFloras VALUES ('16','62','101262','84');
INSERT INTO DistributionAreaFloras VALUES ('16','76','101277','100');
INSERT INTO DistributionAreaFloras VALUES ('17','1','100000','100');
INSERT INTO DistributionAreaFloras VALUES ('17','34','100700','96');
INSERT INTO DistributionAreaFloras VALUES ('17','41','100758','94');
INSERT INTO DistributionAreaFloras VALUES ('17','42','100859','92');
INSERT INTO DistributionAreaFloras VALUES ('17','46','101208','90');
INSERT INTO DistributionAreaFloras VALUES ('17','7','101270','98');
INSERT INTO DistributionAreaFloras VALUES ('18','3','100394','94');
INSERT INTO DistributionAreaFloras VALUES ('18','38','100733','98');
INSERT INTO DistributionAreaFloras VALUES ('18','4','100756','92');
INSERT INTO DistributionAreaFloras VALUES ('18','44','101061','96');
INSERT INTO DistributionAreaFloras VALUES ('18','79','101280','100');
INSERT INTO DistributionAreaFloras VALUES ('19','12','100104','98');
INSERT INTO DistributionAreaFloras VALUES ('19','20','100380','100');
INSERT INTO DistributionAreaFloras VALUES ('19','50','101248','96');
INSERT INTO DistributionAreaFloras VALUES ('19','58','101257','94');
INSERT INTO DistributionAreaFloras VALUES ('20','16','100337','90');
INSERT INTO DistributionAreaFloras VALUES ('20','27','100389','92');
INSERT INTO DistributionAreaFloras VALUES ('20','34','100700','98');
INSERT INTO DistributionAreaFloras VALUES ('20','37','100722','80');
INSERT INTO DistributionAreaFloras VALUES ('20','39','100745','86');
INSERT INTO DistributionAreaFloras VALUES ('20','41','100758','88');
INSERT INTO DistributionAreaFloras VALUES ('20','46','101208','96');
INSERT INTO DistributionAreaFloras VALUES ('20','51','101249','84');
INSERT INTO DistributionAreaFloras VALUES ('20','52','101250','82');
INSERT INTO DistributionAreaFloras VALUES ('20','53','101251','94');
INSERT INTO DistributionAreaFloras VALUES ('20','71','101272','100');
INSERT INTO DistributionAreaFloras VALUES ('21','18','100354','94');
INSERT INTO DistributionAreaFloras VALUES ('21','25','100386','100');
INSERT INTO DistributionAreaFloras VALUES ('21','33','100599','96');
INSERT INTO DistributionAreaFloras VALUES ('21','43','100960','98');
INSERT INTO DistributionAreaFloras VALUES ('22','17','100343','98');
INSERT INTO DistributionAreaFloras VALUES ('22','32','100498','96');
INSERT INTO DistributionAreaFloras VALUES ('22','58','101257','100');
INSERT INTO DistributionAreaFloras VALUES ('22','59','101258','94');
INSERT INTO DistributionAreaFloras VALUES ('23','18','100354','94');
INSERT INTO DistributionAreaFloras VALUES ('23','43','100960','98');
INSERT INTO DistributionAreaFloras VALUES ('23','58','101257','100');
INSERT INTO DistributionAreaFloras VALUES ('23','63','101263','96');
INSERT INTO DistributionAreaFloras VALUES ('24','18','100354','94');
INSERT INTO DistributionAreaFloras VALUES ('24','43','100960','98');
INSERT INTO DistributionAreaFloras VALUES ('24','58','101257','100');
INSERT INTO DistributionAreaFloras VALUES ('24','63','101263','96');
INSERT INTO DistributionAreaFloras VALUES ('25','3','100394','90');
INSERT INTO DistributionAreaFloras VALUES ('25','4','100756','88');
INSERT INTO DistributionAreaFloras VALUES ('25','44','101061','92');
INSERT INTO DistributionAreaFloras VALUES ('25','56','101254','96');
INSERT INTO DistributionAreaFloras VALUES ('25','57','101256','94');
INSERT INTO DistributionAreaFloras VALUES ('25','79','101280','98');
INSERT INTO DistributionAreaFloras VALUES ('25','80','101283','100');
INSERT INTO DistributionAreaFloras VALUES ('26','13','100205','98');
INSERT INTO DistributionAreaFloras VALUES ('26','34','100700','96');
INSERT INTO DistributionAreaFloras VALUES ('26','41','100758','92');
INSERT INTO DistributionAreaFloras VALUES ('26','46','101208','94');
INSERT INTO DistributionAreaFloras VALUES ('26','67','101267','100');
INSERT INTO DistributionAreaFloras VALUES ('27','14','100306','92');
INSERT INTO DistributionAreaFloras VALUES ('27','48','101225','86');
INSERT INTO DistributionAreaFloras VALUES ('27','49','101236','88');
INSERT INTO DistributionAreaFloras VALUES ('27','58','101257','94');
INSERT INTO DistributionAreaFloras VALUES ('27','60','101260','90');
INSERT INTO DistributionAreaFloras VALUES ('27','69','101269','96');
INSERT INTO DistributionAreaFloras VALUES ('27','72','101273','98');
INSERT INTO DistributionAreaFloras VALUES ('27','79','101280','100');

/*************************************************************************************/
 
DELETE FROM DistributionArea;
INSERT INTO DistributionPresence VALUES ('1','-','absent but reported in error','100');
INSERT INTO DistributionPresence VALUES ('2','E','formerly present but presumably extinct','90');
INSERT INTO DistributionPresence VALUES ('3','+','present as native','50');
INSERT INTO DistributionPresence VALUES ('4','?','doubtfully present','30');
INSERT INTO DistributionPresence VALUES ('5','.','not recorded','10');
INSERT INTO DistributionPresence VALUES ('6','&','conflict in data','1');

/*************************************************************************************/
 
DELETE FROM DistributionArea;
INSERT INTO DistributionStatus VALUES ('1','D         ','doubtfully native','70');
INSERT INTO DistributionStatus VALUES ('2','N         ','naturalized','40');
INSERT INTO DistributionStatus VALUES ('3','P         ','problematic','20');
INSERT INTO DistributionStatus VALUES ('4','A         ','alien (xenophyte if mcl-area is used)','60');
INSERT INTO DistributionStatus VALUES ('5','2         ','conflict before import','10');
INSERT INTO DistributionStatus VALUES ('6','3         ','conflict before import','5');
INSERT INTO DistributionStatus VALUES ('7','C         ','cultivated','80');
INSERT INTO DistributionStatus VALUES ('8','E         ','endemic','100');
