<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class ProfessionTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::statement('SET FOREIGN_KEY_CHECKS=0;');
        DB::table('professions')->truncate();

        DB::statement("INSERT INTO professions (id, name, color_hex, salutation, parent_id) VALUES
            (1,'Doctor / Physician','#23408e','Dr.','0'),
            (2,'Abdominal Radiology','#23408e','Dr.','1'),
            (3,'Addiction Psychiatry','#23408e','Dr.','1'),
            (4,'Administrative Psychiatry','#23408e','Dr.','1'),
            (5,'Adolescent Medicine','#23408e','Dr.','1'),
            (6,'Adult Reconstructive Orthopaedics','#23408e','Dr.','1'),
            (7,'Advanced Heart Failure and Transplant Cardiology','#23408e','Dr.','1'),
            (8,'Aerospace Medicine','#23408e','Dr.','1'),
            (9,'Anatomical Pathology','#23408e','Dr.','1'),
            (10,'Anesthesiology','#23408e','Dr.','1'),
            (11,'Anesthesiology Critical Care Medicine','#23408e','Dr.','1'),
            (12,'Anterior Segment/Cornea Ophthalmology','#23408e','Dr.','1'),
            (13,'Biochemical Genetics','#23408e','Dr.','1'),
            (14,'Blood Banking and Transfusion Medicine','#23408e','Dr.','1'),
            (15,'Brain Injury Medicine','#23408e','Dr.','1'),
            (16,'Breast Imaging','#23408e','Dr.','1'),
            (17,'Calculi','#23408e','Dr.','1'),
            (18,'Cardiac Surgery','#23408e','Dr.','1'),
            (19,'Cardiothoracic Radiology','#23408e','Dr.','1'),
            (20,'Cardiovascular Disease','#23408e','Dr.','1'),
            (21,'Cardiovascular Radiology','#23408e','Dr.','1'),
            (22,'Chemical Pathology','#23408e','Dr.','1'),
            (23,'Chest Radiology','#23408e','Dr.','1'),
            (24,'Child Abuse Pediatrics','#23408e','Dr.','1'),
            (25,'Child and Adolescent Psychiatry','#23408e','Dr.','1'),
            (26,'Child Neurology','#23408e','Dr.','1'),
            (27,'Clinical Cardiac Electrophysiology','#23408e','Dr.','1'),
            (28,'Clinical Cytogenetics','#23408e','Dr.','1'),
            (29,'Clinical Genetics','#23408e','Dr.','1'),
            (30,'Clinical Neurophysiology','#23408e','Dr.','1'),
            (31,'Clinical Pathology','#23408e','Dr.','1'),
            (32,'Colon and Rectal Surgery','#23408e','Dr.','1'),
            (33,'Community Psychiatry','#23408e','Dr.','1'),
            (34,'Congenital Cardiac Surgery','#23408e','Dr.','1'),
            (35,'Consultation/Liaison Psychiatry','#23408e','Dr.','1'),
            (36,'Craniofacial Surgery','#23408e','Dr.','1'),
            (37,'Critical Care Medicine','#23408e','Dr.','1'),
            (38,'Cytopathology','#23408e','Dr.','1'),
            (39,'Dermatology','#23408e','Dr.','1'),
            (40,'Dermatopathology','#23408e','Dr.','1'),
            (41,'Developmental-Behavioral Pediatrics','#23408e','Dr.','1'),
            (42,'Diagnostic Radiology','#23408e','Dr.','1'),
            (43,'Emergency Medical Services','#23408e','Dr.','1'),
            (44,'Emergency Medicine','#23408e','Dr.','1'),
            (45,'Emergency Psychiatry','#23408e','Dr.','1'),
            (46,'Emergency Radiology','#23408e','Dr.','1'),
            (47,'Endocrinology, Diabetes, and Metabolism','#23408e','Dr.','1'),
            (48,'Endovascular Surgical Neuroradiology','#23408e','Dr.','1'),
            (49,'Family Medicine','#23408e','Dr.','1'),
            (50,'Female Pelvic Medicine and Reconstructive Surgery','#23408e','Dr.','1'),
            (51,'Female Urology','#23408e','Dr.','1'),
            (52,'Foot and Ankle Orthopaedics','#23408e','Dr.','1'),
            (53,'Forensic Pathology','#23408e','Dr.','1'),
            (54,'Forensic Psychiatry','#23408e','Dr.','1'),
            (55,'Gastroenterology','#23408e','Dr.','1'),
            (56,'Gastrointestinal Radiology','#23408e','Dr.','1'),
            (57,'General Practice','#23408e','Dr.','1'),
            (58,'General Surgery','#23408e','Dr.','1'),
            (59,'Genetic Pathology','#23408e','Dr.','1'),
            (60,'Genitourinary Radiology','#23408e','Dr.','1'),
            (61,'Geriatric Medicine','#23408e','Dr.','1'),
            (62,'Geriatric Psychiatry','#23408e','Dr.','1'),
            (63,'Glaucoma Ophthalmology','#23408e','Dr.','1'),
            (64,'Gynecologic Oncology','#23408e','Dr.','1'),
            (65,'Hand Surgery','#23408e','Dr.','1'),
            (66,'Head and Neck Radiology','#23408e','Dr.','1'),
            (67,'Hematology','#23408e','Dr.','1'),
            (68,'Hematology and Oncology','#23408e','Dr.','1'),
            (69,'Hospice and Palliative Care','#23408e','Dr.','1'),
            (70,'Hospice and Palliative Medicine','#23408e','Dr.','1'),
            (71,'Immunopathology','#23408e','Dr.','1'),
            (72,'Infectious Disease','#23408e','Dr.','1'),
            (73,'Internal Medicine','#23408e','Dr.','1'),
            (74,'Internal Medicine / Critical Care Medicine','#23408e','Dr.','1'),
            (75,'Interventional Cardiology','#23408e','Dr.','1'),
            (76,'Interventional Radiology','#23408e','Dr.','1'),
            (77,'Male Infertility','#23408e','Dr.','1'),
            (78,'Maternal-Fetal Medicine','#23408e','Dr.','1'),
            (79,'Medical Genetics','#23408e','Dr.','1'),
            (80,'Medical Microbiology','#23408e','Dr.','1'),
            (81,'Medical Toxicology','#23408e','Dr.','1'),
            (82,'Mental Retardation Psychiatry','#23408e','Dr.','1'),
            (83,'Military Psychiatry','#23408e','Dr.','1'),
            (84,'Molecular Genetic Pathology','#23408e','Dr.','1'),
            (85,'Molecular Pathology','#23408e','Dr.','1'),
            (86,'Musculoskeletal Oncology','#23408e','Dr.','1'),
            (87,'Musculoskeletal Radiology','#23408e','Dr.','1'),
            (88,'Neonatal','#23408e','Dr.','1'),
            (89,'Neonatal-Perinatal Medicine','#23408e','Dr.','1'),
            (90,'Nephrology','#23408e','Dr.','1'),
            (91,'Neurodevelopmental Disabilities','#23408e','Dr.','1'),
            (92,'Neurological Surgery','#23408e','Dr.','1'),
            (93,'Neurology','#23408e','Dr.','1'),
            (94,'Neuromuscular Medicine','#23408e','Dr.','1'),
            (95,'Neuro-Ophthalmology','#23408e','Dr.','1'),
            (96,'Neuropathology','#23408e','Dr.','1'),
            (97,'Neuroradiology','#23408e','Dr.','1'),
            (98,'Neurourology','#23408e','Dr.','1'),
            (99,'Nuclear Medicine','#23408e','Dr.','1'),
            (100,'Nuclear Radiology','#23408e','Dr.','1'),
            (101,'Obstetrics and Gynecology','#23408e','Dr.','1'),
            (102,'Occupational Medicine','#23408e','Dr.','1'),
            (103,'Ocular Oncology','#23408e','Dr.','1'),
            (104,'Oculoplastics/Orbit','#23408e','Dr.','1'),
            (105,'Oncology','#23408e','Dr.','1'),
            (106,'Ophthalmic Plastic & Reconstructive Surgery','#23408e','Dr.','1'),
            (107,'Ophthalmic Surgery','#23408e','Dr.','1'),
            (108,'Ophthalmology','#23408e','Dr.','1'),
            (109,'Oral and Maxillofacial Surgery','#23408e','Dr.','1'),
            (110,'Orthopaedic Sports Medicine','#23408e','Dr.','1'),
            (111,'Orthopaedic Surgery','#23408e','Dr.','1'),
            (112,'Orthopaedic Surgery Of The Spine','#23408e','Dr.','1'),
            (113,'Orthopaedic Trauma','#23408e','Dr.','1'),
            (114,'Otolaryngology','#23408e','Dr.','1'),
            (115,'Otology Neurotology','#23408e','Dr.','1'),
            (116,'Pain Medicine','#23408e','Dr.','1'),
            (117,'Pathology','#23408e','Dr.','1'),
            (118,'Pediatric Anesthesiology','#23408e','Dr.','1'),
            (119,'Pediatric Cardiology','#23408e','Dr.','1'),
            (120,'Pediatric Critical Care Medicine','#23408e','Dr.','1'),
            (121,'Pediatric Dermatology','#23408e','Dr.','1'),
            (122,'Pediatric Emergency Medicine','#23408e','Dr.','1'),
            (123,'Pediatric Endocrinology','#23408e','Dr.','1'),
            (124,'Pediatric Gastroenterology','#23408e','Dr.','1'),
            (125,'Pediatric Hematology-Oncology','#23408e','Dr.','1'),
            (126,'Pediatric Infectious Diseases','#23408e','Dr.','1'),
            (127,'Pediatric Internal Medicine','#23408e','Dr.','1'),
            (128,'Pediatric Nephrology','#23408e','Dr.','1'),
            (129,'Pediatric Oncology','#23408e','Dr.','1'),
            (130,'Pediatric Orthopaedics','#23408e','Dr.','1'),
            (131,'Pediatric Otolaryngology','#23408e','Dr.','1'),
            (132,'Pediatric Pathology','#23408e','Dr.','1'),
            (133,'Pediatric Pulmonology','#23408e','Dr.','1'),
            (134,'Pediatric Radiology','#23408e','Dr.','1'),
            (135,'Pediatric Rehabilitation Medicine','#23408e','Dr.','1'),
            (136,'Pediatric Rheumatology','#23408e','Dr.','1'),
            (137,'Pediatric Sports Medicine','#23408e','Dr.','1'),
            (138,'Pediatric Surgery','#23408e','Dr.','1'),
            (139,'Pediatric Transplant Hepatology','#23408e','Dr.','1'),
            (140,'Pediatric Urology','#23408e','Dr.','1'),
            (141,'Pediatrics','#23408e','Dr.','1'),
            (142,'Physical Medicine and Rehabilitation','#23408e','Dr.','1'),
            (143,'Plastic Surgery','#23408e','Dr.','1'),
            (144,'Prenatal','#23408e','Dr.','1'),
            (145,'Preventive Medicine','#23408e','Dr.','1'),
            (146,'Procedural Dermatology','#23408e','Dr.','1'),
            (147,'Psychiatric Research','#23408e','Dr.','1'),
            (148,'Psychiatry','#23408e','Dr.','1'),
            (149,'Psychosomatic Medicine','#23408e','Dr.','1'),
            (150,'Public Health Medicine','#23408e','Dr.','1'),
            (151,'Pulmonary Disease','#23408e','Dr.','1'),
            (152,'Pulmonary Disease and Critical Care Medicine','#23408e','Dr.','1'),
            (153,'Radiation Oncology','#23408e','Dr.','1'),
            (154,'Radiology','#23408e','Dr.','1'),
            (155,'Renal Transplant','#23408e','Dr.','1'),
            (156,'Reproductive Endocrinologists and Infertility','#23408e','Dr.','1'),
            (157,'Retina/Uveitis','#23408e','Dr.','1'),
            (158,'Rheumatology','#23408e','Dr.','1'),
            (159,'Sleep Medicine','#23408e','Dr.','1'),
            (160,'Spinal Cord Injury Medicine','#23408e','Dr.','1'),
            (161,'Sports Medicine','#23408e','Dr.','1'),
            (162,'Strabismus/Pediatric Ophthalmology','#23408e','Dr.','1'),
            (163,'Surgery','#23408e','Dr.','1'),
            (164,'Surgical Critical Care','#23408e','Dr.','1'),
            (165,'Surgical Intensivists, Specializing In Critical Care Patients','#23408e','Dr.','1'),
            (166,'Thoracic Surgery','#23408e','Dr.','1'),
            (167,'Thoracic Surgery-Integrated','#23408e','Dr.','1'),
            (168,'Transplant Hepatology','#23408e','Dr.','1'),
            (169,'Trauma','#23408e','Dr.','1'),
            (170,'Undersea and Hyperbaric Medicine','#23408e','Dr.','1'),
            (171,'Urologic Oncology','#23408e','Dr.','1'),
            (172,'Urology','#23408e','Dr.','1'),
            (173,'Vascular and Interventional Radiology','#23408e','Dr.','1'),
            (174,'Vascular Neurology','#23408e','Dr.','1'),
            (175,'Vascular Surgery','#23408e','Dr.','1'),
            (176,'Lawyer','#A020F0','Atty.','0'),
            (177,'Administrative Law','#A020F0','Atty.','176'),
            (178,'Admiralty (Maritime) Law','#A020F0','Atty.','176'),
            (179,'Alternative Dispute Resolution','#A020F0','Atty.','176'),
            (180,'Animal Law','#A020F0','Atty.','176'),
            (181,'Business Law','#A020F0','Atty.','176'),
            (182,'Civil Litigation','#A020F0','Atty.','176'),
            (183,'Construction Law','#A020F0','Atty.','176'),
            (184,'Contracts Management','#A020F0','Atty.','176'),
            (185,'Corporate Compliance','#A020F0','Atty.','176'),
            (186,'Criminal Law','#A020F0','Atty.','176'),
            (187,'Cybersecurity','#A020F0','Atty.','176'),
            (188,'Digital Media and Internet','#A020F0','Atty.','176'),
            (189,'E-commerce','#A020F0','Atty.','176'),
            (190,'Education Law','#A020F0','Atty.','176'),
            (191,'Entertainment Law','#A020F0','Atty.','176'),
            (192,'Environmental Law','#A020F0','Atty.','176'),
            (193,'Family Law','#A020F0','Atty.','176'),
            (194,'Finance and Securities','#A020F0','Atty.','176'),
            (195,'General Law Practice','#A020F0','Atty.','176'),
            (196,'Health and Healthcare Law','#A020F0','Atty.','176'),
            (197,'Human Rights','#A020F0','Atty.','176'),
            (198,'Immigration Law','#A020F0','Atty.','176'),
            (199,'Indigenous Peoples Law','#A020F0','Atty.','176'),
            (200,'Intellectual Property','#A020F0','Atty.','176'),
            (201,'International Law','#A020F0','Atty.','176'),
            (202,'International Trade and Business Law','#A020F0','Atty.','176'),
            (203,'Labor and Employment','#A020F0','Atty.','176'),
            (204,'Litigation and Trials','#A020F0','Atty.','176'),
            (205,'Mediation and Arbitration','#A020F0','Atty.','176'),
            (206,'Mergers and Acquisitions','#A020F0','Atty.','176'),
            (207,'Mining Law','#A020F0','Atty.','176'),
            (208,'Oil, Gas and Energy Law','#A020F0','Atty.','176'),
            (209,'Property and Real Estate','#A020F0','Atty.','176'),
            (210,'Public Law and Policy','#A020F0','Atty.','176'),
            (211,'Sports Law','#A020F0','Atty.','176'),
            (212,'Taxation Law','#A020F0','Atty.','176'),
            (213,'Technology Law','#A020F0','Atty.','176'),
            (214,'Trusts and Estates','#A020F0','Atty.','176'),
            (215,'Engineer','#FFA500','Engr.','0'),
            (216,'Aeronautical Engineering','#FFA500','Engr.','215'),
            (217,'Agricultural and Biosystems Engineering','#FFA500','Engr.','215'),
            (218,'Chemical Engineering','#FFA500','Engr.','215'),
            (219,'Civil Engineering','#FFA500','Engr.','215'),
            (220,'Electrical Engineering','#FFA500','Engr.','215'),
            (221,'Electronics Engineering','#FFA500','Engr.','215'),
            (222,'Geodetic Engineering','#FFA500','Engr.','215'),
            (223,'Industrial Engineering','#FFA500','Engr.','215'),
            (224,'Mechanical Engineering','#FFA500','Engr.','215'),
            (225,'Metallurgical Engineering','#FFA500','Engr.','215'),
            (226,'Mining Engineering','#FFA500','Engr.','215'),
            (227,'Sanitary Engineering','#FFA500','Engr.','215'),
            (228,'Accountant / CPA','#967117','Mr. / Ms.','0'),
            (229,'Agriculturist','#ddd66a','Mr. / Ms.','0'),
            (230,'Architect','#754737','Mr. / Ms.','0'),
            (231,'Chemist','#0D98BA','Mr. / Ms.','0'),
            (232,'Criminologist','#6699CC','Mr. / Ms.','0'),
            (233,'Customs Broker','#000080','Mr. / Ms.','0'),
            (234,'Dentist','#C8A2C8','Dr.','0'),
            (235,'Environmental Planner','#3A5F0B','Mr. / Ms.','0'),
            (236,'Fisheries Technologist','#2B65EC','Mr. / Ms.','0'),
            (237,'Food Technologist','#f2ba49','Mr. / Ms.','0'),
            (238,'Forester','#80461B','Mr. / Ms.','0'),
            (239,'Geologist','#9b7653','Mr. / Ms.','0'),
            (240,'Guidance and Counselor','#00C8FF','Mr. / Ms.','0'),
            (241,'Interior Designer','#A47449','Mr. / Ms.','0'),
            (242,'Landscape Architect','#80AC31','Mr. / Ms.','0'),
            (243,'Librarian','#FAFA33','Mr. / Ms.','0'),
            (244,'Master Plumber','#A4C5D5','Mr. / Ms.','0'),
            (245,'Medical Technologist','#008BB0','Mr. / Ms.','0'),
            (246,'Midwife','#008BB0','Mr. / Ms.','0'),
            (247,'Naval Architect','#000080','Mr. / Ms.','0'),
            (248,'Nurse','#FBCEB1','Mr. / Ms.','0'),
            (249,'Nutritionist-Dietitian','#f2ba49','Mr. / Ms.','0'),
            (250,'Optometrist','#008BB0','Dr.','0'),
            (251,'Pharmacist','#808000','Mr. / Ms.','0'),
            (252,'Physical and Occupational Therapist','#008BB0','Mr. / Ms.','0'),
            (253,'Professional Teacher / Professor / ESL / Tutor','#ADD8E6','Mr. / Ms.','0'),
            (254,'Psychologist / Psychometrician','#008BB0','Mr. / Ms.','0'),
            (255,'Radiologic Technologist','#008BB0','Mr. / Ms.','0'),
            (256,'Real Estate Service Practitioner','#622F22','Mr. / Ms.','0'),
            (257,'Respiratory Therapist','#008BB0','Mr. / Ms.','0'),
            (258,'Social Worker','#9fa91f','Mr. / Ms.','0'),
            (259,'Speech-Language Pathology','#C0C0C0','Mr. / Ms.','0'),
            (260,'Veterinarian','#808080','Dr.','0')
		");

		DB::statement('SET FOREIGN_KEY_CHECKS=1;');
    }
}