【小程序毕业设计】小程序乐器商城源码（完整前后端+mysql+说明文档）.zip

-- phpMyAdmin SQL Dump -- version phpStudy 2014 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 07, 2021 at 06:00 PM -- Server version: 5.5.36 -- PHP Version: 5.3.28 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `shangcheng1` -- -- -------------------------------------------------------- -- -- Table structure for table `eat_addrs` -- CREATE TABLE IF NOT EXISTS `eat_addrs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `addrs_name` varchar(255) DEFAULT NULL COMMENT '地址', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地址表' AUTO_INCREMENT=7 ; -- -- Dumping data for table `eat_addrs` -- INSERT INTO `eat_addrs` (`id`, `user_id`, `addrs_name`) VALUES (1, 1, '111'), (2, 1, 'waefawgvwefv|1564651|aofjnajbnca王佛啊女哦那'), (3, 1, 'waefawgvwefv|1564651|aofjnajbnca王佛啊女哦那|奥烦恼念佛按佛按我阿奎那打开能否'), (4, 20, 'waefawgvwefv|1564651|aofjnajbnca王佛啊女哦那|奥烦恼念佛按佛按我阿奎那打开能否'), (5, 20, '啊手动阀|17856444444|HLS小酒馆(小寨店)|啊手动阀'), (6, 20, 'qqq|15422222222|华旗国际广场B座|ASEDF'); -- -------------------------------------------------------- -- -- Table structure for table `eat_evaluate` -- CREATE TABLE IF NOT EXISTS `eat_evaluate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL COMMENT '订单ID', `remark` varchar(255) DEFAULT NULL COMMENT '评论内容', `img_url` varchar(255) DEFAULT NULL COMMENT '图片路径', `create_date` datetime DEFAULT NULL COMMENT '评价时间', `hold1` varchar(255) DEFAULT NULL COMMENT '预留1', `hold2` varchar(255) DEFAULT NULL COMMENT '预留2', `hold3` varchar(255) DEFAULT NULL COMMENT '预留3', `hold4` varchar(255) DEFAULT NULL COMMENT '预留4', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论表' AUTO_INCREMENT=2 ; -- -- Dumping data for table `eat_evaluate` -- INSERT INTO `eat_evaluate` (`id`, `order_id`, `remark`, `img_url`, `create_date`, `hold1`, `hold2`, `hold3`, `hold4`) VALUES (1, 7, 'ASD阿斯顿AAD', NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `eat_goods` -- CREATE TABLE IF NOT EXISTS `eat_goods` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `doods_name` varchar(255) DEFAULT NULL COMMENT '商品名称', `goods_type` varchar(255) DEFAULT NULL COMMENT '商品分类', `goods_money` decimal(10,0) DEFAULT NULL COMMENT '商品价格', `img_url` varchar(255) DEFAULT NULL COMMENT '商品图片', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `hold1` varchar(255) DEFAULT NULL COMMENT '是否推荐', `desc1` varchar(255) DEFAULT NULL COMMENT '描述', `maincontain` varchar(255) DEFAULT NULL COMMENT '主料', `mouth` varchar(255) DEFAULT NULL COMMENT '口感描述', `goods_number` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品表' AUTO_INCREMENT=13 ; -- -- Dumping data for table `eat_goods` -- INSERT INTO `eat_goods` (`id`, `doods_name`, `goods_type`, `goods_money`, `img_url`, `create_date`, `hold1`, `desc1`, `maincontain`, `mouth`, `goods_number`) VALUES (8, '立式钢琴1', '立式钢琴', '1200', 'http://192.168.2.16:80/upload/cbbe0d93-ae4d-4165-a33c-b8556aceb812.png', NULL, '是', '啊手动阀手动阀手动阀手动阀', NULL, NULL, 100), (9, '立式钢琴2', '立式钢琴', '1300', '', NULL, '是', '', NULL, NULL, 200), (10, '三角钢琴1', '三角钢琴', '1000', 'http://192.168.2.16:80/upload/badd4a1f-109c-4af3-9bf8-5c4405cdc8cb.png', NULL, '否', '啊手动阀手动阀', NULL, NULL, 300), (11, '自动钢琴1', '自动钢琴', '1400', 'http://192.168.2.16:80/upload/09c91fe3-25b5-422b-9eb4-d52edec1b47c.png', NULL, '是', '啊手动阀手动阀', NULL, NULL, 50), (12, '立式钢琴3', '立式钢琴', '4500', 'http://192.168.2.16:80/upload/92ff666a-34cc-4785-a7f4-ed653ff0c560.png', NULL, '是', 'ASDFASDFASDF', NULL, NULL, 150); -- -------------------------------------------------------- -- -- Table structure for table `eat_img` -- CREATE TABLE IF NOT EXISTS `eat_img` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `img_url` varchar(255) DEFAULT NULL COMMENT '图片路径', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `hold1` varchar(255) DEFAULT NULL, `hold2` varchar(255) DEFAULT NULL, `hold3` varchar(255) DEFAULT NULL, `hold4` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='轮播图' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `eat_order` -- CREATE TABLE IF NOT EXISTS `eat_order` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `user_id` int(11) NOT NULL COMMENT '用户ID', `goods_id` varchar(255) NOT NULL COMMENT '商品Id列表', `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称', `goods_num` int(11) DEFAULT NULL COMMENT '商品数量', `order_all_money` decimal(10,0) NOT NULL COMMENT '商品总价', `order_status` varchar(255) DEFAULT '0' COMMENT '订单状态G购物车0待付款1待收货2待评价', `order_code` varchar(255) DEFAULT NULL COMMENT '取餐码', `create_date` datetime DEFAULT NULL COMMENT '下单时间', `pay_date` datetime DEFAULT NULL COMMENT '支付时间', `desc1` varchar(255) DEFAULT NULL COMMENT '备注', `type1` varchar(255) DEFAULT NULL COMMENT '就餐方式', `addrs_name` varchar(255) DEFAULT NULL COMMENT 'hold3', `hold4` varchar(255) DEFAULT NULL COMMENT 'hold4', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表' AUTO_INCREMENT=8 ; -- -- Dumping data for table `eat_order` -- INSERT INTO `eat_order` (`id`, `user_id`, `goods_id`, `goods_name`, `goods_num`, `order_all_money`, `order_status`, `order_code`, `create_date`, `pay_date`, `desc1`, `type1`, `addrs_name`, `hold4`) VALUES (3, 20, '8', '立式钢琴1', 1, '1200', 'G', NULL, '2021-03-30 21:57:39', NULL, '', '', NULL, NULL), (4, 20, '8', '立式钢琴1', 1, '1200', '0', NULL, '2021-03-31 00:02:52', NULL, '', '', 'waefawgvwefv|1564651|undefined|奥烦恼念佛按佛按我阿奎那打开能否', NULL), (5, 20, '8', '立式钢琴1', 1, '1200', '0', NULL, '2021-03-31 00:03:50', NULL, '', '', 'waefawgvwefv|1564651|undefined|奥烦恼念佛按佛按我阿奎那打开能否', NULL), (6, 20, '11', '自动钢琴1', 2, '2800', 'G', NULL, '2021-03-31 00:13:18', NULL, '', '', NULL, NULL), (7, 20, '8,11', '立式钢琴1,自动钢琴1', 2, '6800', '3', NULL, '2021-03-31 00:13:42', NULL, 'Zasdf', '', 'waefawgvwefv|1564651|undefined|奥烦恼念佛按佛按我阿奎那打开能否', NULL); -- -------------------------------------------------------- -- -- Table structure for table `eat_shoucang` -- CREATE TABLE IF NOT EXISTS `eat_shoucang` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `user_id` int(11) NOT NULL COMMENT '用户ID', `goods_id` int(11) NOT NULL COMMENT '商品ID', `hold1` varchar(255) DEFAULT NULL COMMENT '预留1', `hold2` varchar(255) DEFAULT NULL COMMENT '预留1', `hold3` varchar(255) DEFAULT NULL COMMENT '预留3', `hold4` varchar(255) DEFAULT NULL COMMENT '预留4', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表' AUTO_INCREMENT=4 ; -- -- Dumping data for table `eat_shoucang` -- INSERT INTO `eat_shoucang` (`id`, `user_id`, `goods_id`, `hold1`, `hold2`, `hold3`, `hold4`) VALUES (3, 20, 11, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `eat_tyep` -- CREATE TABLE IF NOT EXISTS `e