#数据库连接
import sqlite3
#1、打开数据库
conn = sqlite3.connect("test_Raspberry.db")
#2、打开游标
c = conn.cursor()
#3、执行SQL语句
c.execute('drop table IF EXISTS user;')
c.execute('drop table IF EXISTS orderlist;')
c.execute('CREATE TABLE user ( _id integer PRIMARY KEY AUTOINCREMENT, user TEXT, pass text, age integer )')
c.execute('''CREATE TABLE orderlist (
_id integer PRIMARY KEY AUTOINCREMENT,
item_name text,
item_price real,
item_number integer,
user_id integer,
FOREIGN KEY ( user_id ) REFERENCES user_tb ( _id ));''')
#4、关闭游标
c.close()
#5、关闭连接
conn.close()