/*
Navicat MySQL Data Transfer

Source Server         : 本地数据库
Source Server Version : 50538
Source Host           : localhost:3306
Source Database       : weicake

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

Date: 2015-05-15 23:52:15
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for yw_article
-- ----------------------------
DROP TABLE IF EXISTS `yw_article`;
CREATE TABLE `yw_article` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `acid` int(11) DEFAULT NULL,
  `atitle` varchar(150) DEFAULT NULL,
  `pic` varchar(300) DEFAULT NULL,
  `keyword` varchar(100) DEFAULT NULL,
  `alink` varchar(300) DEFAULT NULL,
  `des` varchar(150) DEFAULT NULL,
  `content` mediumtext,
  `uid` int(10) DEFAULT NULL,
  `count_click` int(10) DEFAULT '0',
  `create_time` int(13) DEFAULT NULL,
  `top` int(2) DEFAULT '0',
  `isyes` int(2) DEFAULT '0',
  `sort` int(3) DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `aid` (`aid`,`acid`,`atitle`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_article
-- ----------------------------
INSERT INTO `yw_article` VALUES ('31', '13', '联系我们', '', '', '', '', '<p>联系我们:</p><p><br/></p>', '0', '0', '1431703159', '0', '0', '0');
INSERT INTO `yw_article` VALUES ('40', '13', '加盟须知', null, null, '', null, '<p>加盟须知<br/></p>', null, '0', '1431703830', '0', '0', '0');
INSERT INTO `yw_article` VALUES ('36', '13', '服务宗旨', '', '', '', '', '<p>我们的服务宗旨是:<br/></p>', '0', '0', '1431702917', '0', '0', '0');
INSERT INTO `yw_article` VALUES ('37', '13', '关于我们', '', '', '', '', '<p>关于我们<br/></p>', '0', '0', '1431703103', '0', '0', '0');
INSERT INTO `yw_article` VALUES ('41', '13', '小店招聘', null, null, '', null, '<p>小店招聘<br/></p>', null, '0', '1431703844', '0', '0', '0');
INSERT INTO `yw_article` VALUES ('39', '13', '小店介绍', null, null, '', null, '<p>小店介绍<br/></p>', null, '0', '1431703804', '0', '0', '0');

-- ----------------------------
-- Table structure for yw_article_cat
-- ----------------------------
DROP TABLE IF EXISTS `yw_article_cat`;
CREATE TABLE `yw_article_cat` (
  `acid` int(11) NOT NULL AUTO_INCREMENT,
  `afid` int(11) DEFAULT NULL,
  `aname` varchar(80) DEFAULT NULL,
  `dir` char(20) DEFAULT NULL,
  `atop` int(2) DEFAULT '0',
  `apic` varchar(300) DEFAULT NULL,
  `wap` int(2) DEFAULT '0',
  `sort` int(2) DEFAULT '0',
  `keyword` char(200) DEFAULT NULL,
  `ades` char(200) DEFAULT NULL,
  `acreate_time` int(13) DEFAULT NULL,
  `ispic` int(2) DEFAULT '0',
  PRIMARY KEY (`acid`),
  KEY `acid` (`acid`,`afid`,`aname`,`dir`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_article_cat
-- ----------------------------
INSERT INTO `yw_article_cat` VALUES ('13', '0', '常见问题', 'question', '0', '', '0', '0', '', '', '1396075063', '0');
INSERT INTO `yw_article_cat` VALUES ('15', '0', '优惠活动', 'youhui', '0', '', '0', '0', '', '', '1396081003', '0');

-- ----------------------------
-- Table structure for yw_config
-- ----------------------------
DROP TABLE IF EXISTS `yw_config`;
CREATE TABLE `yw_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `cate` int(3) DEFAULT '0' COMMENT '0为基本设置，1为支付设置，2登录设置,3店铺设置,4积分设置',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
  `remark` varchar(100) NOT NULL COMMENT '配置说明',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `value` text NOT NULL COMMENT '配置值',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`),
  KEY `type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_config
-- ----------------------------
INSERT INTO `yw_config` VALUES ('2', '0', 'title', '1', '首页标题', '', '首页标题', '0', '0', '0', '雨薇Cake', '0');
INSERT INTO `yw_config` VALUES ('1', '0', 'name', '1', '网站名称', '', '网站名称或店铺名称', '0', '0', '0', '雨薇Cake', '0');
INSERT INTO `yw_config` VALUES ('3', '0', 'url', '1', '网站URL', '', '网站域名,不带/', '0', '0', '0', 'http://localhost/WeiCake/', '0');
INSERT INTO `yw_config` VALUES ('4', '0', 'logo', '5', 'logo', '', 'logo上传', '0', '0', '0', '/templates/kfc/images/logo/logo.png', '0');
INSERT INTO `yw_config` VALUES ('5', '0', 'key', '1', '关键字', '', '网站SEO关键字', '0', '0', '0', '', '0');
INSERT INTO `yw_config` VALUES ('6', '0', 'des', '2', '网站描述', '', '网站SEO描述', '0', '0', '0', '雨薇Cake', '0');
INSERT INTO `yw_config` VALUES ('7', '0', 'tj', '1', '统计', '', '网站流量统计代码', '0', '0', '0', 'fsdf75765666', '0');
INSERT INTO `yw_config` VALUES ('8', '0', 'isorder', '4', '允许游客下单', '1:允许,0:禁止', '允许游客下单', '0', '0', '1', '1', '1');
INSERT INTO `yw_config` VALUES ('9', '1', 'pos', '3', '货到付款', '', '', '0', '0', '1', '默认为货到付款,', '0');
INSERT INTO `yw_config` VALUES ('11', '4', 'points', '1', '积分设置', '', '税分兑换设置,多少元等于1积分', '0', '0', '0', '144', '0');
INSERT INTO `yw_config` VALUES ('12', '0', 'icp', '1', '网站备案号', '', '网站备案号', '0', '0', '0', 'ICP备19042558号\r\n\r\n', '0');
INSERT INTO `yw_config` VALUES ('13', '3', 'address', '1', '店铺地址', '', '店铺详细地址', '0', '0', '0', 'rew', '0');
INSERT INTO `yw_config` VALUES ('14', '3', 'tel', '1', '店铺电话', '', '店铺电话', '0', '0', '0', '4008-323-323', '0');
INSERT INTO `yw_config` VALUES ('15', '3', 'startpay', '8', '起送金额', '', '起送金额', '0', '0', '0', '0', '0');
INSERT INTO `yw_config` VALUES ('16', '3', 'pspay', '8', '配送费用', '', '配送费用', '0', '0', '0', '0', '0');
INSERT INTO `yw_config` VALUES ('17', '3', 'notice', '2', '店铺公告', '', '店铺公告', '0', '0', '0', '凡2月22日--2月26日在淘宝点外卖，返现50%，期待您的光临。', '0');
INSERT INTO `yw_config` VALUES ('18', '3', 'psarea', '2', '配送区域', '', '配送区域', '0', '0', '0', '肯德基宅急送实行专属菜单及价格。为了保证食物品质，肯德基宅急送有送餐范围和服务时间限制。不同城市、不同送餐范围的菜单有所不同。不同时段产品品项及价格有所不同。详情以输入送餐地址后显示的菜单为准。不设最低起送金额，每单酌收8元外送费。', '0');
INSERT INTO `yw_config` VALUES ('27', '3', 'endtime', '7', '', '', '', '0', '0', '0', '', '0');
INSERT INTO `yw_config` VALUES ('25', '3', 'opentime', '6', '营业时间', '', '', '0', '0', '0', '17:00,19:00', '0');
INSERT INTO `yw_config` VALUES ('28', '5', 'appid', '0', '', '', '', '0', '0', '0', '12525525852', '0');
INSERT INTO `yw_config` VALUES ('29', '5', 'appkey', '0', '', '', '', '0', '0', '0', '88888888855855', '0');
INSERT INTO `yw_config` VALUES ('10', '0', 'islogin', '4', '产品页展示方式', '1:弹窗,0:新页面', '产品页展示方式', '0', '0', '0', '0', '1');
INSERT INTO `yw_config` VALUES ('30', '6', 'SMTP_HOST', '1', 'SMTP服务器', '', 'SMTP服务器', '0', '0', '0', '8781111111111111111111111', '0');
INSERT INTO `yw_config` VALUES ('31', '6', 'SMTP_PORT', '1', 'SMTP服务器端口', '', 'SMTP服务器端口', '0', '0', '0', 'fgfgfgfgfdgdf', '0');
INSERT INTO `yw_config` VALUES ('32', '6', 'SMTP_USER', '1', 'SMTP服务器用户名', '', 'SMTP服务器用户名', '0', '0', '0', '111111111111111', '0');
INSERT INTO `yw_config` VALUES ('33', '6', 'SMTP_PASS', '1', 'SMTP服务器密码', '', 'SMTP服务器密码', '0', '0', '0', '1111111111111111', '0');
INSERT INTO `yw_config` VALUES ('34', '6', 'REPLY_NAME', '1', '回复名称', '', '回复名称（留空则为发件人名称）', '0', '0', '0', '1111111111111111', '0');
INSERT INTO `yw_config` VALUES ('35', '6', 'REPLY_EMAIL', '1', '回复EMAIL', '', '回复EMAIL（留空则为发件人EMAIL）', '0', '0', '0', '111111111111111', '0');
INSERT INTO `yw_config` VALUES ('36', '6', 'FROM_NAME', '1', '发件人名称', '', '发件人名称', '0', '0', '0', '1111111111111111111', '0');
INSERT INTO `yw_config` VALUES ('37', '7', 'webappid', '1', '授权码', '', '请购买授权码，联系QQ:97297326', '0', '0', '0', '11', '0');
INSERT INTO `yw_config` VALUES ('38', '7', 'webkey', '1', '密钥key', '', '', '0', '0', '0', '111', '0');
INSERT INTO `yw_config` VALUES ('39', '6', 'FROM_EMAIL', '1', '发件人邮件', '', '发件人邮件', '0', '0', '0', '', '0');
INSERT INTO `yw_config` VALUES ('40', '6', 'TO_EMAIL', '1', '收件邮件', '', '收件人邮件', '0', '0', '0', '', '0');

-- ----------------------------
-- Table structure for yw_credit
-- ----------------------------
DROP TABLE IF EXISTS `yw_credit`;
CREATE TABLE `yw_credit` (
  `creid` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '充值id',
  `type` int(3) DEFAULT '0' COMMENT '0为加，1为减去',
  `typename` char(200) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL COMMENT '用户id',
  `sid` int(15) DEFAULT NULL,
  `sname` char(100) DEFAULT NULL,
  `source` char(100) DEFAULT NULL,
  `crecount` int(8) DEFAULT NULL,
  `ctime` int(15) DEFAULT NULL,
  `ip` char(100) DEFAULT NULL,
  `etime` int(15) DEFAULT NULL COMMENT '积分失效时间',
  `crecontent` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`creid`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_credit
-- ----------------------------

-- ----------------------------
-- Table structure for yw_creditgood
-- ----------------------------
DROP TABLE IF EXISTS `yw_creditgood`;
CREATE TABLE `yw_creditgood` (
  `cgid` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '充值id',
  `goodname` char(150) DEFAULT '0' COMMENT '0为加，1为减去',
  `goodcontent` varchar(500) DEFAULT NULL,
  `credits` int(10) DEFAULT NULL COMMENT '积分数量',
  `count` int(10) DEFAULT NULL,
  `sid` int(15) DEFAULT NULL,
  `sname` char(100) DEFAULT NULL COMMENT '充值门店名称',
  `goodpic` char(200) DEFAULT NULL,
  `ctime` int(15) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`cgid`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_creditgood
-- ----------------------------
INSERT INTO `yw_creditgood` VALUES ('5', '手机', '有', '55', '10', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('6', '手机相链接', '', '5', '555', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('7', '手机相链接', '', '9789', '5', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('8', '手机相链接', '', '56', '4', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('9', '手机相链接', '', '54', '5', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('10', '手机相链接', '', '55788', '5555', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('11', '0手机相链接', '', '55555', '5', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('12', '手机相链接', '', '55', '5', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('13', '手机相链接', '', '64', '552', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('14', '手机相链接', '', '555', '55', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('15', '手机相链接', '', '815', '55', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('16', '手机相链接', '', '6546', '5', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('17', '手机相链接', '', '6456788', '5', '0', '', '/uploads/fimg/20140330/5337c5b48d4dd.jpg', '0', '0');
INSERT INTO `yw_creditgood` VALUES ('18', '手机相链接', '', '55877', '5', '0', '', '', '0', '0');

-- ----------------------------
-- Table structure for yw_faddress
-- ----------------------------
DROP TABLE IF EXISTS `yw_faddress`;
CREATE TABLE `yw_faddress` (
  `faddid` int(15) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `cityid` int(10) DEFAULT NULL,
  `cityname` char(90) DEFAULT NULL,
  `areaid` int(15) DEFAULT '0',
  `areaname` char(60) DEFAULT NULL,
  `address` char(100) DEFAULT NULL,
  `addtop` int(5) DEFAULT '0',
  `ctime` int(15) DEFAULT NULL,
  `name` char(60) DEFAULT NULL,
  `tel` char(60) DEFAULT NULL,
  PRIMARY KEY (`faddid`),
  KEY `fcid` (`uid`,`areaid`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_faddress
-- ----------------------------
INSERT INTO `yw_faddress` VALUES ('46', '22', '0', '', '0', '', 'fdsfdsf', '0', '1401634755', 'fdsfd', 'sfdsfds');
INSERT INTO `yw_faddress` VALUES ('27', '22', '0', '', '0', '', '4444北京东路22号0000', '0', '0', '545玩友', '鬼地方');

-- ----------------------------
-- Table structure for yw_food
-- ----------------------------
DROP TABLE IF EXISTS `yw_food`;
CREATE TABLE `yw_food` (
  `fid` int(10) NOT NULL AUTO_INCREMENT,
  `fcid` int(10) DEFAULT NULL,
  `fnum` int(10) DEFAULT NULL,
  `fname` char(90) DEFAULT NULL,
  `ftitle` char(150) DEFAULT NULL,
  `fprice` float(10,2) DEFAULT NULL,
  `fcontent` varchar(200) DEFAULT NULL,
  `fpic` char(200) DEFAULT NULL,
  `fsort` int(5) DEFAULT '0',
  `ftop` int(5) DEFAULT '0',
  `fctime` int(16) DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `salecount` int(10) DEFAULT NULL,
  `iswaimai` int(2) DEFAULT '0' COMMENT '是否为外卖',
  PRIMARY KEY (`fid`),
  KEY `fid` (`fid`,`fcid`,`fnum`,`fname`,`fprice`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_food
-- ----------------------------
INSERT INTO `yw_food` VALUES ('82', '19', null, '芒果慕斯', null, '168.00', '谁是炎炎盛夏里最受爱戴的水果明星，当非芒果莫属。妍媚透亮奔放的香，丰腴得饱满欲滴的甜，新鲜清爽的酸，绵细软糯的口感，让人仿佛置身于阳光、沙滩、椰树、芒果飘香的热带风情里。', '/uploads/fimg/20150514/55548924c7735.jpg', '0', '0', '1431609506', '0', null, '0');
INSERT INTO `yw_food` VALUES ('100', '19', null, '苹果慕斯', null, '188.00', '亲手配制的酱料，熬煮玉桂青苹果铺在咖啡慕斯的表面，底层是浓郁气质完美相融。酸甜，俏皮，令人想起初恋的滋味。', '/uploads/fimg/20150514/555497a498e4d.jpg', '0', '0', '1431609372', '0', null, '0');
INSERT INTO `yw_food` VALUES ('84', '19', null, '抹茶相思', null, '168.00', '采用日本京都原产抹茶，它的绿色跟市面上其他品牌抹茶的颜色有明显区别，红豆则是使用日本有机红豆一抹清茶、一缕幽香、丹丹翠烟、平静如湖。', '/uploads/fimg/20150514/55548a5fe6766.jpg', '2', '0', '1431609523', '0', null, '0');
INSERT INTO `yw_food` VALUES ('85', '19', null, '黄梅果榛子慕斯', null, '168.00', '在瑞典，每年的诺贝尔颁奖典礼是人们必看的节目，就像中国人对春晚的情节。2009年的颁奖晚宴上 的一道金黄色的甜点，吸引了众人的目光，同时政府了所有嘉宾的味蕾--这就是i黄梅果榛子蛋糕。 柔滑的顶级榛子酱包裹着极有颗粒感的榛子碎的夹层，配合巧克力慕斯的绵软想起，相似相融；  酸甜一人的黄梅果茸淋面，零星的果仁颗粒细碎的散落。它的登场，无疑让这场激动人心的北欧晚宴锦上添花。', '/uploads/fimg/20150514/55548a179cb2e.jpg', '4', '0', '1431609460', '0', null, '0');
INSERT INTO `yw_food` VALUES ('86', '19', null, '香蕉榛子蛋糕', null, '168.00', '用榛子粉、杏仁粉、提子干做的饼底（不用于一般海绵蛋糕底）口感香、脆，混合了白兰地酒的榛子奶冻。尝过就知道不同了。', '/uploads/fimg/20150514/55548a05d9baf.jpg', '3', '0', '1431609424', '0', null, '0');
INSERT INTO `yw_food` VALUES ('87', '26', null, '芒果芝士', null, '199.00', '芒果香味浓烈，令人充满甜蜜希望，故早期人们称为“蜜望”。无论含义还是色彩都是和爱你的人一起分享。', '/uploads/fimg/20150514/555489b18b678.jpg', '0', '0', '1431603633', '0', null, '0');
INSERT INTO `yw_food` VALUES ('88', '26', null, '四季慕斯芝士', null, '199.00', '春晨，茶韵滴滴相思；夏日，鲜芒甜蜜来袭；秋收，硕果累累喜人；冬夜，黑巧温暖飘香。', '/uploads/fimg/20150514/55548954073d2.jpg', '1', '0', '1431603540', '0', null, '0');
INSERT INTO `yw_food` VALUES ('89', '26', null, '蓝莓芝士', null, '199.00', '清透诱人的蓝莓酱混合醇厚的冻乳酪慕斯，淡淡的乳香中透出丝丝酸甜的果味，生命原来可以这样的安宁和美丽。', '/uploads/fimg/20150514/555475bc34302.jpg', '0', '0', '1431598524', '0', null, '0');
INSERT INTO `yw_food` VALUES ('90', '26', null, '谁动了我的乳酪', null, '199.00', '巧克力的浓郁，杏仁蛋糕坯的香酥，层层迭迭的口感，仿佛味蕾在这巧克力舞台上的舞蹈。', '/uploads/fimg/20150514/5554765a031f3.jpg', '0', '0', '1431598682', '0', null, '0');
INSERT INTO `yw_food` VALUES ('91', '27', null, '西西里的优雅浪漫', null, '199.00', '电影《西西里的美丽传说》中的女主角玛莲娜有着摄人心脾的美丽，让所有的女人乃至男人妒忌，Influence Cake同样让那些绝大多数的蛋糕黯然失色。由于主材的产量极少，就算在欧洲，她曾经都是那么遥不可及，可如今将她的优雅、浪漫的情怀带到您身边。', '/uploads/fimg/20150514/5554778145034.jpg', '0', '0', '1431603667', '0', null, '0');
INSERT INTO `yw_food` VALUES ('92', '27', null, '王室沙哈酱', null, '199.00', '柔滑的巧克力淋浆和口感细腻的巧克力蛋糕，夹心是黄梅果果酱和秘制巧克力酱，一解你的巧克力之痒。', '/uploads/fimg/20150514/5554790659182.jpg', '0', '0', '1431600151', '0', null, '0');
INSERT INTO `yw_food` VALUES ('93', '27', null, '黑金暗香', null, '199.00', '55%可可脂黑巧，法式香草布蕾，丝滑中包裹着柔嫩。\r\n', '/uploads/fimg/20150514/5554811f35192.jpg', '0', '0', '1431601439', '0', null, '0');
INSERT INTO `yw_food` VALUES ('94', '28', null, '香草开心果饼干', null, '25.00', '香草在英文的注释中是：甜蜜的草“Sweetgrass”。无论是在阳光宜人的午后；好友相聚深夜；还是留给自己独享的散漫空间里，这一份温暖酥脆的“甜蜜”和“开心”是必不可少。', '/uploads/fimg/20150514/555482cc7438a.jpg', '0', '0', '1431609690', '0', null, '0');
INSERT INTO `yw_food` VALUES ('95', '28', null, '柠檬榛子饼干', null, '25.00', '如晨曦的第一缕阳光，新鲜柠檬皮与榛子相伴，清新透亮，果香轻盈，层次细腻。用它来唤醒沉睡中的味蕾，开启美好快乐的一天。\r\n', '/uploads/fimg/20150514/555483aa27f8a.jpg', '0', '0', '1431609676', '0', null, '0');
INSERT INTO `yw_food` VALUES ('96', '28', null, '巧克力核桃饼干', null, '25.00', '香浓巧克力与核桃的完美结合，香甜酥松。间中无添加酿造的橙皮透出一丝小清新，味觉丰富。大大的满足了巧克力的钟爱者，而饼干中充满不饱和脂肪酸的核桃果仁又平衡了你的健康与纠结。', '/uploads/fimg/20150514/555484b47200a.jpg', '0', '0', '1431609660', '0', null, '0');
INSERT INTO `yw_food` VALUES ('97', '28', null, '抹茶杏仁饼干', null, '25.00', '抹茶是春天的味道。轻轻的闭上眼睛，迎向拂面的风，你听得见闻得到世间那最美的一抹新绿。IDIK\r\n选用最为顶尖的日本DK抹茶，搭配美国加州大杏仁精心烘培而就的抹茶杏仁饼干，清新自然，甜度适宜，是闺蜜们聚会\r\n分享下午茶的心水之选。', '/uploads/fimg/20150514/555485a8389d8.jpg', '0', '0', '1431609647', '0', null, '0');
INSERT INTO `yw_food` VALUES ('98', '28', null, '红枣碧根果饼干', null, '25.00', '混合了浓郁的枣香；富含蛋白质，氨基酸和维生素等营养价值的美国碧根果，还有一片感恩之心研制的手工饼干，温润与见识的如同老祖母宽厚的怀抱，在忙碌了大半天的午后，它会及时的为你补充能量与活力。\r\n', '/uploads/fimg/20150514/555486b255f76.jpg', '0', '0', '1431609636', '0', null, '0');
INSERT INTO `yw_food` VALUES ('99', '28', null, '燕麦提子饼干', null, '25.00', '天然质朴带着谷香的燕麦，甘甜醇厚有着嚼劲的提子干，它们收集了整个夏季阳光的精髓和乐观，\r\n不含杂质与任何添加，精研细作，还原大自然的本质，让健康与美味有了更多的选择，这也是我们秉承的品牌理念与生活态度。', '/uploads/fimg/20150514/555487978e63d.jpg', '0', '0', '1431609621', '0', null, '0');
INSERT INTO `yw_food` VALUES ('103', '19', null, '欧式方形蛋糕', null, '198.00', '抹茶与黄梅果是初夏的凉风与灿烂，携风吹过山丘留下漫不经心的水果。', '/uploads/fimg/20150514/55549b7a27e41.jpg', '0', '0', '1431609305', '0', null, '0');
INSERT INTO `yw_food` VALUES ('104', '19', null, '巴黎情人', null, '208.00', '玫瑰有约，邂逅巴黎。红与黑的相遇，热情而高雅，每一口都是浓情蜜意的法式浪漫。\r\n', '/uploads/fimg/20150514/55549c432d623.jpg', '0', '0', '1431609258', '0', null, '0');
INSERT INTO `yw_food` VALUES ('105', '19', null, '榴莲芒果双拼', null, '168.00', '榴莲，难以逃避的霸道香味；芒果，难以抵挡的诱惑香甜；难以取舍，何不一次满足自己小小的“贪心”，一起感受榴莲与芒果合奏的美味的歌。\r\n', '/uploads/fimg/20150514/55549e83d9415.jpg', '0', '0', '1431609288', '0', null, '0');
INSERT INTO `yw_food` VALUES ('106', '26', null, '榴莲芝士', null, '168.00', '“榴莲忘返”已经撬开了味蕾，一袭素雅净白里等待着你的是怎样难以抵挡的诱惑。浓郁的芝士味混合着迷人的榴莲香，口腔里还有依稀回荡的白兰地，仿佛踏上繁华热闹的异域之旅...\r\n', '/uploads/fimg/20150514/5554a2e62c734.jpg', '0', '0', '1431610086', '0', null, '0');
INSERT INTO `yw_food` VALUES ('107', '26', null, '提拉米苏', null, '258.00', '松软细腻的意大利马士卡帮芝士，混合了迷人的意式特浓咖啡，以及意大利杏仁利口酒和顶级可可粉。入口时，芝士的香滑、咖啡的苦涩、杏仁酒的甘浓，交织成馥郁难忘的专属味道，让人不由得想起那个恒古流传的实验：带我走......', '/uploads/fimg/20150514/5554a481472fe.jpg', '0', '0', '1431610497', '0', null, '0');
INSERT INTO `yw_food` VALUES ('108', '29', null, '榴莲忘返', null, '166.00', '榴莲凭着它那独特的香味，滑似奶膏的果肉，令爱吃之人久久不能忘怀。用榴莲做成的蛋糕，混合了奶油的乳香，冷藏后绝对堪比榴莲冰淇淋。\r\n', '/uploads/fimg/20150514/5554a603ea4d3.jpg', '0', '0', '1431610906', '0', null, '0');
INSERT INTO `yw_food` VALUES ('109', '29', null, '玫瑰情人', null, '168.00', '百利甜酒的加入与淡奶油产生的奇妙反应，就像爱情的突然发生......\r\n', '/uploads/fimg/20150514/5554a696bd7a0.jpg', '0', '0', '1431611031', '0', null, '0');
INSERT INTO `yw_food` VALUES ('110', '29', null, '红黄白绿', null, '168.00', '各种水果夹着百利酒淡淡的香味，在你的口腔一层一层的绽放。（蛋糕所用水果因季节原因，同图片上会有少许不同）', '/uploads/fimg/20150514/5554a80c46e9c.jpg', '0', '0', '1431611404', '0', null, '0');
INSERT INTO `yw_food` VALUES ('111', '29', null, '黑森林巧克力', null, '168.00', '黑色巧克力碎屑让人联想起美丽的黑森林，然而真正的主角并非来自性感的黑巧克力，而是来自那浸满樱桃酒的可可坯和极具诱惑的樱桃，绝对经得起各种口味的挑剔。', '/uploads/fimg/20150514/5554ab33cef21.jpg', '0', '0', '1431612212', '0', null, '0');
INSERT INTO `yw_food` VALUES ('114', '19', null, '四季慕斯芝士', null, '199.00', '春晨，茶韵滴滴相思；夏日，鲜芒甜蜜来袭；秋收，硕果累累喜人；冬夜，黑巧温暖飘香。', '/uploads/fimg/20150514/5554aeab8622f.jpg', '0', '0', '1431613099', '0', null, '0');
INSERT INTO `yw_food` VALUES ('115', '29', null, '榴莲芒果双拼', null, '168.00', '榴莲，难以逃避的霸道香味；芒果，难以抵挡的诱惑香甜；难以取舍，何不一次满足自己小小的“贪心”，一起感受榴莲与芒果合奏的美味的歌。', '/uploads/fimg/20150514/5554af1d825b7.jpg', '0', '0', '1431613213', '0', null, '0');
INSERT INTO `yw_food` VALUES ('113', '29', null, '栗香融融', null, '188.00', '细密香浓的栗香，混合香甜的淡奶油，再以白兰地酒调味，温柔敦实的味道，为午后倦怠的心情画上完美的句号。', '/uploads/fimg/20150514/5554ac403f3ba.jpg', '0', '0', '1431612480', '0', null, '0');
INSERT INTO `yw_food` VALUES ('116', '29', null, '四季慕斯芝士', null, '288.00', '春晨，茶韵滴滴相思；夏日，鲜芒甜蜜来袭；秋收，硕果累累喜人；冬夜，黑巧温暖飘香。', '/uploads/fimg/20150514/5554af7770d06.jpg', '0', '0', '1431613303', '0', null, '0');
INSERT INTO `yw_food` VALUES ('117', '29', null, '巴黎情人', null, '208.00', '玫瑰有约，邂逅巴黎。红与黑的相遇，热情而高雅，每一口都是浓情蜜意的法式浪漫。', '/uploads/fimg/20150514/5554afc0eab0a.jpg', '0', '0', '1431613377', '0', null, '0');
INSERT INTO `yw_food` VALUES ('118', '29', null, '黄梅果榛子蛋糕', null, '168.00', '在瑞典，每年的诺贝尔颁奖典礼是人们必看的节目，就像中国人对春晚的情节。2009年的颁奖晚宴上\r\n          的一道金黄色的甜点，吸引了众人的目光，同时政府了所有嘉宾的味蕾--这就是i黄梅果榛子蛋糕。柔滑的顶级榛子酱包裹着极有颗粒感的榛子碎的夹层，配合巧克力慕斯的绵软想起，相似相融； 酸甜一人的黄梅果茸淋面，零星的果仁颗粒细碎的散落。它的登场，无疑让这场激动人心的北欧晚宴锦上添花。', '/uploads/fimg/20150514/5554aff78f697.jpg', '0', '0', '1431613431', '0', null, '0');

-- ----------------------------
-- Table structure for yw_foodcat
-- ----------------------------
DROP TABLE IF EXISTS `yw_foodcat`;
CREATE TABLE `yw_foodcat` (
  `fcid` int(10) NOT NULL AUTO_INCREMENT,
  `fcname` char(90) DEFAULT NULL,
  `fpid` int(15) DEFAULT '0',
  `fcsort` int(5) DEFAULT '0',
  `fctop` int(5) DEFAULT '0',
  `ctime` int(15) DEFAULT NULL,
  `sid` int(10) DEFAULT NULL,
  `fcount` int(5) DEFAULT NULL,
  PRIMARY KEY (`fcid`),
  KEY `fcid` (`fcid`,`fcname`,`fpid`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_foodcat
-- ----------------------------
INSERT INTO `yw_foodcat` VALUES ('19', '慕斯系列', '0', '0', '0', '1396161410', '0', '0');
INSERT INTO `yw_foodcat` VALUES ('29', '乳脂果仁系列', '0', '0', '0', '1431610849', null, null);
INSERT INTO `yw_foodcat` VALUES ('28', '手工饼干', '0', '0', '0', '1431601578', null, null);
INSERT INTO `yw_foodcat` VALUES ('26', '芝士蛋糕', '0', '0', '0', '1431596657', null, null);
INSERT INTO `yw_foodcat` VALUES ('27', '巧克力蛋糕', '0', '0', '0', '1431599336', null, null);

-- ----------------------------
-- Table structure for yw_foodorder
-- ----------------------------
DROP TABLE IF EXISTS `yw_foodorder`;
CREATE TABLE `yw_foodorder` (
  `oid` int(30) NOT NULL AUTO_INCREMENT,
  `orderprice` float(10,2) DEFAULT NULL,
  `ordercount` int(10) DEFAULT NULL,
  `zhekou` float(10,2) DEFAULT NULL,
  `pay` float(10,2) DEFAULT NULL,
  `paytype` int(2) DEFAULT '0',
  `ucount` int(10) DEFAULT '0',
  `uid` int(15) DEFAULT NULL,
  `uname` char(60) DEFAULT NULL,
  `pid` char(100) DEFAULT NULL,
  `shopspay` int(11) DEFAULT '0' COMMENT '配送费用',
  `shopname` char(100) DEFAULT NULL,
  `gid` char(90) DEFAULT NULL,
  `order_ctime` int(16) DEFAULT NULL,
  `order_endtime` int(16) DEFAULT NULL,
  `print_time` int(16) DEFAULT NULL,
  `print_name` char(100) DEFAULT NULL,
  `morecontent` char(200) DEFAULT NULL,
  `otel` char(80) DEFAULT NULL,
  `oman` char(100) DEFAULT NULL,
  `oaddress` char(200) DEFAULT NULL,
  `orderstatus` int(1) DEFAULT '1',
  `ordersource` char(40) DEFAULT NULL,
  `couponid` int(30) DEFAULT '0',
  `order_dtime` datetime DEFAULT NULL,
  PRIMARY KEY (`oid`),
  KEY `oid` (`oid`,`orderprice`,`ordercount`,`orderstatus`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 CHECKSUM=1;

-- ----------------------------
-- Records of yw_foodorder
-- ----------------------------
INSERT INTO `yw_foodorder` VALUES ('80', '22.00', '2', '0.00', '0.00', '0', '0', '72', '122111', 'b5m0qdokkssepp4amm1209lng5', '0', '', '', '1401679568', '0', '0', '', '5453543', 'fdsf', 'fds', 'fdsfs', '4', '', '0', '2014-06-02 11:30:02');

-- ----------------------------
-- Table structure for yw_foodorderext
-- ----------------------------
DROP TABLE IF EXISTS `yw_foodorderext`;
CREATE TABLE `yw_foodorderext` (
  `oid` bigint(30) DEFAULT NULL,
  `did` int(6) DEFAULT NULL,
  `fid` int(6) DEFAULT NULL,
  `fname` char(100) DEFAULT NULL,
  `fcid` int(15) DEFAULT NULL,
  `fcname` char(100) DEFAULT NULL,
  `fprice` float(10,2) DEFAULT NULL,
  `fcount` int(10) DEFAULT NULL,
  `prices` float(10,2) DEFAULT NULL,
  `muid` int(15) DEFAULT NULL,
  `muname` char(100) DEFAULT NULL,
  `time` int(10) DEFAULT NULL,
  `fenliang` char(100) DEFAULT NULL,
  `kouwei` char(100) DEFAULT NULL,
  `call_time` int(16) DEFAULT NULL,
  `print_time` int(16) DEFAULT NULL,
  `end_time` int(16) DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `gid` char(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_foodorderext
-- ----------------------------
INSERT INTO `yw_foodorderext` VALUES ('45', '0', '61', '培根鸡腿燕麦堡套餐B', '0', '', '32.50', '1', '32.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('45', '0', '63', '藤椒麻香鸡腿堡套餐A', '0', '', '25.50', '1', '25.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('45', '0', '60', 'D培根鸡腿燕麦堡套餐A', '0', '', '35.50', '1', '35.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('45', '0', '71', '雪菜粥热豆浆油条餐', '0', '', '15.50', '1', '15.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('45', '0', '70', '瘦肉粥热豆浆油条餐', '0', '', '17.50', '1', '17.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('46', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('46', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('46', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '1', '75.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('47', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('47', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('47', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('47', '0', '78', '九珍果汁饮料', '0', '', '15.00', '1', '15.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('48', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('48', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('48', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('49', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('49', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('49', '0', '77', '吮指原味鸡套餐B', '0', '', '34.50', '1', '34.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('50', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('50', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('50', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '1', '75.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('50', '0', '77', '吮指原味鸡套餐B', '0', '', '34.50', '1', '34.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('51', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('51', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('51', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '1', '75.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('52', '0', '62', '培根鸡腿燕麦堡套餐C', '0', '', '35.50', '1', '35.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('52', '0', '61', '培根鸡腿燕麦堡套餐B', '0', '', '32.50', '1', '32.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('52', '0', '65', '培根鸡腿燕麦堡', '0', '', '17.50', '1', '17.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('53', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('53', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('54', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('54', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('55', '0', '71', '雪菜粥热豆浆油条餐', '0', '', '15.50', '1', '15.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('55', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('55', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('55', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '1', '75.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('55', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('56', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('57', '0', '78', '九珍果汁饮料', '0', '', '15.00', '1', '15.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('57', '0', '71', '雪菜粥热豆浆油条餐', '0', '', '15.50', '1', '15.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('58', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('58', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('59', '0', '73', '五味小吃桶升级版', '0', '', '50.00', '1', '50.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('59', '0', '75', '饭堡双人餐', '0', '', '50.00', '1', '50.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('59', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '1', '75.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('59', '0', '77', '吮指原味鸡套餐B', '0', '', '34.50', '1', '34.50', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('59', '0', '78', '九珍果汁饮料', '0', '', '15.00', '1', '15.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('59', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('59', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('60', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('60', '0', '78', '九珍果汁饮料', '0', '', '15.00', '1', '15.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('60', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('60', '0', '73', '五味小吃桶升级版', '0', '', '50.00', '1', '50.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('61', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('62', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('63', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('64', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('64', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('65', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('66', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('66', '0', '75', '饭堡双人餐', '0', '', '50.00', '1', '50.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('66', '0', '74', '堡堡双人餐', '0', '', '80.00', '1', '80.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('66', '0', '73', '五味小吃桶升级版', '0', '', '50.00', '1', '50.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('66', '0', '78', '九珍果汁饮料', '0', '', '15.00', '1', '15.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('67', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '2', '150.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('68', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('68', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('69', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('69', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('70', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('71', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('71', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '1', '75.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('72', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('72', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('73', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('74', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('74', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('74', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('75', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('76', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('76', '0', '76', '九块吮指原味鸡', '0', '', '75.00', '1', '75.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('77', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('77', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('78', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('78', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('79', '0', '81', '土豆泥', '0', '', '6.00', '1', '6.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('80', '0', '79', '1.25升装百事可乐', '0', '', '12.00', '1', '12.00', '0', '', '0', '', '', '0', '0', '0', '0', '');
INSERT INTO `yw_foodorderext` VALUES ('80', '0', '80', '菌菇四宝汤', '0', '', '10.00', '1', '10.00', '0', '', '0', '', '', '0', '0', '0', '0', '');

-- ----------------------------
-- Table structure for yw_link
-- ----------------------------
DROP TABLE IF EXISTS `yw_link`;
CREATE TABLE `yw_link` (
  `lid` int(10) NOT NULL AUTO_INCREMENT,
  `type` int(1) DEFAULT '0',
  `linkname` varchar(200) DEFAULT NULL,
  `link` varchar(300) DEFAULT NULL,
  `linkpic` varchar(300) DEFAULT NULL,
  `des` varchar(300) DEFAULT NULL,
  `content` varchar(300) DEFAULT NULL,
  `top` int(2) DEFAULT '0',
  `create_time` int(15) DEFAULT NULL,
  `isweb` int(1) DEFAULT '0',
  PRIMARY KEY (`lid`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of yw_link
-- ----------------------------
INSERT INTO `yw_link` VALUES ('17', '1', '3', 'http://', './uploads/aimg/9885883_013816151000_2.jpg', null, null, '0', '1431600898', '0');
INSERT INTO `yw_link` VALUES ('16', '1', '2', 'http://', './uploads/aimg/2704568_173058678176_2.jpg', null, null, '0', '1431600879', '0');
INSERT INTO `yw_link` VALUES ('15', '1', '1', 'http://', './uploads/aimg/9885883_162630058000_2.jpg', null, null, '0', '1431600867', '0');
INSERT INTO `yw_link` VALUES ('18', '0', '雅荷之家', 'http://he29.com', null, null, null, '0', '1431703614', '0');
INSERT INTO `yw_link` VALUES ('19', '0', '百度一下', 'http://www.baidu.com', null, null, null, '0', '1431703625', '0');

-- ----------------------------
-- Table structure for yw_members
-- ----------------------------
DROP TABLE IF EXISTS `yw_members`;
CREATE TABLE `yw_members` (
  `uid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `username` char(60) NOT NULL,
  `userpass` char(90) NOT NULL DEFAULT '',
  `userpic` varchar(200) NOT NULL,
  `useremail` varchar(100) NOT NULL DEFAULT '',
  `usertel` int(15) DEFAULT '0',
  `nickname` varchar(50) DEFAULT NULL,
  `userqq` int(15) NOT NULL,
  `usersex` int(3) DEFAULT NULL,
  `usergroup` int(8) DEFAULT '0',
  `last_login_ip` varchar(16) NOT NULL,
  `last_login_time` int(15) DEFAULT NULL,
  `create_time` int(15) DEFAULT NULL,
  `userlevel` varchar(60) NOT NULL DEFAULT '0',
  `userpoint` smallint(6) DEFAULT '0',
  `userstatus` int(11) NOT NULL DEFAULT '0',
  `gid` char(100) DEFAULT NULL,
  PRIMARY KEY (`uid`),
  KEY `user_nicename` (`nickname`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_members
-- ----------------------------
INSERT INTO `yw_members` VALUES ('1', 'admin', '96e79218965eb72c92a549dd5a330112', '', '111@11.com', '0', '', '0', '1', '99', '127.0.0.1', '1431617219', '1431702576', '99', '0', '0', '');

-- ----------------------------
-- Table structure for yw_message
-- ----------------------------
DROP TABLE IF EXISTS `yw_message`;
CREATE TABLE `yw_message` (
  `msid` int(10) NOT NULL AUTO_INCREMENT,
  `mtype` int(1) DEFAULT '0',
  `sid` int(10) DEFAULT NULL,
  `sname` char(100) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `uname` char(200) DEFAULT NULL,
  `upic` char(200) DEFAULT NULL,
  `mcontent` varchar(600) DEFAULT NULL,
  `pid` int(10) DEFAULT '0',
  `top` int(2) DEFAULT '0',
  `create_time` int(15) DEFAULT NULL,
  `isweb` int(1) DEFAULT '0',
  PRIMARY KEY (`msid`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of yw_message
-- ----------------------------

-- ----------------------------
-- Table structure for yw_pages
-- ----------------------------
DROP TABLE IF EXISTS `yw_pages`;
CREATE TABLE `yw_pages` (
  `pagid` int(11) NOT NULL AUTO_INCREMENT,
  `page_fid` int(11) DEFAULT '0',
  `pagedir` char(30) DEFAULT NULL,
  `page_title` varchar(150) DEFAULT NULL,
  `page_content` mediumtext,
  `page_header` varchar(1000) DEFAULT NULL,
  `page_footer` varchar(1000) DEFAULT NULL,
  `page_key` char(100) DEFAULT NULL,
  `page_des` char(200) DEFAULT NULL,
  `pic` varchar(300) DEFAULT NULL,
  `pic2` varchar(300) DEFAULT NULL,
  `pic3` varchar(300) DEFAULT NULL,
  `pic4` varchar(300) DEFAULT NULL,
  `sort` int(2) DEFAULT '0',
  `create_time` int(13) DEFAULT NULL,
  `page_top` int(1) DEFAULT '0',
  PRIMARY KEY (`pagid`),
  KEY `pagid` (`pagid`,`pagedir`,`page_title`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yw_pages
-- ----------------------------
INSERT INTO `yw_pages` VALUES ('11', '0', 'about', '关于我们', '', '', '', '', '', '', '', '', '', '0', '1431604213', '0');
INSERT INTO `yw_pages` VALUES ('12', '0', 'add', '加入我们', '<p>fdsf</p>', '', '', '', '', '', '', '', '', '0', '1396074928', '0');
INSERT INTO `yw_pages` VALUES ('13', '0', 'yins', '隐私条款', '<p>fdsfdfdyyyy</p>', '', '', '', '', '', '', '', '', '0', '1396087696', '0');
INSERT INTO `yw_pages` VALUES ('14', '0', 'law', '法律条款', '<p>欢迎您使用肯德基宅急送网络订餐服务，包括但不限于通过肯德基宅急送互联网订餐网站，肯德基宅急送手机App订餐客户端，以及肯德基宅急送基于互联网或手机上网功能开发的其他订餐平台（如肯德基宅急送移动互联网订餐网站），提供的服务（以下简称“我们的服务”）。请仔细阅读本法律条款。您使用我们的服务即表示您已同意本条款。我们的服务范围可能会拓展，因此有时还会适用一些附加条款或要求。附加条款将会与相关服务一同提供，并且在您使用这些服务后，成为您与我们所达成的协议的一部分。本法律条款适用于您当前及未来使用的我们的服务。</p><p><strong class="ersee-lp-subtitle-bottom"></strong></p><ul class=" list-paddingleft-2"><li><p>我们的服务中所涉及的商标、服务标志、设计、文字或图案及相关知识产权等均属百胜咨询（上海）有限公司或其关联公司（以下简称：百胜公司）所有、或已取得所有人的正式授权，受法律保护，在未取得百胜公司或有关第三方书面授权之前，任何人不得擅自使用，包括但不限于复制、复印、修改、出版、公布、传送、分发我们的服务中使用的文本、图象、影音、镜像等内容，否则将承担相应法律责任。使用我们的服务并不让您拥有我们的服务或您所访问的内容的任何知识产权。本条款并未授予您使用我们的服务中所用的任何商标、标志、设计、文字等的权利。</p></li><li><p>我们在提供服务时将会尽到商业上合理水平的技能和注意义务，希望您会喜欢我们的服务，但有些关于服务的事项恕我们无法作出承诺。因此，在法律允许的范围内，我们的服务对信息的准确性和及时性不给予任何明示或默示的保证。我们的服务不承担因您进入或使用我们的服务而导致的任何直接的、间接的、意外的、因果性的损害责任。请使用合法软件和设备。</p></li><li><p>您在使用我们的服务时，可以自愿选择是否提交个人信息资料。如果您提交个人信息，即表示您接受我们的服务隐私权条款，我们的服务对于您的个人信息和隐私权予以尊重和保密。您在使用我们的服务时传送的任何其他资料、信息，包括但不限于意见、客户反馈、喜好、建议、支持、请求、问题等内容，将被当作非保密资料和非专有资料处理；您的传送行为即表示您同意这些资料用作我们的调查、统计等目的而由我们无偿使用。</p></li><li><p>当您在使用我们的服务时，某些信息可以通过各种技术和方法不经您主动提供而被收集，这些方法包括IP地址、Cookies，设备信息，日志数据收集等。这些信息不足以使他人辨认您个人的身份，收集上述信息的目的旨在为您提供更完善的服务。</p></li><li><p>您在使用我们的服务时不得传送和发放带有中伤、诽谤、造谣、色情及其他违法或不道德的资料和言论，我们有权对此进行管理和监督，但并不对您的上述行为承担任何责任。</p></li><li><p>我们的服务无意向18岁以下未成年人提供网络订餐服务或收集个人信息，家长或监护人应承担未成年人在网络环境下的隐私权的首要责任。请家长或监护人对其子女或被监护人使用我们的服务进行监管和负责。由于我们的服务无法辨认用户是否为未成年人，因此如有未成年人使用我们的服务，则表示其已获得家长或监护人认可，任何相关后果由其家长或监护人承担。</p></li><li><p>如果我们的服务提供了第三方网站链接，仅仅是为了向您提供便利。如果您使用这些链接，您将离开本站。我们无法评估此类第三方网站，也不对任何此类第三方网站或这些网站提供的产品、服务或内容负责。因此，对于此类第三方网站，或此类网站上提供的任何信息、软件、产品、服务或材料，或使用这些网站可能得到的任何结果，您需自行评估及承担使用风险。</p></li><li><p>我们可以修改本条款或相关条款并会予以更新和公布，所有修改的适用不具有追溯力。但是，对服务新功能的特别修改或由于法律原因所作的修改将立即生效。如果您不同意服务的修改条款，应停止使用我们的服务。</p></li></ul><p></p>', '', '', '', '', '', '', '', '', '0', '1396074998', '0');
INSERT INTO `yw_pages` VALUES ('15', '0', 'pays', '支付方式', '<p>支付方式内容编辑　</p>', '', '', '', '', '', '', '', '', '0', '1397633115', '0');
INSERT INTO `yw_pages` VALUES ('16', '0', 'sess', '服务费用', '<p>服务费用</p>', '', '', '', '', '', '', '', '', '0', '1397633186', '0');