DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS holidays;

CREATE TABLE users (
	service_number INT PRIMARY KEY,
	first_name VARCHAR(255) COLLATE NOCASE,
	last_name VARCHAR(255) COLLATE NOCASE,
	pin CHAR(40)
);

CREATE INDEX idx_first_name ON users (first_name);
CREATE INDEX idx_last_name ON users (last_name);