15.03.20.sql 534 B

1234567891011121314
  1. DROP TABLE IF EXISTS `session`;
  2. CREATE TABLE `session`(
  3. `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `token` VARBINARY(64) NOT NULL,
  5. `user_id` INT UNSIGNED NOT NULL,
  6. `created` DATETIME NOT NULL,
  7. PRIMARY KEY (`id`),
  8. UNIQUE KEY `session_token` (`token`),
  9. KEY `session_user_id` (`user_id`),
  10. CONSTRAINT `session_user_id` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE CASCADE ON DELETE CASCADE
  11. ) ENGINE=INNODB CHARSET=utf8 COLLATE=utf8_unicode_ci;
  12. UPDATE `config` SET `value` = '15.03.20' WHERE `attribute` = 'version';