--$Id:

--Store this as PopulateCoreCatalogTables.sql

--This script was generated by the procedure p_PopulateCatalogTables on: Dec  1 2003 11:20AM

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

-- Catalogue entries for table FactCategory

/*
There are no core catalogue entries in the FactCategory table.
But there is an agreement to stick to a certain range of IDs for a registered project as follows:

0   -  99   Euro+Med
100 - 199   MedChecklist
200 - 299   Algaterra
300 - 399   Salvador
400 - 499   ???
500 - 599   IOPI
600 - 699   MoreTax Moose
700 - 799   MoreTax Standardliste

*/

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

Delete FROM NomStatus;
INSERT INTO NomStatus VALUES (1,'nom. inval.',Null);
INSERT INTO NomStatus VALUES (2,'nom. illeg.',Null);
INSERT INTO NomStatus VALUES (3,'nom. nud.',Null);
INSERT INTO NomStatus VALUES (4,'nom. rej.',Null);
INSERT INTO NomStatus VALUES (5,'nom. rej. prop.',Null);
INSERT INTO NomStatus VALUES (6,'nom. utique rej. ',Null);
INSERT INTO NomStatus VALUES (7,'nom. utique rej. prop.',Null);
INSERT INTO NomStatus VALUES (8,'nom. cons.',Null);
INSERT INTO NomStatus VALUES (9,'nom. cons. prop.',Null);
INSERT INTO NomStatus VALUES (10,'orth. cons.',Null);
INSERT INTO NomStatus VALUES (11,'orth. cons. prop.',Null);

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

Delete FROM Rank;
INSERT INTO Rank VALUES (1,'reg.','Regnum',Null);
INSERT INTO Rank VALUES (3,'subreg.','Subregnum',Null);
INSERT INTO Rank VALUES (5,'phyl.','Phylum',Null);
INSERT INTO Rank VALUES (7,'subphyl.','subphylum',Null);
INSERT INTO Rank VALUES (8,'div.','Divisio',Null);
INSERT INTO Rank VALUES (9,'subdiv.','Subdivisio',Null);
INSERT INTO Rank VALUES (10,'cl.','Classis',Null);
INSERT INTO Rank VALUES (13,'subcl.','Subclassis',Null);
INSERT INTO Rank VALUES (16,'superor.','Superordo',Null);
INSERT INTO Rank VALUES (18,'ordo','Ordo',Null);
INSERT INTO Rank VALUES (19,'subor.','Subordo',Null);
INSERT INTO Rank VALUES (20,'fam.','Familia',Null);
INSERT INTO Rank VALUES (25,'subfam.','Subfamilia',Null);
INSERT INTO Rank VALUES (30,'trib.','Tribus',Null);
INSERT INTO Rank VALUES (35,'subtrib.','Subtribus',Null);
INSERT INTO Rank VALUES (40,'gen.','Genus',Null);
INSERT INTO Rank VALUES (42,'subgen.','Subgenus',Null);
INSERT INTO Rank VALUES (45,'sect.','Sectio',Null);
INSERT INTO Rank VALUES (47,'subsect.','Subsectio',Null);
INSERT INTO Rank VALUES (50,'ser.','Series',Null);
INSERT INTO Rank VALUES (52,'subser.','Subseries',Null);
INSERT INTO Rank VALUES (58,'aggr.','Aggregate',Null);
INSERT INTO Rank VALUES (59,'group','Speciesgroup',Null);
INSERT INTO Rank VALUES (60,'sp.','Species',Null);
INSERT INTO Rank VALUES (65,'subsp.','Subspecies',Null);
INSERT INTO Rank VALUES (68,'convar.','Convarietas',Null);
INSERT INTO Rank VALUES (70,'var.','Varietas',Null);
INSERT INTO Rank VALUES (73,'subvar.','Subvarietas',Null);
INSERT INTO Rank VALUES (80,'f.','Forma',Null);
INSERT INTO Rank VALUES (82,'subf.','Subforma',Null);
INSERT INTO Rank VALUES (84,'f.spec.','Forma spec.',Null);
INSERT INTO Rank VALUES (98,'t.infgen.','tax.infragen.',Null);
INSERT INTO Rank VALUES (99,'t.infr.','tax.infrasp.',Null);

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

Delete FROM RefCategory;
INSERT INTO RefCategory VALUES (1,'article in periodical','AP',Null);
INSERT INTO RefCategory VALUES (2,'part of other title','IN',Null);
INSERT INTO RefCategory VALUES (3,'book','BK',Null);
INSERT INTO RefCategory VALUES (4,'database','DB',Null);
INSERT INTO RefCategory VALUES (5,'informal reference','IR',Null);
INSERT INTO RefCategory VALUES (6,'not applicable','NA',Null);
INSERT INTO RefCategory VALUES (7,'website','WB',Null);
INSERT INTO RefCategory VALUES (8,'published CD','CD',Null);
INSERT INTO RefCategory VALUES (9,'journal','JR',Null);
INSERT INTO RefCategory VALUES (10,'unresolved','UR',Null);

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

Delete FROM RelAuthorQualifier;
INSERT INTO RelAuthorQualifier VALUES (1,'equals',Null);
INSERT INTO RelAuthorQualifier VALUES (2,'orthographic variant of',Null);
INSERT INTO RelAuthorQualifier VALUES (3,'old standard for',Null);

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

Delete FROM RelNameQualifier;
INSERT INTO RelNameQualifier VALUES (1,'is basionym for',Null);
INSERT INTO RelNameQualifier VALUES (2,'is later homonym of',Null);
INSERT INTO RelNameQualifier VALUES (3,'is replaced synonym for',Null);
INSERT INTO RelNameQualifier VALUES (4,'is validation of',Null);
INSERT INTO RelNameQualifier VALUES (5,'is later validation of',Null);
INSERT INTO RelNameQualifier VALUES (6,'is type of',Null);
INSERT INTO RelNameQualifier VALUES (7,'is conserved type of',Null);
INSERT INTO RelNameQualifier VALUES (8,'is rejected type of',Null);
INSERT INTO RelNameQualifier VALUES (9,'is first parent of',Null);
INSERT INTO RelNameQualifier VALUES (10,'is second parent of',Null);
INSERT INTO RelNameQualifier VALUES (11,'is female parent of',Null);
INSERT INTO RelNameQualifier VALUES (12,'is male parent of',Null);
INSERT INTO RelNameQualifier VALUES (13,'is conserved against',Null);
INSERT INTO RelNameQualifier VALUES (14,'is rejected in favour of',Null);
INSERT INTO RelNameQualifier VALUES (15,'is treated as later homonym of',Null);
INSERT INTO RelNameQualifier VALUES (16,'is orthographic variant of',Null);

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

Delete FROM RelPTQualifier;
INSERT INTO RelPTQualifier VALUES (-99,'inactivated --> is taxonomically included in',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (1,'is taxonomically included in',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (2,'is synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (3,'is misapplied name for',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (4,'is pro parte synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (5,'is partial synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (6,'is heterotypic synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (7,'is homotypic synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (10,'is contradiction',0,0,0,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (11,'is congruent to',1,0,0,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (12,'is included in',0,1,0,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (13,'is congruent to or is included in',1,1,0,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (14,'includes',0,0,1,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (15,'is congruent to or includes',1,0,1,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (16,'is included in or includes',0,1,1,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (17,'is congruent to or is included in or includes',1,1,1,0,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (18,'overlaps',0,0,0,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (19,'is congruent to or overlaps',1,0,0,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (20,'is included in or overlaps',0,1,0,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (21,'is congruent to or is included in or overlaps',1,1,0,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (22,'includes or overlaps',0,0,1,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (23,'is congruent to or includes or overlaps',1,0,1,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (24,'is included in or includes or overlaps',0,1,1,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (25,'has common elements with',1,1,1,1,0,0,1,Null);
INSERT INTO RelPTQualifier VALUES (26,'excludes',0,0,0,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (27,'is congruent to or excludes',1,0,0,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (28,'is included in or excludes',0,1,0,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (29,'is congruent to or is included in or excludes',1,1,0,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (30,'includes or excludes',0,0,1,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (31,'is congruent to or includes or excludes',1,0,1,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (32,'is included in or includes or excludes',0,1,1,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (33,'does not overlap',1,1,1,0,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (34,'overlaps or excludes',0,0,0,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (35,'is congruent to or overlaps or excludes',1,0,0,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (36,'is included in or overlaps or excludes',0,1,0,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (37,'does not include',1,1,0,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (38,'includes or overlaps or excludes',0,0,1,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (39,'is not included in',1,0,1,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (40,'is not congruent to',0,1,1,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (41,'all relationships with',1,1,1,1,1,0,1,Null);
INSERT INTO RelPTQualifier VALUES (42,'doubtful',0,0,0,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (43,'? congruent to',1,0,0,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (44,'? included in',0,1,0,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (45,'is congruent to or is included in, doubtful',1,1,0,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (46,'? includes',0,0,1,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (47,'is congruent to or includes, doubtful',1,0,1,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (48,'is included in or includes, doubtful',0,1,1,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (49,'is congruent to or is included in or includes, doubtful',1,1,1,0,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (50,'? overlaps',0,0,0,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (51,'is congruent to or overlaps, doubtful',1,0,0,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (52,'is included in or overlaps, doubtful',0,1,0,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (53,'is congruent to or is included in or overlaps, doubtful',1,1,0,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (54,'includes or overlaps, doubtful',0,0,1,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (55,'is congruent to or includes or overlaps, doubtful',1,0,1,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (56,'is included in or includes or overlaps, doubtful',0,1,1,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (57,'? has common elements with',1,1,1,1,0,1,1,Null);
INSERT INTO RelPTQualifier VALUES (58,'? excludes',0,0,0,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (59,'is congruent to or excludes, doubtful',1,0,0,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (60,'is included in or excludes, doubtful',0,1,0,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (61,'is congruent to or is included in or excludes, doubtful',1,1,0,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (62,'includes or excludes, doubtful',0,0,1,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (63,'is congruent to or includes or excludes, doubtful',1,0,1,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (64,'is included in or includes or excludes, doubtful',0,1,1,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (65,'? does not overlap',1,1,1,0,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (66,'overlaps or excludes ,doubtful',0,0,0,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (67,'is congruent to or overlaps or excludes, doubtful',1,0,0,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (68,'is included in or overlaps or excludes, doubtful',0,1,0,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (69,'? does not include',1,1,0,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (70,'includes or overlaps or excludes, doubtful',0,0,1,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (71,'? is not included in',1,0,1,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (72,'? is not congruent to',0,1,1,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (73,'all relationships with, doubtful',1,1,1,1,1,1,1,Null);
INSERT INTO RelPTQualifier VALUES (101,'is pro parte and homotypic synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (102,'is pro parte and heterotypic synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (103,'is partial and homotypic synonym of',0,0,0,0,0,0,0,Null);
INSERT INTO RelPTQualifier VALUES (104,'is partial and heterotypic synonym of',0,0,0,0,0,0,0,Null);
/*************************************************************************************/

Delete FROM RelReferenceQualifier;
INSERT INTO RelReferenceQualifier VALUES (1,'equals',Null);
INSERT INTO RelReferenceQualifier VALUES (2,'orthographical variant of',Null);

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

Delete FROM Status;
INSERT INTO Status VALUES (1,'accepted','A         ',Null);
INSERT INTO Status VALUES (2,'synonym','S         ',Null);
INSERT INTO Status VALUES (3,'partial synonym','P         ',Null);
INSERT INTO Status VALUES (4,'pro parte synonym','L         ',Null);
INSERT INTO Status VALUES (5,'unresolved','U         ',Null);