-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 22, 2020 at 01:22 PM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `chatbot`
--

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(5, '2014_10_12_000000_create_users_table', 1),
(6, '2014_10_12_100000_create_password_resets_table', 1),
(7, '2019_08_19_000000_create_failed_jobs_table', 1),
(8, '2020_06_18_162631_create_table_main_occupation_list', 1),
(9, '2020_06_19_122328_organize_table_occupation_list', 2),
(10, '2020_06_19_123222_add_column_table_occupation_list', 3),
(11, '2020_06_19_123437_add_column_assessing_table_occupation_list', 4);

-- --------------------------------------------------------

--
-- Table structure for table `occupation_list`
--

CREATE TABLE `occupation_list` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `anzsco_code` int(11) NOT NULL,
  `occupation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assessing_authority` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `occupation_list`
--

INSERT INTO `occupation_list` (`id`, `anzsco_code`, `occupation`, `assessing_authority`, `active`) VALUES
(1, 133111, 'Construction Project Manager', 'VETASSESS', 1),
(2, 133211, 'Engineering Manager', 'EA/AIM', 1),
(3, 134111, 'Child Care Centre Manager', 'ACECQA', 1),
(4, 134212, 'Nursing Clinical Director', 'ANMAC', 1),
(5, 134213, 'Primary Health Organisation Manager', 'VETASSESS', 1),
(6, 134214, 'Welfare Centre Manager', 'ACWA', 1),
(7, 139911, 'Arts Administrator or Manager', 'VETASSESS', 1),
(8, 139912, 'Environmental Manager', 'VETASSESS', 1),
(9, 211112, 'Dancer or Choreographer', 'VETASSESS', 1),
(10, 211212, 'Music Director', 'VETASSESS', 1),
(11, 211213, 'Musician (Instrumental)', 'VETASSESS', 1),
(12, 212111, 'Artistic Director', 'VETASSESS', 1),
(13, 221111, 'Accountant (General)', 'CPAA/CAANZ/IPA', 1),
(14, 221112, 'Management Accountant', 'CPAA/CAANZ/IPA', 1),
(15, 221113, 'Taxation Accountant', 'CPAA/CAANZ/IPA', 1),
(16, 221213, 'External Auditor', 'CPAA/CAANZ/IPA', 1),
(17, 221214, 'Internal Auditor', 'VETASSESS', 1),
(18, 224111, 'Actuary', 'VETASSESS', 1),
(19, 224113, 'Statistician', 'VETASSESS', 1),
(20, 224311, 'Economist', 'VETASSESS', 1),
(21, 224511, 'Land Economist', 'VETASSESS', 1),
(22, 224512, 'Valuer', 'VETASSESS', 1),
(23, 224711, 'Management Consultant', 'VETASSESS', 1),
(24, 232111, 'Architect', 'AACA', 1),
(25, 232112, 'Landscape Architect', 'VETASSESS', 1),
(26, 232212, 'Surveyor', 'SSSI', 1),
(27, 232213, 'Cartographer', 'VETASSESS', 1),
(28, 232214, 'Other Spatial Scientist', 'VETASSESS', 1),
(29, 233111, 'Chemical Engineer', 'EA', 1),
(30, 233112, 'Materials Engineer', 'EA', 1),
(31, 233211, 'Civil Engineer', 'EA', 1),
(32, 233212, 'Geotechnical Engineer', 'EA', 1),
(33, 233213, 'Quantity Surveyor', 'AIQS', 1),
(34, 233214, 'Structural Engineer', 'EA', 1),
(35, 233215, 'Transport Engineer', 'EA', 1),
(36, 233311, 'Electrical Engineer', 'EA', 1),
(37, 233411, 'Electronics Engineer', 'EA', 1),
(38, 233511, 'Industrial Engineer', 'EA', 1),
(39, 233512, 'Mechanical Engineer', 'EA', 1),
(40, 233513, 'Production or Plant Engineer', 'EA', 1),
(41, 233611, 'Mining Engineer (excluding Petroleum)', 'EA', 1),
(42, 233612, 'Petroleum Engineer', 'EA', 1),
(43, 233911, 'Aeronautical Engineer', 'EA', 1),
(44, 233912, 'Agricultural Engineer', 'EA', 1),
(45, 233913, 'Biomedical Engineer', 'EA', 1),
(46, 233914, 'Engineering Technologist', 'EA', 1),
(47, 233915, 'Environmental Engineer', 'EA', 1),
(48, 233916, 'Naval Architect / Marine Designer', 'EA', 1),
(49, 233999, 'Engineering Professionals nec', 'EA', 1),
(50, 234111, 'Agricultural Consultant', 'VETASSESS', 1),
(51, 234112, 'Agricultural Scientist', 'VETASSESS', 1),
(52, 234113, 'Forester / Forest Scientist', 'VETASSESS', 1),
(53, 234211, 'Chemist', 'VETASSESS', 1),
(54, 234212, 'Food Technologist', 'VETASSESS', 1),
(55, 234312, 'Environmental Consultant', 'VETASSESS', 1),
(56, 234313, 'Environmental Research Scientist', 'VETASSESS', 1),
(57, 234399, 'Environmental Scientists nec', 'VETASSESS', 1),
(58, 234412, 'Geophysicist', 'VETASSESS', 1),
(59, 234413, 'Hydrogeologist', 'VETASSESS', 1),
(60, 234511, 'Life Scientist (General)', 'VETASSESS', 1),
(61, 234513, 'Biochemist', 'VETASSESS', 1),
(62, 234514, 'Biotechnologist', 'VETASSESS', 1),
(63, 234515, 'Botanist', 'VETASSESS', 1),
(64, 234516, 'Marine Biologist', 'VETASSESS', 1),
(65, 234517, 'Microbiologist', 'VETASSESS', 1),
(66, 234518, 'Zoologist', 'VETASSESS', 1),
(67, 234599, 'Life Scientists nec', 'VETASSESS', 1),
(68, 234611, 'Medical Laboratory Scientist', 'AIMS', 1),
(69, 234711, 'Veterinarian', 'AVBC', 1),
(70, 234911, 'Conservator', 'VETASSESS', 1),
(71, 234912, 'Metallurgist', 'VETASSESS', 1),
(72, 234913, 'Meteorologist', 'VETASSESS', 1),
(73, 234914, 'Physicist', 'VETASSESS/ACPSEM', 1),
(74, 234999, 'Natural and Physical Science Professionals nec', 'VETASSESS', 1),
(75, 241111, 'Early Childhood (Pre-primary School) Teacher', 'AITSL', 1),
(76, 241411, 'Secondary School Teacher', 'AITSL', 1),
(77, 241511, 'Special Needs Teacher', 'AITSL', 1),
(78, 241512, 'Teacher of the Hearing Impaired', 'AITSL', 1),
(79, 241513, 'Teacher of the Sight Impaired', 'AITSL', 1),
(80, 241599, 'Special Education Teachers nec', 'AITSL', 1),
(81, 242111, 'University Lecturer', 'VETASSESS', 1),
(82, 251211, 'Medical Diagnostic Radiographer', 'ASMIRT', 1),
(83, 251212, 'Medical Radiation Therapist', 'ASMIRT', 1),
(84, 251213, 'Nuclear Medicine Technologist', 'ANZSNM', 1),
(85, 251214, 'Sonographer', 'ASMIRT', 1),
(86, 251411, 'Optometrist', 'OCANZ', 1),
(87, 251912, 'Orthotist or Prosthetist', 'AOPA', 1),
(88, 252111, 'Chiropractor', 'CCEA', 1),
(89, 252112, 'Osteopath', 'AOAC', 1),
(90, 252411, 'Occupational Therapist', 'OTC', 1),
(91, 252511, 'Physiotherapist', 'APC', 1),
(92, 252611, 'Podiatrist', 'PodBA', 1),
(93, 252711, 'Audiologist', 'VETASSESS', 1),
(94, 252712, 'Speech Pathologist / Speech Language Therapist', 'SPA', 1),
(95, 253111, 'General Practitioner', 'MedBA', 1),
(96, 253311, 'Specialist Physician (General Medicine)', 'MedBA', 1),
(97, 253312, 'Cardiologist', 'MedBA', 1),
(98, 253313, 'Clinical Haematologist', 'MedBA', 1),
(99, 253314, 'Medical Oncologist', 'MedBA', 1),
(100, 253315, 'Endocrinologist', 'MedBA', 1),
(101, 253316, 'Gastroenterologist', 'MedBA', 1),
(102, 253317, 'Intensive Care Specialist', 'MedBA', 1),
(103, 253318, 'Neurologist', 'MedBA', 1),
(104, 253321, 'Paediatrician', 'MedBA', 1),
(105, 253322, 'Renal Medicine Specialist', 'MedBA', 1),
(106, 253323, 'Rheumatologist', 'MedBA', 1),
(107, 253324, 'Thoracic Medicine Specialist', 'MedBA', 1),
(108, 253399, 'Specialist Physicians nec', 'MedBA', 1),
(109, 253411, 'Psychiatrist', 'MedBA', 1),
(110, 253511, 'Surgeon (General)', 'MedBA', 1),
(111, 253512, 'Cardiothoracic Surgeon', 'MedBA', 1),
(112, 253513, 'Neurosurgeon', 'MedBA', 1),
(113, 253514, 'Orthopaedic Surgeon', 'MedBA', 1),
(114, 253515, 'Otorhinolaryngologist', 'MedBA', 1),
(115, 253516, 'Paediatric Surgeon', 'MedBA', 1),
(116, 253517, 'Plastic and Reconstructive Surgeon', 'MedBA', 1),
(117, 253518, 'Urologist', 'MedBA', 1),
(118, 253521, 'Vascular Surgeon', 'MedBA', 1),
(119, 253911, 'Dermatologist', 'MedBA', 1),
(120, 253912, 'Emergency Medicine Specialist', 'MedBA', 1),
(121, 253913, 'Obstetrician and Gynaecologist', 'MedBA', 1),
(122, 253914, 'Ophthalmologist', 'MedBA', 1),
(123, 253915, 'Pathologist', 'MedBA', 1),
(124, 253917, 'Diagnostic and Interventional Radiologist', 'MedBA', 1),
(125, 253918, 'Radiation Oncologist', 'MedBA', 1),
(126, 253999, 'Medical Practitioners nec', 'MedBA', 1),
(127, 254111, 'Midwife', 'ANMAC', 1),
(128, 254411, 'Nurse Practitioner', 'ANMAC', 1),
(129, 254412, 'Registered Nurse (Aged Care)', 'ANMAC', 1),
(130, 254413, 'Registered Nurse (Child and Family Health)', 'ANMAC', 1),
(131, 254414, 'Registered Nurse (Community Health)', 'ANMAC', 1),
(132, 254415, 'Registered Nurse (Critical Care and Emergency)', 'ANMAC', 1),
(133, 254416, 'Registered Nurse (Developmental Disability)', 'ANMAC', 1),
(134, 254417, 'Registered Nurse (Disability and Rehabilitation)', 'ANMAC', 1),
(135, 254418, 'Registered Nurse (Medical)', 'ANMAC', 1),
(136, 254421, 'Registered Nurse (Medical Practice)', 'ANMAC', 1),
(137, 254422, 'Registered Nurse (Mental Health)', 'ANMAC', 1),
(138, 254423, 'Registered Nurse (Perioperative)', 'ANMAC', 1),
(139, 254424, 'Registered Nurse (Surgical)', 'ANMAC', 1),
(140, 254425, 'Registered Nurse (Paediatrics)', 'ANMAC', 1),
(141, 254499, 'Registered Nurses nec', 'ANMAC', 1),
(142, 261111, 'ICT Business Analyst', 'ACS', 1),
(143, 261112, 'Systems Analyst', 'ACS', 1),
(144, 261211, 'Multimedia Specialist', 'ACS', 1),
(145, 261311, 'Analyst Programmer', 'ACS', 1),
(146, 261312, 'Developer Programmer', 'ACS', 1),
(147, 261313, 'Software Engineer', 'ACS', 1),
(148, 261399, 'Software and Applications Programmers nec', 'ACS', 1),
(149, 262112, 'ICT Security Specialist', 'ACS', 1),
(150, 263111, 'Computer Network and Systems Engineer', 'ACS', 1),
(151, 263311, 'Telecommunications Engineer', 'EA', 1),
(152, 263312, 'Telecommunications Network Engineer', 'EA', 1),
(153, 271111, 'Barrister', 'SLAA', 1),
(154, 271311, 'Solicitor', 'SLAA', 1),
(155, 272311, 'Clinical Psychologist', 'APS', 1),
(156, 272312, 'Educational Psychologist', 'APS', 1),
(157, 272313, 'Organisational Psychologist', 'APS', 1),
(158, 272399, 'Psychologists nec', 'APS', 1),
(159, 272511, 'Social Worker', 'AASW', 1),
(160, 312211, 'Civil Engineering Draftsperson', 'EA/VETASSESS', 1),
(161, 312212, 'Civil Engineering Technician', 'VETASSESS', 1),
(162, 312311, 'Electrical Engineering Draftsperson', 'EA', 1),
(163, 312312, 'Electrical Engineering Technician', 'TRA', 1),
(164, 313211, 'Radiocommunications Technician', 'TRA', 1),
(165, 313212, 'Telecommunications Field Engineer', 'EA', 1),
(166, 313213, 'Telecommunications Network Planner', 'EA', 1),
(167, 313214, 'Telecommunications Technical Officer or Technologist', 'EA', 1),
(168, 321111, 'Automotive Electrician', 'TRA', 1),
(169, 321211, 'Motor Mechanic (General)', 'TRA', 1),
(170, 321212, 'Diesel Motor Mechanic', 'TRA', 1),
(171, 321213, 'Motorcycle Mechanic', 'TRA', 1),
(172, 321214, 'Small Engine Mechanic', 'TRA', 1),
(173, 322211, 'Sheetmetal Trades Worker', 'TRA', 1),
(174, 322311, 'Metal Fabricator', 'TRA', 1),
(175, 322312, 'Pressure Welder', 'TRA', 1),
(176, 322313, 'Welder (First Class) (Aus) / Welder (NZ)', 'TRA', 1),
(177, 323211, 'Fitter (General)', 'TRA', 1),
(178, 323212, 'Fitter and Turner', 'TRA', 1),
(179, 323213, 'Fitter-Welder', 'TRA', 1),
(180, 323214, 'Metal Machinist (First Class)', 'TRA', 1),
(181, 323313, 'Locksmith', 'TRA', 1),
(182, 324111, 'Panelbeater', 'TRA', 1),
(183, 331111, 'Bricklayer', 'TRA', 1),
(184, 331112, 'Stonemason', 'TRA', 1),
(185, 331211, 'Carpenter and Joiner', 'TRA', 1),
(186, 331212, 'Carpenter', 'TRA', 1),
(187, 331213, 'Joiner', 'TRA', 1),
(188, 332211, 'Painting Trades Worker', 'TRA', 1),
(189, 333111, 'Glazier', 'TRA', 1),
(190, 333211, 'Fibrous Plasterer', 'TRA', 1),
(191, 333212, 'Solid Plasterer', 'TRA', 1),
(192, 333411, 'Wall and Floor Tiler', 'TRA', 1),
(193, 334111, 'Plumber (General)', 'TRA', 1),
(194, 334112, 'Airconditioning and Mechanical Services Plumber', 'TRA', 1),
(195, 334113, 'Drainer / Drainlayer', 'TRA', 1),
(196, 334114, 'Gasfitter', 'TRA', 1),
(197, 334115, 'Roof Plumber', 'TRA', 1),
(198, 341111, 'Electrician (General)', 'TRA', 1),
(199, 341112, 'Electrician (Special Class)', 'TRA', 1),
(200, 341113, 'Lift Mechanic', 'TRA', 1),
(201, 342111, 'Airconditioning and Refrigeration Mechanic', 'TRA', 1),
(202, 342212, 'Technical Cable Jointer', 'TRA', 1),
(203, 342313, 'Electronic Equipment Trades Worker', 'TRA', 1),
(204, 342314, 'Electronic Instrument Trades Worker (General)', 'TRA', 1),
(205, 342315, 'Electronic Instrument Trades Worker (Special Class)', 'TRA', 1),
(206, 351311, 'Chef', 'TRA', 1),
(207, 361112, 'Horse Trainer', 'TRA', 1),
(208, 394111, 'Cabinetmaker', 'TRA', 1),
(209, 399111, 'Boat Builder and Repairer', 'TRA', 1),
(210, 399112, 'Shipwright', 'TRA', 1),
(211, 452316, 'Tennis Coach', 'VETASSESS', 1),
(212, 452411, 'Footballer', 'VETASSESS', 1);

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `occupation_list`
--
ALTER TABLE `occupation_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `occupation_list`
--
ALTER TABLE `occupation_list`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=213;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
