-- Source: sql/payroll_anomalies.sql


-- Source: demoData/groups.sql
INSERT INTO groups (id, name, description, parent_id) VALUES
(2, 'Finance Team', 'Handles company finances', NULL),
(3, 'Sales Team', 'Responsible for sales', NULL);


-- Source: sql/grant_user1_all_permissions.sql
-- Create HR Administrator role with full access
INSERT INTO groups (id, name, description)
VALUES (1, 'HR Admin Group', 'Full access group')
ON DUPLICATE KEY UPDATE name = VALUES(name), description = VALUES(description);

-- Super Admin role with wildcard permissions
INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Super Admin',
    NULL,
    '{"*": ["*"]}',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Procurement Manager',
    NULL,
    '{
        "procurement_requests": ["getAll","create","update","delete","approve","reject"],
        "purchase_requests": ["getAll","create","update","delete","approve","reject"],
        "rfqs": ["getAll","create","update","delete","approve","close"],
        "purchase_orders": ["getAll","create","update","delete","approve","close"],
        "goods_receipts": ["getAll","create","update","delete"],
        "vendor_invoices": ["getAll","create","update","delete","approve"],
        "vendors": ["getAll","create","update","delete"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Finance Approver',
    NULL,
    '{
        "procurement_requests": ["getAll","approve"],
        "rfqs": ["getAll","approve"],
        "purchase_orders": ["getAll","approve"],
        "vendor_invoices": ["getAll","approve"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'CEO Approver',
    NULL,
    '{
        "procurement_requests": ["getAll","approve"],
        "rfqs": ["getAll","approve"],
        "purchase_orders": ["getAll","approve"],
        "vendor_invoices": ["getAll","approve"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Employee',
    NULL,
    '{
        "disciplinary_cases": ["getById"],
        "appeals": ["submit","getById"],
        "purchase_requests": ["getAll","create","update"],
        "time_clocks": ["getAll"],
        "payroll_periods": ["getAll"]
    }',
    -- permissions allow regular employees to submit and view their
    -- own purchase requests
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'HR Administrator',
    NULL,
    '{
        "attendance": ["getAll","create","update","delete","approve","reject"],
        "employees": ["getAll","create","update","delete"],
        "employee_types": ["getAll","create","update","delete"],
        "users": ["getAll","create","update","delete"],
        "time_clock_locations": ["getAll","create","update","delete"],
        "payroll": ["getAll","create","update","delete"],
        "payroll_config": ["getAll","create","update","delete"],
        "payslips": ["verify"],
        "requisitions": ["getAll","create","update","delete","approve","reject"],
        "procurement_requests": ["getAll","create","update","delete","approve","reject"],
        "purchase_requests": ["getAll","create","update","delete","approve","reject"],
        "vendor": ["getAll","create","update","delete"],
        "groups": ["getAll","create","update","delete"],
        "user_group_memberships": ["getAll","create","update","delete"],
        "group_permissions": ["getAll","create","update","delete"],
        "training_courses": ["getAll","create","update","delete"],
        "resources": ["getAll","create","update","delete"],
        "locations": ["getAll","create","update","delete"],
        "timeclocks": ["getAll","create","update","delete"],
        "time_clocks": ["getAll","create","update","delete"],
        "reports": ["company","summaryToday","absenteesToday","locationAlerts"],
        "performance_goals": ["*"],
        "performance_reviews": ["*"],
        "feedback_notes": ["*"],
        "check_ins": ["*"],
        "performance_dashboard": ["view"]
        "reports": ["company","summaryToday","absenteesToday","locationAlerts"],
        "violation_types": ["getAll","create","update","delete"],
        "disciplinary_cases": ["getAll","create","update","delete"],
        "case_evidence": ["getAll","create","update","delete"],
        "interview_logs": ["getAll","create","update","delete"],
        "disciplinary_actions": ["getAll","create","update","delete"],
        "appeals": ["getAll","create","update","delete","review"],
        "ohs_actions": ["manage"],
        "ohs_inspections": ["view"],
        "ohs_regulations": ["manage"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Location Officer',
    NULL,
    '{"*": ["*"]}',
    NOW(),
    1
);

-- Exit workflow roles
INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'HR Manager',
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Department Head',
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'IT',
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Admin',
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Legal',
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
        "reports": ["company","summaryToday","absenteesToday","locationAlerts"],
        "ohs_inspections": ["view"]
    }',
    NOW(),
    1
);
INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Legal Admin',
    NULL,
    '{"cases": ["*"], "matters": ["*"], "case_documents": ["*"], "case_events": ["*"], "case_communications": ["*"], "case_instructions": ["*"]}',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Finance Manager',
    NULL,
    '{
        "glaccounts": ["getAll","create","update","delete","toggle"],
        "gltransactions": ["getAll","create","update","delete","import","postBatch","split","parseText"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Accountant',
    'Finance Manager',
    '{
        "glaccounts": ["getAll","update"],
        "gltransactions": ["getAll","create","postBatch","split"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Auditor',
    NULL,
    '{
        "glaccounts": ["getAll"],
        "gltransactions": ["getAll"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Finance Officer',
    NULL,
    '{
        "properties": ["getAll","create","update","delete"],
        "ratepayers": ["*"],
        "property_rates": ["*"],
        "rates_billing": ["generate"],
        "rate_payments": ["create"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Council Clerk',
    NULL,
    '{
        "properties": ["getAll","create","update","delete"],
        "ratepayers": ["*"],
        "property_rates": ["*"],
        "rates_billing": ["generate"],
        "rate_payments": ["create"]
    }',
    NOW(),
    1
);

-- DMS roles
INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'SuperAdmin',
    NULL,
    '{"storage_connectors": ["*"], "documents": ["*"], "calendar_events": ["*"], "meetings": ["*"]}',
    NOW(),
    1
);
INSERT INTO roles_permissions (role, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'User',
    NULL,
    '{"documents": ["getAll","getById","uploadVersion"]}',
    NOW(),
    1
);


INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (1, 1, 'Super Admin', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);
INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (6, 1, 'Location Officer', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);
INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (3, 1, 'Location Officer', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);
INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (4, 1, 'Location Officer', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);

INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (7, 1, 'Procurement Manager', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);
INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (8, 1, 'Finance Approver', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);
INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (9, 1, 'CEO Approver', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);

INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (8, 1, 'Finance Officer', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);
INSERT INTO user_group_memberships (user_id, group_id, role, joined_at)
VALUES (9, 1, 'Council Clerk', NOW())
ON DUPLICATE KEY UPDATE group_id = VALUES(group_id), role = VALUES(role);



-- Source: demoData/group_permissions.sql
INSERT INTO group_permissions (id, group_id, resource_id, can_view, can_edit, can_create, can_delete) VALUES
(1, 2, 1, 1, 1, 1, 1),
(2, 2, 2, 1, 1, 1, 1),
(3, 3, 1, 1, 0, 0, 0),
(4, 2, 3, 1, 1, 1, 1),
(5, 3, 3, 1, 0, 0, 0);


-- Source: demoData/user_group_memberships.sql
INSERT INTO user_group_memberships (user_id, group_id, role, joined_at) VALUES
(2, 2, 'Finance Team', NOW()),
(3, 3, 'Sales Team', NOW());


-- Source: sql/locations.sql
INSERT INTO locations (name, latitude, longitude, radius_m, company_id) VALUES
  ('Suva Headquarters', -18.1397956843015, 178.42656254768372, 50, 1),
  ('Sigatoka Office', -18.1458, 177.5065, 50, 1),
  ('Suva Export', -18.1292, 178.4265, 50, 1),
  ('Nadi Office', -17.7533, 177.4435, 50, 1),
  ('Lautoka Office', -17.6167, 177.4667, 50, 1),
  ('Ba Office', -17.5341, 177.6838, 50, 1),
  ('Nausori Office', -18.0244, 178.5451, 50, 1),
  ('Labasa Office', -16.4302, 179.3822, 50, 1),
  ('Nausori Station', -18.0244, 178.5451, 50, 1),
  ('Savusavu', -16.7794, 179.3314, 50, 1),
  ('Navua Station', -18.2194, 178.1592, 50, 1),
  ('Rakiraki Office', -17.3658, 178.1650, 50, 1),
  ('Rotuma', -12.5025, 177.0720, 50, 1),
  ('Lab', -18.0491, 178.5298, 50, 1);


-- Source: demoData/time_clock_locations.sql
INSERT INTO time_clock_locations (id, name, shape, center_lat, center_lng, radius_m, assigned_to_type, assigned_to_ids) VALUES
(1, 'Suva HQ', 'circle', -18.1398, 178.4266, 50, 'location', '1'),
(2, 'Nadi Office', 'circle', -17.7533, 177.4435, 50, 'location', '4');

-- Source: demoData/pay_cycles.sql
INSERT INTO pay_cycles (id, name, frequency, pay_day, cutoff_offset, next_run_date, locale) VALUES
(1, 'Weekly', 'weekly', 'Friday', 0, '2025-06-07', 'en_US'),
(2, 'Fortnightly', 'fortnightly', 'Tuesday', 4, '2025-06-14', 'en_US'),
(3, 'Bi-Monthly-15', 'bi-monthly', '15', 2, '2025-06-15', 'en_US'),
(4, 'Bi-Monthly-30', 'bi-monthly', '30', 2, '2025-06-30', 'en_US'),
(5, 'Monthly', 'monthly', '30', 2, '2025-06-30', 'en_US');


-- Source: demoData/pay_rules.sql
INSERT INTO pay_rules (id, rule_name, overtime_rate, threshold_hours, notes) VALUES
(1, 'Standard OT', 1.50, 40, 'Overtime after 40 hours'),
(2, 'Holiday OT', 2.00, 0, 'Double pay on holidays');


-- Source: demoData/payroll_periods.sql
INSERT INTO payroll_periods (id, pay_cycle_id, period_start, period_end) VALUES
(1, 2, '2025-05-02', '2025-05-15'),
(2, 2, '2025-05-16', '2025-05-29'),
(3, 2, '2025-05-30', '2025-06-05');


-- Source: demoData/employee_types.sql
INSERT INTO employee_types (id, type, default_items) VALUES
(1, 'Full-Time', 'Laptop,Phone'),
(2, 'Contractor', 'Laptop');


-- Source: demoData/employees.sql
INSERT INTO employees (id, name, department, email, phone, title, salary, updatedAt, createdBy, pay_cycle_id, manager_id, company_id) VALUES
(1, 'Alice Johnson', 'HR', 'alice.johnson@example.com', '+1-555-01001', 'HR Manager', 55000, NOW(), 1, 1, NULL, 1),
(2, 'Bob Smith', 'Engineering', 'bob.smith@example.com', '+1-555-01002', 'Software Engineer', 52000, NOW(), 1, 2, 1, 1),
(3, 'Carol Williams', 'Sales', 'carol.williams@example.com', '+1-555-01003', 'Sales Representative', 48000, NOW(), 1, 2, 1, 2),
(4, 'David Brown', 'Engineering', 'david.brown@example.com', '+1-555-01004', 'DevOps Engineer', 56000, NOW(), 1, 2, 2, 2),
(5, 'Eva Davis', 'Support', 'eva.davis@example.com', '+1-555-01005', 'Support Specialist', 47000, NOW(), 1, 3, 1, 3);


-- Source: demoData/compensation.sql
INSERT INTO compensation (id, employee_id, pay_type, amount, effective_from, effective_to) VALUES
(1, 1, 'salary', 60000.00, '2025-01-01', NULL),
(2, 2, 'salary', 80000.00, '2025-01-01', NULL),
(3, 3, 'salary', 50000.00, '2025-01-01', NULL),
(4, 4, 'salary', 75000.00, '2025-01-01', NULL),
(5, 5, 'salary', 45000.00, '2025-01-01', NULL);


-- Source: demoData/benefit_plans.sql
INSERT INTO benefit_plans (id, name, deduction_amount, pre_tax) VALUES
(1, 'Health Insurance', 150.00, 1),
(2, 'Retirement 401k', 200.00, 1);


-- Source: demoData/employee_benefits.sql
INSERT INTO employee_benefits (id, employee_id, benefit_plan_id, start_date, end_date) VALUES
(1, 1, 1, '2025-01-01', NULL),
(2, 2, 2, '2025-01-01', NULL);


-- Source: demoData/employee_items.sql
INSERT INTO employee_items (id, employee_id, item_name, is_ppe, expiry_date, assignee_user_id, assignee_group_id) VALUES
(1, 2, 'Laptop', 0, NULL, 1, NULL),
(2, 3, 'Safety Helmet', 1, '2025-12-31', 1, NULL);


-- Source: demoData/jobs.sql
INSERT INTO jobs (id, title) VALUES
(1, 'Software Engineer'),
(2, 'Sales Representative'),
(3, 'HR Specialist');


-- Source: demoData/open_positions.sql
INSERT INTO open_positions (id, title, department, location, status, description, createdBy, updatedAt) VALUES
(1, 'Junior Developer', 'Engineering', 'Suva', 'Open', 'Entry level role', 1, NOW()),
(2, 'Sales Intern', 'Sales', 'Nadi', 'Open', 'Assist sales team', 1, NOW());


-- Source: demoData/applications.sql
INSERT INTO applications (id, job_id, first_name, last_name, email, phone, address, date_of_birth, position_applied, application_date, status, source, notes, created_by) VALUES
(1, 1, 'George', 'Miller', 'george.miller@example.com', '+1-555-1000', '10 Market St', '1990-04-12', 'Software Engineer', '2025-05-20', 'Under Review', 'Website', NULL, 1);


-- Source: demoData/application_documents.sql
INSERT INTO application_documents (id, application_id, file_name, file_type, file_path, uploaded_by) VALUES
(1, 1, 'resume.pdf', 'resume', '/docs/applications/resume1.pdf', 1);


-- Source: sql/employee_onboarding_workflow.sql
INSERT INTO workflows (name, trigger_event, definition, is_active)
VALUES (
  'Employee Onboarding',
  'employee.hired',
  '{
    "conditions": [],
    "steps": [
      { "type": "assign_items" },
      { "type": "notify_manager" },
      { "type": "trigger_api", "items": ["365"] }
    ]
  }',
  1
);

-- Workflow for OHS incident reporting
INSERT INTO workflows (name, trigger_event, definition, is_active)
VALUES (
  'OHS Incident Reporting',
  'ohs_incident_reported',
  '{
    "conditions": [],
    "steps": [
      { "type": "wait_approval", "role": "hs_officer" },
      { "type": "update_status", "field": "status", "value": "investigating" }
    ]
  }',
  1
);


-- Source: demoData/tasks.sql
INSERT INTO tasks (id, employee_id, item_name, manager_id, status) VALUES
(1, 2, 'Submit project report', 1, 'pending'),
(2, 3, 'Client follow up', 1, 'completed');


-- Source: demoData/payroll_runs.sql
INSERT INTO payroll_runs (id, payroll_period_id, run_date, status) VALUES
(1, 1, '2025-06-07', 'completed'),
(2, 2, '2025-06-07', 'completed'),
(3, 3, '2025-06-01', 'completed');


-- Source: demoData/payslips.sql
INSERT INTO payslips (
  id,
  payroll_run_id,
  employee_id,
  gross_pay,
  net_pay,
  document_path,
  verified_by,
  verified_at,
  verification_notes
) VALUES
(1, 1, 1, 5000.00, 4000.00, '/docs/payslips/1.pdf', NULL, NULL, NULL),
(2, 1, 2, 6666.67, 5200.00, '/docs/payslips/2.pdf', NULL, NULL, NULL),
(3, 2, 3, 4166.67, 3400.00, '/docs/payslips/3.pdf', NULL, NULL, NULL);


-- Source: demoData/payslip_lines.sql
INSERT INTO payslip_lines (id, payslip_id, description, amount, line_type) VALUES
(1, 1, 'Base Salary', 5000.00, 'earning'),
(2, 1, 'Tax', -1000.00, 'deduction'),
(3, 2, 'Base Salary', 6666.67, 'earning'),
(4, 2, 'Tax', -1466.67, 'deduction');


-- Source: demoData/payroll_adjustments.sql
INSERT INTO payroll_adjustments (id, employee_id, payroll_period_id, description, amount, adjustment_type) VALUES
(1, 1, 1, 'Bonus', 500.00, 'earning'),
(2, 2, 1, 'Health Insurance', -200.00, 'deduction');


-- Source: demoData/payroll_anomalies.sql
INSERT INTO payroll_anomalies (id, payroll_run_id, employee_id, message) VALUES
(1, 1, 2, 'Missing timesheet');


-- Source: demoData/notification_log.sql
INSERT INTO notification_log (type, recipient, subject, message, status) VALUES
('email', 'alice.johnson@example.com', 'Welcome', 'Welcome to the company!', 'sent');


-- Source: demoData/leave_types.sql
INSERT INTO leave_types (id, name, code, description, daysPerYear, accrualType, carryForward, maxCarry, approvalRequired, paid, active, createdBy) VALUES
(1, 'Annual Leave', 'AL', 'Paid annual leave', 20, 'monthly', 1, 10, 1, 1, 1, 1),
(2, 'Sick Leave', 'SL', 'Paid sick leave', 10, 'yearly', 0, NULL, 0, 1, 1, 1),
(3, 'Unpaid Leave', 'UL', 'Leave without pay', 0, 'none', 0, NULL, 1, 0, 1, 1);


-- Source: demoData/leave_requests.sql
INSERT INTO leave_requests (id, employeeName, leaveType, startDate, endDate, reason, status, createdBy, approvedAt, approvedBy) VALUES
(1, 'Alice Johnson', 'Annual Leave', '2025-07-01', '2025-07-10', 'Vacation', 'Approved', 1, '2025-06-15', 1),
(2, 'Bob Smith', 'Sick Leave', '2025-06-02', '2025-06-05', 'Flu', 'Approved', 1, '2025-06-01', 1);


-- Source: demoData/GL_Journal_Entries.sql
INSERT INTO GL_Journal_Entries (id, reference, memo, timestamp, created_by, company_id) VALUES
(1, 'INV-1001', 'Initial capital', '2025-05-01 09:00:00', 1, 1);


-- Source: demoData/tax_settings.sql
INSERT INTO tax_settings (id, name, value) VALUES
(1, 'federal_tax_rate', '10'),
(2, 'state_tax_rate', '5');


-- Source: demoData/tax_brackets.sql
INSERT INTO tax_brackets (id, min_income, max_income, rate) VALUES
(1, 0.00, 20000.00, 10.00),
(2, 20000.01, 50000.00, 20.00),
(3, 50000.01, NULL, 30.00);


-- Source: demoData/procurement_requests.sql
INSERT INTO procurement_requests (id, description, justification, estimated_cost, quantity, preferred_vendor, needed_by, status, requester_id, updatedAt) VALUES
(1, 'Office Chairs', 'Replace old chairs', 1200.00, 10, 'Fiji Furniture', '2025-07-01', 'Pending', 1, NOW());


-- Source: demoData/purchase_requests.sql
INSERT INTO purchase_requests (id, description, justification, estimated_cost, quantity, preferred_vendor, needed_by, updatedAt, created_by) VALUES
(1, 'Laptop', 'New hire equipment', 1500.00, 1, 'Computer World', '2025-06-15', NOW(), 1);


-- Source: demoData/vendors.sql
INSERT INTO vendors (id, vendorName, tradingName, businessRegNumber, tin, vatNumber, businessType, incorporationDate, registrationCountry, status, created_by, updated_by) VALUES
(1, 'Fiji Stationers Ltd', 'Fiji Stationers', 'BRN12345', 'TIN54321', 'VAT11111', 'LLC', '2010-03-15', 'Fiji', 'approved', 1, 1),
(2, 'Island Tech Solutions', 'IslandTech', 'BRN67890', 'TIN98765', 'VAT22222', 'Ltd', '2015-07-20', 'Fiji', 'pending', 1, 1),
(3, 'Pacific Catering Co', 'PacCater', 'BRN23456', 'TIN12321', 'VAT33333', 'Ltd', '2012-11-10', 'Fiji', 'approved', 1, 1);


-- Source: demoData/vendor_addresses.sql
INSERT INTO vendor_addresses (id, vendor_id, type, address) VALUES
(1, 1, 'office', '123 Main St, Suva'),
(2, 2, 'office', '456 Tech Park, Nadi'),
(3, 3, 'office', '789 Catering Rd, Lautoka');


-- Source: demoData/vendor_bank_accounts.sql
INSERT INTO vendor_bank_accounts (id, vendor_id, bankName, bankBranch, accountName, accountNumber, bankCode, bankAddress) VALUES
(1, 1, 'Bank of Fiji', 'Suva', 'Fiji Stationers Ltd', '123456789', 'BOF001', '1 Bank St, Suva'),
(2, 2, 'Fiji Bank', 'Nadi', 'Island Tech Solutions', '987654321', 'FJB002', '2 Bank St, Nadi'),
(3, 3, 'Bank of Pacific', 'Lautoka', 'Pacific Catering Co', '555666777', 'BOP003', '3 Bank St, Lautoka');


-- Source: demoData/vendor_capabilities.sql
INSERT INTO vendor_capabilities (id, vendor_id, goodsServices, categoryTags, pastClients, experienceYears, certifications, capacity) VALUES
(1, 1, 'Office Supplies', 'stationery', 'Gov Dept', 15, 'ISO9001', 'High volume'),
(2, 2, 'IT Services', 'software,hardware', 'Various clients', 10, 'Cisco', 'Medium'),
(3, 3, 'Catering Services', 'food', 'Hotels', 8, 'FoodSafe', 'Large events');


-- Source: demoData/vendor_contacts.sql
INSERT INTO vendor_contacts (id, vendor_id, primaryContactName, designation, email, phone) VALUES
(1, 1, 'John Vendor', 'Manager', 'contact@fijistationers.com', '+679-100-200'),
(2, 2, 'Jane Tech', 'Director', 'info@islandtech.com', '+679-200-300'),
(3, 3, 'Paul Cater', 'Owner', 'service@paccater.com', '+679-300-400');


-- Source: demoData/vendor_documents.sql
INSERT INTO vendor_documents (id, vendor_id, filetype, type, file_url, validity) VALUES
(1, 1, 'pdf', 'business_license', '/docs/vendors/license1.pdf', '2026-12-31'),
(2, 2, 'pdf', 'business_license', '/docs/vendors/license2.pdf', '2027-05-31'),
(3, 3, 'pdf', 'business_license', '/docs/vendors/license3.pdf', '2027-10-31');


-- Source: demoData/vendor_supporting_docs.sql
INSERT INTO vendor_supporting_docs (id, vendor_id, filetype, type, file_url, validity) VALUES
(1, 1, 'pdf', 'insurance_certificate', '/docs/vendors/insurance1.pdf', '2025-12-31'),
(2, 2, 'pdf', 'insurance_certificate', '/docs/vendors/insurance2.pdf', '2026-12-31'),
(3, 3, 'pdf', 'insurance_certificate', '/docs/vendors/insurance3.pdf', '2026-12-31');


-- Source: demoData/user_auth_providers.sql
INSERT INTO user_auth_providers (id, user_id, provider, provider_user_id, email, name, linked_at) VALUES
(1, 1, 'google', 'google-uid-1', 'admin@example.com', 'Test Admin', NOW());


-- Source: demoData/user_2fa.sql
INSERT INTO user_2fa (id, user_id, secret) VALUES
(1, 1, 'SECRET1');


-- Source: demoData/user_passkeys.sql
INSERT INTO user_passkeys (id, user_id, credential_id, public_key, updatedAt) VALUES
(1, 1, 'cred1', 'publickeydata', NOW());


-- Source: demoData/user_phones.sql
INSERT INTO user_phones (id, user_id, phone_number) VALUES
(1, 1, '+1-555-2001'),
(2, 2, '+1-555-2002');


-- Source: demoData/assessment_numbers.sql
INSERT INTO assessment_numbers (id, user_id, number) VALUES
(1, 1, 'A100'),
(2, 2, 'A101');


-- Source: demoData/disciplinary_module.sql
INSERT INTO violation_types (id, name, handbook_ref, updatedAt) VALUES
(1, 'Attendance Violation', 'Section 5.2', NOW()),
(2, 'Code of Conduct', 'Section 3.1', NOW());

INSERT INTO disciplinary_cases (id, employee_id, violation_id, severity, summary, status, assigned_to, updatedAt) VALUES
(1, 2, 1, 'minor', 'Late arrival on 2025-05-01', 'open', 1, NOW());

INSERT INTO case_evidence (id, case_id, file_path, description) VALUES
(1, 1, '/evidence/late1.jpg', 'Time clock screenshot');

INSERT INTO interview_logs (id, case_id, person, notes, logged_at) VALUES
(1, 1, 'Bob Smith', 'Employee admitted being late due to traffic', NOW());

INSERT INTO disciplinary_actions (id, case_id, action, effective_date, approved_by, updatedAt) VALUES
(1, 1, 'Written warning', '2025-06-01', 1, NOW());

INSERT INTO appeals (id, case_id, employee_id, reason, status, updatedAt) VALUES
(1, 1, 2, 'Disputes severity', 'submitted', NOW());

-- Sample data for general ledger
INSERT INTO gl_accounts (id, code, name, type, tags, is_active, parent_id, updatedAt) VALUES
  (1, '1000', 'Cash', 'asset', 'bank', 1, NULL, NOW()),
  (2, '2000', 'Accounts Payable', 'liability', 'ap', 1, NULL, NOW()),
  (3, '4000', 'Sales Revenue', 'revenue', 'income', 1, NULL, NOW());

INSERT INTO GL_Journal_Entries (id, reference, memo, timestamp, created_by, company_id) VALUES
  (2, 'JE001', 'Opening balance', NOW(), 1, 1);

INSERT INTO gl_transactions (id, journal_entry_id, account_id, type, amount, currency, rate, timestamp, memo, reference) VALUES
  (1, 1, 1, 'debit', 1000.00, 'USD', 1.000000, NOW(), 'Opening cash', 'JE001-1'),
  (2, 1, 3, 'credit', 1000.00, 'USD', 1.000000, NOW(), 'Opening equity', 'JE001-2');

INSERT INTO bank_transactions (id, gl_transaction_id) VALUES (1, 1);
INSERT INTO ap_transactions (id, gl_transaction_id) VALUES (1, 2);
INSERT INTO ar_transactions (id, gl_transaction_id) VALUES (1, 2);
-- Source: demoData/payroll_attendance_demo.sql
-- Demo attendance records for five employees over two weeks
-- Source: demoData/tax_super_demo.sql
-- Superannuation contribution settings
INSERT INTO superannuation_settings (employee_rate, employer_rate)
VALUES (8.00, 10.00);

-- Demo deduction settings
INSERT INTO deduction_settings (name, start_salary, end_salary, base_amount, percent, company_contribution)
VALUES
  ('Union Fee', 0.00, 2000.00, 5.00, 1.00, 1.00),
  ('Union Fee Tier 2', 2000.01, NULL, 10.00, 2.00, 1.50);

-- PAYE tax brackets for Fiji dollars
DELETE FROM tax_brackets;
INSERT INTO tax_brackets (min_income, max_income, rate) VALUES
  (0.00, 30000.00, 0.00),
  (30000.01, 50000.00, 18.00),
  (50000.01, 270000.00, 20.00),
  (270000.01, 300000.00, 33.00);
-- Source: demoData/payroll_run_demo.sql
-- Payroll period covering the demo attendance
INSERT INTO payroll_periods (pay_cycle_id, period_start, period_end)
VALUES (2, '2025-06-09', '2025-06-20');
SET @period_id = LAST_INSERT_ID();

INSERT INTO payroll_runs (payroll_period_id, run_date, status)
VALUES (@period_id, '2025-06-21', 'completed');
SET @run_id = LAST_INSERT_ID();

-- Payslips for five employees
INSERT INTO payslips (payroll_run_id, employee_id, gross_pay, net_pay) VALUES (@run_id, 1, 2307.69, 1907.69);
SET @slip_id = LAST_INSERT_ID();
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Base Salary', 2307.69, 'earning');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employee Superannuation', 184.62, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'PAYE', 215.38, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employer Superannuation', 230.77, 'earning');
INSERT INTO payslips (payroll_run_id, employee_id, gross_pay, net_pay) VALUES (@run_id, 2, 3076.92, 2461.54);
SET @slip_id = LAST_INSERT_ID();
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Base Salary', 3076.92, 'earning');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employee Superannuation', 246.15, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'PAYE', 369.23, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employer Superannuation', 307.69, 'earning');
INSERT INTO payslips (payroll_run_id, employee_id, gross_pay, net_pay) VALUES (@run_id, 3, 1923.08, 1630.77);
SET @slip_id = LAST_INSERT_ID();
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Base Salary', 1923.08, 'earning');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employee Superannuation', 153.85, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'PAYE', 138.46, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employer Superannuation', 192.31, 'earning');
INSERT INTO payslips (payroll_run_id, employee_id, gross_pay, net_pay) VALUES (@run_id, 4, 2884.62, 2323.08);
SET @slip_id = LAST_INSERT_ID();
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Base Salary', 2884.62, 'earning');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employee Superannuation', 230.77, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'PAYE', 330.77, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employer Superannuation', 288.46, 'earning');
INSERT INTO payslips (payroll_run_id, employee_id, gross_pay, net_pay) VALUES (@run_id, 5, 1730.77, 1488.46);
SET @slip_id = LAST_INSERT_ID();
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Base Salary', 1730.77, 'earning');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employee Superannuation', 138.46, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'PAYE', 103.85, 'deduction');
INSERT INTO payslip_lines (payslip_id, description, amount, line_type) VALUES (@slip_id, 'Employer Superannuation', 173.08, 'earning');



-- Create employee records for existing users
INSERT INTO employees (id, name, department, email, phone, title, salary, updatedAt, createdBy, pay_cycle_id, manager_id, company_id) VALUES
  (17, 'Test Admin', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (18, 'Test User', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (19, 'Nadi Location Officer', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (20, 'Suva Location Officer', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (21, 'Lab Location Officer', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (22, 'Admin Location Officer', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (23, 'HR Manager', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (24, 'Payroll Manager', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (25, 'Accounting Clerk', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (26, 'Building Inspector', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1),
  (27, 'Health Inspector', NULL, NULL, NULL, NULL, 30000, NOW(), 1, 1, NULL, 1);

-- Map employees to their user accounts
INSERT INTO employees2users (employee_id, user_id) VALUES
  (1, 12),
  (2, 13),
  (3, 14),
  (4, 15),
  (5, 16),
  (17, 1),
  (18, 2),
  (19, 3),
  (20, 4),
  (21, 5),
  (22, 6),
  (23, 7),
  (24, 8),
  (25, 9),
  (26, 10),
  (27, 11);


-- Source: sql/20251001_country_company.sql

INSERT INTO companies (id, country_id, name, updatedAt) VALUES
  (1, 1, 'Fiji Holdings', NOW()),
  (2, 2, 'Acme Corp', NOW()),
  (3, 3, 'Aussie Pty Ltd', NOW());

-- Source: sql/20251201_country_holidays.sql
-- Country holidays table and Fiji 2025 holidays
-- Demo countries and companies
INSERT INTO countries (id, name, updatedAt) VALUES
  (1, 'Fiji', NOW()),
  (2, 'United States', NOW()),
  (3, 'Australia', NOW());

-- Fiji national holidays for 2025
INSERT INTO country_holidays (country_id, holiday_name, holiday_date) VALUES
  (1, 'New Year''s Day', '2025-01-01'),
  (1, 'Good Friday', '2025-04-18'),
  (1, 'Easter Saturday', '2025-04-19'),
  (1, 'Easter Monday', '2025-04-21'),
  (1, 'Girmit Day', '2025-05-12'),
  (1, 'Ratu Sir Lala Sukuna Day', '2025-05-30'),
  (1, 'Prophet Mohammed''s Birthday', '2025-09-08'),
  (1, 'Fiji Day', '2025-10-10'),
  (1, 'Diwali', '2025-10-21'),
  (1, 'Christmas Day', '2025-12-25'),
  (1, 'Boxing Day', '2025-12-26');
 

-- Overtime remuneration rules
INSERT INTO overtime_rules
    (scope,country_id,shift_hours,first4_rate,after4_rate,holiday_rate,
     sixth_day_rate,seventh_day_rate)
VALUES
    ('country',1,9,1.5,2.0,2.0,2.0,2.0),
    ('country',1,8,1.5,2.0,2.0,2.0,2.0),
    ('country',2,8,1.5,2.0,2.0,2.0,2.0),
    ('country',3,8,1.5,2.0,2.0,2.0,2.0);
-- Sample test users
-- Copy or rename this file to test_users.sql and edit as needed
-- testadmin and testuser are the default passwords respectively
INSERT INTO users (id, full_name, password, locations) VALUES
(1, 'Test Admin', '$2y$10$PXEdpEbxI5c11/tC3UdC6OrZr7V2MsHAatf5C6LRzRV/goxQDPTl.', NULL),
(2, 'Fiji Rice Test Account', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', NULL),
(3, 'BAF Test Account', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', 'Nadi Office'),
(4, 'Alvin Test Account', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS.', 'Suva Headquarters'),
(5, 'Krishant Test Account', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', 'Lab'),
(6, 'Jagath Test Account', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', NULL);

-- Associate login emails with the sample users
INSERT INTO user_emails (id, user_id, email) VALUES
(1, 1, 'admin@example.com'),
(2, 2, 'fijirice@cybexpte.com'),
(3, 3, 'baf@cybexpte.com'),
(4, 4, 'alvinkirpal@cybexpte.com'),
(5, 5, 'krishant@cybexpte.com'),
(6, 6, 'jagathka@gmail.com'),
(7, 7, 'demo@cybexpte.com'),
(8, 8, 'ksharma@baf.com.fj'),
(9, 9, 'pmeke@baf.com.fj'),
(10, 10, 'mvakadromusiga@baf.com.fj'),
(11, 11, 'mohammed.istikar@baf.com.fj');

INSERT INTO users (id, full_name, password, locations) VALUES
(8, 'Demo Account', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', 'Suva Headquarters'),
(8, 'Kritesh Sharma', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', 'Suva Headquarters'),
(8, 'Panapasa Meke', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', 'Suva Headquarters'),
(10, 'Mereani Vakadromusiga', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', 'Nadi Office'),
(11, 'Mohammed Istikar', '$2y$10$fofsRVhEGSSK7YENW/iE6ep1FLEJ2vy4LoyTYwbAQj0oKtGTGCROS', 'Nadi Office');


INSERT INTO time_clocks (user_id, clock_type, lat, lng, security_type, clocked_at) VALUES
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:19:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:18:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-12 16:56:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:13:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:25:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:21:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:10:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:17:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:24:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:14:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:25:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:20:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:06:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:23:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:11:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:11:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:09:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:04:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:09:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:19:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:08:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:14:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:13:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:22:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:17:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:24:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:23:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:09:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:04:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:08:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:18:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:07:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:15:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:10:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:22:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-13 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:16:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:08:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:15:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:14:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:25:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:11:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:25:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:10:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:19:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:22:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:21:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:03:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:06:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:20:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:22:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:24:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:05:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-14 16:57:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:17:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:25:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-15 16:55:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:24:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:10:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:15:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:02:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:15:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:17:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:07:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:01:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:23:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:02:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:12:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:20:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:09:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:20:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:22:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:09:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:07:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-16 16:57:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:15:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:23:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:21:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:20:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-16 16:58:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:14:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:12:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:14:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:17:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:08:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:12:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:15:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:22:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:01:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:24:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:12:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:04:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:19:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-19 16:57:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:24:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:20:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:17:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:05:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:23:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:02:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:14:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:00:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:11:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:21:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:10:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-19 16:56:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:16:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:13:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:10:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:07:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-20 16:57:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:09:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:23:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:09:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:06:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:21:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:07:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:23:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:22:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:16:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:17:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:21:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:21:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:03:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:21:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:20:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:12:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:22:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:11:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:23:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:23:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:21:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:18:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:13:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:13:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:09:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:20:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:16:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:25:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:17:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:16:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-21 16:57:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:15:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:14:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:10:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:23:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:15:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:15:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:22:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:11:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:02:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:05:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:18:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:13:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-22 16:58:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:06:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:10:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:05:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:18:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:21:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:06:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-22 16:58:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:09:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:22:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:12:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-22 16:56:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:15:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:22:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:14:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:07:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-23 16:55:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:08:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:15:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:11:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:14:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:23:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-23 16:58:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:17:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-23 16:57:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:16:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-23 16:56:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:24:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-23 16:55:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:25:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:16:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:26:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:10:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:12:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:18:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:18:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:05:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:18:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:14:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:07:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:15:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-01 16:57:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:07:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:13:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:20:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:19:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:23:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:18:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:24:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:07:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:12:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:00:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:09:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:04:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:07:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:15:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:07:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:16:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:20:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:19:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:15:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:15:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:06:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:13:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:19:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:00:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:15:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:04:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:09:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:05:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:24:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:21:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:20:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:08:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:09:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:09:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:09:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:03:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:27:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:16:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:28:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-02 16:56:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-02 16:58:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:23:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:04:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:17:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:29:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:17:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:22:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:16:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:05:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:14:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:05:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:23:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-03 16:59:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:11:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:07:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:06:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:06:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-03 16:58:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:28:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:13:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:07:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-03 16:58:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:18:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:08:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:11:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:02:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:26:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:17:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:23:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:18:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:01:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:12:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:04:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-03 16:58:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:15:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:01:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:24:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:12:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:12:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:14:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-04 16:57:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:12:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:21:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:23:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:14:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:26:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:11:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:06:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:21:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:14:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:18:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:10:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:16:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:23:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:30:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:02:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:07:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:13:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:12:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:22:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-04 16:57:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:23:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:28:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:00:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:11:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:18:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:07:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:08:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:14:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:27:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-04 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:13:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:21:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:09:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:11:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-07 16:58:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:18:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:25:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:27:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:23:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:16:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:08:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:12:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:13:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:07:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-07 16:56:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:12:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:27:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-07 16:59:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:20:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-07 16:57:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:28:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:23:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:08:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:05:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:25:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:10:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:12:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-07 16:57:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:16:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:22:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:10:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:13:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:11:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:13:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:18:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:19:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:22:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:18:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:13:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:09:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:06:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:29:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:00:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:30:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:21:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:17:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-08 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:30:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:06:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:10:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:26:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-08 16:58:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:17:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:13:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:14:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:09:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-08 16:56:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:21:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:12:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:13:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-08 16:56:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:22:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:21:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:18:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:02:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:16:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:08:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:16:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:30:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:19:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:03:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:22:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:22:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:20:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:07:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:15:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:26:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:14:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:10:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:08:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-09 16:59:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:22:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:06:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:15:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:28:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-09 16:56:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:26:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-09 16:57:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:24:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:19:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:25:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:05:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:10:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:06:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:09:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:25:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:16:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:13:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:26:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-10 16:57:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:20:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:24:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:09:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:16:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:10:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:17:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:13:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:23:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:23:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:13:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:17:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:17:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:20:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:10:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:06:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:02:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:14:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:10:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:13:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:22:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:17:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:25:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:14:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:25:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:15:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:14:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:13:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:00:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:23:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:20:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:28:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:23:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-11 16:59:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:17:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:21:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:21:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:21:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:09:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:22:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:29:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:02:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:16:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:20:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:12:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:19:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:02:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-11 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:18:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:10:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:20:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:28:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:09:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-11 16:59:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:21:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-11 16:55:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-11 16:58:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-11 16:57:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:22:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:14:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:14:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:18:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:19:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:09:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:10:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:05:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:25:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:02:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:12:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:19:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:22:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:03:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:00:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:29:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:13:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:25:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:21:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:15:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:09:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:22:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:28:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:15:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:24:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-14 16:58:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:06:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:25:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:17:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:16:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-14 16:55:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:10:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:26:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:08:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:26:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:20:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:05:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:07:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:13:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:16:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:29:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:08:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:25:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:17:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:30:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:05:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-15 16:57:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:13:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:08:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:06:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:25:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:20:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:06:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:18:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:24:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:02:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:29:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-15 16:55:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:24:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:22:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:07:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:20:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:06:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:09:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:29:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:02:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:28:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:16:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:15:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:06:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-16 16:55:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-16 16:59:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:10:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-16 16:58:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:07:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:29:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:09:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:14:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:12:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:13:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-16 16:59:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:11:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:14:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:09:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:19:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:22:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-16 16:58:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:06:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:07:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:30:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:02:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:06:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:30:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:23:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:09:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:16:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:18:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:22:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:04:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:08:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:11:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:24:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:20:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:28:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:15:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:22:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:05:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:06:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:08:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:23:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:02:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:21:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:09:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:05:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:07:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:20:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:14:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:06:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:01:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:28:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-17 16:59:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:20:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:22:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:18:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:04:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:10:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:14:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:18:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:25:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:21:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:28:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:13:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:06:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:17:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:22:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-17 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:09:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:24:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:05:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:17:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:24:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-18 16:56:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:08:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:17:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:07:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:23:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-18 17:05:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:21:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:07:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:17:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:10:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:07:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-18 16:57:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:20:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-18 16:55:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:21:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-18 16:59:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:09:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-18 17:18:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:20:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:18:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:24:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:07:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:27:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-18 16:57:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:07:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:11:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:11:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:21:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:14:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-18 17:25:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:14:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:16:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:25:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:05:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:09:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:16:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:24:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:18:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:04:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:21:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:23:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:21:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:26:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-21 16:55:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:14:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:10:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:27:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:15:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:26:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:14:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:01:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:26:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:14:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:28:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:11:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:10:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-21 16:59:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:08:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:02:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:14:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:25:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:18:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:13:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:21:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-21 16:58:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:29:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:10:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:29:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:01:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:30:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:21:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:11:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:22:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:12:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:00:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:22:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:11:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:19:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:08:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:19:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-22 16:56:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:19:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:15:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:06:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:25:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-22 16:58:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:18:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:22:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:09:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:06:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-22 16:55:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:11:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:07:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:18:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-22 16:55:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:11:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:25:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:17:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:27:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:08:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:30:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:10:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:15:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:08:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:08:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:18:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:13:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:19:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:09:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:16:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:17:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:16:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:28:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:28:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:03:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:18:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:05:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:09:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:01:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:17:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-23 16:55:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:09:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:07:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:25:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:05:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:09:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:20:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:05:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:01:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:21:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-23 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:16:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:06:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:11:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:08:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:03:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:08:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:24:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:20:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:05:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:19:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:14:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:25:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:22:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:23:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:19:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:12:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:26:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:11:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:30:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:00:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:27:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-24 16:55:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:15:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:11:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:20:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:06:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:22:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:20:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:18:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:22:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:24:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:21:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-24 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:14:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-24 16:56:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:24:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:13:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:08:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:25:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:23:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:21:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:20:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:13:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:06:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:22:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:29:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:05:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:27:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-25 16:55:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:20:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:19:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:23:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:20:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:14:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:26:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-25 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:22:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:12:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:26:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:02:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:13:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:19:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:06:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:07:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:16:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:29:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:00:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:20:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:12:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:05:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:22:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:14:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:24:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:16:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:21:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-28 16:59:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:23:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:24:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:12:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:09:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:29:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:07:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:11:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:01:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:16:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:05:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:21:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-28 16:56:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-28 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:23:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-28 16:57:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:28:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:08:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:19:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:30:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:05:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:05:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-28 16:58:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:05:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:02:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:12:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:00:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:10:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:25:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-29 16:57:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:10:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:15:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:19:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:14:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-29 16:56:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:19:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:08:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:23:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:07:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:06:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:15:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:18:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:04:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:09:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:23:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:19:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:01:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:19:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:08:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:06:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:14:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:06:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:19:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:13:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:21:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:11:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:18:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:19:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-30 16:58:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:21:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:24:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:10:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:26:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-30 16:55:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:13:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:00:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:22:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:05:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:20:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:24:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:25:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:13:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:11:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:03:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:20:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:17:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:24:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:10:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:12:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:19:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:12:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:05:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:23:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:04:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:21:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:23:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:25:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:01:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:08:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:22:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:13:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:09:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:29:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:21:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-01 16:55:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:17:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:22:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:14:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:18:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-01 16:55:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:10:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:09:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:10:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:22:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:05:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:20:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:04:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:19:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:22:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:05:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:08:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:05:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:22:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:13:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:13:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:25:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:18:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:20:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:14:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:13:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:01:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:28:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:24:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:17:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:10:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:18:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:21:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:24:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:06:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:06:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:01:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:15:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:14:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:16:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:01:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:07:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:25:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:29:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:20:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:30:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:20:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:16:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:14:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:05:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:04:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:09:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-02 16:59:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:24:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:22:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:17:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:03:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:09:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:23:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:21:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-02 16:56:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:16:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-02 16:59:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:20:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:27:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:19:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:23:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-02 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:22:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:20:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:09:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:09:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:08:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:23:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:25:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:06:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:20:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:09:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:20:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:30:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-05 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:06:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-05 16:59:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:18:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:19:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:11:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:15:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:28:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:06:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:25:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:02:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:24:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:18:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:08:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:16:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:07:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:25:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:19:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:14:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:11:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:08:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:29:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:04:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:10:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:07:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:13:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:02:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:07:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:15:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:11:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:20:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:18:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:01:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:10:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:13:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:28:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:04:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:27:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:20:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-06 16:57:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:25:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:11:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:04:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:23:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:00:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:24:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:05:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:24:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:18:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:11:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-06 16:56:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:20:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:15:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:08:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:04:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:14:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:14:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:13:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-07 16:55:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:29:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:04:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:29:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:05:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:14:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:19:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:12:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:07:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:05:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:12:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:05:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:06:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:01:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:11:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:17:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:13:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:25:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:27:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:00:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:13:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:24:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:07:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:02:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:20:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:20:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:18:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:23:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:28:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:18:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:12:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-07 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:19:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:23:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:19:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:14:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:09:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:07:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:27:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:00:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:09:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:18:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:27:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:14:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:12:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:24:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:19:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:14:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:06:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:07:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:25:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:29:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-08 16:57:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:26:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:12:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:29:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-08 16:57:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:08:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:17:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:09:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:02:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:06:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:15:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:28:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:01:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:09:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-09 16:58:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:23:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:11:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:19:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:17:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:18:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:12:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:13:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:10:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:12:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:17:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:10:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:25:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:06:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:25:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:08:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:00:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:26:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:22:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:10:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-09 16:55:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:06:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:13:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:29:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:22:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:10:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:06:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:06:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:13:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-12 16:57:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:24:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:00:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:07:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:18:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:19:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:29:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-12 16:58:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:24:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:25:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:05:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:15:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:11:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:21:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-12 16:58:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-12 16:56:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:29:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:25:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:23:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:12:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:10:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:25:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:11:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:13:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:09:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:25:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:15:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:21:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:18:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:19:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:10:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:27:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:00:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:13:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:13:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:19:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:14:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:27:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:12:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:26:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:14:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:28:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:03:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:05:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:13:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:16:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:27:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:04:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:12:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:11:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:18:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:22:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-13 16:59:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:09:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:13:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:06:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:21:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:12:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:25:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:24:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:28:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-13 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:06:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:24:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:23:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:02:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:29:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:11:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:06:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:03:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:21:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:06:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:08:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:11:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:23:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:03:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:30:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:18:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:26:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:08:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:12:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-14 16:57:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:21:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-14 16:56:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:09:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:07:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:08:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:10:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:04:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:27:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:14:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:08:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:28:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:09:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:18:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:13:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:20:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:09:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:27:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:23:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:27:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-15 16:56:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-15 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:28:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:06:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:25:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:13:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:10:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:07:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:17:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:28:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:23:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:25:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:13:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-15 16:58:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:13:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:08:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:05:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:18:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-15 16:56:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:21:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:09:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:20:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:03:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:15:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:04:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:25:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-15 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:23:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-15 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:11:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:19:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:05:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:22:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:21:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:25:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:21:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:29:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:14:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:18:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:15:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-16 16:58:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:09:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:15:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:23:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:22:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:06:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:10:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:07:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:13:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:05:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:12:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:10:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:26:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:15:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:30:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:19:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:24:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:27:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:20:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:06:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-16 16:55:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:28:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:00:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:07:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:12:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:19:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:11:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:17:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:05:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:00:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:09:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:12:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:27:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:24:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:28:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:07:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:27:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:25:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:14:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:21:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:12:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:21:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:03:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:22:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:18:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:26:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:12:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:09:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:17:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:22:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:03:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:12:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-19 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:10:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:19:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:22:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:16:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:24:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:12:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:22:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:25:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:18:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:03:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:18:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:03:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:06:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:25:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:12:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:20:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:28:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:18:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:26:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-20 16:56:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:10:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:14:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:17:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:21:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:15:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:22:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:19:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:05:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:20:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:14:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-20 16:55:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:20:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:03:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:14:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:22:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-20 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:15:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:01:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:30:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:19:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:22:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:09:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:02:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:00:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:01:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:24:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:08:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:02:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:14:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-21 16:58:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:17:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:16:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:11:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:09:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:12:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:10:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-21 16:58:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:13:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:22:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:24:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:09:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:12:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:04:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:24:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:13:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:01:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:10:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:11:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:19:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:01:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:08:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:13:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:25:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:17:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:02:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:07:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:00:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:27:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:04:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:09:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-22 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:12:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:04:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:11:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:15:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:30:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-22 16:57:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:08:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-22 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:10:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-22 16:56:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:24:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:24:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:06:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:13:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:11:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:13:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:24:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:26:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:07:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:15:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:22:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:06:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:07:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:19:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:04:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:27:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:06:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:25:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:15:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-23 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:07:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:21:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:14:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:19:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:21:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:12:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:21:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:11:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:29:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:17:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:17:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:00:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:03:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:03:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:19:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:26:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:23:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:30:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:25:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:06:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:02:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:24:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:24:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:12:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:25:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:17:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:18:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:13:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:15:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:01:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:11:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:11:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:15:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-26 16:56:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:20:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:12:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:11:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:23:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:15:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:29:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:24:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-26 16:56:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:27:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:12:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-26 16:58:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:07:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:22:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:18:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:14:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:19:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:17:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:19:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-26 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:20:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:17:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:27:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:03:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:10:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-27 16:59:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:07:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:20:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:28:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-27 16:59:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-27 16:57:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:21:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:18:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:15:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:06:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:04:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:30:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:11:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:07:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:02:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:13:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-27 16:59:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:08:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-27 16:57:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:06:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:05:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:23:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:14:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:16:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:18:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:02:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:05:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:27:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:06:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:13:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:23:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:16:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:04:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:15:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:01:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:24:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:22:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:08:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:17:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:26:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-28 16:58:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:30:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:11:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:18:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:24:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:23:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:21:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:16:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:11:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:10:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:05:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:24:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:14:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:20:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:29:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:10:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:00:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:30:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-28 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-29 16:56:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:06:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:09:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:29:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:06:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:25:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-29 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:06:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:23:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:13:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:03:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:21:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:00:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:29:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-29 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:01:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:05:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:22:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:30:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:13:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:26:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:08:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:08:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:21:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:17:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:10:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:18:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:18:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:21:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:27:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:19:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:05:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:07:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:11:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:07:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:11:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:14:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:00:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:29:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:08:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:19:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-30 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-30 16:59:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-30 16:57:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:11:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:25:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:21:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:17:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:29:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:25:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:17:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:12:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:19:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:05:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:23:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:20:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:06:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:19:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:19:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-30 16:59:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:28:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-30 16:58:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:22:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:08:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:11:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:10:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:02:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:15:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:04:00');
