bjtu_order/dctjxt.sql

# Host: localhost  (Version 5.5.15)
# Date: 2020-05-23 23:04:30
# Generator: MySQL-Front 6.0  (Build 2.20)


#
# Structure for table "admin"
#
create database dctjxt;
use dctjxt;
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(450) DEFAULT NULL,
  `userPw` varchar(450) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

#
# Data for table "admin"
#

/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,'admin','123456'),(6,'gly','123456');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;

#
# Structure for table "catelog"
#

DROP TABLE IF EXISTS `catelog`;
CREATE TABLE `catelog` (
  `catelogid` int(11) NOT NULL AUTO_INCREMENT,
  `catelogname` varchar(50) DEFAULT NULL,
  `catelogmiaoshu` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`catelogid`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

#
# Data for table "catelog"
#

/*!40000 ALTER TABLE `catelog` DISABLE KEYS */;
INSERT INTO `catelog` VALUES (1,'火锅','火锅'),(2,'川菜','川菜'),(3,'烤肉','烤肉'),(4,'粥类','粥类');
/*!40000 ALTER TABLE `catelog` ENABLE KEYS */;

#
# Structure for table "gonggao"
#

DROP TABLE IF EXISTS `gonggao`;
CREATE TABLE `gonggao` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT '',
  `content` longtext,
  `shijian` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "gonggao"
#

/*!40000 ALTER TABLE `gonggao` DISABLE KEYS */;
INSERT INTO `gonggao` VALUES (1,'端午节活动通知','最好吃的火锅','2020-05-23 16:59:47');
/*!40000 ALTER TABLE `gonggao` ENABLE KEYS */;

#
# Structure for table "goods"
#

DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `goodsId` int(11) NOT NULL AUTO_INCREMENT,
  `goodsName` varchar(1000) DEFAULT '',
  `goodsMiaoshu` text,
  `goodsPic` varchar(255) DEFAULT '',
  `goodsShichangjia` int(11) DEFAULT NULL,
  `goodsCatelogId` int(11) DEFAULT NULL,
  `goodsDel` varchar(20) DEFAULT '',
  `kucun` int(11) DEFAULT '0',
  `zt` int(11) DEFAULT '0',
  `zan` int(11) DEFAULT '0',
  `tj` int(11) DEFAULT '0',
  PRIMARY KEY (`goodsId`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

#
# Data for table "goods"
#

INSERT INTO `goods` VALUES (1,'牛油麻辣','<p>非常香的牛油麻辣</p>','/upload/1586767306576.jpg',25,1,'1',999,0,0,1),(2,'番茄底料','<p>番茄底料</p>','/upload/1586767369952.jpg',18,1,'1',997,0,0,0),(3,'秘制芝麻酱','<p>秘制芝麻酱</p>','/upload/1586767411876.jpg',5,1,'1',999,0,0,0),(4,'蒜泥油碟','<p>蒜泥油碟</p>','/upload/1586767446441.jpg',3,1,'1',1000,0,0,0),(5,'极品鲜毛肚','<p>极品鲜毛肚 300G</p>','/upload/1586767489834.JPG',28,1,'1',997,0,0,1),(6,'羊肉卷','<p>羊肉卷 400g</p>','/upload/1586767525985.JPG',28,1,'1',1000,0,0,0),(7,'竹笋','<p>新鲜竹笋</p>','/upload/1586767570633.JPG',10,1,'1',999,0,0,0),(8,'豆腐','<p>新鲜豆腐</p>','/upload/1586767608579.jpg',5,1,'1',1000,0,0,0),(25,'麻婆豆腐','<p>麻婆豆腐</p>','/upload/1590245025593.jpg',35,2,'1',999,0,1,1),(26,'回锅肉','<p>回锅肉</p>','/upload/1590245062523.jpg',28,2,'1',999,0,1,1),(27,'毛血旺','<p>毛血旺</p>','/upload/1590245105333.jpg',68,2,'1',1000,0,0,0),(28,'小炒肉','<p>小炒肉</p>','/upload/1590245135709.jpg',21,2,'1',1000,0,0,0),(29,'烤猪五花','<p>烤猪五花</p>','/upload/1590245182907.jpg',32,3,'1',1000,0,0,1),(30,'烤牛舌','<p>烤牛舌</p>','/upload/1590245227655.jpg',57,3,'1',1000,0,0,0),(31,'皮蛋廋肉粥','<p>皮蛋廋肉粥</p>','/upload/1590245274032.jpg',5,4,'1',1000,0,0,0),(32,'红枣山药粥','<p>红枣山药粥</p>','/upload/1590245310469.jpg',5,4,'1',1000,0,0,1);

#
# Structure for table "liuyan"
#

DROP TABLE IF EXISTS `liuyan`;
CREATE TABLE `liuyan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(100) DEFAULT NULL,
  `lynr` varchar(255) DEFAULT NULL,
  `lysj` varchar(20) DEFAULT NULL,
  `lyhf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

#
# Data for table "liuyan"
#

INSERT INTO `liuyan` VALUES (1,'25','不错的菜，我很喜欢','2020-05-23 23:03:02','谢谢你的支持');

#
# Structure for table "orderitem"
#

DROP TABLE IF EXISTS `orderitem`;
CREATE TABLE `orderitem` (
  `orderItemId` int(11) NOT NULL AUTO_INCREMENT,
  `orderId` int(11) DEFAULT NULL,
  `goodsId` int(11) DEFAULT NULL,
  `goodsQuantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`orderItemId`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

#
# Data for table "orderitem"
#

/*!40000 ALTER TABLE `orderitem` DISABLE KEYS */;
INSERT INTO `orderitem` VALUES (1,1,25,1),(2,1,26,1);
/*!40000 ALTER TABLE `orderitem` ENABLE KEYS */;

#
# Structure for table "pinglun"
#

DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contents` varchar(500) DEFAULT '',
  `fbsj` varchar(50) DEFAULT NULL,
  `uname` varchar(255) DEFAULT NULL,
  `uhead` varchar(255) DEFAULT NULL,
  `zid` int(11) DEFAULT NULL,
  `huifu` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

#
# Data for table "pinglun"
#

INSERT INTO `pinglun` VALUES (1,'很好吃的豆腐','2020-05-23 23:01:53','李强',NULL,25,' 谢谢你的支持');

#
# Structure for table "torder"
#

DROP TABLE IF EXISTS `torder`;
CREATE TABLE `torder` (
  `orderId` int(11) NOT NULL AUTO_INCREMENT,
  `orderBianhao` varchar(450) DEFAULT NULL,
  `orderDate` varchar(450) DEFAULT NULL,
  `orderZhuangtai` varchar(450) DEFAULT NULL,
  `orderJine` int(11) DEFAULT NULL,
  `orderSonghuodizhi` varchar(450) DEFAULT NULL,
  `orderFukuangfangshi` varchar(450) DEFAULT NULL,
  `orderUserId` varchar(100) DEFAULT NULL,
  `sjfk` int(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `tel` varchar(100) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `zuowei` varchar(50) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`orderId`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

#
# Data for table "torder"
#

/*!40000 ALTER TABLE `torder` DISABLE KEYS */;
INSERT INTO `torder` VALUES (1,'20200523230111','2020-05-23 23:01:11','已完成',63,NULL,NULL,'25',63,'李强','15577777777','',NULL,NULL);
/*!40000 ALTER TABLE `torder` ENABLE KEYS */;

#
# Structure for table "userinfo"
#

DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `upwd` varchar(255) DEFAULT NULL,
  `utype` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

#
# Data for table "userinfo"
#

/*!40000 ALTER TABLE `userinfo` DISABLE KEYS */;
INSERT INTO `userinfo` VALUES (25,'李强','15577777777','123456','3,4');
/*!40000 ALTER TABLE `userinfo` ENABLE KEYS */;

#
# Structure for table "zaninfo"
#

DROP TABLE IF EXISTS `zaninfo`;
CREATE TABLE `zaninfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tcid` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

#
# Data for table "zaninfo"
#

INSERT INTO `zaninfo` VALUES (2,25,25),(3,26,25);