LEYbiU4Z

1PRAGMA FOREIGN_KEYS = ON;
2
3CREATE TABLE IF NOT EXISTS users(
4    id INTEGER PRIMARY KEY AUTOINCREMENT,
5    username VARCHAR(22) NOT NULL UNIQUE,
6    password VARCHAR(255) NOT NULL,
7    email VARCHAR(255) NOT NULL UNIQUE,
8    сreated_at DATETIME NOT NULL,
9    updated_at DATEIME NOT NULL
10);
11
12CREATE TABLE IF NOT EXISTS profiles(
13    id INTEGER PRIMARY KEY AUTOINCREMENT,
14    user_id INREGER NOT NULL,
15    name VARCHAR(255),
16    last_name VARCHAR(255),
17    photo_path VARCHAR(255),
18    about TEXT,
19    FOREIGN KEY (user_id) REFERENCES users(id)
20);
21
22CREATE TRIGGER new_profile AFTER INSERT ON users
23    FOR EACH ROW
24    BEGIN
25        INSERT INTO profiles(user_id) VALUES (NEW.id);
26END;