MYSQL

创建数据库

 DROP database if EXISTS xz;
 set names utf8;
    CREATE database xz charset=utf8;
    USE xz;
    CREATE TABLE xz_news (
        id INT PRIMARY KEY AUTO_INCREMENT,
        title VARCHAR(128),
        time DATETIME,
        img_url VARCHAR(128),
        point INT
    );
    INSERT INTO xz_news VALUES
    (NULL,'..1',now(),"http://127.0.0.1:3000/img/cbd.jpg",0),
    (null,'..2',now(),"http://127.0.0.1:3000/img/muwu.jpg",0),
    (null,'..3',now(),"http://127.0.0.1:3000/img/shuijiao.jpg",0),
    (null,'..4',now(),"http://127.0.0.1:3000/img/cbd.jpg",0),
    (null,'..5',now(),"http://127.0.0.1:3000/img/muwu.jpg",0),
    (null,'..6',now(),"http://127.0.0.1:3000/img/shuijiao.jpg",0),
    (null,'..7',now(),"http://127.0.0.1:3000/img/cbd.jpg",0),
    (null,'..8',now(),"http://127.0.0.1:3000/img/muwu.jpg",0),
    (null,'..9',now(),"http://127.0.0.1:3000/img/shuijiao.jpg",0),
    (null,'..10',now(),"http://127.0.0.1:3000/img/cbd.jpg",0),
    (null,'..11',now(),"http://127.0.0.1:3000/img/muwu.jpg",0),
    (null,'..12',now(),"http://127.0.0.1:3000/img/shuijiao.jpg",0),
    (null,'..13',now(),"http://127.0.0.1:3000/img/cbd.jpg",0);

#md5加密

drop table if exists xz_user
create table xz_user(
    id int primary key auto_increment,
    uname varchar(25),
    upwd varchar(32)
);
insert into xz_user values
(null,'jack',md5('123456')),
(null,'tom',md5('123456')),
(null,'jack',md5('123456'));