随聊

create table friend
(
    fid      bigint auto_increment,
    myid     bigint not null,
    friendid bigint not null,
    constraint friends_fid_uindex
        unique (fid)
)
  

alter table friend
    add primary key (fid);


create table message
(
    mid     bigint auto_increment,
    message text   not null,
    talkid  bigint not null,
    constraint message_mid_uindex
        unique (mid)
)
    comment '这个是用来存对话的';

alter table message
    add primary key (mid);



create table talk
(
    tid     bigint auto_increment,
    mytalk  bigint not null comment '这个是当前用户的id',
    shetalk bigint not null comment '这个是被对话的对象的id',
    constraint talk_tid_uindex
        unique (tid)
)
    comment '这个是用存储用户交流的表，每个人对应的话都要分开了存储，方便后面加入撤回功能';

alter table talk
    add primary key (tid);

create table user
(
    id       bigint auto_increment,
    account  varchar(128) not null,
    username varchar(24)  not null,
    password varchar(128) not null,
    constraint user_account_uindex
        unique (account),
    constraint user_id_uindex
        unique (id)
)
    comment '用户表';

alter table user
    add primary key (id);