CREATE TABLE distributors (
    distributor_id VARCHAR(100) PRIMARY KEY,
    distributor_name VARCHAR(255),
    rank_name VARCHAR(100),
    status_name VARCHAR(100),
    ic_no VARCHAR(50),
    race VARCHAR(50),
    gender VARCHAR(20),
    join_date DATE,
    date_of_birth DATE,
    sponsor_id VARCHAR(100),
    sponsor_name VARCHAR(255),
    sponsor_rank VARCHAR(100),
    mobile VARCHAR(30),
    email VARCHAR(255),
    address1 TEXT,
    address2 TEXT,
    postcode VARCHAR(10),
    city VARCHAR(100),
    state VARCHAR(100),
    country VARCHAR(100)
);