init.sql

CREATE TABLE IF NOT EXISTS volunteers (
    volunteer_id UUID PRIMARY KEY,
    first_name VARCHAR(100) NOT NULL,
    last_name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    phone_number VARCHAR(20),
    date_of_birth DATE,
    address VARCHAR(255),
    skills TEXT[],
    availability JSON,
    date_joined DATE NOT NULL DEFAULT CURRENT_DATE,
    background_check BOOLEAN DEFAULT FALSE
);

INSERT INTO volunteers (volunteer_id, first_name, last_name, email, phone_number, date_of_birth, address, skills, availability, background_check)
VALUES
    ('123e4567-e89b-12d3-a456-426614174000', 'John', 'Doe', 'john.doe@example.com', '+1234567890', '1990-01-01', '123 Main St, Anytown, AS', '{"First Aid", "Counseling"}', '{"Monday": ["AM"], "Saturday": ["PM"]}', TRUE),
    ('223e4567-e89b-12d3-a456-426614174001', 'Jane', 'Smith', 'jane.smith@example.com', '+1987654321', '1985-05-10', '456 Elm St, Othertown, BS', '{"CPR", "Teaching"}', '{"Wednesday": ["AM"], "Sunday": ["PM"]}', TRUE),
    ('323e4567-e89b-12d3-a456-426614174002', 'Michael', 'Johnson', 'michael.j@example.com', '+1987654331', '1992-11-15', '789 Oak St, Newcity, CS', '{"Driving", "Organizing"}', '{"Friday": ["PM"]}', FALSE);