user_table_query - MukeshKumar101/IPL_Auction GitHub Wiki

CREATE TABLE user ( id BINARY(16) NOT NULL, name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, role ENUM('seller','buyer') NOT NULL, active TINYINT(2) NOT NULL DEFAULT '1', created_by BINARY(16) NULL DEFAULT NULL, updated_by BINARY(16) NULL DEFAULT NULL, created_on DATETIME NULL DEFAULT 'CURRENT_TIMESTAMP', updated_on DATETIME NULL DEFAULT 'CURRENT_TIMESTAMP', PRIMARY KEY (id) );