# MySQL-Front 5.1  (Build 4.2)

/*!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' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


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

#
# Source for table t_field
#

DROP TABLE IF EXISTS `t_field`;
CREATE TABLE `t_field` (
  `id` int(11) NOT NULL auto_increment,
  `bianhao` varchar(255) default NULL,
  `deletestatus` int(11) NOT NULL,
  `mingchen` varchar(255) default NULL,
  `renshu` int(11) NOT NULL,
  `time` varchar(255) default NULL,
  `week` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table t_field
#

LOCK TABLES `t_field` WRITE;
/*!40000 ALTER TABLE `t_field` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_field` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table t_record
#

DROP TABLE IF EXISTS `t_record`;
CREATE TABLE `t_record` (
  `id` int(11) NOT NULL auto_increment,
  `deletestatus` int(11) NOT NULL,
  `riqi` int(11) NOT NULL,
  `status` varchar(255) default NULL,
  `ytime` varchar(255) default NULL,
  `yystatus` int(11) NOT NULL,
  `userid` int(11) default NULL,
  `yuyueid` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK4523AA9C4A9A2A23` (`yuyueid`),
  KEY `FK4523AA9C1433B443` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table t_record
#

LOCK TABLES `t_record` WRITE;
/*!40000 ALTER TABLE `t_record` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_record` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table t_tongji
#

DROP TABLE IF EXISTS `t_tongji`;
CREATE TABLE `t_tongji` (
  `id` int(11) NOT NULL auto_increment,
  `chenggong` int(11) NOT NULL,
  `quxiao` int(11) NOT NULL,
  `riqi` varchar(255) default NULL,
  `fieldid` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK491F27FE46DA2C7D` (`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table t_tongji
#

LOCK TABLES `t_tongji` WRITE;
/*!40000 ALTER TABLE `t_tongji` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_tongji` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table t_user
#

DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int(11) NOT NULL auto_increment,
  `createtime` varchar(255) default NULL,
  `deletestatus` int(11) NOT NULL,
  `password` varchar(255) default NULL,
  `role` int(11) NOT NULL,
  `tel` varchar(255) default NULL,
  `username` varchar(255) default NULL,
  `xingming` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table t_user
#

LOCK TABLES `t_user` WRITE;
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table t_yuyue
#

DROP TABLE IF EXISTS `t_yuyue`;
CREATE TABLE `t_yuyue` (
  `id` int(11) NOT NULL auto_increment,
  `deletestatus` int(11) NOT NULL,
  `riqi` int(11) NOT NULL,
  `rq` varchar(255) default NULL,
  `shiji` int(11) NOT NULL,
  `time` varchar(255) default NULL,
  `week` varchar(255) default NULL,
  `fieldid` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK9F8C6C8246DA2C7D` (`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table t_yuyue
#

LOCK TABLES `t_yuyue` WRITE;
/*!40000 ALTER TABLE `t_yuyue` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_yuyue` ENABLE KEYS */;
UNLOCK TABLES;

#
#  Foreign keys for table t_record
#

ALTER TABLE `t_record`
ADD CONSTRAINT `FK4523AA9C1433B443` FOREIGN KEY (`userid`) REFERENCES `t_user` (`id`),
ADD CONSTRAINT `FK4523AA9C4A9A2A23` FOREIGN KEY (`yuyueid`) REFERENCES `t_yuyue` (`id`);

#
#  Foreign keys for table t_tongji
#

ALTER TABLE `t_tongji`
ADD CONSTRAINT `FK491F27FE46DA2C7D` FOREIGN KEY (`fieldid`) REFERENCES `t_field` (`id`);

#
#  Foreign keys for table t_yuyue
#

ALTER TABLE `t_yuyue`
ADD CONSTRAINT `FK9F8C6C8246DA2C7D` FOREIGN KEY (`fieldid`) REFERENCES `t_field` (`id`);


/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;