#prepare environment 

import sqlite3
conn=sqlite3.connect('example.db')
cursor=conn.cursor()
cursor.execute("PRAGMA foreign_keys=ON")

#--------------------------------------------------------------------

cursor.execute("""
 CREATE TABLE users(
 id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 email TEXT NOT NULL,
 name TEXT NOT NULL
 )
 """)
#--------------------------------------------------------------------
 cursor.execute("""
 CREATE TABLE cars(
 id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 brand TEXT NOT NULL,
 model TEXT NOT NULL,
 owner INTEGER NOT NULL,
 FOREIGN KEY(owner) REFERENCES users(id) ON DELETE CASCADE
 )
 """)
#--------------------------------------------------------------------