User Table

CREATE TABLE IF NOT EXISTS `mydb`.`User` (
  `idUser` INT NULL,
  `First` VARCHAR(45) NULL,
  `Middle` VARCHAR(45) NULL,
  `Last` VARCHAR(45) NULL,
  `Street1` VARCHAR(45) NULL,
  `Street2` VARCHAR(45) NULL,
  `City` VARCHAR(45) NULL,
  `District` VARCHAR(45) NULL,
  `Occupation` ENUM('Teacher','SchoolAdministrator','SchoolITPersonal','Student','Other') NULL,
  `SchoolAffiliation` VARCHAR(45) NULL,
  `ComputerUse` ENUM('schoollab','schooladmin','schoolserver','teachingstation','teacher(schoolowed)','teacher(personal)','Student(personal)','Other') NULL COMMENT 'ENUM(\"school lab\",\"school admin\",\"school server\",\"teaching station\",\"teacher (school owed)\",\"teacher (personal)\",\"Student (personal)\",\"Other\")',
  `Email` VARCHAR(45) NULL,
  `Phone1` VARCHAR(45) NULL,
  `Phone2` VARCHAR(45) NULL,
  `password` VARCHAR(45) NULL,
  `Verified` TINYINT(1) NULL COMMENT 'Email verified',
  PRIMARY KEY (`idUser`))
ENGINE = InnoDB
COMMENT = 'Laptop Buyers'
Topic revision: r1 - 2013-10-10 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback