/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50728
Source Host : localhost:3306
Source Database : employee
Target Server Type : MYSQL
Target Server Version : 50728
File Encoding : 65001
Date: 2021-09-15 17:59:25
*/
SET FOREIGN_KEY_CHECKS=0;
– Table structure for admin
DROP TABLE IF EXISTS admin
;
CREATE TABLE admin
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(60) NOT NULL,
password
varchar(16) NOT NULL,
PRIMARY KEY (id
,name
)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
– Records of admin
INSERT INTO admin
VALUES (‘4’, ‘admin1’, ‘123’);
– Table structure for dept
DROP TABLE IF EXISTS dept
;
CREATE TABLE dept
(
did
int(11) NOT NULL AUTO_INCREMENT,
dname
varchar(20) NOT NULL,
PRIMARY KEY (did
)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
– Records of dept
INSERT INTO dept
VALUES (‘1’, ‘技术部’);
INSERT INTO dept
VALUES (‘2’, ‘开发部’);
INSERT INTO dept
VALUES (‘3’, ‘测试部’);
INSERT INTO dept