我的sql2

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50150
Source Host : localhost:3306
Source Database : erp

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

Date: 2018-12-04 20:22:43
*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for plan

---

DROP TABLE IF EXISTS plan;
CREATE TABLE plan (
PLAN_ID int(11) NOT NULL AUTO_INCREMENT,
USERNO varchar(50) DEFAULT NULL,
USERNAME varchar(50) DEFAULT NULL,
TEACHER varchar(50) DEFAULT NULL,
TEACHERNAME varchar(50) DEFAULT NULL,
PERIOD varchar(50) DEFAULT NULL,
PLANDES varchar(500) DEFAULT NULL,
BECOMEDESTARGET varchar(500) DEFAULT NULL,
SERVICELEARNCONT varchar(500) DEFAULT NULL,
SERVICELEARNGOL varchar(500) DEFAULT NULL,
SERVICELEARNCON varchar(500) DEFAULT NULL,
SERVICELEARNSTA varchar(500) DEFAULT NULL,
SERVICEREMARK varchar(500) DEFAULT NULL,
PROBLEMSOLVCONT varchar(500) DEFAULT NULL,
PROBLEMSOLVGOL varchar(500) DEFAULT NULL,
PROBLEMSOLVCON varchar(500) DEFAULT NULL,
PROBLEMSOLVSTA varchar(500) DEFAULT NULL,
PROBLEMSOLVMARK varchar(500) DEFAULT NULL,
SKILLCONT varchar(500) DEFAULT NULL,
SKILLGOL varchar(500) DEFAULT NULL,
SKILLCON varchar(500) DEFAULT NULL,
SKILLSTA varchar(500) DEFAULT NULL,
SKILLMARK varchar(500) DEFAULT NULL,
BEHAVIOURCONT varchar(500) DEFAULT NULL,
BEHAVIOURGOL varchar(500) DEFAULT NULL,
BEHAVIOURCON varchar(500) DEFAULT NULL,
BEHAVIOURSTA varchar(500) DEFAULT NULL,
BEHAVIOURMARK varchar(500) DEFAULT NULL,
STATUS char(1) DEFAULT NULL COMMENT ‘状态’,
CREATED datetime DEFAULT NULL COMMENT ‘创造日期’,
LASTMOD datetime DEFAULT NULL COMMENT ‘修改日期’,
CREATER varchar(10) DEFAULT NULL COMMENT ‘创建人’,
MODIFYER int(10) DEFAULT NULL COMMENT ‘修改人’,
SERVICELEARNCONPRIVATE varchar(255) DEFAULT NULL,
SERVICELEARNSTAPRIVATE varchar(255) DEFAULT NULL,
SERVICEREMARKPRIVATE varchar(255) DEFAULT NULL,
SERVICEREMARKE varchar(255) DEFAULT NULL,
PRIMARY KEY (PLAN_ID)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COMMENT=‘培养计划’;

---

– Records of plan

---

INSERT INTO plan VALUES (‘49’, ‘003’, ‘王五’, ‘002’, ‘赵四1’, ‘1’, ‘1’, ‘2222222222222’, ‘11’, ‘111111’, ‘1’, ‘closed’, null, ‘1’, ‘1’, ‘1’, ‘closed’, ‘’, ‘1’, ‘11’, ‘11’, ‘closed’, ‘’, ‘2’, ‘11’, ‘1’, ‘closed’, ‘’, ‘A’, ‘2018-12-04 00:00:00’, ‘2018-12-04 00:00:00’, ‘27’, ‘27’, null, null, null, ‘’);
INSERT INTO plan VALUES (‘50’, ‘004’, ‘李l六’, ‘002’, ‘赵四2’, ‘1’, ‘1’, ‘’, ‘1’, ‘11’, ‘1’, ‘open’, null, ‘1’, ‘1’, ‘1’, ‘open’, ‘’, ‘1’, ‘11’, ‘1’, ‘open’, ‘’, ‘1’, ‘1’, ‘1’, ‘open’, ‘’, ‘A’, ‘2018-12-04 00:00:00’, ‘2018-12-04 00:00:00’, ‘27’, ‘27’, null, null, null, ‘’);