import sqlite3

conn = sqlite3.connect('instance/swiftcart_cloud.db')
c = conn.cursor()

try:
    c.execute('''
        CREATE TABLE coupon (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            code VARCHAR(50) UNIQUE NOT NULL,
            discount FLOAT NOT NULL,
            active BOOLEAN DEFAULT 1
        )
    ''')
    print("Coupon table created successfully!")
except Exception as e:
    print(f"Error: {e}")

conn.commit()
conn.close()