Bus Ticket Booking System

import sqlite3

def init_bus_db():
    with sqlite3.connect("bus.db") as conn:
        cursor = conn.cursor()
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS routes (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                origin TEXT NOT NULL,
                destination TEXT NOT NULL,
                fare REAL NOT NULL
            )
        """)
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS bookings (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                route_id INTEGER NOT NULL,
                seat_num INTEGER NOT NULL,
                passenger TEXT NOT NULL,
                FOREIGN KEY(route_id) REFERENCES routes(id),
                UNIQUE(route_id, seat_num)
            )
        """)
        conn.commit()