database/db_affairmanage.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

# MySQL-Front 5.0  (Build 1.0)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: db_affairmanage
# ------------------------------------------------------
# Server version 5.0.67-community-nt

DROP DATABASE IF EXISTS `db_affairmanage`;
CREATE DATABASE `db_affairmanage` /*!40100 DEFAULT CHARACTER SET gb2312 */;
USE `db_affairmanage`;

#
# Table structure for table tb_criticism
#

CREATE TABLE `tb_criticism` (
  `criticismID` int(11) NOT NULL auto_increment,
  `criticismContent` text,
  `employeeID` int(11) default NULL,
  `criticismTime` datetime default NULL,
  `messageID` int(11) default NULL,
  PRIMARY KEY  (`criticismID`),
  KEY `employeeID` (`employeeID`),
  KEY `messageID` (`messageID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312 COMMENT='消息批复表';
INSERT INTO `tb_criticism` VALUES (3,'<p>不错，以后大家好好干活！！</p>',3052,'2009-08-25 15:08:16',14);
INSERT INTO `tb_criticism` VALUES (4,'<p>测试批复</p>',3052,'2010-01-26 20:52:46',14);
INSERT INTO `tb_criticism` VALUES (5,'<p>测试批复</p>',3052,'2010-01-26 20:53:06',16);

#
# Table structure for table tb_employee
#

CREATE TABLE `tb_employee` (
  `employeeID` int(11) NOT NULL default '0',
  `employeeName` varchar(20) default NULL,
  `employeeSex` bit(1) default NULL,
  `employeeBirth` date default NULL,
  `employeePhone` varchar(20) default NULL,
  `employeePlace` varchar(50) default NULL,
  `joinTime` date default NULL,
  `password` varchar(20) default NULL,
  `isLead` bit(1) default NULL,
  PRIMARY KEY  (`employeeID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='员工信息表';
INSERT INTO `tb_employee` VALUES (3052,'李俊',b'1','1978-01-08','1378675****','北京市','2008-12-30','123456',b'1');

#
# Table structure for table tb_message
#

CREATE TABLE `tb_message` (
  `messageID` int(11) NOT NULL auto_increment,
  `messageTitle` varchar(50) default NULL,
  `messageContent` text,