· 8 years ago · May 16, 2018, 12:58 PM
1request = """
2 CREATE TABLE IF NOT EXISTS Users (
3 id INT PRIMARY KEY AUTO_INCREMENT,
4 firstname VARCHAR(128) NOT NULL,
5 lastname VARCHAR(128) NOT NULL,
6 username VARCHAR(128) NOT NULL UNIQUE,
7 password VARCHAR(256) NOT NULL,
8 email VARCHAR(128) NOT NULL,
9 sex SMALLINT(1),
10 orientation SMALLINT(1),
11 biography TEXT(256),
12 notifications BOOL DEFAULT 1,
13 is_valid BOOL DEFAULT 0,
14 date_created TIMSTAMP DEFAULT current_timestamp
15);"""