· 4 years ago · May 15, 2021, 07:44 AM
1CREATE TABLE IF NOT EXISTS Users(
2 id INTEGER PRIMARY KEY AUTOINCREMENT,
3 username TEXT NOT NULL,
4 password TEXT NOT NULL,
5 phone TEXT NOT NULL,
6 gender TEXT NOT NULL,
7 wallet INTEGER NOT NULL,
8 dateOfBirth TEXT NOT NULL
9)
10
11CREATE TABLE IF NOT EXISTS Products (
12 id INTEGER PRIMARY KEY AUTOINCREMENT,
13 name TEXT NOT NULL,
14 minPlayer INTEGER NOT NULL,
15 maxPlayer INTEGER NOT NULL,
16 price INTEGER NOT NULL,
17 latitude INTEGER NOT NULL,
18 longitude INTEGER NOT NULL
19)
20
21CREATE TABLE IF NOT EXISTS Transactions (
22 id INTEGER PRIMARY KEY AUTOINCREMENT,
23 userId INTEGER NOT NULL,
24 productId INTEGER NOT NULL,
25
26 FOREIGN KEY (userId) REFERENCES Users (id)
27 ON DELETE CASCADE ON UPDATE CASCADE,
28 FOREIGN KEY (productId) REFERENCES Products (id)
29 ON DELETE CASCADE ON UPDATE CASCADE,
30)