Advertisement
Guest User

Untitled

a guest
Mar 29th, 2015
225
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `app`.`token` (
  2. `id` INT NOT NULL AUTO_INCREMENT,
  3. `token` VARCHAR(64) NOT NULL,
  4. `creation_date` DATETIME NOT NULL DEFAULT NOW(),
  5. `expiration_date` DATETIME NOT NULL DEFAULT NOW() + INTERVAL 1 HOUR,
  6. PRIMARY KEY (`id`))
  7. ENGINE = InnoDB;
  8.  
  9. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '+ INTERVAL 1 HOUR,
  10. PRIMARY KEY (`id`))
  11. ENGINE = InnoDB' at line 5
  12.  
  13. INSERT INTO `app`.`token` (`token`,`expiration_date`) VALUES ('b1ae528de7ec8355a655926fcb84397f5d21d604e232b6567471c84610a171a8', NOW() + INTERVAL 1 HOUR);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement