aboutsummaryrefslogtreecommitdiff
path: root/backend/migrations/2020-09-22-104623_create_users/up.sql
blob: dfd27d94314d44392ac9dcde99ec521ab156e468 (plain)
1
2
3
4
5
6
7
8
-- Your SQL goes here
CREATE TABLE members (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(255) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    phone_number VARCHAR(10) NOT NULL,
    email_id VARCHAR(255) NOT NULL
)