users.sql

DROP TABLE IF EXISTS users;
CREATE TABLE users
(
  id                smallint unsigned NOT NULL auto_increment,
  username          VARCHAR(50) NOT NULL,
  password          VARCHAR(50) NOT NULL,
  joinDateTime      date NOT NULL,
  lastLoginDateTime date NOT NULL,
  lastLoginFrom     VARCHAR(50) NOT NULL,
  userType          VARCHAR(50) NOT NULL,
  name              VARCHAR(50) NOT NULL, 
  rollNo            VARCHAR(20) NOT NULL, 
  hostel            VARCHAR(20) NOT NULL, 
  room              VARCHAR(20) NOT NULL, 
  phone             VARCHAR(20) NOT NULL, 
  email             VARCHAR(20) NOT NULL UNIQUE,
  socialMediaUrl    VARCHAR(50) NOT NULL,
  avatarLocation    VARCHAR(50) NOT NULL,
  expertise         VARCHAR(20) NOT NULL,
  rating            VARCHAR(20) NOT NULL,
  aboutMe           text NOT NULL,
  coreRemark        text NOT NULL,
 
  PRIMARY KEY     (id)
);