user_auth.sql 343 B

12345678
  1. CREATE TABLE user_auth
  2. (
  3. id INT unsigned AUTO_INCREMENT PRIMARY KEY COMMENT '自增id',
  4. user_id int COMMENT '用户id',
  5. email_account varchar(30) COMMENT '收件人前缀',
  6. UNIQUE INDEX udx_uid_ename ( user_id, email_account),
  7. UNIQUE INDEX udx_ename_uid ( email_account,user_id )
  8. )COMMENT='登陆信息表'