创建数据库
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'));