数据库/mysc_db.sql

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

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

/*
MySQL Data Transfer
Source Host: localhost
Source Database: mysc_db
Target Host: localhost
Target Database: mysc_db
Date: 2015/3/10 16:36:09
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_dingdan
-- ----------------------------
CREATE TABLE `t_dingdan` (
  `id` int(11) NOT NULL auto_increment,
  `address` varchar(255) default NULL,
  `beizhu` varchar(255) default NULL,
  `createtime` datetime default NULL,
  `deletestatus` int(11) NOT NULL,
  `orderid` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  `sjname` varchar(255) default NULL,
  `status` varchar(255) default NULL,
  `xiangqing` varchar(255) default NULL,
  `zongjia` double NOT NULL,
  `userid` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK8224F8E8471EE685` (`userid`),
  CONSTRAINT `FK8224F8E8471EE685` FOREIGN KEY (`userid`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for t_fenlei
-- ----------------------------
CREATE TABLE `t_fenlei` (
  `id` int(11) NOT NULL auto_increment,
  `deletestatus` int(11) NOT NULL,
  `name` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for t_gonggao
-- ----------------------------
CREATE TABLE `t_gonggao` (
  `id` int(11) NOT NULL auto_increment,
  `biaoti` varchar(255) default NULL,
  `content` varchar(255) default NULL,
  `createtime` datetime default NULL,
  `deletestatus` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for t_gouwuche
-- ----------------------------
CREATE TABLE `t_gouwuche` (
  `id` int(11) NOT NULL auto_increment,
  `createtime` datetime default NULL,
  `deletestatus` int(11) NOT NULL,