· 7 years ago · Nov 04, 2018, 11:20 AM
1def NewDataBase():
2 with sqlite3.connect("Users.db") as db:
3 cursor = db.cursor()
4
5 cursor.execute('''
6CREATE TABLE IF NOT EXISTS user(
7userID INTEGER PRIMARY KEY,
8username VARCHAR(20) NOT NULL,
9firstname VARCHAR(20) NOT NULL,
10sirname VARCHAR(20) NOT NULL,
11password VARCHAR(20) NOT NULL,
12email VARCHAR(20) NOT NULL,
13recID VARCHAR(20) NOT NULL);
14''')