text:
INSERT INTO public.namespace (id, lock_version, name, description_html, rdf_id) VALUES
(nextval('nsl_global_seq'), 0, 'APNI', '(description of APNI)', 'apni'),
(nextval('nsl_global_seq'), 0, 'ANHSIR', '(description of ANHSIR)', 'anhsir'),
(nextval('nsl_global_seq'), 0, 'AusMoss', '(description of AusMoss)', 'ausmoss'),
(nextval('nsl_global_seq'), 0, 'Algae', '(description of Algae)', 'algae'),
(nextval('nsl_global_seq'), 0, 'Lichen', '(description of Lichen)', 'lichen'),
(nextval('nsl_global_seq'), 0, 'Fungi', '(description of Fungi)', 'fungi');
--language
INSERT INTO public.language (id, lock_version, iso6391code, iso6393code, name) VALUES
(nextval('nsl_global_seq'), 0, null, 'mul', 'Multiple languages'),
(nextval('nsl_global_seq'), 0, null, 'zxx', 'No linguistic content'),
(nextval('nsl_global_seq'), 0, null, 'mis', 'Uncoded languages'),
(nextval('nsl_global_seq'), 0, null, 'und', 'Undetermined'),
(nextval('nsl_global_seq'), 0, 'aa', 'aar', 'Afar'),
(nextval('nsl_global_seq'), 0, 'ab', 'abk', 'Abkhazian'),
(nextval('nsl_global_seq'), 0, null, 'ace', 'Achinese'),
(nextval('nsl_global_seq'), 0, null, 'ach', 'Acoli'),
(nextval('nsl_global_seq'), 0, null, 'ada', 'Adangme'),
(nextval('nsl_global_seq'), 0, null, 'ady', 'Adyghe'),
(nextval('nsl_global_seq'), 0, 'af', 'afr', 'Afrikaans'),
(nextval('nsl_global_seq'), 0, null, 'ain', 'Ainu'),
(nextval('nsl_global_seq'), 0, null, 'ale', 'Aleut'),
(nextval('nsl_global_seq'), 0, null, 'alt', 'Southern Altai'),
(nextval('nsl_global_seq'), 0, 'am', 'amh', 'Amharic'),
(nextval('nsl_global_seq'), 0, null, 'anp', 'Angika'),
(nextval('nsl_global_seq'), 0, 'an', 'arg', 'Aragonese'),
(nextval('nsl_global_seq'), 0, null, 'arn', 'Mapudungun'),
(nextval('nsl_global_seq'), 0, null, 'arp', 'Arapaho'),
(nextval('nsl_global_seq'), 0, null, 'arw', 'Arawak'),
(nextval('nsl_global_seq'), 0, 'as', 'asm', 'Assamese'),
(nextval('nsl_global_seq'), 0, null, 'ast', 'Asturian'),
(nextval('nsl_global_seq'), 0, 'av', 'ava', 'Avaric'),
(nextval('nsl_global_seq'), 0, null, 'awa', 'Awadhi'),
(nextval('nsl_global_seq'), 0, 'ba', 'bak', 'Bashkir'),
(nextval('nsl_global_seq'), 0, 'bm', 'bam', 'Bambara'),
(nextval('nsl_global_seq'), 0, null, 'ban', 'Balinese'),
(nextval('nsl_global_seq'), 0, null, 'bas', 'Basa'),
(nextval('nsl_global_seq'), 0, null, 'bej', 'Beja'),
(nextval('nsl_global_seq'), 0, 'be', 'bel', 'Belarusian'),
(nextval('nsl_global_seq'), 0, null, 'bem', 'Bemba'),
(nextval('nsl_global_seq'), 0, 'bn', 'ben', 'Bengali'),
(nextval('nsl_global_seq'), 0, null, 'bho', 'Bhojpuri'),
(nextval('nsl_global_seq'), 0, null, 'bin', 'Bini'),
(nextval('nsl_global_seq'), 0, 'bi', 'bis', 'Bislama'),
(nextval('nsl_global_seq'), 0, null, 'bla', 'Siksika'),
(nextval('nsl_global_seq'), 0, 'bo', 'bod', 'Tibetan'),
(nextval('nsl_global_seq'), 0, 'bs', 'bos', 'Bosnian'),
(nextval('nsl_global_seq'), 0, null, 'bra', 'Braj'),
(nextval('nsl_global_seq'), 0, 'br', 'bre', 'Breton'),
(nextval('nsl_global_seq'), 0, null, 'bug', 'Buginese'),
(nextval('nsl_global_seq'), 0, 'bg', 'bul', 'Bulgarian'),
(nextval('nsl_global_seq'), 0, null, 'byn', 'Bilin'),
(nextval('nsl_global_seq'), 0, null, 'cad', 'Caddo'),
(nextval('nsl_global_seq'), 0, null, 'car', 'Galibi Carib'),
(nextval('nsl_global_seq'), 0, 'ca', 'cat', 'Catalan'),
(nextval('nsl_global_seq'), 0, null, 'ceb', 'Cebuano'),
(nextval('nsl_global_seq'), 0, 'cs', 'ces', 'Czech'),
(nextval('nsl_global_seq'), 0, 'ch', 'cha', 'Chamorro'),
(nextval('nsl_global_seq'), 0, 'ce', 'che', 'Chechen'),
(nextval('nsl_global_seq'), 0, null, 'chk', 'Chuukese'),
(nextval('nsl_global_seq'), 0, null, 'chn', 'Chinook jargon'),
(nextval('nsl_global_seq'), 0, null, 'cho', 'Choctaw'),
(nextval('nsl_global_seq'), 0, null, 'chp', 'Chipewyan'),
(nextval('nsl_global_seq'), 0, null, 'chr', 'Cherokee'),
(nextval('nsl_global_seq'), 0, 'cv', 'chv', 'Chuvash'),
(nextval('nsl_global_seq'), 0, null, 'chy', 'Cheyenne'),
(nextval('nsl_global_seq'), 0, 'kw', 'cor', 'Cornish'),
(nextval('nsl_global_seq'), 0, 'co', 'cos', 'Corsican'),
(nextval('nsl_global_seq'), 0, null, 'crh', 'Crimean Tatar'),
(nextval('nsl_global_seq'), 0, null, 'csb', 'Kashubian'),
(nextval('nsl_global_seq'), 0, 'cy', 'cym', 'Welsh'),
(nextval('nsl_global_seq'), 0, null, 'dak', 'Dakota'),
(nextval('nsl_global_seq'), 0, 'da', 'dan', 'Danish'),
(nextval('nsl_global_seq'), 0, null, 'dar', 'Dargwa'),
(nextval('nsl_global_seq'), 0, 'de', 'deu', 'German'),
(nextval('nsl_global_seq'), 0, null, 'dgr', 'Dogrib'),
(nextval('nsl_global_seq'), 0, 'dv', 'div', 'Dhivehi'),
(nextval('nsl_global_seq'), 0, null, 'dsb', 'Lower Sorbian'),
(nextval('nsl_global_seq'), 0, null, 'dua', 'Duala'),
(nextval('nsl_global_seq'), 0, null, 'dyu', 'Dyula'),
(nextval('nsl_global_seq'), 0, 'dz', 'dzo', 'Dzongkha'),
(nextval('nsl_global_seq'), 0, null, 'efi', 'Efik'),
(nextval('nsl_global_seq'), 0, null, 'eka', 'Ekajuk'),
(nextval('nsl_global_seq'), 0, 'el', 'ell', 'Greek'),
(nextval('nsl_global_seq'), 0, 'en', 'eng', 'English'),
(nextval('nsl_global_seq'), 0, 'eu', 'eus', 'Basque'),
(nextval('nsl_global_seq'), 0, 'ee', 'ewe', 'Ewe'),
(nextval('nsl_global_seq'), 0, null, 'ewo', 'Ewondo'),
(nextval('nsl_global_seq'), 0, null, 'fan', 'Fang'),
(nextval('nsl_global_seq'), 0, 'fo', 'fao', 'Faroese'),
(nextval('nsl_global_seq'), 0, null, 'fat', 'Fanti'),
(nextval('nsl_global_seq'), 0, 'fj', 'fij', 'Fijian'),
(nextval('nsl_global_seq'), 0, null, 'fil', 'Filipino'),
(nextval('nsl_global_seq'), 0, 'fi', 'fin', 'Finnish'),
(nextval('nsl_global_seq'), 0, null, 'fon', 'Fon'),
(nextval('nsl_global_seq'), 0, 'fr', 'fra', 'French'),
(nextval('nsl_global_seq'), 0, null, 'frr', 'Northern Frisian'),
(nextval('nsl_global_seq'), 0, null, 'frs', 'Eastern Frisian'),
(nextval('nsl_global_seq'), 0, 'fy', 'fry', 'Western Frisian'),
(nextval('nsl_global_seq'), 0, null, 'fur', 'Friulian'),
(nextval('nsl_global_seq'), 0, null, 'gaa', 'Ga'),
(nextval('nsl_global_seq'), 0, null, 'gay', 'Gayo'),
(nextval('nsl_global_seq'), 0, null, 'gil', 'Gilbertese'),
(nextval('nsl_global_seq'), 0, 'gd', 'gla', 'Scottish Gaelic'),
(nextval('nsl_global_seq'), 0, 'ga', 'gle', 'Irish'),
(nextval('nsl_global_seq'), 0, 'gl', 'glg', 'Galician'),
(nextval('nsl_global_seq'), 0, 'gv', 'glv', 'Manx'),
(nextval('nsl_global_seq'), 0, null, 'gor', 'Gorontalo'),
(nextval('nsl_global_seq'), 0, null, 'gsw', 'Swiss German'),
(nextval('nsl_global_seq'), 0, 'gu', 'guj', 'Gujarati'),
(nextval('nsl_global_seq'), 0, null, 'gwi', 'Gwich'in'),
(nextval('nsl_global_seq'), 0, 'ht', 'hat', 'Haitian'),
(nextval('nsl_global_seq'), 0, 'ha', 'hau', 'Hausa'),
(nextval('nsl_global_seq'), 0, null, 'haw', 'Hawaiian'),
(nextval('nsl_global_seq'), 0, 'he', 'heb', 'Hebrew'),
(nextval('nsl_global_seq'), 0, 'hz', 'her', 'Herero'),
(nextval('nsl_global_seq'), 0, null, 'hil', 'Hiligaynon'),
(nextval('nsl_global_seq'), 0, 'hi', 'hin', 'Hindi'),
(nextval('nsl_global_seq'), 0, 'ho', 'hmo', 'Hiri Motu'),
(nextval('nsl_global_seq'), 0, 'hr', 'hrv', 'Croatian'),
(nextval('nsl_global_seq'), 0, null, 'hsb', 'Upper Sorbian'),
(nextval('nsl_global_seq'), 0, 'hu', 'hun', 'Hungarian'),
(nextval('nsl_global_seq'), 0, null, 'hup', 'Hupa'),
(nextval('nsl_global_seq'), 0, 'hy', 'hye', 'Armenian'),
(nextval('nsl_global_seq'), 0, null, 'iba', 'Iban'),
(nextval('nsl_global_seq'), 0, 'ig', 'ibo', 'Igbo'),
(nextval('nsl_global_seq'), 0, 'ii', 'iii', 'Sichuan Yi'),
(nextval('nsl_global_seq'), 0, null, 'ilo', 'Iloko'),
(nextval('nsl_global_seq'), 0, 'id', 'ind', 'Indonesian'),
(nextval('nsl_global_seq'), 0, null, 'inh', 'Ingush'),
(nextval('nsl_global_seq'), 0, 'is', 'isl', 'Icelandic'),
(nextval('nsl_global_seq'), 0, 'it', 'ita', 'Italian'),
(nextval('nsl_global_seq'), 0, 'jv', 'jav', 'Javanese'),
(nextval('nsl_global_seq'), 0, 'ja', 'jpn', 'Japanese'),
(nextval('nsl_global_seq'), 0, null, 'jpr', 'Judeo-Persian'),
(nextval('nsl_global_seq'), 0, null, 'kaa', 'Kara-Kalpak'),
(nextval('nsl_global_seq'), 0, null, 'kab', 'Kabyle'),
(nextval('nsl_global_seq'), 0, null, 'kac', 'Kachin'),
(nextval('nsl_global_seq'), 0, 'kl', 'kal', 'Kalaallisut'),
(nextval('nsl_global_seq'), 0, null, 'kam', 'Kamba'),
(nextval('nsl_global_seq'), 0, 'kn', 'kan', 'Kannada'),
(nextval('nsl_global_seq'), 0, 'ks', 'kas', 'Kashmiri'),
(nextval('nsl_global_seq'), 0, 'ka', 'kat', 'Georgian'),
(nextval('nsl_global_seq'), 0, 'kk', 'kaz', 'Kazakh'),
(nextval('nsl_global_seq'), 0, null, 'kbd', 'Kabardian'),
(nextval('nsl_global_seq'), 0, null, 'kha', 'Khasi'),
(nextval('nsl_global_seq'), 0, 'km', 'khm', 'Central Khmer'),
(nextval('nsl_global_seq'), 0, 'ki', 'kik', 'Kikuyu'),
(nextval('nsl_global_seq'), 0, 'rw', 'kin', 'Kinyarwanda'),
(nextval('nsl_global_seq'), 0, 'ky', 'kir', 'Kirghiz'),
(nextval('nsl_global_seq'), 0, null, 'kmb', 'Kimbundu'),
(nextval('nsl_global_seq'), 0, 'ko', 'kor', 'Korean'),
(nextval('nsl_global_seq'), 0, null, 'kos', 'Kosraean'),
(nextval('nsl_global_seq'), 0, null, 'krc', 'Karachay-Balkar'),
(nextval('nsl_global_seq'), 0, null, 'krl', 'Karelian'),
(nextval('nsl_global_seq'), 0, null, 'kru', 'Kurukh'),
(nextval('nsl_global_seq'), 0, 'kj', 'kua', 'Kuanyama'),
(nextval('nsl_global_seq'), 0, null, 'kum', 'Kumyk'),
(nextval('nsl_global_seq'), 0, null, 'kut', 'Kutenai'),
(nextval('nsl_global_seq'), 0, null, 'lad', 'Ladino'),
(nextval('nsl_global_seq'), 0, null, 'lam', 'Lamba'),
(nextval('nsl_global_seq'), 0, 'la', 'lat', 'Latin'),
(nextval('nsl_global_seq'), 0, 'lo', 'lao', 'Lao'),
(nextval('nsl_global_seq'), 0, null, 'lez', 'Lezghian'),
(nextval('nsl_global_seq'), 0, 'li', 'lim', 'Limburgan'),
(nextval('nsl_global_seq'), 0, 'ln', 'lin', 'Lingala'),
(nextval('nsl_global_seq'), 0, 'lt', 'lit', 'Lithuanian'),
(nextval('nsl_global_seq'), 0, null, 'lol', 'Mongo'),
(nextval('nsl_global_seq'), 0, null, 'loz', 'Lozi'),
(nextval('nsl_global_seq'), 0, 'lb', 'ltz', 'Luxembourgish'),
(nextval('nsl_global_seq'), 0, null, 'lua', 'Luba-Lulua'),
(nextval('nsl_global_seq'), 0, 'lu', 'lub', 'Luba-Katanga'),
(nextval('nsl_global_seq'), 0, 'lg', 'lug', 'Ganda'),
(nextval('nsl_global_seq'), 0, null, 'lui', 'Luiseno'),
(nextval('nsl_global_seq'), 0, null, 'lun', 'Lunda'),
(nextval('nsl_global_seq'), 0, null, 'luo', 'Luo'),
(nextval('nsl_global_seq'), 0, null, 'lus', 'Lushai'),
(nextval('nsl_global_seq'), 0, null, 'mad', 'Madurese'),
(nextval('nsl_global_seq'), 0, null, 'mag', 'Magahi'),
(nextval('nsl_global_seq'), 0, 'mh', 'mah', 'Marshallese'),
(nextval('nsl_global_seq'), 0, null, 'mai', 'Maithili'),
(nextval('nsl_global_seq'), 0, null, 'mak', 'Makasar'),
(nextval('nsl_global_seq'), 0, 'ml', 'mal', 'Malayalam'),
(nextval('nsl_global_seq'), 0, 'mr', 'mar', 'Marathi'),
(nextval('nsl_global_seq'), 0, null, 'mas', 'Masai'),
(nextval('nsl_global_seq'), 0, null, 'mdf', 'Moksha'),
(nextval('nsl_global_seq'), 0, null, 'mdr', 'Mandar'),
(nextval('nsl_global_seq'), 0, null, 'men', 'Mende'),
(nextval('nsl_global_seq'), 0, null, 'mic', 'Mi''kmaq'),
(nextval('nsl_global_seq'), 0, null, 'min', 'Minangkabau'),
(nextval('nsl_global_seq'), 0, 'mk', 'mkd', 'Macedonian'),
(nextval('nsl_global_seq'), 0, 'mt', 'mlt', 'Maltese'),
(nextval('nsl_global_seq'), 0, null, 'mnc', 'Manchu'),
(nextval('nsl_global_seq'), 0, null, 'mni', 'Manipuri'),
(nextval('nsl_global_seq'), 0, null, 'moh', 'Mohawk'),
(nextval('nsl_global_seq'), 0, null, 'mos', 'Mossi'),
(nextval('nsl_global_seq'), 0, 'mi', 'mri', 'Maori'),
(nextval('nsl_global_seq'), 0, null, 'mus', 'Creek'),
(nextval('nsl_global_seq'), 0, null, 'mwl', 'Mirandese'),
(nextval('nsl_global_seq'), 0, 'my', 'mya', 'Burmese'),
(nextval('nsl_global_seq'), 0, null, 'myv', 'Erzya'),
(nextval('nsl_global_seq'), 0, null, 'nap', 'Neapolitan'),
(nextval('nsl_global_seq'), 0, 'na', 'nau', 'Nauru'),
(nextval('nsl_global_seq'), 0, 'nv', 'nav', 'Navajo'),
(nextval('nsl_global_seq'), 0, 'nr', 'nbl', 'South Ndebele'),
(nextval('nsl_global_seq'), 0, 'nd', 'nde', 'North Ndebele'),
(nextval('nsl_global_seq'), 0, 'ng', 'ndo', 'Ndonga'),
(nextval('nsl_global_seq'), 0, null, 'nds', 'Low German'),
(nextval('nsl_global_seq'), 0, null, 'new', 'Newari'),
(nextval('nsl_global_seq'), 0, null, 'nia', 'Nias'),
(nextval('nsl_global_seq'), 0, null, 'niu', 'Niuean'),
(nextval('nsl_global_seq'), 0, 'nl', 'nld', 'Dutch'),
(nextval('nsl_global_seq'), 0, 'nn', 'nno', 'Norwegian Nynorsk'),
(nextval('nsl_global_seq'), 0, 'nb', 'nob', 'Norwegian Bokmål'),
(nextval('nsl_global_seq'), 0, null, 'nog', 'Nogai'),
(nextval('nsl_global_seq'), 0, null, 'nqo', 'N''Ko'),
(nextval('nsl_global_seq'), 0, null, 'nso', 'Pedi'),
(nextval('nsl_global_seq'), 0, 'ny', 'nya', 'Nyanja'),
(nextval('nsl_global_seq'), 0, null, 'nym', 'Nyamwezi'),
(nextval('nsl_global_seq'), 0, null, 'nyn', 'Nyankole'),
(nextval('nsl_global_seq'), 0, null, 'nyo', 'Nyoro'),
(nextval('nsl_global_seq'), 0, null, 'nzi', 'Nzima'),
(nextval('nsl_global_seq'), 0, 'oc', 'oci', 'Occitan'),
(nextval('nsl_global_seq'), 0, null, 'osa', 'Osage'),
(nextval('nsl_global_seq'), 0, 'os', 'oss', 'Ossetian'),
(nextval('nsl_global_seq'), 0, null, 'pag', 'Pangasinan'),
(nextval('nsl_global_seq'), 0, null, 'pam', 'Pampanga'),
(nextval('nsl_global_seq'), 0, 'pa', 'pan', 'Panjabi'),
(nextval('nsl_global_seq'), 0, null, 'pap', 'Papiamento'),
(nextval('nsl_global_seq'), 0, null, 'pau', 'Palauan'),
(nextval('nsl_global_seq'), 0, 'pl', 'pol', 'Polish'),
(nextval('nsl_global_seq'), 0, null, 'pon', 'Pohnpeian'),
(nextval('nsl_global_seq'), 0, 'pt', 'por', 'Portuguese'),
(nextval('nsl_global_seq'), 0, null, 'rap', 'Rapanui'),
(nextval('nsl_global_seq'), 0, null, 'rar', 'Rarotongan'),
(nextval('nsl_global_seq'), 0, 'rm', 'roh', 'Romansh'),
(nextval('nsl_global_seq'), 0, 'ro', 'ron', 'Romanian'),
(nextval('nsl_global_seq'), 0, 'rn', 'run', 'Rundi'),
(nextval('nsl_global_seq'), 0, null, 'rup', 'Macedo-Romanian'),
(nextval('nsl_global_seq'), 0, 'ru', 'rus', 'Russian'),
(nextval('nsl_global_seq'), 0, null, 'sad', 'Sandawe'),
(nextval('nsl_global_seq'), 0, 'sg', 'sag', 'Sango'),
(nextval('nsl_global_seq'), 0, null, 'sah', 'Yakut'),
(nextval('nsl_global_seq'), 0, null, 'sas', 'Sasak'),
(nextval('nsl_global_seq'), 0, null, 'sat', 'Santali'),
(nextval('nsl_global_seq'), 0, null, 'scn', 'Sicilian'),
(nextval('nsl_global_seq'), 0, null, 'sco', 'Scots'),
(nextval('nsl_global_seq'), 0, null, 'sel', 'Selkup'),
(nextval('nsl_global_seq'), 0, null, 'shn', 'Shan'),
(nextval('nsl_global_seq'), 0, null, 'sid', 'Sidamo'),
(nextval('nsl_global_seq'), 0, 'si', 'sin', 'Sinhala'),
(nextval('nsl_global_seq'), 0, 'sk', 'slk', 'Slovak'),
(nextval('nsl_global_seq'), 0, 'sl', 'slv', 'Slovenian'),
(nextval('nsl_global_seq'), 0, null, 'sma', 'Southern Sami'),
(nextval('nsl_global_seq'), 0, 'se', 'sme', 'Northern Sami'),
(nextval('nsl_global_seq'), 0, null, 'smj', 'Lule Sami'),
(nextval('nsl_global_seq'), 0, null, 'smn', 'Inari Sami'),
(nextval('nsl_global_seq'), 0, 'sm', 'smo', 'Samoan'),
(nextval('nsl_global_seq'), 0, null, 'sms', 'Skolt Sami'),
(nextval('nsl_global_seq'), 0, 'sn', 'sna', 'Shona'),
(nextval('nsl_global_seq'), 0, 'sd', 'snd', 'Sindhi'),
(nextval('nsl_global_seq'), 0, null, 'snk', 'Soninke'),
(nextval('nsl_global_seq'), 0, 'so', 'som', 'Somali'),
(nextval('nsl_global_seq'), 0, 'st', 'sot', 'Southern Sotho'),
(nextval('nsl_global_seq'), 0, 'es', 'spa', 'Spanish'),
(nextval('nsl_global_seq'), 0, null, 'srn', 'Sranan Tongo'),
(nextval('nsl_global_seq'), 0, 'sr', 'srp', 'Serbian'),
(nextval('nsl_global_seq'), 0, null, 'srr', 'Serer'),
(nextval('nsl_global_seq'), 0, 'ss', 'ssw', 'Swati'),
(nextval('nsl_global_seq'), 0, null, 'suk', 'Sukuma'),
(nextval('nsl_global_seq'), 0, 'su', 'sun', 'Sundanese'),
(nextval('nsl_global_seq'), 0, null, 'sus', 'Susu'),
(nextval('nsl_global_seq'), 0, 'sv', 'swe', 'Swedish'),
(nextval('nsl_global_seq'), 0, 'ty', 'tah', 'Tahitian'),
(nextval('nsl_global_seq'), 0, 'ta', 'tam', 'Tamil'),
(nextval('nsl_global_seq'), 0, 'tt', 'tat', 'Tatar'),
(nextval('nsl_global_seq'), 0, 'te', 'tel', 'Telugu'),
(nextval('nsl_global_seq'), 0, null, 'tem', 'Timne'),
(nextval('nsl_global_seq'), 0, null, 'ter', 'Tereno'),
(nextval('nsl_global_seq'), 0, null, 'tet', 'Tetum'),
(nextval('nsl_global_seq'), 0, 'tg', 'tgk', 'Tajik'),
(nextval('nsl_global_seq'), 0, 'tl', 'tgl', 'Tagalog'),
(nextval('nsl_global_seq'), 0, 'th', 'tha', 'Thai'),
(nextval('nsl_global_seq'), 0, null, 'tig', 'Tigre'),
(nextval('nsl_global_seq'), 0, 'ti', 'tir', 'Tigrinya'),
(nextval('nsl_global_seq'), 0, null, 'tiv', 'Tiv'),
(nextval('nsl_global_seq'), 0, null, 'tkl', 'Tokelau'),
(nextval('nsl_global_seq'), 0, null, 'tli', 'Tlingit'),
(nextval('nsl_global_seq'), 0, null, 'tog', 'Tonga (Nyasa)'),
(nextval('nsl_global_seq'), 0, 'to', 'ton', 'Tonga (Tonga Islands)'),
(nextval('nsl_global_seq'), 0, null, 'tpi', 'Tok Pisin'),
(nextval('nsl_global_seq'), 0, null, 'tsi', 'Tsimshian'),
(nextval('nsl_global_seq'), 0, 'tn', 'tsn', 'Tswana'),
(nextval('nsl_global_seq'), 0, 'ts', 'tso', 'Tsonga'),
(nextval('nsl_global_seq'), 0, 'tk', 'tuk', 'Turkmen'),
(nextval('nsl_global_seq'), 0, null, 'tum', 'Tumbuka'),
(nextval('nsl_global_seq'), 0, 'tr', 'tur', 'Turkish'),
(nextval('nsl_global_seq'), 0, null, 'tvl', 'Tuvalu'),
(nextval('nsl_global_seq'), 0, 'tw', 'twi', 'Twi'),
(nextval('nsl_global_seq'), 0, null, 'tyv', 'Tuvinian'),
(nextval('nsl_global_seq'), 0, null, 'udm', 'Udmurt'),
(nextval('nsl_global_seq'), 0, 'ug', 'uig', 'Uighur'),
(nextval('nsl_global_seq'), 0, 'uk', 'ukr', 'Ukrainian'),
(nextval('nsl_global_seq'), 0, null, 'umb', 'Umbundu'),
(nextval('nsl_global_seq'), 0, 'ur', 'urd', 'Urdu'),
(nextval('nsl_global_seq'), 0, null, 'vai', 'Vai'),
(nextval('nsl_global_seq'), 0, 've', 'ven', 'Venda'),
(nextval('nsl_global_seq'), 0, 'vi', 'vie', 'Vietnamese'),
(nextval('nsl_global_seq'), 0, null, 'vot', 'Votic'),
(nextval('nsl_global_seq'), 0, null, 'wal', 'Wolaytta'),
(nextval('nsl_global_seq'), 0, null, 'war', 'Waray'),
(nextval('nsl_global_seq'), 0, null, 'was', 'Washo'),
(nextval('nsl_global_seq'), 0, 'wa', 'wln', 'Walloon'),
(nextval('nsl_global_seq'), 0, 'wo', 'wol', 'Wolof'),
(nextval('nsl_global_seq'), 0, null, 'xal', 'Kalmyk'),
(nextval('nsl_global_seq'), 0, 'xh', 'xho', 'Xhosa'),
(nextval('nsl_global_seq'), 0, null, 'yao', 'Yao'),
(nextval('nsl_global_seq'), 0, null, 'yap', 'Yapese'),
(nextval('nsl_global_seq'), 0, 'yo', 'yor', 'Yoruba'),
(nextval('nsl_global_seq'), 0, null, 'zen', 'Zenaga'),
(nextval('nsl_global_seq'), 0, 'zu', 'zul', 'Zulu'),
(nextval('nsl_global_seq'), 0, null, 'zun', 'Zuni'),
(nextval('nsl_global_seq'), 0, 'ak', 'aka', 'Akan'),
(nextval('nsl_global_seq'), 0, 'ar', 'ara', 'Arabic'),
(nextval('nsl_global_seq'), 0, 'ay', 'aym', 'Aymara'),
(nextval('nsl_global_seq'), 0, 'az', 'aze', 'Azerbaijani'),
(nextval('nsl_global_seq'), 0, null, 'bal', 'Baluchi'),
(nextval('nsl_global_seq'), 0, null, 'bik', 'Bikol'),
(nextval('nsl_global_seq'), 0, null, 'bua', 'Buriat'),
(nextval('nsl_global_seq'), 0, null, 'chm', 'Mari'),
(nextval('nsl_global_seq'), 0, 'cr', 'cre', 'Cree'),
(nextval('nsl_global_seq'), 0, null, 'del', 'Delaware'),
(nextval('nsl_global_seq'), 0, null, 'den', 'Slave'),
(nextval('nsl_global_seq'), 0, null, 'din', 'Dinka'),
(nextval('nsl_global_seq'), 0, null, 'doi', 'Dogri'),
(nextval('nsl_global_seq'), 0, 'et', 'est', 'Estonian'),
(nextval('nsl_global_seq'), 0, 'fa', 'fas', 'Persian'),
(nextval('nsl_global_seq'), 0, 'ff', 'ful', 'Fulah'),
(nextval('nsl_global_seq'), 0, null, 'gba', 'Gbaya'),
(nextval('nsl_global_seq'), 0, null, 'gon', 'Gondi'),
(nextval('nsl_global_seq'), 0, null, 'grb', 'Grebo'),
(nextval('nsl_global_seq'), 0, 'gn', 'grn', 'Guarani'),
(nextval('nsl_global_seq'), 0, null, 'hai', 'Haida'),
(nextval('nsl_global_seq'), 0, null, 'hmn', 'Hmong'),
(nextval('nsl_global_seq'), 0, 'iu', 'iku', 'Inuktitut'),
(nextval('nsl_global_seq'), 0, 'ik', 'ipk', 'Inupiaq'),
(nextval('nsl_global_seq'), 0, null, 'jrb', 'Judeo-Arabic'),
(nextval('nsl_global_seq'), 0, 'kr', 'kau', 'Kanuri'),
(nextval('nsl_global_seq'), 0, null, 'kok', 'Konkani'),
(nextval('nsl_global_seq'), 0, 'kv', 'kom', 'Komi'),
(nextval('nsl_global_seq'), 0, 'kg', 'kon', 'Kongo'),
(nextval('nsl_global_seq'), 0, null, 'kpe', 'Kpelle'),
(nextval('nsl_global_seq'), 0, 'ku', 'kur', 'Kurdish'),
(nextval('nsl_global_seq'), 0, null, 'lah', 'Lahnda'),
(nextval('nsl_global_seq'), 0, 'lv', 'lav', 'Latvian'),
(nextval('nsl_global_seq'), 0, null, 'man', 'Mandingo'),
(nextval('nsl_global_seq'), 0, 'mg', 'mlg', 'Malagasy'),
(nextval('nsl_global_seq'), 0, 'mn', 'mon', 'Mongolian'),
(nextval('nsl_global_seq'), 0, 'ms', 'msa', 'Malay'),
(nextval('nsl_global_seq'), 0, null, 'mwr', 'Marwari'),
(nextval('nsl_global_seq'), 0, 'ne', 'nep', 'Nepali'),
(nextval('nsl_global_seq'), 0, 'no', 'nor', 'Norwegian'),
(nextval('nsl_global_seq'), 0, 'oj', 'oji', 'Ojibwa'),
(nextval('nsl_global_seq'), 0, 'or', 'ori', 'Oriya'),
(nextval('nsl_global_seq'), 0, 'om', 'orm', 'Oromo'),
(nextval('nsl_global_seq'), 0, 'ps', 'pus', 'Pushto'),
(nextval('nsl_global_seq'), 0, 'qu', 'que', 'Quechua'),
(nextval('nsl_global_seq'), 0, null, 'raj', 'Rajasthani'),
(nextval('nsl_global_seq'), 0, null, 'rom', 'Romany'),
(nextval('nsl_global_seq'), 0, 'sq', 'sqi', 'Albanian'),
(nextval('nsl_global_seq'), 0, 'sc', 'srd', 'Sardinian'),
(nextval('nsl_global_seq'), 0, 'sw', 'swa', 'Swahili'),
(nextval('nsl_global_seq'), 0, null, 'syr', 'Syriac'),
(nextval('nsl_global_seq'), 0, null, 'tmh', 'Tamashek'),
(nextval('nsl_global_seq'), 0, 'uz', 'uzb', 'Uzbek'),
(nextval('nsl_global_seq'), 0, 'yi', 'yid', 'Yiddish'),
(nextval('nsl_global_seq'), 0, null, 'zap', 'Zapotec'),
(nextval('nsl_global_seq'), 0, 'za', 'zha', 'Zhuang'),
(nextval('nsl_global_seq'), 0, 'zh', 'zho', 'Chinese'),
(nextval('nsl_global_seq'), 0, null, 'zza', 'Zaza');
-- instance note key
INSERT INTO public.instance_note_key (id, lock_version, deprecated, name, sort_order, description_html, rdf_id) VALUES
(nextval('nsl_global_seq'), 0, false, 'Neotype', 3, '(description of Neotype)', 'neotype'),
(nextval('nsl_global_seq'), 0, true, 'Ex.distribution', 100, '(description of Ex.distribution)', 'ex-distribution'),
(nextval('nsl_global_seq'), 0, false, 'APC Comment', 7, '(description of APC Comment)', 'apc-comment'),
(nextval('nsl_global_seq'), 0, false, 'EPBC Impact', 10, '(description of EPBC Impact)', 'epbc-impact'),
(nextval('nsl_global_seq'), 0, true, 'Status', 100, '(description of Status)', 'status'),
(nextval('nsl_global_seq'), 0, true, 'Under', 100, '(description of Under)', 'under'),
(nextval('nsl_global_seq'), 0, true, 'Distribution', 100, '(description of Distribution)', 'distribution'),
(nextval('nsl_global_seq'), 0, true, 'URL', 100, '(description of URL)', 'url'),
(nextval('nsl_global_seq'), 0, false, 'Lectotype', 2, '(description of Lectotype)', 'lectotype'),
(nextval('nsl_global_seq'), 0, true, 'Context', 100, '(description of Context)', 'context'),
(nextval('nsl_global_seq'), 0, false, 'Vernacular', 100, '(description of Vernacular)', 'vernacular'),
(nextval('nsl_global_seq'), 0, false, 'Text', 4, '(description of Text)', 'text'),
(nextval('nsl_global_seq'), 0, false, 'Comment', 5, '(description of Comment)', 'comment'),
(nextval('nsl_global_seq'), 0, true, 'Synonym', 100, '(description of Synonym)', 'synonym'),
(nextval('nsl_global_seq'), 0, false, 'Type', 1, '(description of Type)', 'type'),
(nextval('nsl_global_seq'), 0, false, 'APC Dist.', 8, '(description of APC Dist.)', 'apc-dist'),
(nextval('nsl_global_seq'), 0, false, 'Etymology', 6, '(description of Etymology)', 'etymology'),
(nextval('nsl_global_seq'), 0, false, 'EPBC Advice', 9, '(description of EPBC Advice)', 'epbc-advice'),
(nextval('nsl_global_seq'), 0, true, 'APNI', 100, '(description of APNI)', 'apni'),
(nextval('nsl_global_seq'), 0, false, 'Type herbarium', 11, '(description of Type herbarium)', 'type-herbarium'),
(nextval('nsl_global_seq'), 0, false, 'AMANI dist.', 16, '(description of AMANI distribution)', 'amani-distribution'),
(nextval('nsl_global_seq'), 0, false, 'AMANI comment', 17, '(description of AMANI comment)', 'amani-comment'),
(nextval('nsl_global_seq'), 0, false, 'Type locality', 12, '(description of Type locality)', 'type-locality'),
(nextval('nsl_global_seq'), 0, false, 'Type specimen', 13, '(description of Type specimen)', 'type-specimen'),
(nextval('nsl_global_seq'), 0, false, 'Culture collection', 100, '(description of Culture collection)', 'culture-collection'),
(nextval('nsl_global_seq'), 0, false, 'Graphic', 100, '(description of Graphic)', 'graphic'),
(nextval('nsl_global_seq'), 0, false, 'Habit', 100, '(description of Habit)', 'habit'),
(nextval('nsl_global_seq'), 0, false, 'Habitat', 100, '(description of Habitat)', 'habitat'),
(nextval('nsl_global_seq'), 0, false, 'Nutrition', 100, '(description of Nutrition)', 'nutrition'),
(nextval('nsl_global_seq'), 0, false, 'Type comment', 14, '(description of Type comment)', 'type-comment'),
(nextval('nsl_global_seq'), 0, false, 'Type illustration', 15, '(description of Type illustration)', 'type-illustration');
-- instance type
INSERT INTO public.instance_type (id, lock_version, citing, deprecated, doubtful, misapplied, name, nomenclatural, primary_instance, pro_parte, protologue, relationship, secondary_instance, sort_order, standalone, synonym, taxonomic, unsourced, description_html, rdf_id, has_label, of_label, bidirectional) VALUES
(nextval('nsl_global_seq'), 0, false, false, false, false, '[default]', false, false, false, false, false, false, 400, false, false, false, false, '(description of [default])', 'default', '[default]', '[default] of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, '[unknown]', false, false, false, false, false, false, 400, false, false, false, false, '(description of [unknown])', 'unknown', '[unknown]', '[unknown] of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, '[n/a]', false, false, false, false, false, false, 400, false, false, false, false, '(description of [n/a])', 'n-a', '[n/a]', '[n/a] of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'primary reference', false, true, false, false, false, false, 400, true, false, false, false, '(description of primary reference)', 'primary-reference', 'primary reference', 'primary reference of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'tax. nov.', false, true, false, true, false, false, 400, true, false, false, false, '(description of tax. nov.)', 'tax-nov', 'tax. nov.', 'tax. nov. of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'nom. nov.', false, true, false, true, false, false, 400, true, false, false, false, '(description of nom. nov.)', 'nom-nov', 'nom. nov.', 'nom. nov. of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'nom. et stat. nov.', false, true, false, true, false, false, 400, true, false, false, false, '(description of nom. et stat. nov.)', 'nom-et-stat-nov', 'nom. et stat. nov.', 'nom. et stat. nov. of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'comb. nov.', false, true, false, true, false, false, 400, true, false, false, false, '(description of comb. nov.)', 'comb-nov', 'comb. nov.', 'comb. nov. of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'comb. et stat. nov.', false, true, false, true, false, false, 400, true, false, false, false, '(description of comb. et stat. nov.)', 'comb-et-stat-nov', 'comb. et stat. nov.', 'comb. et stat. nov. of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'autonym', false, false, false, false, false, false, 400, true, false, false, false, '(description of autonym)', 'autonym', 'autonym', 'autonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'orthographic variant', false, false, false, false, true, false, 5, false, true, false, false, '(description of orthographic variant)', 'orthographic-variant', 'orthographic variant', 'orthographic variant of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'implicit autonym', false, false, false, false, false, false, 400, true, false, false, false, '(description of implicit autonym)', 'implicit-autonym', 'implicit autonym', 'implicit autonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, true, 'misapplied', false, false, false, false, true, false, 400, false, false, false, false, '(description of misapplied)', 'misapplied', 'misapplication', 'misapplied to', false),
(nextval('nsl_global_seq'), 0, true, false, false, true, 'pro parte misapplied', false, false, true, false, true, false, 70, false, false, false, false, '(description of pro parte misapplied)', 'pro-parte-misapplied', 'pro parte misapplication', 'pro parte misapplied to', false),
(nextval('nsl_global_seq'), 0, true, false, true, true, 'doubtful misapplied', false, false, false, false, true, false, 80, false, false, false, false, '(description of doubtful misapplied)', 'doubtful-misapplied', 'doubtful misapplication', 'doubtful misapplied to', false),
(nextval('nsl_global_seq'), 0, true, false, true, true, 'doubtful pro parte misapplied', false, false, false, false, true, false, 90, false, false, false, false, '(description of doubtful pro parte misapplied)', 'doubtful-pro-parte-misapplied', 'doubtful pro parte misapplication', 'doubtful pro parte misapplied to', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'secondary reference', false, false, false, false, false, true, 400, true, false, false, false, '(description of secondary reference)', 'secondary-reference', 'secondary reference', 'secondary reference of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'isonym', false, false, false, false, true, false, 400, false, true, false, false, '(description of isonym)', 'isonym', 'isonym', 'isonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'trade name', false, false, false, false, true, false, 400, false, true, false, false, '(description of trade name)', 'trade-name', 'trade name', 'trade name of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'excluded name', false, false, false, false, false, false, 400, false, false, false, false, '(description of excluded name)', 'excluded-name', 'excluded name', 'excluded name of', false),
(nextval('nsl_global_seq'), 0, false, false, true, false, 'doubtful invalid publication', false, false, false, false, false, false, 400, false, false, false, false, '(description of doubtful invalid publication)', 'doubtful-invalid-publication', 'doubtful invalid publication', 'doubtful invalid publication of', false),
(nextval('nsl_global_seq'), 0, true, true, false, false, 'synonym', false, false, false, false, true, false, 140, false, true, false, true, '(description of synonym)', 'synonym', 'synonym', 'synonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'nomenclatural synonym', true, false, false, false, true, false, 30, false, true, false, false, '(description of nomenclatural synonym)', 'nomenclatural-synonym', 'nomenclatural synonym', 'nomenclatural synonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'taxonomic synonym', false, false, false, false, true, false, 100, false, true, true, false, '(description of taxonomic synonym)', 'taxonomic-synonym', 'taxonomic synonym', 'taxonomic synonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'replaced synonym', false, false, false, false, true, false, 10, false, true, false, false, '(description of replaced synonym)', 'replaced-synonym', 'replaced synonym', 'replaced synonym of', false),
(nextval('nsl_global_seq'), 0, true, true, false, false, 'pro parte synonym', false, false, true, false, true, false, 150, false, true, false, false, '(description of pro parte synonym)', 'pro-parte-synonym', 'pro parte synonym', 'pro parte synonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'pro parte taxonomic synonym', false, false, true, false, true, false, 110, false, true, true, false, '(description of pro parte taxonomic synonym)', 'pro-parte-taxonomic-synonym', 'pro parte taxonomic synonym', 'pro parte taxonomic synonym of', false),
(nextval('nsl_global_seq'), 0, true, true, true, false, 'doubtful synonym', false, false, false, false, true, false, 160, false, true, false, false, '(description of doubtful synonym)', 'doubtful-synonym', 'doubtful synonym', 'doubtful synonym of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'homonym', false, false, false, false, false, false, 400, true, false, false, false, '(description of homonym)', 'homonym', 'homonym', 'homonym of', false),
(nextval('nsl_global_seq'), 0, false, true, false, false, 'invalid publication', false, false, false, false, false, false, 400, false, false, false, false, '(description of invalid publication)', 'invalid-publication', 'invalid publication', 'invalid publication of', false),
(nextval('nsl_global_seq'), 0, false, true, false, false, 'sens. lat.', false, false, false, false, false, false, 400, false, false, false, false, '(description of sens. lat.)', 'sens-lat', 'sens. lat.', 'sens. lat. of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'common name', false, false, false, false, true, false, 400, false, false, false, true, '(description of common name)', 'common-name', 'common name', 'common name of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'vernacular name', false, false, false, false, true, false, 400, false, false, false, true, '(description of vernacular name)', 'vernacular-name', 'vernacular name', 'vernacular name of', false),
(nextval('nsl_global_seq'), 0, true, false, true, false, 'doubtful taxonomic synonym', false, false, false, false, true, false, 120, false, true, true, false, '(description of doubtful taxonomic synonym)', 'doubtful-taxonomic-synonym', 'doubtful taxonomic synonym', 'doubtful taxonomic synonym of', false),
(nextval('nsl_global_seq'), 0, true, true, true, false, 'doubtful pro parte synonym', false, false, false, false, true, false, 170, false, true, false, false, '(description of doubtful pro parte synonym)', 'doubtful-pro-parte-synonym', 'doubtful pro parte synonym', 'doubtful pro parte synonym of', false),
(nextval('nsl_global_seq'), 0, true, false, true, false, 'doubtful pro parte taxonomic synonym', false, false, false, false, true, false, 130, false, true, true, false, '(description of doubtful pro parte taxonomic synonym)', 'doubtful-pro-parte-taxonomic-synonym', 'doubtful pro parte taxonomic synonym', 'doubtful pro parte taxonomic synonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, false, 'basionym', true, false, false, false, true, false, 10, false, true, false, false, '(description of basionym)', 'basionym', 'basionym', 'basionym of', false),
(nextval('nsl_global_seq'), 0, false, false, true, false, 'doubtful nomenclatural synonym', true, false, false, false, false, false, 40, false, true, false, false, '(description of doubtful nomenclatural synonym)', 'doubtful-nomenclatural-synonym', 'doubtful nomenclatural synonym', 'doubtful nomenclatural synonym of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'pro parte nomenclatural synonym', true, false, true, false, false, false, 50, false, true, false, false, '(description of pro parte nomenclatural synonym)', 'pro-parte-nomenclatural-synonym', 'pro parte nomenclatural synonym', 'pro parte nomenclatural synonym of', false),
(nextval('nsl_global_seq'), 0, false, false, false, false, 'pro parte replaced synonym', false, false, true, false, false, false, 20, false, true, false, false, '(description of pro parte replaced synonym)', 'pro-parte-replaced-synonym', 'pro parte replaced synonym', 'pro parte replaced synonym of', false),
(nextval('nsl_global_seq'), 0, true, false, false, true, 'unsourced misapplied', false, false, false, false, true, false, 400, false, false, false, true, '(description of unsourced misapplied)', 'unsourced-misapplied', 'misapplication', 'misapplied to', false),
(nextval('nsl_global_seq'), 0, true, false, false, true, 'unsourced pro parte misapplied', false, false, true, false, true, false, 70, false, false, false, true, '(description of unsourced pro parte misapplied)', 'unsourced-pro-parte-misapplied', 'pro parte misapplication', 'pro parte misapplied to', false),
(nextval('nsl_global_seq'), 0, true, false, true, true, 'unsourced doubtful misapplied', false, false, false, false, true, false, 80, false, false, false, true, '(description of unsourced doubtful misapplied)', 'unsourced-doubtful-misapplied', 'doubtful misapplication', 'doubtful misapplied to', false),
(nextval('nsl_global_seq'), 0, true, false, true, true, 'unsourced doubtful pro parte misapplied', false, false, false, false, true, false, 90, false, false, false, true, '(description of unsourced doubtful pro parte misapplied)', 'unsourced-doubtful-pro-parte-misapplied', 'doubtful pro parte misapplication', 'doubtful pro parte misapplied to', false);

-- name category
insert into name_category
(id, lock_version,
 name,
 sort_order,
 description_html,
 rdf_id,
 max_parents_allowed,
 min_parents_required,
 parent_1_help_text,
 parent_2_help_text,
 requires_family,
 requires_higher_ranked_parent,
 requires_name_element,
 takes_author_only,
 takes_authors,
 takes_cultivar_scoped_parent,
 takes_hybrid_scoped_parent,
 takes_name_element,
 takes_verbatim_rank,
 takes_rank)
values
(nextval('nsl_global_seq'), 0,'cultivar', 50, 'names entered and edited as cultivar names', 'cultivar', 1, 1, 'cultivar - genus and below, or unranked if unranked', null, true, false, true, false, false, true, false, true, true, true),
(nextval('nsl_global_seq'), 0,'scientific', 10, 'names entered and edited as scientific names', 'scientific', 1, 1, 'ordinary - restricted by rank, or unranked if unranked', null, true, true, true, false, true, false, false, true, true, true),
(nextval('nsl_global_seq'), 0,'cultivar hybrid', 60, 'names entered and edited as cultivar hybrid names', null, 2, 2, 'cultivar - genus and below, or unranked if unranked', 'cultivar - genus and below, or unranked if unranked', true, false, true, false, false, true, false, true, true, true),
(nextval('nsl_global_seq'), 0,'other', 70, 'names entered and edited as other names', null, 0, 0, 'ordinary - restricted by rank, or unranked if unranked', null, false, false, true, false, false, true, false, true, true, false),
(nextval('nsl_global_seq'), 0,'phrase name', 20, 'names entered and edited as scientific phrase names', null, 1, 1, 'ordinary - restricted by rank, or unranked if unranked', null, true, false, false, true, false, false, false, true, false, true),
(nextval('nsl_global_seq'), 0,'scientific hybrid formula', 30, 'names entered and edited as scientific hybrid formulae', null, 2, 2, 'hybrid - species and below or unranked if unranked', 'hybrid - species and below or unranked if unranked', true, false, false, false, false, false, true, false, true, true),
(nextval('nsl_global_seq'), 0,'scientific hybrid formula unknown 2nd parent', 40, 'names entered and edited as scientific hybrid formulae with unknown 2nd parent', null, 1, 1, 'hybrid - species and below or unranked if unranked', null, true, false, false, false, false, true, true, false, true, true);

-- name group
INSERT INTO public.name_group (id, lock_version, name, description_html, rdf_id) VALUES
(nextval('nsl_global_seq'), 0, '[unknown]', '(description of [unknown])', 'unknown'),
(nextval('nsl_global_seq'), 0, '[n/a]', '(description of [n/a])', 'n-a'),
(nextval('nsl_global_seq'), 0, 'botanical', '(description of botanical)', 'botanical'),
(nextval('nsl_global_seq'), 0, 'zoological', '(description of zoological)', 'zoological');

-- name rank
INSERT INTO public.name_rank (id, lock_version, abbrev, deprecated, has_parent, italicize, major, name, name_group_id, parent_rank_id, sort_order, visible_in_name, description_html, rdf_id, use_verbatim_rank, display_name) VALUES
(nextval('nsl_global_seq'), 0, 'regio', false, false, false, true,      'Regio',              (select id from name_group where name = 'botanical'), null, 8, false, '(description of Regio)', 'regio', false, 'Regio'),
(nextval('nsl_global_seq'), 0, 'reg.', false, false, false, true,       'Regnum',             (select id from name_group where name = 'botanical'), null, 10, false, '(description of Regnum)', 'regnum', false, 'Regnum'),
(nextval('nsl_global_seq'), 0, 'div.', false, false, false, true,       'Division',           (select id from name_group where name = 'botanical'), null, 20, false, '(description of Division)', 'division', false, 'Division'),
(nextval('nsl_global_seq'), 0, 'cl.', false, false, false, true,        'Classis',            (select id from name_group where name = 'botanical'), null, 30, false, '(description of Classis)', 'classis', false, 'Classis'),
(nextval('nsl_global_seq'), 0, 'subcl.', false, false, false, false,    'Subclassis',         (select id from name_group where name = 'botanical'), null, 40, false, '(description of Subclassis)', 'subclassis', false, 'Subclassis'),
(nextval('nsl_global_seq'), 0, 'superordo', false, false, false, false, 'Superordo',          (select id from name_group where name = 'botanical'), null, 50, false, '(description of Superordo)', 'superordo', false, 'Superordo'),
(nextval('nsl_global_seq'), 0, 'ordo', false, false, false, true,       'Ordo',               (select id from name_group where name = 'botanical'), null, 60, false, '(description of Ordo)', 'ordo', false, 'Ordo'),
(nextval('nsl_global_seq'), 0, 'subordo', false, false, false, false,   'Subordo',            (select id from name_group where name = 'botanical'), null, 70, false, '(description of Subordo)', 'subordo', false, 'Subordo'),
(nextval('nsl_global_seq'), 0, 'fam.', false, false, false, true,       'Familia',            (select id from name_group where name = 'botanical'), null, 80, false, '(description of Familia)', 'familia', false, 'Familia'),
(nextval('nsl_global_seq'), 0, 'subfam.', false, true, false, false,    'Subfamilia',         (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'fam.'), 90, false, '(description of Subfamilia)', 'subfamilia', false, 'Subfamilia'),
(nextval('nsl_global_seq'), 0, 'trib.', false, true, false, false,      'Tribus',             (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'fam.'), 100, false, '(description of Tribus)', 'tribus', false, 'Tribus'),
(nextval('nsl_global_seq'), 0, 'subtrib.', false, true, false, false,   'Subtribus',          (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'fam.'), 110, false, '(description of Subtribus)', 'subtribus', false, 'Subtribus'),
(nextval('nsl_global_seq'), 0, 'gen.', false, false, false, true,       'Genus',              (select id from name_group where name = 'botanical'), null,                                             120, false, '(description of Genus)', 'genus', false, 'Genus'),
(nextval('nsl_global_seq'), 0, 'subg.', false, true, false, false,      'Subgenus',           (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 130, true, '(description of Subgenus)', 'subgenus', false, 'Subgenus'),
(nextval('nsl_global_seq'), 0, 'sect.', false, true, false, false,      'Sectio',             (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 140, true, '(description of Sectio)', 'sectio', false, 'Sectio'),
(nextval('nsl_global_seq'), 0, 'subsect.', false, true, false, false,   'Subsectio',          (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 150, true, '(description of Subsectio)', 'subsectio', false, 'Subsectio'),
(nextval('nsl_global_seq'), 0, 'ser.', false, true, false, false,       'Series',             (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 160, true, '(description of Series)', 'series', false, 'Series'),
(nextval('nsl_global_seq'), 0, 'subser.', false, true, false, false,    'Subseries',          (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 170, true, '(description of Subseries)', 'subseries', false, 'Subseries'),
(nextval('nsl_global_seq'), 0, 'supersp.', false, true, false, false,   'Superspecies',       (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 180, true, '(description of Superspecies)', 'superspecies', false, 'Superspecies'),
(nextval('nsl_global_seq'), 0, 'sp.', false, true, false, true,         'Species',            (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 190, false, '(description of Species)', 'species', false, 'Species'),
(nextval('nsl_global_seq'), 0, 'subsp.', false, true, false, false,     'Subspecies',         (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  200, true, '(description of Subspecies)', 'subspecies', false, 'Subspecies'),
(nextval('nsl_global_seq'), 0, 'nothovar.', false, true, false, false,  'Nothovarietas',      (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  210, true, '(description of Nothovarietas)', 'nothovarietas', false, 'Nothovarietas'),
(nextval('nsl_global_seq'), 0, 'var.', false, true, false, false,       'Varietas',           (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  210, true, '(description of Varietas)', 'varietas', false, 'Varietas'),
(nextval('nsl_global_seq'), 0, 'subvar.', false, true, false, false,    'Subvarietas',        (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  220, true, '(description of Subvarietas)', 'subvarietas', false, 'Subvarietas'),
(nextval('nsl_global_seq'), 0, 'f.', false, true, false, false,         'Forma',              (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  230, true, '(description of Forma)', 'forma', false, 'Forma'),
(nextval('nsl_global_seq'), 0, 'subf.', false, true, false, false,      'Subforma',           (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  240, true, '(description of Subforma)', 'subforma', false, 'Subforma'),
(nextval('nsl_global_seq'), 0, 'form taxon', true, true, false, false,  'form taxon',         (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  250, false, '(description of form taxon)', 'form-taxon', false, 'form taxon'),
(nextval('nsl_global_seq'), 0, 'morph.', true, true, false, false,      'morphological var.', (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  260, false, '(description of morphological var.)', 'morphological-var', false, 'morphological var.'),
(nextval('nsl_global_seq'), 0, 'nothomorph', true, true, false, false,  'nothomorph.',        (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  270, false, '(description of nothomorph.)', 'nothomorph', false, 'nothomorph.'),
(nextval('nsl_global_seq'), 0, '[n/a]', false, false, false, false,     '[n/a]',              (select id from name_group where name = 'botanical'), null,                                             500, false, '(description of [n/a])', 'n-a', false, '[n/a]'),
(nextval('nsl_global_seq'), 0, '[infrafamily]', false, true, false, false, '[infrafamily]',   (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'fam.'), 500, true, '(description of [infrafamily])', 'infrafamily', true, '[infrafamily]'),
(nextval('nsl_global_seq'), 0, '[infragenus]', false, true, false, false, '[infragenus]',     (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'gen.'), 500, true, '(description of [infragenus])', 'infragenus', true, '[infragenus]'),
(nextval('nsl_global_seq'), 0, '[unknown]', true, false, false, false,  '[unknown]',          (select id from name_group where name = 'botanical'), null,                                             500, false, '(description of [unknown])', 'unknown', true, '[unknown]'),
(nextval('nsl_global_seq'), 0, '[unranked]', false, true, false, false, '[unranked]',         (select id from name_group where name = 'botanical'), null,                                             500, true, '(description of [unranked])', 'unranked', true, '[unranked]'),
(nextval('nsl_global_seq'), 0, '[infrasp.]', false, true, false, false, '[infraspecies]',     (select id from name_group where name = 'botanical'), (select id from name_rank where abbrev = 'sp.'),  500, false, '(description of [infraspecies])', 'infraspecies', true, '[infraspecies]');

--name status
INSERT INTO public.name_status (id, lock_version, display, name, name_group_id, name_status_id, nom_illeg, nom_inval, description_html, rdf_id) VALUES
(nextval('nsl_global_seq'), 0, true, '[default]', (select id from name_group where name = '[n/a]'), null, false, false, '(description of [default])', 'default'),
(nextval('nsl_global_seq'), 0, true, '[unknown]', (select id from name_group where name = '[n/a]'), null, false, false, '(description of [unknown])', 'unknown'),
(nextval('nsl_global_seq'), 0, true, '[n/a]', (select id from name_group where name = '[n/a]'), null, false, false, '(description of [n/a])', 'n-a'),
(nextval('nsl_global_seq'), 0, true, '[deleted]', (select id from name_group where name = '[n/a]'), null, false, false, '(description of [deleted])', 'deleted'),
(nextval('nsl_global_seq'), 0, true, 'legitimate', (select id from name_group where name = 'botanical'), null, false, false, '(description of legitimate)', 'legitimate'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval.)', 'nom-inval'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., pro syn.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., pro syn.)', 'nom-inval-pro-syn'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., nom. nud.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., nom. nud.)', 'nom-inval-nom-nud'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., nom. subnud.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., nom. subnud.)', 'nom-inval-nom-subnud'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., nom. ambig.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., nom. ambig.)', 'nom-inval-nom-ambig'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., nom. confus.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., nom. confus.)', 'nom-inval-nom-confus'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., nom. prov.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., nom. prov.)', 'nom-inval-nom-prov'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., nom. alt.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., nom. alt.)', 'nom-inval-nom-alt'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., nom. dub.', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., nom. dub.)', 'nom-inval-nom-dub'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., opera utique oppressa', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., opera utique oppressa)', 'nom-inval-opera-utique-oppressa'),
(nextval('nsl_global_seq'), 0, true, 'nom. inval., tautonym', (select id from name_group where name = 'botanical'), null, false, true, '(description of nom. inval., tautonym)', 'nom-inval-tautonym'),
(nextval('nsl_global_seq'), 0, true, 'nom. illeg.', (select id from name_group where name = 'botanical'), null, true, false, '(description of nom. illeg.)', 'nom-illeg'),
(nextval('nsl_global_seq'), 0, true, 'nom. illeg., nom. superfl.', (select id from name_group where name = 'botanical'), null, true, false, '(description of nom. illeg., nom. superfl.)', 'nom-illeg-nom-superfl'),
(nextval('nsl_global_seq'), 0, true, 'nom. illeg., nom. rej.', (select id from name_group where name = 'botanical'), null, true, false, '(description of nom. illeg., nom. rej.)', 'nom-illeg-nom-rej'),
(nextval('nsl_global_seq'), 0, true, 'isonym', (select id from name_group where name = 'botanical'), null, false, false, '(description of isonym)', 'isonym'),
(nextval('nsl_global_seq'), 0, true, 'nom. superfl.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. superfl.)', 'nom-superfl'),
(nextval('nsl_global_seq'), 0, true, 'nom. rej.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. rej.)', 'nom-rej'),
(nextval('nsl_global_seq'), 0, true, 'nom. alt.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. alt.)', 'nom-alt'),
(nextval('nsl_global_seq'), 0, true, 'nom. cult.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. cult.)', 'nom-cult'),
(nextval('nsl_global_seq'), 0, true, 'nom. cons.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. cons.)', 'nom-cons'),
(nextval('nsl_global_seq'), 0, true, 'nom. cons., orth. cons.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. cons., orth. cons.)', 'nom-cons-orth-cons'),
(nextval('nsl_global_seq'), 0, true, 'nom. cons., nom. alt.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. cons., nom. alt.)', 'nom-cons-nom-alt'),
(nextval('nsl_global_seq'), 0, true, 'nom. cult., nom. alt.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. cult., nom. alt.)', 'nom-cult-nom-alt'),
(nextval('nsl_global_seq'), 0, true, 'nom. et typ. cons.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. et typ. cons.)', 'nom-et-typ-cons'),
(nextval('nsl_global_seq'), 0, true, 'nom. et orth. cons.', (select id from name_group where name = 'botanical'), null, false, false, '(description of nom. et orth. cons.)', 'nom-et-orth-cons'),
(nextval('nsl_global_seq'), 0, true, 'nomina utique rejicienda', (select id from name_group where name = 'botanical'), null, false, false, '(description of nomina utique rejicienda)', 'nomina-utique-rejicienda'),
(nextval('nsl_global_seq'), 0, true, 'typ. cons.', (select id from name_group where name = 'botanical'), null, false, false, '(description of typ. cons.)', 'typ-cons'),
(nextval('nsl_global_seq'), 0, true, 'orth. var.', (select id from name_group where name = 'botanical'), null, false, false, '(description of orth. var.)', 'orth-var'),
(nextval('nsl_global_seq'), 0, true, 'orth. cons.', (select id from name_group where name = 'botanical'), null, false, false, '(description of orth. cons.)', 'orth-cons'),
(nextval('nsl_global_seq'), 0, true, 'manuscript', (select id from name_group where name = 'botanical'), null, false, false, '(description of manuscript)', 'manuscript'),
(nextval('nsl_global_seq'), 0, true, 'nom. alt., nom. illeg', (select id from name_group where name = 'botanical'), null, true, false, '(description of nom. alt., nom. illeg.)', 'nom-alt-nom-illeg');
-- name type                                                                                --name cat name group
INSERT INTO public.name_type (id, lock_version, autonym, connector, cultivar, formula, hybrid, name, name_category_id, name_group_id, scientific, sort_order, description_html, rdf_id, deprecated) VALUES
(nextval('nsl_global_seq'), 0, false, null, false, false, false, '[default]', (select id from name_category where name = 'other'), (select id from name_group where name = '[n/a]'), false, 1, '(description of [default])', 'default', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, '[unknown]', (select id from name_category where name = 'other'), (select id from name_group where name = '[n/a]'), false, 2, '(description of [unknown])', 'unknown', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, '[n/a]', (select id from name_category where name = 'other'), (select id from name_group where name = '[n/a]'), false, 3, '(description of [n/a])', 'n-a', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, 'scientific', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 4, '(description of scientific)', 'scientific', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, 'sanctioned', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 5, '(description of sanctioned)', 'sanctioned', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, 'phrase name', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 6, '(description of phrase name)', 'phrase-name', false),
(nextval('nsl_global_seq'), 0, false, 'x', false, true, true, 'hybrid formula parents known', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 7, '(description of hybrid formula parents known)', 'hybrid-formula-parents-known', false),
(nextval('nsl_global_seq'), 0, false, 'x', false, true, true, 'hybrid formula unknown 2nd parent', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 8, '(description of hybrid formula unknown 2nd parent)', 'hybrid-formula-unknown-2nd-parent', false),
(nextval('nsl_global_seq'), 0, false, 'x', false, false, true, 'named hybrid', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 9, '(description of named hybrid)', 'named-hybrid', false),
(nextval('nsl_global_seq'), 0, true, 'x', false, false, true, 'named hybrid autonym', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 10, '(description of named hybrid autonym)', 'named-hybrid-autonym', false),
(nextval('nsl_global_seq'), 0, true, 'x', false, false, true, 'hybrid autonym', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 11, '(description of hybrid autonym)', 'hybrid-autonym', false),
(nextval('nsl_global_seq'), 0, false, '-', false, true, true, 'intergrade', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 12, '(description of intergrade)', 'intergrade', false),
(nextval('nsl_global_seq'), 0, true, null, false, false, false, 'autonym', (select id from name_category where name = 'scientific'), (select id from name_group where name = 'botanical'), true, 13, '(description of autonym)', 'autonym', false),
(nextval('nsl_global_seq'), 0, false, null, true, false, false, 'cultivar', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 17, '(description of cultivar)', 'cultivar', false),
(nextval('nsl_global_seq'), 0, false, null, true, false, true, 'cultivar hybrid', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 18, '(description of cultivar hybrid)', 'cultivar-hybrid', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, 'informal', (select id from name_category where name = 'other'), (select id from name_group where name = 'botanical'), false, 26, '(description of informal)', 'informal', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, 'common', (select id from name_category where name = 'other'), (select id from name_group where name = 'botanical'), false, 15, '(description of common)', 'common', false),
(nextval('nsl_global_seq'), 0, false, null, false, false, false, 'vernacular', (select id from name_category where name = 'other'), (select id from name_group where name = 'botanical'), false, 16, '(description of vernacular)', 'vernacular', false),
(nextval('nsl_global_seq'), 0, false, '+', true, true, false, 'graft/chimera', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 25, '(description of graft / chimera)', 'graft-chimera', false),
(nextval('nsl_global_seq'), 0, false, null, true, false, false, 'acra', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 20, '(description of acra)', 'acra', true),
(nextval('nsl_global_seq'), 0, false, null, true, false, true, 'acra hybrid', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 21, '(description of acra hybrid)', 'acra-hybrid', true),
(nextval('nsl_global_seq'), 0, false, null, true, false, false, 'pbr', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 22, '(description of pbr)', 'pbr', true),
(nextval('nsl_global_seq'), 0, false, null, true, false, true, 'pbr hybrid', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 23, '(description of pbr hybrid)', 'pbr-hybrid', true),
(nextval('nsl_global_seq'), 0, false, null, true, false, false, 'trade', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 24, '(description of trade)', 'trade', true),
(nextval('nsl_global_seq'), 0, false, null, true, false, true, 'trade hybrid', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 25, '(description of trade hybrid)', 'trade-hybrid', true),
(nextval('nsl_global_seq'), 0, false, 'x', true, true, true, 'cultivar hybrid formula', (select id from name_category where name = 'cultivar'), (select id from name_group where name = 'botanical'), false, 19, '(description of cultivar hybrid formula)', 'cultivar-hybrid-formula', false);
-- reference author role
INSERT INTO public.ref_author_role (id, lock_version, name, description_html, rdf_id) VALUES
(nextval('nsl_global_seq'), 0, 'Unknown', '(description of Unknown)', 'unknown'),
(nextval('nsl_global_seq'), 0, 'Compiler', '(description of Compiler)', 'compiler'),
(nextval('nsl_global_seq'), 0, 'Editor', '(description of Editor)', 'editor'),
(nextval('nsl_global_seq'), 0, 'Author', '(description of Author)', 'author');
-- reference type
INSERT INTO public.ref_type (id, lock_version, name, parent_id, parent_optional, description_html, rdf_id, use_parent_details) VALUES
(nextval('nsl_global_seq'), 0, 'Personal Communication', null, false, '(description of Personal Communication)', 'personal-communication', false),
(nextval('nsl_global_seq'), 0, 'Series', null, false, '(description of Series)', 'series', false),
(nextval('nsl_global_seq'), 0, 'Journal', null, false, '(description of Journal)', 'journal', false),
(nextval('nsl_global_seq'), 0, 'Index', null, false, '(description of Index)', 'index', false),
(nextval('nsl_global_seq'), 0, 'Herbarium annotation', null, false, '(description of Herbarium annotation)', 'herbarium-annotation', false),
(nextval('nsl_global_seq'), 0, 'Database', null, false, '(description of Database)', 'database', false),
(nextval('nsl_global_seq'), 0, 'Database Record', (select id from ref_type where name = 'Database'), false, '(description of Database Record)', 'database-record', false),
(nextval('nsl_global_seq'), 0, 'Paper', (select id from ref_type where name = 'Journal'), false, '(description of Paper)', 'paper', false),
(nextval('nsl_global_seq'), 0, 'Book', (select id from ref_type where name = 'Series'), true, '(description of Book)', 'book', false),
(nextval('nsl_global_seq'), 0, 'Section', (select id from ref_type where name = 'Book'), false, '(description of Section)', 'section', false),
(nextval('nsl_global_seq'), 0, 'Chapter', (select id from ref_type where name = 'Book'), false, '(description of Chapter)', 'chapter', false),
(nextval('nsl_global_seq'), 0, 'Part', (select id from ref_type where name = 'Paper'), false, '(description of Part)', 'part', true),
(nextval('nsl_global_seq'), 0, 'Unknown', null, true, '(description of Unknown)', 'unknown', false);
UPDATE public.ref_type SET parent_id = id WHERE name = 'Unknown'; --self parent

-- set up APC regions
INSERT INTO public.dist_region (description_html, def_link, name, sort_order) VALUES
('Western Australia', null, 'WA', 1),
('Cocos (Keeling) Islands', null, 'CoI', 2),
('Christmas Island', null, 'ChI', 3),
('Ashmore Reef', null, 'AR', 4),
('Cartier Island', null, 'CaI', 5),
('Northern Territory', null, 'NT', 6),
('South Australia', null, 'SA', 7),
('Queensland', null, 'Qld', 8),
('Coral Sea Islands', null, 'CSI', 9),
('New South Wales', null, 'NSW', 10),
('Lord Howe Island', null, 'LHI', 11),
('Norfolk Island', null, 'NI', 12),
('Australian Capital Australian Capital Territory excl. Jervis Bay', null, 'ACT', 13),
('Victoria', null, 'Vic', 14),
('Tasmainia', null, 'Tas', 15),
('Heard Island', null, 'HI', 16),
('McDonald Island', null, 'MDI', 17),
('Macquarie Island', null, 'MI', 18);

-- set up APC statuses
INSERT INTO public.dist_status (description_html, def_link, name, sort_order) VALUES
('a native taxon that no longer occurs in the given jurisdiction', null, 'presumed extinct', 4),
('taxa that are represented by one or more naturalised populations in a given jurisdiction, but the extent of naturalisation is uncertain and populations may or may not persist in the longer term.', null, 'doubtfully naturalised', 3),
('non-native or native taxa previously recorded as being naturalised in a given jurisdiction but of which no collections have been made within a defined timeframe.', null, 'formerly naturalised', 2),
('
plant taxa in a given jurisdiction where:

a native taxon has become naturalised outside of its natural range within that jurisdiction, or;

a native or non-native taxon that did not originate in a given jurisdiction but has since arrived and become established there.

', null, 'naturalised', 1),
('"taxa that have originated in a given area without human involvement or that have arrived there without intentional or unintentional intervention of humans from an area in which they are native" (definition from Pysek et al. (2004)).', null, 'native', 0),
('For some taxa there is uncertainty as to whether the populations present in a given jurisdiction represent native or naturalised plants or a combination of the two former categories. In these cases, the jurisdiction is listed with the parenthetical qualifier "(uncertain origin)". Comment fields may be added under the APC reference to indicate the nature of this uncertainty.', null, 'uncertain origin', 5);

insert into dist_status_dist_status (dist_status_combining_status_id, dist_status_id)
    (SELECT comb.id, ds.id from dist_status ds, dist_status comb where ds.name = 'naturalised' and comb.name = 'uncertain origin');
insert into dist_status_dist_status (dist_status_combining_status_id, dist_status_id)
    (SELECT comb.id, ds.id from dist_status ds, dist_status comb where ds.name = 'native' and comb.name = 'naturalised');
insert into dist_status_dist_status (dist_status_combining_status_id, dist_status_id)
    (SELECT comb.id, ds.id from dist_status ds, dist_status comb where ds.name = 'native' and comb.name = 'formerly naturalised');
insert into dist_status_dist_status (dist_status_combining_status_id, dist_status_id)
    (SELECT comb.id, ds.id from dist_status ds, dist_status comb where ds.name = 'native' and comb.name = 'doubtfully naturalised');
insert into dist_status_dist_status (dist_status_combining_status_id, dist_status_id)
    (SELECT comb.id, ds.id from dist_status ds, dist_status comb where ds.name = 'native' and comb.name = 'uncertain origin');

drop table if exists temp_comb_status_order;

create table temp_comb_status_order
(
    name             varchar(255)                              not null,
    sort_order       int4    default 0                         not null,
    primary key (name)
);

insert into temp_comb_status_order (name, sort_order) VALUES
('(native)', 0),
('(naturalised)', 1),
('(native and naturalised)', 2),
('(native and doubtfully naturalised)', 3),
('(native and formerly naturalised)', 4),
('(native and uncertain origin)', 5),
('(doubtfully naturalised)', 6),
('(formerly naturalised)', 7),
('(naturalised and uncertain origin)', 8),
('(uncertain origin)', 9),
('(presumed extinct)', 10)
;

-- make all the combinations of distribution entries we can make
drop function if exists make_entries();
create function make_entries() returns integer as
$$
declare
    entry_id    bigint;
    region      record;
    status      record;
    comb_status record;
    display_str text;
    entry_order integer;
begin
    entry_order := 0;
    for region in select * from dist_region order by sort_order
        loop
            for status in select * from dist_status order by sort_order
                loop
                    display_str := region.name || ' (' || status.name || ')';
                    entry_order := region.sort_order * 20 + (select sort_order from temp_comb_status_order where name = '(' || status.name || ')');
                    insert into dist_entry (region_id, display, sort_order)
                    values (region.id, display_str, entry_order) returning id into entry_id;
                    insert into dist_entry_dist_status (dist_entry_status_id, dist_status_id)
                    values (entry_id, status.id);
                    for comb_status in select ds.*
                                       from dist_status_dist_status dsds
                                                join dist_status ds on ds.id = dsds.dist_status_combining_status_id and
                                                                       dsds.dist_status_id = status.id
                                       order by ds.sort_order
                        loop
                            display_str := region.name || ' (' || status.name || ' and ' || comb_status.name || ')';
                            entry_order := region.sort_order * 20 + (select sort_order from temp_comb_status_order where name = '(' || status.name || ' and ' || comb_status.name || ')');
                            insert into dist_entry (region_id, display, sort_order)
                            values (region.id, display_str, entry_order) returning id into entry_id;
                            insert into dist_entry_dist_status (dist_entry_status_id, dist_status_id)
                            values (entry_id, status.id);
                            insert into dist_entry_dist_status (dist_entry_status_id, dist_status_id)
                            values (entry_id, comb_status.id);
                        end loop;
                end loop;
        end loop;
    return (select count(*) from dist_entry);
end;
$$ LANGUAGE plpgsql;

select make_entries();
drop function make_entries();
drop table temp_comb_status_order;

update dist_entry e set display = (select r.name from dist_region r where r.id = e.region_id) where display ~ '\(native\)';


text:
require 'rubygems'
require "bundler/setup"

require 'rails'

ENV['ADAPTER'] ||= 'active_record'
if ENV['ADAPTER'] == 'active_record'
  require 'active_record/railtie'
end

module TestApp
  class Application < ::Rails::Application
    config.root = File.dirname(__FILE__)
  end
end

require 'ammeter/init'

redpajama_set_name: RedPajamaGithub


text:
package org.elasticsearch.transport;

import org.elasticsearch.cluster.node.DiscoveryNode;
import org.elasticsearch.common.io.stream.StreamInput;

import java.io.IOException;

public class NodeDisconnectedException extends ConnectTransportException {

    public NodeDisconnectedException(DiscoveryNode node, String action) {
        super(node, "disconnected", action, null);
    }

    public NodeDisconnectedException(StreamInput in) throws IOException {
        super(in);
    }

    // stack trace is meaningless...

    @Override
    public Throwable fillInStackTrace() {
        return this;
    }
}


text:
(function () {
  'use strict';

  // Projects controller
  angular
    .module('projects')
    .controller('ProjectsController', ProjectsController);

  ProjectsController.$inject = ['$scope', '$state', 'Authentication', 'projectResolve', '$mdDialog'];

  function ProjectsController ($scope, $state, Authentication, project, $mdDialog) {
    var vm = this;

    vm.authentication = Authentication;
    vm.project = project;
    vm.error = null;
    vm.form = {};
    vm.remove = remove;
    vm.save = save;
    vm.getVideoLink = getVideoLink;

    function getVideoLink(videoLink) {
      return videoLink;
    }

    // Remove existing Project
    function remove() {
      if (confirm('Are you sure you want to delete?')) {
        vm.project.$remove($state.go('projects.list'));
      }
    }

    // Save Project
    function save(isValid) {
      if (!isValid) {
        $scope.$broadcast('show-errors-check-validity', 'vm.form.projectForm');
        return false;
      }

      // TODO: move create/update logic to service
      if (vm.project._id) {
        vm.project.$update(successCallback, errorCallback);
      } else {
        vm.project.$save(successCallback, errorCallback);
      }

      function successCallback(res) {
        $state.go('projects.view', {
          projectId: res._id
        });
      }

      function errorCallback(res) {
        vm.error = res.data.message;
      }
    }

    vm.showUserPreview = function($event, userData) {
      $mdDialog.show({
        controller: DialogController,
        template:
        '<md-dialog aria-label="List dialog">' +
        '  <md-dialog-content>'+
        '<md-content class="md-padding" layout-xs="column" layout="row">' +
        '
' +
          ' <md-card> ' +
          '  ' +
          ' <md-card-content>' +
          '
{{ userData.displayName }}
 ' +
          '
' +
              '
 ' +
              '
 ' +
              '
First Name:
 ' +
              '
{{ userData.firstName }}
 ' +
              '
 ' +
              '
 ' +
              '
Last Name:
 ' +
              '
{{ userData.lastName }}
 ' +
              '
 ' +
              '
 ' +
              '
Email:
 ' +
              '
{{ userData.email }}
 ' +
              '
 ' +
              '
 ' +
          '
 ' +
          ' </md-card-content> ' +
          ' </md-card> ' +
        '
' +
        '</md-content>' +
        '  </md-dialog-content>' +
        '  <md-dialog-actions>' +
        '    <md-button ng-href="/users/{{ userData._id }}" ng-click="closeDialog()" class="md-primary">View Profile</md-button>' +
        '    <md-button ng-click="closeDialog()" class="md-primary">Close</md-button>' +
        '  </md-dialog-actions>' +
        '</md-dialog>',
        targetEvent: $event,
        parent: angular.element(document.body),
        clickOutsideToClose:true,
        locals: {
          userData: userData
        }
      })
      .then(function(answer) {
        console.log('You said the information was "' + answer + '".');
      }, function() {
        console.log('You cancelled the dialog.');
      });

      function DialogController($scope, userData) {
        $scope.userData = userData;
        $scope.closeDialog = function () {
          $mdDialog.hide();
        };
        $scope.cancel = function () {
          $mdDialog.cancel();
        };
        $scope.answer = function (answer) {
          $mdDialog.hide(answer);
        };
      }

    };

  }

})();


text:
<?php

include("../inc/conn.php");
include("../inc/layouts.php");

 proteggi(2);

 echo openLayout1(_("Report Administration"), array("sty/admin.css"));

 echo closeLayout1();

?>


text:
"""Certificate chain where the target certificate contains an unknown X.509v3
extension (OID=1.2.3.4) that is marked as critical."""

import sys
sys.path += ['../..']

import gencerts

# Self-signed root certificate.
root = gencerts.create_self_signed_root_certificate('Root')

# Intermediate certificate.
intermediate = gencerts.create_intermediate_certificate('Intermediate', root)

# Target certificate (has unknown critical extension).
target = gencerts.create_end_entity_certificate('Target', intermediate)
target.get_extensions().add_property('1.2.3.4',
                                     'critical,DER:01:02:03:04')

chain = [target, intermediate, root]
gencerts.write_chain(__doc__, chain, 'chain.pem')


text:
import json

from server.tests.base import BaseTestCase
from server.models import db, Lecturer, Course, Lecture

from server.api.v0.api import api
from server.api.v0.course import CourseListResource

class AddCourseApiTest(BaseTestCase):
    def setUp(self):
        super(AddCourseApiTest, self).setUp()

        self.simon = Lecturer('simon', '1234', 'Simon', 'McCallum')
        db.session.add(self.simon)

        imt3601 = Course('IMT3601 - Game Programming', self.simon)
        db.session.add(imt3601)

        imt3601_l1 = Lecture('Lecture 1', imt3601)
        db.session.add(imt3601_l1)

        self.frode = Lecturer('frode', '1234', 'Frode', 'Haug')
        db.session.add(self.frode)

        imt1031 = Course('IMT1031 - Grunnleggende Programmering', self.frode)
        db.session.add(imt1031)

        imt1031_l1 = Lecture('Lecture 1', imt1031)
        db.session.add(imt1031_l1)

        db.session.flush()

    def test_wrong_lecturer(self):
        self.login(self.simon.email, self.simon.password)

        res = self.client.post(
            api.url_for(
                CourseListResource,
                lecturerId=self.frode.id,
                name='awsm'
            )
        )

        self.assert403(res)

    def test_no_lecturer(self):
        self.login(self.simon.email, self.simon.password)

        res = self.client.post(
            api.url_for(
                CourseListResource,
                name='awsm'
            )
        )

        self.assert400(res)

    def test_no_name(self):
        self.login(self.simon.email, self.simon.password)

        res = self.client.post(
            api.url_for(
                CourseListResource,
                lecturerId=self.frode.id,
            )
        )

        self.assert400(res)

    def test_success(self):
        self.login(self.simon.email, self.simon.password)

        res = self.client.post(
            api.url_for(
                CourseListResource,
                lecturerId=self.simon.id,
                name='awsm'
            )
        )
        self.assert200(res)

        data = json.loads(res.data.decode('utf-8'))

        self.assertIsNotNone(data)
        self.assertIn('id', data)
        self.assertEqual(data['id'], 3) # It's the third course, so it should be 3

        awsmCourse = Course.query.filter(Course.id == data['id']).first()
        self.assertFalse(awsmCourse is None)
        self.assertEqual(awsmCourse.name, 'awsm')
        self.assertEqual(awsmCourse.lecturer_id, self.simon.id)


text:
from distutils.core import setup

setup(name='pyxp',
      version='0.2',
      description='Python 9P client library',
      author='Kris Maglione',
      author_email='maglione.k@gmail.com',
      url='http://wmii.suckless.org',
      packages=['pyxp'],
      license='MIT',
     )


text:
layout: post
microblog: true
audio:
photo:
date: 2014-06-26 08:36:07 -0600
guid: http://craigmcclellan.micro.blog/2014/06/26/t482170447983702017.html
---
Today I launch my new project @theclassnerd, a blog about technology in education. Here's my first post: [t.co/3YlanvhtR...](http://t.co/3YlanvhtRI)


text:
package org.commonmark.internal;

import org.commonmark.node.*;
import org.commonmark.parser.block.*;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class ListBlockParser extends AbstractBlockParser {

    private static Pattern BULLET_LIST_MARKER = Pattern.compile("^[*+-]( +|$)");
    private static Pattern ORDERED_LIST_MARKER = Pattern.compile("^(\\d{1,9})([.)])( +|$)");

    private final ListBlock block;

    public ListBlockParser(ListBlock block) {
        this.block = block;
    }

    @Override
    public boolean isContainer() {
        return true;
    }

    @Override
    public boolean canContain(Block block) {
        return block instanceof ListItem;
    }

    @Override
    public Block getBlock() {
        return block;
    }

    @Override
    public BlockContinue tryContinue(ParserState state) {
        // List blocks themselves don't have any markers, only list items. So try to stay in the list.
        // If there is a block start other than list item, canContain makes sure that this list is closed.
        return BlockContinue.atIndex(state.getIndex());
    }

    public void setTight(boolean tight) {
        block.setTight(tight);
    }

    /**
     * Parse a list marker and return data on the marker or null.
     */
    private static ListData parseListMarker(CharSequence ln, int offset) {
        CharSequence rest = ln.subSequence(offset, ln.length());
        int spacesAfterMarker;
        ListBlock listBlock;

        Matcher match;
        if ((match = BULLET_LIST_MARKER.matcher(rest)).find()) {
            BulletList bulletList = new BulletList();
            bulletList.setBulletMarker(match.group(0).charAt(0));
            listBlock = bulletList;
            spacesAfterMarker = match.group(1).length();
        } else if ((match = ORDERED_LIST_MARKER.matcher(rest)).find()) {
            OrderedList orderedList = new OrderedList();
            orderedList.setStartNumber(Integer.parseInt(match.group(1)));
            orderedList.setDelimiter(match.group(2).charAt(0));
            listBlock = orderedList;
            spacesAfterMarker = match.group(3).length();
        } else {
            return null;
        }
        int padding;
        boolean blankItem = match.group(0).length() == rest.length();
        if (spacesAfterMarker >= 5 || spacesAfterMarker < 1 || blankItem) {
            padding = match.group(0).length() - spacesAfterMarker + 1;
        } else {
            padding = match.group(0).length();
        }
        return new ListData(listBlock, padding);
    }

    /**
     * Returns true if the two list items are of the same type,
     * with the same delimiter and bullet character. This is used
     * in agglomerating list items into lists.
     */
    private static boolean listsMatch(ListBlock a, ListBlock b) {
        if (a instanceof BulletList && b instanceof BulletList) {
            return equals(((BulletList) a).getBulletMarker(), ((BulletList) b).getBulletMarker());
        } else if (a instanceof OrderedList && b instanceof OrderedList) {
            return equals(((OrderedList) a).getDelimiter(), ((OrderedList) b).getDelimiter());
        }
        return false;
    }

    private static boolean equals(Object a, Object b) {
        return (a == null) ? (b == null) : a.equals(b);
    }

    public static class Factory extends AbstractBlockParserFactory {

        @Override
        public BlockStart tryStart(ParserState state, MatchedBlockParser matchedBlockParser) {
            BlockParser matched = matchedBlockParser.getMatchedBlockParser();

            if (state.getIndent() >= 4 && !(matched instanceof ListBlockParser)) {
                return BlockStart.none();
            }
            int nextNonSpace = state.getNextNonSpaceIndex();
            ListData listData = parseListMarker(state.getLine(), nextNonSpace);
            if (listData == null) {
                return BlockStart.none();
            }

            // list item
            int newIndex = nextNonSpace + listData.padding;

            int itemIndent = state.getIndent() + listData.padding;
            ListItemParser listItemParser = new ListItemParser(itemIndent);

            // prepend the list block if needed
            if (!(matched instanceof ListBlockParser) ||
                    !(listsMatch((ListBlock) matched.getBlock(), listData.listBlock))) {

                ListBlockParser listBlockParser = new ListBlockParser(listData.listBlock);
                listBlockParser.setTight(true);

                return BlockStart.of(listBlockParser, listItemParser).atIndex(newIndex);
            } else {
                return BlockStart.of(listItemParser).atIndex(newIndex);
            }
        }
    }

    private static class ListData {
        final ListBlock listBlock;
        final int padding;

        public ListData(ListBlock listBlock, int padding) {
            this.listBlock = listBlock;
            this.padding = padding;
        }
    }

}


text:
package com.thinkaurelius.titan.hadoop.mapreduce.util;

import junit.framework.TestCase;

import org.apache.hadoop.conf.Configuration;

import com.thinkaurelius.titan.hadoop.mapreduce.util.EmptyConfiguration;

/**
 * @author Marko A. Rodriguez (http://markorodriguez.com)
 */
public class EmptyConfigurationTest extends TestCase {

    public void testEmptyConfiguration() {
        Configuration configuration = new Configuration();
        assertTrue(configuration.size() > 1);
        configuration = new EmptyConfiguration();
        assertEquals(configuration.size(), 0);
    }
}


text:
<?php

namespace Kunstmaan\AdminListBundle\Tests\AdminList\FilterType\ORM;

use Kunstmaan\AdminListBundle\AdminList\FilterType\ORM\NumberFilterType;
use Symfony\Component\HttpFoundation\Request;

class NumberFilterTypeTest extends BaseOrmFilterTest
{
    /**
     * @var NumberFilterType
     */
    protected $object;

    protected function setUp(): void
    {
        $this->object = new NumberFilterType('number', 'b');
    }

    public function testBindRequest()
    {
        $request = new Request(['filter_comparator_number' => 'eq', 'filter_value_number' => 10]);

        $data = [];
        $uniqueId = 'number';
        $this->object->bindRequest($request, $data, $uniqueId);

        $this->assertEquals(['comparator' => 'eq', 'value' => 10], $data);
    }

    /**
     * @param string $comparator  The comparator
     * @param string $whereClause The where clause
     * @param mixed  $value       The value
     * @param mixed  $testValue   The test value
     *
     * @dataProvider applyDataProvider
     */
    public function testApply($comparator, $whereClause, $value, $testValue)
    {
        $qb = $this->getQueryBuilder();
        $qb->select('b')
            ->from('Entity', 'b');
        $this->object->setQueryBuilder($qb);
        $this->object->apply(['comparator' => $comparator, 'value' => $value], 'number');

        $this->assertEquals("SELECT b FROM Entity b WHERE b.number $whereClause", $qb->getDQL());
        if ($testValue) {
            $this->assertEquals($value, $qb->getParameter('var_number')->getValue());
        }
    }

    public static function applyDataProvider(): array
    {
        return [
            ['eq', '= :var_number', 1, true],
            ['neq', '<> :var_number', 2, true],
            ['lt', '< :var_number', 3, true],
            ['lte', '<= :var_number', 4, true],
            ['gt', '> :var_number', 5, true],
            ['gte', '>= :var_number', 6, true],
            ['isnull', 'IS NULL', 0, false],
            ['isnotnull', 'IS NOT NULL', 0, false],
        ];
    }

    public function testGetTemplate()
    {
        $this->assertEquals('@KunstmaanAdminList/FilterType/numberFilter.html.twig', $this->object->getTemplate());
    }
}


text:
layout: post
date: 2017-04-17
title: "Watters - Watters Watters Maids Dress Liquorice style 3475 Sleeveless Short/Mini Sheath/Column"
category: Watters - Watters
tags: [Watters - Watters,Watters,Sheath/Column,Strapless,Short/Mini,Sleeveless]
---
### Watters - Watters Watters Maids Dress Liquorice style 3475
Just **$219.99**
###   Sleeveless Short/Mini Sheath/Column

BRANDS	Watters

Silhouette	Sheath/Column

Neckline	Strapless

Hemline/Train	Short/Mini

Sleeve	Sleeveless

Buy it: [https://www.readybrides.com/en/watters-watters/14261-watters-dress-liquorice-style-3475.html](https://www.readybrides.com/en/watters-watters/14261-watters-dress-liquorice-style-3475.html)


text:
import redux from 'npm:redux';
import { combineReducers } from 'npm:redux-immutable';
import Immutable from 'npm:immutable';

import reducers from './reducers/index';
import enhancers from './enhancers/index';
import middleware from './middleware/index';
import initialState from './state-initializers/index';
import config from 'ember-get-config';

const { createStore, applyMiddleware, compose } = redux;
const devTools = window.devToolsExtension ? window.devToolsExtension({serialize: true}) : f => f;
const createStoreWithMiddleware = compose(applyMiddleware(...middleware), devTools, enhancers)(createStore);
const initialize = (c) => {
  const raw = Object.keys(initialState)
    .map(i => {
      return { [i]: initialState[i].loadState(c) };
    })
    .reduce( (prev, current) => Object.assign({}, prev, {[current.key]: current.value}) );
  return Immutable.Map(raw);
};

export default function(addonReducers) {
  const combinedReducers = typeof reducers === 'function'
    ? reducers
    : combineReducers(Object.assign({}, reducers, addonReducers));

  return createStoreWithMiddleware(combinedReducers, initialize(config));
}


text:
namespace base {
class DictionaryValue;
}

namespace ash {

// SmsObserver is called when a new sms message is received. Then it shows the
// sms message to the user in the notification center.
class SmsObserver : public chromeos::NetworkSmsHandler::Observer {
 public:
  SmsObserver();
  ~SmsObserver() override;

  // chromeos::NetworkSmsHandler::Observer:
  void MessageReceived(const base::DictionaryValue& message) override;

 private:
  // Used to create notification identifier.
  uint32_t message_id_ = 0;

  DISALLOW_COPY_AND_ASSIGN(SmsObserver);
};

}  // namespace ash

#endif  // ASH_SYSTEM_NETWORK_SMS_OBSERVER_H_


text:
package com.alibaba.dubbo.registry.zookeeper;

import com.alibaba.dubbo.common.URL;

import junit.framework.Assert;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;

/**
 * ZookeeperRegistryTest
 *
 * @author tony.chenl
 */
public class ZookeeperRegistryTest {

    String service = "com.alibaba.dubbo.test.injvmServie";
    URL registryUrl = URL.valueOf("zookeeper://239.255.255.255/");
    URL serviceUrl = URL.valueOf("zookeeper://zookeeper/" + service
            + "?notify=false&methods=test1,test2");
    URL consumerUrl = URL.valueOf("zookeeper://consumer/" + service + "?notify=false&methods=test1,test2");
    // ZookeeperRegistry registry    = new ZookeeperRegistry(registryUrl);

    /**
     * @throws java.lang.Exception
     */
    @BeforeClass
    public static void setUpBeforeClass() throws Exception {
    }

    /**
     * @throws java.lang.Exception
     */
    @Before
    public void setUp() throws Exception {
        //registry.register(service, serviceUrl);
    }

    /*@Test(expected = IllegalStateException.class)
    public void testUrlerror() {
        URL errorUrl = URL.valueOf("zookeeper://zookeeper/");
        new ZookeeperRegistry(errorUrl);
    }*/

    @Test
    public void testDefaultPort() {
        Assert.assertEquals("10.20.153.10:2181", ZookeeperRegistry.appendDefaultPort("10.20.153.10:0"));
        Assert.assertEquals("10.20.153.10:2181", ZookeeperRegistry.appendDefaultPort("10.20.153.10"));
    }

    /**
     * Test method for {@link com.alibaba.dubbo.registry.support.injvm.InjvmRegistry#register(java.util.Map)}.
     */
    @Test
    public void testRegister() {
        /*List<URL> registered = null;
        // clear first
        registered = registry.getRegistered(service);

        for (int i = 0; i < 2; i++) {
            registry.register(service, serviceUrl);
            registered = registry.getRegistered(service);
            assertTrue(registered.contains(serviceUrl));
        }
        // confirm only 1 regist success;
        registered = registry.getRegistered(service);
        assertEquals(1, registered.size());*/
    }

    /**
     * Test method for
     * {@link com.alibaba.dubbo.registry.support.injvm.InjvmRegistry#subscribe(java.util.Map, com.alibaba.dubbo.registry.support.NotifyListener)}
     * .
     */
    @Test
    public void testSubscribe() {
        /*final String subscribearg = "arg1=1&arg2=2";
        // verify lisener.
        final AtomicReference<Map<String, String>> args = new AtomicReference<Map<String, String>>();
        registry.subscribe(service, new URL("dubbo", NetUtils.getLocalHost(), 0, StringUtils.parseQueryString(subscribearg)), new NotifyListener() {

            public void notify(List<URL> urls) {
                // FIXME assertEquals(ZookeeperRegistry.this.service, service);
                args.set(urls.get(0).getParameters());
            }
        });
        assertEquals(serviceUrl.toParameterString(), StringUtils.toQueryString(args.get()));
        Map<String, String> arg = registry.getSubscribed(service);
        assertEquals(subscribearg, StringUtils.toQueryString(arg));*/

    }

}


text:
package ch.swissonid.design_lib_sample;

import android.os.Bundle;
import android.support.annotation.IdRes;
import android.support.design.widget.NavigationView;
import android.support.v4.widget.DrawerLayout;
import android.support.v7.app.ActionBar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.Gravity;
import android.view.MenuItem;

import butterknife.Bind;
import butterknife.ButterKnife;
import ch.swissonid.design_lib_sample.fragments.BaseFragment;
import ch.swissonid.design_lib_sample.fragments.FlexibleSpaceFragment;
import ch.swissonid.design_lib_sample.fragments.FlexibleSpaceWithImageFragment;
import ch.swissonid.design_lib_sample.fragments.FloatingActionButtonFragment;
import ch.swissonid.design_lib_sample.fragments.StandardAppBarFragment;
import ch.swissonid.design_lib_sample.fragments.tabs.TabHolderFragment;
import ch.swissonid.design_lib_sample.util.LogUtils;
import ch.swissonid.design_lib_sample.util.Navigator;

import static ch.swissonid.design_lib_sample.util.LogUtils.LOGD;

public class DrawerActivity extends AppCompatActivity implements NavigationView.OnNavigationItemSelectedListener{

    @Bind(R.id.drawer_layout)
    DrawerLayout mDrawerLayout;

    @Bind(R.id.navigation_view)
    NavigationView mNavigationView;

    private static Navigator mNavigator;
    private Toolbar mToolbar;
    private @IdRes int mCurrentMenuItem;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_drawer);
        ButterKnife.bind(this);
        setupToolbar();
        setupNavDrawer();
        initNavigator();
        mCurrentMenuItem = R.id.standard_app_bar_menu_item;
        setNewRootFragment(StandardAppBarFragment.newInstance());
    }

    private void initNavigator() {
        if(mNavigator != null) return;
        mNavigator = new Navigator(getSupportFragmentManager(), R.id.container);
    }
    private void setNewRootFragment(BaseFragment fragment){
        if(fragment.hasCustomToolbar()){
            hideActionBar();
        }else {
            showActionBar();
        }
        mNavigator.setRootFragment(fragment);
        mDrawerLayout.closeDrawers();
    }

    private void setupToolbar() {
        mToolbar = ButterKnife.findById(this, R.id.toolbar);
        if(mToolbar == null) {
            LOGD(this, "Didn't find a toolbar");
            return;
        }
        setSupportActionBar(mToolbar);
        ActionBar actionBar = getSupportActionBar();
        if(actionBar == null) return;
        actionBar.setDisplayHomeAsUpEnabled(true);
        actionBar.setHomeButtonEnabled(true);
    }

    private void hideActionBar(){
        ActionBar actionBar = getSupportActionBar();
        if(actionBar == null) return;
        actionBar.hide();
    }

    private void showActionBar() {
        ActionBar actionBar = getSupportActionBar();
        if(actionBar == null) return;
        actionBar.show();
    }

    private void setupNavDrawer() {
        if(mDrawerLayout == null) {
            LogUtils.LOGE(this, "mDrawerLayout is null - Can not setup the NavDrawer! Have you set the android.support.v7.widget.DrawerLayout?");
            return;
        }
        mNavigationView.setNavigationItemSelectedListener(this);
        LOGD(this, "setup setupNavDrawer");
    }

    public void openDrawer(){
        mDrawerLayout.openDrawer(Gravity.LEFT);
    }

    @Override
    public boolean onNavigationItemSelected(MenuItem menuItem) {
        @IdRes int id = menuItem.getItemId();
        if(id == mCurrentMenuItem) {
            mDrawerLayout.closeDrawers();
            return false;
        }
        switch (id){
            case R.id.standard_app_bar_menu_item:
                setNewRootFragment(StandardAppBarFragment.newInstance());
                break;
            case R.id.tabs_menu_item:
                setNewRootFragment(TabHolderFragment.newInstance());
                break;

            case R.id.parallax_menu_item:
                setNewRootFragment(FlexibleSpaceWithImageFragment.newInstance());
                break;

            case R.id.pinned_app_bar_menu_item:
                setNewRootFragment(FlexibleSpaceFragment.newInstance());
                break;

            case R.id.floating_action_button:
                setNewRootFragment(FloatingActionButtonFragment.newInstance());
                break;
        }
        mCurrentMenuItem = id;
        menuItem.setChecked(true);
        return false;
    }

    @Override
    public void finish() {
        mNavigator = null;
        super.finish();
    }
}