USE `beautytech`;

CREATE TABLE `answers` (
  `answerId` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `type` int(11) NOT NULL COMMENT 'Type of entity :\n- 0 = domain\n- 1 = subdomain',
  `entityId` varchar(45) NOT NULL,
  `level` int(11) NOT NULL,
  PRIMARY KEY (`answerId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

CREATE TABLE `domains` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `explanation` varchar(512) DEFAULT NULL,
  `targetSample` varchar(512) DEFAULT NULL,
  `subdomains` json DEFAULT NULL,
  `index` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `subdomains` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `explanation` varchar(512) DEFAULT NULL,
  `index` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adid` varchar(1024) DEFAULT NULL,
  `lastAnsweredSubdomain` json DEFAULT NULL,
  `lastAnsweredDomain` int(11) DEFAULT NULL,
  `lastAnsweredTime` bigint(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

SELECT * FROM jlvb.answers;