t2TiqGxT

1class Users():
2    def create_table():
3        request = "CREATE TABLE IF NOT EXISTS Users (
4            id              INT PRIMARY KEY AUTO_INCREMENT,
5            firstname       VARCHAR(128) NOT NULL,
6            lastname        VARCHAR(128) NOT NULL,
7            username        VARCHAR(128) NOT NULL UNIQUE,
8            password        VARCHAR(256) NOT NULL,
9            email           VARCHAR(128) NOT NULL,
10            sex             SMALLINT(1),
11            orientation     SMALLINT(1),
12            biography       TEXT(256),
13            notifications   BOOL DEFAULT 1,
14            is_valid        BOOL DEFAULT 0,
15            date_created    TIMSTAMP DEFAULT current_timestamp
16        )"
17
18class ProfilePics():
19    def create_table():
20        request = "CREATE TABLE IF NOT EXISTS ProfilePics (
21            id              INT PRIMARY KEY AUTO_INCREMENT,
22            user_id         INT(8) NOT NULL,
23            picture         TEXT(512) NOT NULL,
24            date_created    TIMESTAMP DEFAULT current_timestamp,
25            FOREIGN KEY (user_id) REFERENCES Users(id)
26        )"
27
28class Tags:
29    def create_table():
30        request = "CREATE TABLE IF NOT EXISTS Tags (
31            id              INT PRIMARY KEY AUTO_INCREMENT,
32            tag_name        VARCHAR(128) NOT NULL,
33        )"
34
35class UsersTags:
36    def create_table():
37        request = "CREATE TABLE IF NOT EXISTS UsersTags (
38            user_id     INT(8),
39            tag_id      VARCHAR(128) NOT NULL,
40            FOREIGN KEY (user_id) REFERENCES Users(id),
41            FOREIGN KEY (tag_id) REFERENCES Tags(id)
42        )"