create table chat_history
(
    master_id   int          null,
    id          int auto_increment
        primary key,
    chat        varchar(255) null,
    create_time datetime     null,
    room_id     int          null,
    user_id     int          null
);

create table depository
(
    did          bigint unsigned auto_increment
        primary key,
    uid          bigint unsigned null,
    space        bigint unsigned null,
    max_space    bigint unsigned null,
    gmt_create   datetime        null,
    gmt_modified datetime        null
);

create table file
(
    fid          bigint unsigned auto_increment
        primary key,
    rid          bigint unsigned null,
    ffid         bigint unsigned null,
    did          bigint unsigned null,
    uid          bigint unsigned null,
    fname        varchar(255)    null,
    suffix       varchar(20)     null,
    type         varchar(10)     null,
    size         bigint unsigned null,
    status       tinyint         null,
    gmt_create   datetime        null,
    gmt_modified datetime        null
);

create table friend
(
    master_id   int         null,
    room_id     int         null,
    id          int auto_increment
        primary key,
    user_id     int         null,
    friend_name varchar(20) null,
    friend_id   int         null
);

create table notify
(
    id          int auto_increment
        primary key,
    friend_name varchar(20) null,
    message     longtext    null,
    username    varchar(50) null,
    type_id     int         null
);

create table notify_type
(
    id       int auto_increment
        primary key,
    descript varchar(20) null
);

create table permission
(
    name     varchar(255) null,
    descript varchar(255) null,
    id       int auto_increment
        primary key
);

create table resources
(
    rid          bigint unsigned auto_increment
        primary key,
    name         varchar(50)     null,
    md5          varchar(255)    null,
    path         varchar(255)    null,
    size         bigint unsigned null,
    up_uid       bigint unsigned null,
    up_time      datetime        null,
    down_times   int unsigned    null,
    quantity     int unsigned    null,
    gmt_create   datetime        null,
    gmt_modified datetime        null
);

create table room
(
    user_id1 int null,
    user_id2 int null,
    id       int auto_increment
        primary key
);

create table user
(
    username          varchar(20)     null,
    phone             varchar(20)     null,
    email             varchar(20)     null,
    password          varchar(100)    null,
    reg_time          datetime        null,
    last_time         datetime        null,
    transfer_times    int unsigned    null,
    transferred_times int unsigned    null,
    up_times          int unsigned    null,
    down_times        int unsigned    null,
    gmt_create        datetime        null,
    gmt_modified      datetime        null,
    status            tinyint         null,
    state             tinyint         null,
    nick              varchar(20)     null,
    pic_url           varchar(255)    null,
    birthday          date            null,
    id                int auto_increment
        primary key,
    did               bigint unsigned null
);

create table user_permission
(
    id            int auto_increment
        primary key,
    user_id       int null,
    permission_id int null
);
insert into notify_type(descript) values("添加好友");
insert into notify_type(descript) values("好友消息");

insert into permission(name,descript)  values("/index.html","访问首页");
insert into permission(name,descript)  values("/chat.html","访问聊天界面");