-- ITX Client Meeting Scheduling System
-- Database Schema
-- Created: 21-Jan-2026

CREATE DATABASE IF NOT EXISTS itx;
USE itx;

-- =========================
-- Table: bookings
-- =========================
CREATE TABLE IF NOT EXISTS bookings (
    booking_id INT AUTO_INCREMENT PRIMARY KEY,

    full_name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    contact_number VARCHAR(50) NOT NULL,

    meeting_date DATE NOT NULL,
    time_slot VARCHAR(20) NOT NULL,

    message TEXT NULL,

    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

);