201912G14/mysql/news.sql

/*
Navicat MySQL Data Transfer

Source Server         : chen
Source Server Version : 50168
Source Host           : localhost:3306
Source Database       : news

Target Server Type    : MYSQL
Target Server Version : 50168
File Encoding         : 65001

Date: 2019-12-20 08:03:46
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for testbar
-- ----------------------------
DROP TABLE IF EXISTS `testbar`;
CREATE TABLE `testbar` (
  `name` varchar(255) NOT NULL,
  `num` int(225) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of testbar
-- ----------------------------
INSERT INTO `testbar` VALUES ('惠州', '300');
INSERT INTO `testbar` VALUES ('汕头', '168');
INSERT INTO `testbar` VALUES ('汕尾', '200');
INSERT INTO `testbar` VALUES ('江门', '225');
INSERT INTO `testbar` VALUES ('深圳', '364');
INSERT INTO `testbar` VALUES ('湛江', '200');
INSERT INTO `testbar` VALUES ('珠海', '180');
INSERT INTO `testbar` VALUES ('韶关', '300');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'admin', '123', '0', 'sziit@qq.com');
INSERT INTO `users` VALUES ('2', 'admin', 'admin', '1', 'sziit@qq.com');
INSERT INTO `users` VALUES ('3', '123', '1234', '0', 'sziit@qq.com');
INSERT INTO `users` VALUES ('4', 'cfl', '1231356', '0', 'sziit@qq.com');
INSERT INTO `users` VALUES (null, 'czn', '123', '0', 'sziit@qq.com');
INSERT INTO `users` VALUES (null, 'xxx', '11233', '0', 'sziit@qq.com');