from sqlite3 import *

with connect("schule.db") as con:
    cursor = con.cursor()
    sql = """CREATE TABLE person
             (personid INTEGER PRIMARY KEY, 
             familienname VARCHAR, 
             vorname VARCHAR, 
             wohnort VARCHAR,
             geschlecht VARCHAR,  
             jahrgang INTEGER)"""  
    cursor.execute(sql)       
print("Done")

