CREATE  TABLE IF NOT EXISTS `mydb`.`Users` (
  `userId` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `type` ENUM('physical', 'juridical', 'employee', 'server') NULL ,
  `status` ENUM('active', 'blocked') NULL ,
  PRIMARY KEY (`userId`) )
COMMENT = 'Общая таблица пользователей системы';

CREATE  TABLE IF NOT EXISTS `mydb`.`JuridicalClients` (
  `userId` BIGINT UNSIGNED NOT NULL ,
  PRIMARY KEY (`userId`) ,
)

CREATE  TABLE IF NOT EXISTS `mydb`.`PhysicalClients` (
  `userId` BIGINT UNSIGNED NOT NULL ,
  `name` VARCHAR( 255 ) NOT NULL ,
  `surname` VARCHAR( 255 ) NOT NULL ,
  `patronymic` VARCHAR( 255 ) NOT NULL ,
  `docType` ENUM('passport', 'residential') NOT NULL ,
  `docSeries` VARCHAR( 45 ) NOT NULL ,
  `docNumber` VARCHAR( 45 ) NOT NULL ,
  `docIssueDate` DATE NOT NULL ,
  `docIssuedBy` VARCHAR( 300 ) NOT NULL ,
  `regDate` DATE NOT NULL ,
  `contractNum` BIGINT NOT NULL ,
  PRIMARY KEY (`userId`)
)