laravel_employee-attendance.sql

-- phpMyAdmin SQL Dump

-- version 5.1.1

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

--

-- Host: 127.0.0.1

-- Generation Time: Jun 08, 2022 at 07:20 PM

-- Server version: 10.4.19-MariaDB

-- PHP Version: 8.0.7

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

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: `laravel_employee-attendance`

--

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

--

-- Table structure for table `attendances`

--

CREATE TABLE `attendances` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `user_id` bigint(20) UNSIGNED NOT NULL,
    `status` 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 `attendances`

--

INSERT INTO
    `attendances` (
        `id`,
        `user_id`,
        `status`,
        `created_at`,
        `updated_at`
    )
VALUES
    (
        1,
        1,
        0,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        2,
        1,
        1,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        3,
        1,
        0,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        4,
        1,
        0,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        5,
        1,
        0,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        6,
        1,
        0,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        7,
        1,
        0,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        8,
        1,
        0,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        9,
        1,
        1,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        10,
        1,
        2,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        11,
        1,
        2,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        12,
        1,
        2,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        13,
        1,
        1,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        14,
        1,
        0,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        15,
        1,
        2,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        16,
        1,
        2,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        17,
        1,
        2,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        18,
        1,
        1,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        19,
        1,
        1,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        20,
        1,
        0,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        21,
        1,
        2,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        22,
        1,
        1,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        23,
        1,
        1,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        24,
        1,
        2,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        25,
        1,
        2,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        26,
        1,
        1,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        27,
        1,
        2,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        28,
        1,
        1,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        29,
        1,
        0,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        30,
        1,
        0,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        31,
        2,
        2,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        32,
        2,
        1,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        33,
        2,
        0,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        34,
        2,
        0,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        35,
        2,
        2,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        36,
        2,
        0,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        37,
        2,
        0,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        38,
        2,
        0,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        39,
        2,
        2,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        40,
        2,
        2,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        41,
        2,
        2,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        42,
        2,
        2,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        43,
        2,
        0,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        44,
        2,
        1,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        45,
        2,
        1,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        46,
        2,
        0,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        47,
        2,
        1,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        48,
        2,
        1,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        49,
        2,
        1,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        50,
        2,
        2,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        51,
        2,
        1,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        52,
        2,
        0,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        53,
        2,
        0,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        54,
        2,
        1,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        55,
        2,
        1,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        56,
        2,
        0,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        57,
        2,
        0,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        58,
        2,
        2,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        59,
        2,
        1,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        60,
        2,
        0,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        61,
        3,
        1,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        62,
        3,
        2,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        63,
        3,
        0,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        64,
        3,
        1,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        65,
        3,
        0,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        66,
        3,
        1,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        67,
        3,
        2,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        68,
        3,
        0,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        69,
        3,
        1,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        70,
        3,
        1,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        71,
        3,
        2,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        72,
        3,
        2,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        73,
        3,
        1,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        74,
        3,
        1,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        75,
        3,
        2,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        76,
        3,
        0,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        77,
        3,
        2,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        78,
        3,
        0,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        79,
        3,
        0,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        80,
        3,
        0,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        81,
        3,
        2,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        82,
        3,
        0,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        83,
        3,
        2,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        84,
        3,
        1,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        85,
        3,
        1,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        86,
        3,
        2,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        87,
        3,
        2,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        88,
        3,
        1,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        89,
        3,
        0,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        90,
        3,
        0,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        91,
        4,
        0,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        92,
        4,
        1,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        93,
        4,
        1,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        94,
        4,
        1,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        95,
        4,
        1,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        96,
        4,
        1,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        97,
        4,
        1,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        98,
        4,
        1,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        99,
        4,
        1,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        100,
        4,
        2,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        101,
        4,
        1,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        102,
        4,
        0,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        103,
        4,
        0,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        104,
        4,
        1,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        105,
        4,
        0,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        106,
        4,
        0,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        107,
        4,
        2,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        108,
        4,
        1,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:52'
    ),
    (
        109,
        4,
        2,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        110,
        4,
        0,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        111,
        4,
        0,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        112,
        4,
        2,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        113,
        4,
        2,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        114,
        4,
        0,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        115,
        4,
        2,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        116,
        4,
        0,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        117,
        4,
        1,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        118,
        4,
        1,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        119,
        4,
        1,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        120,
        4,
        1,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        121,
        5,
        1,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        122,
        5,
        2,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        123,
        5,
        2,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        124,
        5,
        0,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        125,
        5,
        2,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        126,
        5,
        1,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        127,
        5,
        0,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        128,
        5,
        2,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        129,
        5,
        2,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        130,
        5,
        0,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        131,
        5,
        1,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        132,
        5,
        0,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        133,
        5,
        0,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        134,
        5,
        2,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        135,
        5,
        0,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        136,
        5,
        1,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        137,
        5,
        0,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        138,
        5,
        1,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        139,
        5,
        0,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        140,
        5,
        1,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        141,
        5,
        1,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        142,
        5,
        0,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        143,
        5,
        2,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        144,
        5,
        1,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        145,
        5,
        1,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        146,
        5,
        1,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        147,
        5,
        2,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        148,
        5,
        0,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        149,
        5,
        0,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        150,
        5,
        0,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        151,
        6,
        1,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        152,
        6,
        0,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        153,
        6,
        1,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        154,
        6,
        1,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        155,
        6,
        1,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        156,
        6,
        1,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        157,
        6,
        2,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        158,
        6,
        2,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        159,
        6,
        1,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        160,
        6,
        2,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        161,
        6,
        0,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        162,
        6,
        1,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        163,
        6,
        0,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        164,
        6,
        2,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        165,
        6,
        2,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        166,
        6,
        2,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        167,
        6,
        2,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        168,
        6,
        1,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        169,
        6,
        1,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        170,
        6,
        0,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        171,
        6,
        0,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        172,
        6,
        1,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        173,
        6,
        1,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        174,
        6,
        2,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        175,
        6,
        0,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        176,
        6,
        1,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        177,
        6,
        1,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        178,
        6,
        2,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        179,
        6,
        2,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        180,
        6,
        1,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        181,
        7,
        0,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        182,
        7,
        0,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        183,
        7,
        0,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        184,
        7,
        0,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        185,
        7,
        1,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        186,
        7,
        0,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        187,
        7,
        1,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        188,
        7,
        0,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        189,
        7,
        2,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        190,
        7,
        0,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        191,
        7,
        1,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        192,
        7,
        1,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        193,
        7,
        1,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        194,
        7,
        1,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        195,
        7,
        0,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        196,
        7,
        0,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        197,
        7,
        0,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        198,
        7,
        2,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        199,
        7,
        0,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        200,
        7,
        1,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        201,
        7,
        1,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        202,
        7,
        1,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        203,
        7,
        0,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        204,
        7,
        1,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        205,
        7,
        1,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        206,
        7,
        2,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        207,
        7,
        0,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        208,
        7,
        1,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        209,
        7,
        1,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        210,
        7,
        2,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        211,
        8,
        2,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        212,
        8,
        0,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        213,
        8,
        0,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        214,
        8,
        2,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        215,
        8,
        1,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        216,
        8,
        2,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        217,
        8,
        2,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        218,
        8,
        0,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        219,
        8,
        1,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        220,
        8,
        0,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        221,
        8,
        0,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        222,
        8,
        1,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        223,
        8,
        2,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        224,
        8,
        2,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        225,
        8,
        2,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        226,
        8,
        2,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        227,
        8,
        0,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        228,
        8,
        2,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        229,
        8,
        1,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        230,
        8,
        2,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        231,
        8,
        1,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        232,
        8,
        1,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        233,
        8,
        2,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        234,
        8,
        2,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        235,
        8,
        1,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        236,
        8,
        1,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        237,
        8,
        0,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        238,
        8,
        1,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        239,
        8,
        0,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        240,
        8,
        2,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        241,
        9,
        2,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        242,
        9,
        1,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        243,
        9,
        1,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        244,
        9,
        2,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        245,
        9,
        2,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        246,
        9,
        2,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        247,
        9,
        2,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        248,
        9,
        0,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        249,
        9,
        0,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        250,
        9,
        0,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        251,
        9,
        2,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        252,
        9,
        0,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        253,
        9,
        0,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        254,
        9,
        1,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        255,
        9,
        1,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        256,
        9,
        1,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        257,
        9,
        0,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        258,
        9,
        1,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        259,
        9,
        2,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        260,
        9,
        1,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        261,
        9,
        1,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        262,
        9,
        0,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        263,
        9,
        1,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        264,
        9,
        0,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        265,
        9,
        0,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        266,
        9,
        1,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        267,
        9,
        1,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        268,
        9,
        1,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        269,
        9,
        1,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        270,
        9,
        0,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        271,
        10,
        2,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        272,
        10,
        1,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        273,
        10,
        2,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        274,
        10,
        2,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        275,
        10,
        1,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        276,
        10,
        2,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        277,
        10,
        0,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        278,
        10,
        2,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        279,
        10,
        2,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        280,
        10,
        0,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        281,
        10,
        2,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        282,
        10,
        0,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        283,
        10,
        0,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        284,
        10,
        1,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        285,
        10,
        2,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        286,
        10,
        0,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        287,
        10,
        0,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        288,
        10,
        2,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        289,
        10,
        0,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        290,
        10,
        0,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        291,
        10,
        2,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        292,
        10,
        0,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        293,
        10,
        0,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        294,
        10,
        0,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        295,
        10,
        1,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        296,
        10,
        1,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        297,
        10,
        0,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        298,
        10,
        2,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        299,
        10,
        0,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        300,
        10,
        2,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        301,
        11,
        1,
        '2022-06-06 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        302,
        11,
        0,
        '2022-06-05 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        303,
        11,
        1,
        '2022-06-04 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        304,
        11,
        1,
        '2022-06-03 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        305,
        11,
        0,
        '2022-06-02 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        306,
        11,
        2,
        '2022-06-01 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        307,
        11,
        2,
        '2022-05-31 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        308,
        11,
        2,
        '2022-05-30 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        309,
        11,
        2,
        '2022-05-29 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        310,
        11,
        2,
        '2022-05-28 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        311,
        11,
        2,
        '2022-05-27 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        312,
        11,
        2,
        '2022-05-26 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        313,
        11,
        0,
        '2022-05-25 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        314,
        11,
        2,
        '2022-05-24 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        315,
        11,
        2,
        '2022-05-23 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        316,
        11,
        2,
        '2022-05-22 21:00:00',
        '2022-06-08 14:19:53'
    ),
    (
        317,
        11,
        0,
        '2022-05-21 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        318,
        11,
        1,
        '2022-05-20 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        319,
        11,
        2,
        '2022-05-19 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        320,
        11,
        2,
        '2022-05-18 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        321,
        11,
        1,
        '2022-05-17 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        322,
        11,
        0,
        '2022-05-16 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        323,
        11,
        0,
        '2022-05-15 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        324,
        11,
        2,
        '2022-05-14 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        325,
        11,
        1,
        '2022-05-13 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        326,
        11,
        0,
        '2022-05-12 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        327,
        11,
        0,
        '2022-05-11 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        328,
        11,
        0,
        '2022-05-10 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        329,
        11,
        1,
        '2022-05-09 21:00:00',
        '2022-06-08 14:19:54'
    ),
    (
        330,
        11,
        2,
        '2022-05-08 21:00:00',
        '2022-06-08 14:19:54'
    );

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

--

-- Table structure for table `departments`

--

CREATE TABLE `departments` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` 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;

--

-- Dumping data for table `departments`

--

INSERT INTO
    `departments` (`id`, `name`, `created_at`, `updated_at`)
VALUES
    (
        1,
        'Recruiting and staffing',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        2,
        'Health and safety',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        3,
        'Training and development',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        4,
        'Compensation and benefits',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    );

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

--

-- Table structure for table `jobs`

--

CREATE TABLE `jobs` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `department_id` bigint(20) UNSIGNED NOT NULL,
    `title` 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;

--

-- Dumping data for table `jobs`

--

INSERT INTO
    `jobs` (
        `id`,
        `department_id`,
        `title`,
        `created_at`,
        `updated_at`
    )
VALUES
    (
        1,
        4,
        'Cleaner',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        2,
        3,
        'Back-End Devloper',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        3,
        4,
        'Front-End Devaloper',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        4,
        1,
        'Project Manager',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        5,
        1,
        'Project Coordinator',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        6,
        1,
        'IOS Devloper',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        7,
        4,
        'Android Developer',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        8,
        4,
        'Fluter Developer',
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    );

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

--

-- 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
    (
        1,
        '2022_04_11_075639_create_departments_table',
        1
    ),
    (2, '2022_04_11_075740_create_jobs_table', 1),
    (3, '2022_04_11_075741_create_users_table', 1),
    (
        4,
        '2022_04_20_123700_create_attendances_table',
        1
    ),
    (
        5,
        '2022_04_27_050044_create_notifications_table',
        1
    );

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

--

-- Table structure for table `notifications`

--

CREATE TABLE `notifications` (
    `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_id` bigint(20) UNSIGNED NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `read_at` timestamp NULL DEFAULT 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,
    `job_id` bigint(20) UNSIGNED DEFAULT NULL,
    `is_admin` tinyint(1) NOT NULL DEFAULT 0,
    `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `gender` tinyint(1) DEFAULT NULL,
    `sallary` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_verified_at` timestamp NULL DEFAULT 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;

--

-- Dumping data for table `users`

--

INSERT INTO
    `users` (
        `id`,
        `job_id`,
        `is_admin`,
        `first_name`,
        `last_name`,
        `gender`,
        `sallary`,
        `email`,
        `password`,
        `address`,
        `number`,
        `email_verified_at`,
        `remember_token`,
        `created_at`,
        `updated_at`
    )
VALUES
    (
        1,
        NULL,
        1,
        'admin',
        'User',
        1,
        NULL,
        'admin@test.com',
        '$2y$10$Yxj2Y.NfExkzfoQGlU5PJeZXbHAMxKnlQs4oioUYbk9MkPLnY4502',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        NULL,
        NULL
    ),
    (
        2,
        3,
        0,
        'keith',
        'zijie',
        1,
        NULL,
        'keith_zijie@test.com',
        '$2y$10$QwGYVkG30pgBasArKnMYFOsQ4CCDp5ApnwasE2BM4gdVyDWMb05ke',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        3,
        3,
        0,
        'issiaka',
        'rogan',
        0,
        NULL,
        'issiaka_rogan@test.com',
        '$2y$10$juoEhoUeZqAw61E1kybhD.kVBxVti9DeW.jOUpy08/e5nYDEDBRbC',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        4,
        3,
        0,
        'fionn',
        'rhys',
        1,
        NULL,
        'fionn_rhys@test.com',
        '$2y$10$scIpqItPRHt5O79vRGYWqeJirDS6h89xIvkTY4Lchbq/ajgovkOha',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:51',
        '2022-06-08 14:19:51'
    ),
    (
        5,
        6,
        0,
        'qirui',
        'mclay',
        0,
        NULL,
        'qirui_mclay@test.com',
        '$2y$10$A9XVFAiux8jYiEKUF8kgsuEpGlLQBx6/cjNdqLL1IyPd591VWjdNq',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:52',
        '2022-06-08 14:19:52'
    ),
    (
        6,
        2,
        0,
        'taliesin',
        'tyrnan',
        1,
        NULL,
        'taliesin_tyrnan@test.com',
        '$2y$10$VSl/Fa45drmtWjwYAnTB6u8Syz2fCFntT2QnLXkfbHVgnQw3efSsG',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:52',
        '2022-06-08 14:19:52'
    ),
    (
        7,
        3,
        0,
        'darien',
        'dugald',
        0,
        NULL,
        'darien_dugald@test.com',
        '$2y$10$ccpjm9bsYjZAQ95zDvLukea0pByRtsbxE0ZfkfapeXCcAVZVkN9MO',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:52',
        '2022-06-08 14:19:52'
    ),
    (
        8,
        2,
        0,
        'callan-adam',
        'a-jay',
        1,
        NULL,
        'callan-adam_a-jay@test.com',
        '$2y$10$oFnanWwTVYNv7lfRbWw/FerEO9oz3evgMXOMQn.GzV7jL2gic3XdO',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:52',
        '2022-06-08 14:19:52'
    ),
    (
        9,
        6,
        0,
        'rayane',
        'branden',
        0,
        NULL,
        'rayane_branden@test.com',
        '$2y$10$N9PtCHQo6CPK.9tE7YsoQOO7x5uhC7eX0NXE/7wAG4q8XDccPbSVK',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:52',
        '2022-06-08 14:19:52'
    ),
    (
        10,
        4,
        0,
        'balian',
        'kole',
        1,
        NULL,
        'balian_kole@test.com',
        '$2y$10$BNKY3xrL4hxTRXVJYxib5uWjNd3Nf0L4oWf7FgMqE6OGsqM2MD2Gu',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:52',
        '2022-06-08 14:19:52'
    ),
    (
        11,
        8,
        0,
        'shawnpaul',
        'darryl',
        0,
        NULL,
        'shawnpaul_darryl@test.com',
        '$2y$10$6oGmcQhyM12nlGM0cjqraOXiwKHv5.3Yvo0doNKhu9gNCWZ0TijtO',
        'Erbil, center',
        '750 425 8891',
        NULL,
        NULL,
        '2022-06-08 14:19:52',
        '2022-06-08 14:19:52'
    );

--

-- Indexes for dumped tables

--

--

-- Indexes for table `attendances`

--

ALTER TABLE
    `attendances`
ADD
    PRIMARY KEY (`id`),
ADD
    KEY `attendances_user_id_foreign` (`user_id`);

--

-- Indexes for table `departments`

--

ALTER TABLE `departments` ADD PRIMARY KEY (`id`);

--

-- Indexes for table `jobs`

--

ALTER TABLE
    `jobs`
ADD
    PRIMARY KEY (`id`),
ADD
    KEY `jobs_department_id_foreign` (`department_id`);

--

-- Indexes for table `migrations`

--

ALTER TABLE `migrations` ADD PRIMARY KEY (`id`);

--

-- Indexes for table `notifications`

--

ALTER TABLE
    `notifications`
ADD
    PRIMARY KEY (`id`),
ADD
    KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`, `notifiable_id`);

--

-- Indexes for table `users`

--

ALTER TABLE
    `users`
ADD
    PRIMARY KEY (`id`),
ADD
    UNIQUE KEY `users_id_unique` (`id`),
ADD
    UNIQUE KEY `users_email_unique` (`email`),
ADD
    UNIQUE KEY `users_remember_token_unique` (`remember_token`),
ADD
    KEY `users_job_id_foreign` (`job_id`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `attendances`

--

ALTER TABLE
    `attendances`
MODIFY
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    AUTO_INCREMENT = 331;

--

-- AUTO_INCREMENT for table `departments`

--

ALTER TABLE
    `departments`
MODIFY
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    AUTO_INCREMENT = 5;

--

-- AUTO_INCREMENT for table `jobs`

--

ALTER TABLE
    `jobs`
MODIFY
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    AUTO_INCREMENT = 9;

--

-- AUTO_INCREMENT for table `migrations`

--

ALTER TABLE
    `migrations`
MODIFY
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    AUTO_INCREMENT = 6;

--

-- AUTO_INCREMENT for table `users`

--

ALTER TABLE
    `users`
MODIFY
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    AUTO_INCREMENT = 12;

--

-- Constraints for dumped tables

--

--

-- Constraints for table `attendances`

--

ALTER TABLE
    `attendances`
ADD
    CONSTRAINT `attendances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--

-- Constraints for table `jobs`

--

ALTER TABLE
    `jobs`
ADD
    CONSTRAINT `jobs_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`);

--

-- Constraints for table `users`

--

ALTER TABLE
    `users`
ADD
    CONSTRAINT `users_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE
SET
    NULL;

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 */

;