DROP TABLE IF EXISTS USERS;
CREATE TABLE USERS (
    ID CHAR(36) NOT NULL,
    EMAIL VARCHAR(500) NOT NULL,
    PASSWORD VARCHAR(100) NOT NULL,
    FIRSTNAME VARCHAR(50),
    LASTNAME VARCHAR(50),
    KANA_FIRSTNAME VARCHAR(450),
    KANA_LASTNAME VARCHAR(450),
    ROLE INT NOT NULL DEFAULT 0,
    ENABLED BOOLEAN NOT NULL,
    LINE_ID VARCHAR(100),
    CREATED_AT DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UPDATED_AT DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (ID),
    CONSTRAINT UNQ_USERS_EMAIL UNIQUE (EMAIL)
);