text: CREATE TABLE `accounts` (
    `account_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(100) DEFAULT NULL,
    `name` varchar(45) DEFAULT NULL,
    `password` varchar(60) DEFAULT NULL, -- stores bcrypt hash
    PRIMARY KEY (`account_id`),
    UNIQUE KEY `email_UNIQUE` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Stores user account information';
  
  CREATE TABLE `contacts` (
    `contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `account_id` int(10) unsigned NOT NULL,
    `first_name` varchar(20) DEFAULT NULL,
    `last_name` varchar(20) DEFAULT NULL,
    `email` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`contact_id`),
    UNIQUE KEY `Unique email per account` (`account_id`,`email`) /*!80000 INVISIBLE */,
    FULLTEXT KEY `Index for search` (`first_name`,`last_name`,`email`),
    FULLTEXT KEY `Name Index` (`first_name`,`last_name`),
    FULLTEXT KEY `Email index` (`email`),
    CONSTRAINT `account_fk` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`account_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8 COMMENT='Stores contact details';
  