-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `chatbot`
--

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

--
-- Table structure for table `age_ranges`
--

CREATE TABLE `age_ranges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `age_range` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `age_points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `age_ranges`
--

INSERT INTO `age_ranges` (`id`, `age_range`, `age_points`, `created_at`, `updated_at`) VALUES
(1, 'less than 18', 0, '2020-08-16 19:00:00', NULL),
(2, 'at least 18 but less than 25 years', 25, '2020-08-16 19:00:00', NULL),
(3, 'at least  25 but less than 33 years', 30, '2020-08-16 19:00:00', NULL),
(4, 'at least 33 but less than 40 years', 25, '2020-08-16 19:00:00', NULL),
(5, 'at least 40 but less than 45 years', 15, '2020-08-16 19:00:00', NULL),
(6, 'more than 45', 0, '2020-08-16 19:00:00', NULL);

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

--
-- Table structure for table `australian_work_experience`
--

CREATE TABLE `australian_work_experience` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `australian_work_exp_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `designated_language_points`
--

CREATE TABLE `designated_language_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `input` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `education_in_australia`
--

CREATE TABLE `education_in_australia` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `australian_education_id` bigint(20) UNSIGNED NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_regional_area` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `education_points`
--

CREATE TABLE `education_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `education_points_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `english_level_details`
--

CREATE TABLE `english_level_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `english_level_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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
(10, '2014_10_12_000000_create_users_table', 1),
(11, '2014_10_12_100000_create_password_resets_table', 1),
(12, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(13, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(14, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(15, '2016_06_01_000004_create_oauth_clients_table', 1),
(16, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(17, '2019_08_19_000000_create_failed_jobs_table', 1),
(18, '2020_06_18_162631_create_table_main_occupation_list', 1),
(19, '2020_06_19_123437_add_column_assessing_table_occupation_list', 1),
(20, '2020_07_11_051731_add_tag_table', 1),
(21, '2020_07_11_080151_organize_occupation_list_table', 2),
(22, '2020_07_18_070527_change_user_id_type_table_tags', 3),
(23, '2020_07_27_060800_add_field_to_user_table', 4),
(27, '2020_08_17_035902_user_profile', 5),
(29, '2020_08_17_051632_age_range', 6),
(30, '2020_08_17_052547_users_age_details', 7),
(31, '2020_08_17_060643_ref_english_level', 8),
(32, '2020_08_17_061502_english_level_details', 8),
(33, '2020_08_17_064929_ref_education_points', 9),
(34, '2020_08_17_071220_education_points', 9),
(35, '2020_08_17_072458_ref_overseas_work_experience', 10),
(36, '2020_08_17_075324_overseas_work_experience', 10),
(37, '2020_08_17_080756_ref_australian_work_experience', 11),
(38, '2020_08_17_081224_australian_work_experience', 11),
(39, '2020_08_17_084722_ref_education_in_australia', 12),
(42, '2020_08_17_090207_education_in_australia', 13),
(44, '2020_08_17_090857_specialist_education_qualification', 14),
(46, '2020_08_17_094059_ref_professional_year_australia', 15),
(47, '2020_08_17_094139_professional_year_australia', 15),
(48, '2020_08_17_111322_designated_language_points', 16),
(49, '2020_08_17_111926_ref_partner_skill_qualification', 17),
(50, '2020_08_17_112007_partner_skill_qualification', 17);

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

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('16bf8aa2a1bf4f7fcfff019c7a3ff50f3b737ee6350ec479a1c8746c6c8bf938cd6929a4ac9b2c5d', 2, 1, 'AppName', '[]', 0, '2020-06-24 11:06:17', '2020-06-24 11:06:17', '2021-06-24 16:06:17'),
('78a6693d7adc6aabdddf5f94b6de575a513bd7ed66c8400aa6fd9501db712db08808aeb0c1e6ac1e', 2, 1, 'AppName', '[]', 0, '2020-06-24 13:32:52', '2020-06-24 13:32:52', '2021-06-24 18:32:52'),
('bd6a04740f314053973f8cbaacf2f0b5f4fe68891d3f897dd6e66ec83d1c2562e1ab22b30d611fbe', 2, 1, 'AppName', '[]', 0, '2020-06-24 10:15:48', '2020-06-24 10:15:48', '2021-06-24 15:15:48'),
('c848f16ab6403adc2247643cdaa3a6602af0da925d3d1ec08bf2c3f65f9f61ccd733d9d065cd03b3', 2, 1, 'AppName', '[]', 0, '2020-06-25 11:49:21', '2020-06-25 11:49:21', '2021-06-25 16:49:21'),
('ce6de156d36a268db1503278aca815b9152fb240cc20a0b664eb0635fc54f82a197a1a72eac79196', 2, 1, 'AppName', '[]', 0, '2020-06-24 11:37:05', '2020-06-24 11:37:05', '2021-06-24 16:37:05'),
('e420028c3d0e8cbb8717ba713f64bbb2ebc536c7d36b46f4e2cd0ea74d710148fcb82d7433c2ce6b', 2, 1, 'AppName', '[]', 0, '2020-06-24 13:53:00', '2020-06-24 13:53:00', '2021-06-24 18:53:00'),
('f229a5f7a42ed70cac2d19c00855eae52318dc835b6abe61d09dbcbb0e48f7b695a1b9962e7096b0', 2, 1, 'AppName', '[]', 0, '2020-06-24 10:16:45', '2020-06-24 10:16:45', '2021-06-24 15:16:45');

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'JN6MS8TNAoVD0jdTVNE826KWsvmjrnnxN1UlAgUI', NULL, 'http://localhost', 1, 0, 0, '2020-06-24 07:19:32', '2020-06-24 07:19:32'),
(2, NULL, 'Laravel Password Grant Client', '2FHs3dXVMbvmQ2bFmMiWBa95qv9q5idpEH4tqu9l', 'users', 'http://localhost', 0, 1, 0, '2020-06-24 07:19:32', '2020-06-24 07:19:32'),
(3, 2, 'faizan', '8voVwq5MQDWM2WNE4FYzL0BYy9DysdIvYsr52Oys', NULL, 'http://localhost/auth/callback', 0, 0, 0, '2020-06-24 08:23:53', '2020-06-24 08:23:53');

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2020-06-24 07:19:32', '2020-06-24 07:19:32');

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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 `overseas_work_experience`
--

CREATE TABLE `overseas_work_experience` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `overseas_work_exp_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `partner_skill_qualification`
--

CREATE TABLE `partner_skill_qualification` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `partner_skill_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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 `professional_year_australia`
--

CREATE TABLE `professional_year_australia` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `py_id` bigint(20) UNSIGNED NOT NULL,
  `input` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ref_australian_work_experience`
--

CREATE TABLE `ref_australian_work_experience` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `australian_experience_duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `australian_experience_points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref_australian_work_experience`
--

INSERT INTO `ref_australian_work_experience` (`id`, `australian_experience_duration`, `australian_experience_points`, `created_at`, `updated_at`) VALUES
(1, '8 years or more', 20, NULL, NULL),
(2, '5 Years or more', 15, NULL, NULL),
(3, '3 years or more', 10, NULL, NULL),
(4, '1 year or more', 5, NULL, NULL),
(5, 'Less than 1 year ', 0, NULL, NULL);

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

--
-- Table structure for table `ref_education_in_australia`
--

CREATE TABLE `ref_education_in_australia` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `australian_education` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `australian_education_points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref_education_in_australia`
--

INSERT INTO `ref_education_in_australia` (`id`, `australian_education`, `australian_education_points`, `created_at`, `updated_at`) VALUES
(1, 'Yes, Degree, Diploma, Advance-diploma or trade qualification', 5, NULL, NULL),
(2, 'Working, Degree, Diploma, Advance-diploma or trade qualification', 5, NULL, NULL),
(3, 'No', 0, NULL, NULL);

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

--
-- Table structure for table `ref_education_points`
--

CREATE TABLE `ref_education_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `education_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `education_points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ref_english_level`
--

CREATE TABLE `ref_english_level` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `english_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `english_level_points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref_english_level`
--

INSERT INTO `ref_english_level` (`id`, `english_level`, `english_level_points`, `created_at`, `updated_at`) VALUES
(1, 'Competent English', 0, NULL, NULL),
(2, 'Proficient English', 10, NULL, NULL),
(3, 'Superior English', 20, NULL, NULL);

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

--
-- Table structure for table `ref_overseas_work_experience`
--

CREATE TABLE `ref_overseas_work_experience` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `overseas_experience_duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `overseas_experience_points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref_overseas_work_experience`
--

INSERT INTO `ref_overseas_work_experience` (`id`, `overseas_experience_duration`, `overseas_experience_points`, `created_at`, `updated_at`) VALUES
(1, '8 years or more', 15, NULL, NULL),
(2, '5 years or more', 10, NULL, NULL),
(3, '3 years or more', 5, NULL, NULL),
(4, 'Less than 3 years', 0, NULL, NULL),
(5, 'No work experience', 0, NULL, NULL);

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

--
-- Table structure for table `ref_partner_skill_qualification`
--

CREATE TABLE `ref_partner_skill_qualification` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref_partner_skill_qualification`
--

INSERT INTO `ref_partner_skill_qualification` (`id`, `question`, `points`, `created_at`, `updated_at`) VALUES
(1, 'single', 10, NULL, NULL),
(2, 'married + competent English ', 5, NULL, NULL),
(3, 'married + competent English + skill assessment', 10, NULL, NULL),
(4, 'married ', 0, NULL, NULL);

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

--
-- Table structure for table `ref_professional_year_australia`
--

CREATE TABLE `ref_professional_year_australia` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref_professional_year_australia`
--

INSERT INTO `ref_professional_year_australia` (`id`, `question`, `points`, `created_at`, `updated_at`) VALUES
(1, 'completed professional year', 5, NULL, NULL),
(2, 'complete it in future for Accountants', 5, NULL, NULL),
(3, 'complete it in future for IT professionals', 5, NULL, NULL),
(4, 'complete it in future for Engineers', 5, NULL, NULL);

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

--
-- Table structure for table `specialist_education_qualification`
--

CREATE TABLE `specialist_education_qualification` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `input` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `points` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `tags` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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,
  `access_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refresh_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expires_in` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `access_token`, `refresh_token`, `expires_in`) VALUES
(2, 'tuts make', 'support@brilliant.com', NULL, '$2y$10$/GZlIXe4hU6CCe78QnWiiuJICrT69qBe7YMovK.6WaCbV4JEWqwy2', NULL, '2020-06-24 10:15:47', '2020-06-24 10:15:47', '', '', ''),
(3, 'faizan shahid', 'faizanshahid0334@gmail.com', NULL, '$2y$10$sAANlb2zJvXfOIz7EPLKq.FoQJ/wKQoLGwPnE/KXC7g4Kj7r4iFlm', NULL, '2020-06-24 07:13:03', '2020-06-24 07:13:03', 'ya29.a0AfH6SMBsr_NXPJdBPC8LO85sWIqdzbxfOsvG8siyAgIxfiRXFSl3uK8socMb9qMKjZlEbJe_TlFkchzr9BYxMMC6qW1cds_vOjqKnNepumg-0iinXpdVKGBmIoauyqBssvl8afDkRmX38gdMFacJkDOy_mo2d5YIJFI', '1//04Md8OTjLto-zCgYIARAAGAQSNwF-L9IrPvsdiBIFyAhvjeaM0P0HFgm08lOE8_iMcld0cY0VwgSWnew7hqS6tBC_eXjugqNw9SQ', '3599');

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

--
-- Table structure for table `users_age_details`
--

CREATE TABLE `users_age_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `age_range_id` bigint(20) UNSIGNED NOT NULL,
  `date_of_birth` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users_profile`
--

CREATE TABLE `users_profile` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `fb_user_id` bigint(20) NOT NULL,
  `user_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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 `age_ranges`
--
ALTER TABLE `age_ranges`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `australian_work_experience`
--
ALTER TABLE `australian_work_experience`
  ADD PRIMARY KEY (`id`),
  ADD KEY `australian_work_experience_user_id_foreign` (`user_id`),
  ADD KEY `australian_work_experience_australian_work_exp_id_foreign` (`australian_work_exp_id`);

--
-- Indexes for table `designated_language_points`
--
ALTER TABLE `designated_language_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `designated_language_points_user_id_foreign` (`user_id`);

--
-- Indexes for table `education_in_australia`
--
ALTER TABLE `education_in_australia`
  ADD PRIMARY KEY (`id`),
  ADD KEY `education_in_australia_user_id_foreign` (`user_id`),
  ADD KEY `education_in_australia_australian_education_id_foreign` (`australian_education_id`);

--
-- Indexes for table `education_points`
--
ALTER TABLE `education_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `education_points_user_id_foreign` (`user_id`),
  ADD KEY `education_points_education_points_id_foreign` (`education_points_id`);

--
-- Indexes for table `english_level_details`
--
ALTER TABLE `english_level_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `english_level_details_user_id_foreign` (`user_id`),
  ADD KEY `english_level_details_english_level_id_foreign` (`english_level_id`);

--
-- 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 `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

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

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

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

--
-- Indexes for table `overseas_work_experience`
--
ALTER TABLE `overseas_work_experience`
  ADD PRIMARY KEY (`id`),
  ADD KEY `overseas_work_experience_user_id_foreign` (`user_id`),
  ADD KEY `overseas_work_experience_overseas_work_exp_id_foreign` (`overseas_work_exp_id`);

--
-- Indexes for table `partner_skill_qualification`
--
ALTER TABLE `partner_skill_qualification`
  ADD PRIMARY KEY (`id`),
  ADD KEY `partner_skill_qualification_partner_skill_id_foreign` (`partner_skill_id`),
  ADD KEY `partner_skill_qualification_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `professional_year_australia`
--
ALTER TABLE `professional_year_australia`
  ADD PRIMARY KEY (`id`),
  ADD KEY `professional_year_australia_py_id_foreign` (`py_id`),
  ADD KEY `professional_year_australia_user_id_foreign` (`user_id`);

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

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

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

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

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

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

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

--
-- Indexes for table `specialist_education_qualification`
--
ALTER TABLE `specialist_education_qualification`
  ADD PRIMARY KEY (`id`),
  ADD KEY `specialist_education_qualification_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `users_age_details`
--
ALTER TABLE `users_age_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_age_details_user_id_foreign` (`user_id`),
  ADD KEY `users_age_details_age_range_id_foreign` (`age_range_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- 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=51;

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

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

--
-- 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 `overseas_work_experience`
--
ALTER TABLE `overseas_work_experience`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `australian_work_experience`
--
ALTER TABLE `australian_work_experience`
  ADD CONSTRAINT `australian_work_experience_australian_work_exp_id_foreign` FOREIGN KEY (`australian_work_exp_id`) REFERENCES `ref_australian_work_experience` (`id`),
  ADD CONSTRAINT `australian_work_experience_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `designated_language_points`
--
ALTER TABLE `designated_language_points`
  ADD CONSTRAINT `designated_language_points_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `education_in_australia`
--
ALTER TABLE `education_in_australia`
  ADD CONSTRAINT `education_in_australia_australian_education_id_foreign` FOREIGN KEY (`australian_education_id`) REFERENCES `ref_education_in_australia` (`id`),
  ADD CONSTRAINT `education_in_australia_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `education_points`
--
ALTER TABLE `education_points`
  ADD CONSTRAINT `education_points_education_points_id_foreign` FOREIGN KEY (`education_points_id`) REFERENCES `ref_education_points` (`id`),
  ADD CONSTRAINT `education_points_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `english_level_details`
--
ALTER TABLE `english_level_details`
  ADD CONSTRAINT `english_level_details_english_level_id_foreign` FOREIGN KEY (`english_level_id`) REFERENCES `ref_english_level` (`id`),
  ADD CONSTRAINT `english_level_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `overseas_work_experience`
--
ALTER TABLE `overseas_work_experience`
  ADD CONSTRAINT `overseas_work_experience_overseas_work_exp_id_foreign` FOREIGN KEY (`overseas_work_exp_id`) REFERENCES `ref_overseas_work_experience` (`id`),
  ADD CONSTRAINT `overseas_work_experience_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `partner_skill_qualification`
--
ALTER TABLE `partner_skill_qualification`
  ADD CONSTRAINT `partner_skill_qualification_partner_skill_id_foreign` FOREIGN KEY (`partner_skill_id`) REFERENCES `ref_partner_skill_qualification` (`id`),
  ADD CONSTRAINT `partner_skill_qualification_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `professional_year_australia`
--
ALTER TABLE `professional_year_australia`
  ADD CONSTRAINT `professional_year_australia_py_id_foreign` FOREIGN KEY (`py_id`) REFERENCES `ref_professional_year_australia` (`id`),
  ADD CONSTRAINT `professional_year_australia_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `specialist_education_qualification`
--
ALTER TABLE `specialist_education_qualification`
  ADD CONSTRAINT `specialist_education_qualification_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);

--
-- Constraints for table `users_age_details`
--
ALTER TABLE `users_age_details`
  ADD CONSTRAINT `users_age_details_age_range_id_foreign` FOREIGN KEY (`age_range_id`) REFERENCES `age_ranges` (`id`),
  ADD CONSTRAINT `users_age_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_profile` (`id`);
COMMIT;

