temp.sql 572 B

123456789101112131415161718192021222324
  1. /* ---------------------------------------------------- */
  2. /* Generated by Enterprise Architect Version 12.0 */
  3. /* Created On : 16-12月-2016 15:18:58 */
  4. /* DBMS : MySql */
  5. /* ---------------------------------------------------- */
  6. SET FOREIGN_KEY_CHECKS=0
  7. /* Drop Tables */
  8. DROP TABLE IF EXISTS `sticky_sessions` CASCADE
  9. ;
  10. /* Create Tables */
  11. CREATE TABLE `sticky_sessions`
  12. (
  13. `user_id` VARCHAR(50) COMMENT '用户ID',
  14. `session_id` VARCHAR(50) COMMENT '会话ID',
  15. `score` INTEGER COMMENT '置顶分值'
  16. ) COMMENT='置顶会话'
  17. ;
  18. SET FOREIGN_KEY_CHECKS=1