X1D10uPR

1DROP TABLE IF EXISTS `wlp`.`activation_keys` ;
2
3CREATE TABLE IF NOT EXISTS `wlp`.`activation_keys` (
4  `user_id` INT NOT NULL,
5  `activation_key` VARCHAR(255) NOT NULL,
6  `activation_date` DATE NOT NULL DEFAULT DATE_ADD(DATE(NOW()),INTERVAL 3 DAY),
7  `activation_mode` TINYINT NOT NULL DEFAULT 0,
8  CONSTRAINT `fk_activation_keys_users`
9    FOREIGN KEY (`user_id`)
10    REFERENCES `wlp`.`users` (`user_id`)
11    ON DELETE CASCADE
12    ON UPDATE NO ACTION)
13ENGINE = InnoDB;
14
15CREATE INDEX `INDEX` ON `wlp`.`activation_keys` (`activation_key` ASC);
16
17CREATE INDEX `fk_activation_keys_users_idx` ON `wlp`.`activation_keys` (`user_id` ASC);