CREATE TABLE IF NOT EXISTS employees (
    id INTEGER PRIMARY KEY,
    name TEXT,
    role TEXT
);

INSERT INTO employees (id, name, role) VALUES
(1216677108, 'Alex Mercer', 'Technician'),
(1079892584, 'Helena Efrem', 'Maintenance Lead'),
(3565267609, 'Rolf Ivo', 'Senior Technician'),
(824890700, 'Yann Vancho', 'Remote Operations'),
(436398055, 'Marina Anjana', 'Communications');

CREATE TABLE IF NOT EXISTS configuration_changes (
    id INTEGER PRIMARY KEY,
    timestamp DATETIME,
    device_id INTEGER,
    user_id INTEGER,
    field TEXT,
    value TEXT
);

INSERT INTO configuration_changes (id, timestamp, device_id, user_id, field, value) VALUES
(245, '2216-01-05 09:42:17', 2921422183, 1079892584, 'device_id', '0xae215d67'),
(246, '2216-01-05 09:42:27', 2921422183, 1079892584, 'inside_door_id', '0xae215e12'),
(247, '2216-01-05 09:42:37', 2921422183, 1079892584, 'outside_door_id', '0xae215e13'),
(248, '2216-01-05 09:42:47', 2921422183, 1079892584, 'pressure_ctrl_id', '0xae215e14'),
(249, '2216-01-05 09:42:57', 2921422183, 1079892584, 'occupancy_sensor_id', '0xae215e15'),
(250, '2216-01-05 09:43:07', 2921422183, 1079892584, 'suit_locker_id', '0xae215e16'),
(251, '2216-01-05 09:43:17', 2921422183, 1079892584, 'rx_message_buffer_size', '10240'),
(252, '2216-01-05 09:43:27', 2921422183, 1079892584, 'apply_config_change', '0'),
(253, '2216-01-05 09:43:37', 2921422183, 1079892584, 'remote_fault_clear', '0'),
(254, '2216-03-05 19:26:27', 2921422183, 436398055, 'apply_config_change', '1'),
(255, '2216-03-05 19:26:37', 2921422183, 436398055, 'remote_fault_clear', '1'),
(256, '2216-04-15 11:38:23', 2921422183, 1079892584, 'rx_message_buffer_size', '256');

CREATE TABLE IF NOT EXISTS access_authentication (
    id INTEGER PRIMARY KEY,
    timestamp DATETIME,
    device_id INTEGER,
    user_id INTEGER,
    command TEXT
);

INSERT INTO access_authentication (id, timestamp, device_id, user_id, command) VALUES
(17, '2216-05-03 14:49:09', 2921422183, 824890700, 'SDN_MSG_TYPE_DEBUG_WRITE_CONFIG_INT'),
(18, '2216-05-03 14:49:10', 2921422183, 824890700, 'CLEAR_FAULTS'),
(19, '2216-05-10 12:25:19', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(20, '2216-05-10 12:25:23', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_SUIT_OCCUPANT'),
(21, '2216-05-10 12:26:33', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(22, '2216-05-10 12:35:43', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(23, '2216-05-10 12:35:47', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(24, '2216-05-10 12:35:51', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(25, '2216-05-11 14:59:58', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(26, '2216-05-11 15:00:06', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(27, '2216-05-11 15:00:10', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_SUIT_OCCUPANT'),
(28, '2216-05-11 15:01:20', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(29, '2216-05-11 15:15:30', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(30, '2216-05-11 15:15:34', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(31, '2216-05-11 15:15:38', 2921422183, 3565267609, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(32, '2216-05-14 10:27:52', 2921422183, 436398055, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(33, '2216-05-14 10:28:00', 2921422183, 436398055, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(34, '2216-05-14 10:28:04', 2921422183, 436398055, 'SDN_MSG_TYPE_SET_SUIT_OCCUPANT'),
(35, '2216-05-14 10:29:14', 2921422183, 436398055, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(36, '2216-05-14 10:43:24', 2921422183, 436398055, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(37, '2216-05-14 10:43:28', 2921422183, 436398055, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(38, '2216-05-14 10:43:32', 2921422183, 436398055, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(39, '2216-05-25 08:03:52', 2921422183, 1216677108, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(40, '2216-05-25 08:04:00', 2921422183, 1216677108, 'SDN_MSG_TYPE_SET_AIRLOCK_OPEN'),
(41, '2216-05-25 08:04:04', 2921422183, 1216677108, 'SDN_MSG_TYPE_SET_SUIT_OCCUPANT');