4ALuWRHB

1    def databaseMaker():
2        with sqlite3.connect("Review.db") as db:
3            cursor = db.cursor()
4
5            cursor.execute("""
6            CREATE TABLE IF NOT EXISTS games(
7            gameID INTEGER PRIMARY KEY AUTOINCREMENT,
8            gameName TEXT);
9            """)
10            
11
12            cursor.execute("""
13            CREATE TABLE IF NOT EXISTS website(
14            websiteID INTEGER PRIMARY KEY AUTOINCREMENT,
15            websiteName TEXT,
16            reviewCheck BOOLEAN,
17            scoreCheck BOOLEAN,
18            summaryCheck BOOLEAN
19            );
20            """)#change web crawlers to give one summary
21            
22
23            cursor.execute("""
24            CREATE TABLE IF NOT EXISTS review(
25            reviewID INTEGER PRIMARY KEY AUTOINCREMENT,
26            gameID INTEGER,
27            websiteID INTEGER,
28            review TEXT,
29            score TEXT,
30            summary TEXT,
31            FOREIGN KEY (gameID) REFERENCES games(gameID),
32            FOREIGN KEY (websiteID) REFERENCES website(websiteID));
33            """)