CREATE TABLE i_users(userId BIGINT PRIMARY KEY IDENTITY, username varchar(30), emailaddress varchar(30),isActive BIT DEFAULT 1 , password1 varchar(50), gender varchar(1)); CREATE TABLE i_user_login_logs(userID BIGINT, FOREIGN KEY(userID) REFERENCES i_users(userId), login_date DATE);