temp.sql 703 B

12345678910111213141516171819202122232425
  1. /* ---------------------------------------------------- */
  2. /* Generated by Enterprise Architect Version 12.0 */
  3. /* Created On : 15-Dec-2016 10:44:54 AM */
  4. /* DBMS : MySql */
  5. /* ---------------------------------------------------- */
  6. SET FOREIGN_KEY_CHECKS=0
  7. /* Drop Tables */
  8. DROP TABLE IF EXISTS `wechat_access_tokens` CASCADE
  9. ;
  10. /* Create Tables */
  11. CREATE TABLE `wechat_access_tokens`
  12. (
  13. `access_token` VARCHAR(50) NOT NULL COMMENT '访问token',
  14. `expiry_date` TIMESTAMP(0) COMMENT '过期时间',
  15. `create_time` TIMESTAMP(0) COMMENT '数据创建时间',
  16. CONSTRAINT `PK_wechat_access_tokens` PRIMARY KEY (`access_token`)
  17. ) COMMENT='微信接口调用所需要token'
  18. ;
  19. SET FOREIGN_KEY_CHECKS=1