FdroidRepository/db/user.sql

CREATE TABLE users (
                       user_id INT PRIMARY KEY AUTO_INCREMENT,
                       username VARCHAR(50) NOT NULL UNIQUE,
                       password VARCHAR(100) NOT NULL,
                       email VARCHAR(100) NOT NULL UNIQUE,
                       full_name VARCHAR(100),
                       date_of_birth DATE,
                       gender CHAR(1),
                       phone_number VARCHAR(20),
                       registration_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                       is_active BOOLEAN DEFAULT true,
                       role VARCHAR(20) DEFAULT 'USER'
);