DROP TABLE IF EXISTS `USER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `USER` (
  `ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `UUID` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `FIRST_NAME` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `LAST_NAME` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `USERNAME` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `ENCODED_USERNAME` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `EMAIL` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `PASSWORD` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `ROLE` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `LAST_LOGIN` datetime DEFAULT NULL,
  `PASSWORD1` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `USER_POST_COUNT` INTEGER (20) DEFAULT NULL, /*дописал эту строчку*/
  PRIMARY KEY (`ID`),
  UNIQUE KEY `UUID` (`UUID`),
  UNIQUE KEY `USERNAME` (`USERNAME`),
  UNIQUE KEY `EMAIL` (`EMAIL`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;