CREATE TABLE `user` (
  `id` INT(20) NOT NULL,
  `first_name` VARCHAR(100) NOT NULL,
  `last_name` VARCHAR(100) NOT NULL,
  `email` VARCHAR(250) NOT NULL,
  `password` VARCHAR(50) NOT NULL,
  `gender` ENUM('male','female') CHARACTER SET utf8 NOT NULL,
  `mobile` VARCHAR(50) NOT NULL DEFAULT '',
  `designation` VARCHAR(50) NOT NULL DEFAULT '',
  `image` VARCHAR(250) NOT NULL DEFAULT '',
  `type` VARCHAR(250) NOT NULL DEFAULT 'general',
  `status` ENUM('active','inactive','deleted','') NOT NULL DEFAULT 'inactive',
  `authtoken` VARCHAR(250) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=latin1;


ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `user`
  MODIFY `id` INT(20) NOT NULL AUTO_INCREMENT;
	
