Formated by GeSHi
CREATE  TABLE IF NOT EXISTS `lockstock`.`user` (
  `user_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `user_group_id` INT(10) UNSIGNED NOT NULL ,
  `client_type_id` INT(11) NOT NULL ,
  `user_login` VARCHAR(20) NOT NULL ,
  `user_pass` VARCHAR(40) NOT NULL COMMENT 'sha1' ,
  `user_first_name` VARCHAR(40) NOT NULL ,
  `user_surname` VARCHAR(45) NOT NULL ,
  `user_email` VARCHAR(100) NOT NULL ,
  `user_address` VARCHAR(255) NOT NULL ,
  `user_phone` VARCHAR(255) NOT NULL ,
  `user_active` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' ,
  PRIMARY KEY (`user_id`) ,
  INDEX `fk_user_user_group1` (`user_group_id` ASC) ,
  INDEX `fk_user_client_type1` (`client_type_id` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
PACK_KEYS = 0
Parsed in 0.02275681 seconds