FdroidRepository/db/user.sql

CREATE TABLE users (
                      user_id BIGINT PRIMARY KEY AUTO_INCREMENT,
                      username VARCHAR(255) NOT NULL,
                      password VARCHAR(255) NOT NULL,
                      email VARCHAR(255) NOT NULL,
                      full_name VARCHAR(255),
                      date_of_birth DATE,
                      gender VARCHAR(10),
                      phone_number VARCHAR(20),
                      registration_date DATE,
                      active BOOLEAN,
                      role VARCHAR(50),
                      activation_code VARCHAR(255),
                      create_time TIMESTAMP,
                      salt VARCHAR(255)
);