
-- Demo time clocks for new users (September 9-12, 2025)
INSERT INTO time_clocks (time_clocks_id, org_id, user_id, clock_type, location, valid_gps, location_id, locationApproved, security_type, clocked_at)
VALUES
  -- Kevin
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4450-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 17:00:00'),
  -- Bhaskaran
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4451-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 17:00:00'),
  -- Mishika
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4452-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 17:00:00'),
  -- Mahek
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4453-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 17:00:00'),
  -- Marshneel
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-09 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-10 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-11 17:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'in', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 09:00:00'),
  (uuid_generate_v7(), '0194a8b2-1234-7123-8123-123456789abc'::uuid, '0194a8b2-4454-7123-8123-123456789ac3'::uuid, 'out', ST_GeomFromText('POINT(178.42656254768372 -18.1397956843015)', 4326), TRUE, 1, TRUE, 'gps', '2025-09-12 17:00:00')
ON CONFLICT DO NOTHING;
