UenRTVwR

1# Connecting to DB
2conn, cursor = connect()
3
4# SQL command to create inventory table
5create_table = """
6    CREATE TABLE IF NOT EXISTS inventory(
7        index INTEGER,
8        id TEXT PRIMARY KEY NOT NULL,
9        category TEXT,
10        image TEXT,
11        displayName TEXT,
12        urlHistory TEXT
13    )
14    """
15
16# Execute SQL Command and commit to DB
17cursor.execute(create_table)
18conn.commit()
19
20# Disconnect from DB
21disconnect(conn, cursor)