import os
from sqlite3 import dbapi2 as sqlite

fname = ".\\tbl"
try:
    os.unlink(fname)
except OSError:
    pass

con = sqlite.connect(fname)
cur = con.cursor()

cur.execute("""
CREATE TABLE IF NOT EXISTS tbl(
    key1      INTEGER
)""")


cur.execute("""
    CREATE UNIQUE INDEX IF NOT EXISTS idx1 ON tbl(key1)
""")

cur.execute("""
    CREATE UNIQUE INDEX IF NOT EXISTS idx1 ON tbl(key1)
""")