Hotel Reservation CLI Database

import sqlite3

def init_hotel_db():
    with sqlite3.connect("hotel.db") as conn:
        cursor = conn.cursor()
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS rooms (
                room_num TEXT PRIMARY KEY,
                category TEXT NOT NULL,
                rate_per_night REAL NOT NULL,
                status TEXT DEFAULT 'Available'
            )
        """)
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS bookings (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                guest_name TEXT NOT NULL,
                room_num TEXT NOT NULL,
                checkin_date TEXT NOT NULL,
                checkout_date TEXT,
                total_bill REAL DEFAULT 0.0,
                FOREIGN KEY(room_num) REFERENCES rooms(room_num)
            )
        """)
        conn.commit()