登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 45

paste/yjshop

forked from jiaHey/yjshop 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
shop.sql 61.52 KB
一键复制 编辑 原始数据 按行查看 历史
jiaHey 提交于 2017-09-21 19:07 . sql文件
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902
-- phpMyAdmin SQL Dump

-- version 4.7.1

-- https://www.phpmyadmin.net/

--

-- Host: localhost:3306

-- Generation Time: 2017-09-21 19:06:36

-- 服务器版本： 5.6.35

-- PHP Version: 7.1.1



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 utf8mb4 */;



--

-- Database: `shop`

--



-- --------------------------------------------------------



--

-- 表的结构 `sys_config`

--



CREATE TABLE `sys_config` (

  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,

  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `sys_config`

--



INSERT INTO `sys_config` (`name`, `remark`, `value`) VALUES

('appid', '微信公众号的appid', 'wxd1ab848d0831bb16'),

('secret', '微信公众号的app corpSecret', 'd19250db6fdfe51aaa0d0d31734e43c4');



-- --------------------------------------------------------



--

-- 表的结构 `sys_log`

--



CREATE TABLE `sys_log` (

  `id` bigint(20) NOT NULL,

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `operation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `params` text COLLATE utf8mb4_unicode_ci,

  `time` bigint(20) DEFAULT NULL,

  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `sys_log`

--



INSERT INTO `sys_log` (`id`, `created`, `ip`, `method`, `operation`, `params`, `time`, `username`) VALUES

(1, '2017-08-01 06:54:06', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysConfigController.save()', '保存配置', '{\"name\":\"c\",\"value\":\"c\",\"remark\":\"v\"}', 22, 'admin'),

(2, '2017-08-01 07:02:38', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysRoleController.delete()', '删除角色', '[3]', 12, 'admin'),

(3, '2017-08-01 07:03:47', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.delete()', '删除菜单', '6', 0, 'admin'),

(4, '2017-08-01 08:55:10', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysConfigController.save()', '保存配置', '{\"name\":\"appid\",\"value\":\"d19250db6fdfe51aaa0d0d31734e43c4\",\"remark\":\"微信公众号的appid\"}', 54, 'admin'),

(5, '2017-08-01 08:55:30', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysConfigController.save()', '保存配置', '{\"name\":\"secret\",\"value\":\"d19250db6fdfe51aaa0d0d31734e43c4\",\"remark\":\"微信公众号的app corpSecret\"}', 5, 'admin'),

(6, '2017-08-01 08:55:36', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysConfigController.delete()', '删除配置', NULL, 16, 'admin'),

(7, '2017-08-01 08:55:47', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysConfigController.save()', '保存配置', '{\"name\":\"appid\",\"value\":\"wxd1ab848d0831bb16\",\"remark\":\"微信公众号的appid\"}', 8, 'admin'),

(8, '2017-08-01 09:04:17', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.delete()', '删除菜单', '31', 4, 'admin'),

(9, '2017-08-01 09:04:22', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.delete()', '删除菜单', '32', 13, 'admin'),

(10, '2017-08-01 09:04:26', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.delete()', '删除菜单', '31', 8, 'admin'),

(11, '2017-08-01 09:05:01', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":33,\"name\":\"商城管理\",\"type\":0,\"orderNum\":0}', 6, 'admin'),

(12, '2017-08-01 09:05:26', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":34,\"name\":\"商品列表\",\"url\":\"/admin/goods/\",\"type\":1,\"orderNum\":0,\"parentId\":33}', 5, 'admin'),

(13, '2017-08-01 09:06:12', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":34,\"name\":\"商品列表\",\"url\":\"/modules/shop/goods/\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0,\"parentId\":33}', 7, 'admin'),

(14, '2017-08-01 09:10:53', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":34,\"name\":\"商品列表\",\"url\":\"/modules/shop/goods.html\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0,\"parentId\":33}', 8, 'admin'),

(15, '2017-08-02 06:51:11', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.delete()', '删除商品', '[1]', 11, 'admin'),

(16, '2017-08-02 06:51:47', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '删除商品', '{\"id\":2,\"title\":\"a\",\"imgUrl\":\"va\",\"updated\":\"Aug 2, 2017 2:51:47 PM\",\"price\":1}', 10, 'admin'),

(17, '2017-08-02 06:51:51', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.delete()', '删除商品', '[2]', 7, 'admin'),

(18, '2017-08-02 06:52:41', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":3,\"title\":\"v\",\"imgUrl\":\"q\",\"updated\":\"Aug 2, 2017 2:52:41 PM\",\"price\":1}', 9, 'admin'),

(19, '2017-08-02 06:52:45', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.delete()', '删除商品', '[3]', 9, 'admin'),

(20, '2017-08-02 06:53:46', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":4,\"title\":\"as\",\"imgUrl\":\"q\",\"updated\":\"Aug 2, 2017 2:53:46 PM\",\"price\":13}', 5, 'admin'),

(21, '2017-08-02 06:54:41', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.delete()', '删除商品', '[4]', 0, 'admin'),

(22, '2017-08-05 09:51:02', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":4,\"title\":\"as\",\"imgUrl\":\"/ueditor/jsp/upload/image/20170805/1501926642535003978.png\",\"updated\":\"Aug 5, 2017 5:51:02 PM\",\"price\":13}', 63, 'admin'),

(23, '2017-08-05 09:57:55', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":4,\"title\":\"as\",\"imgUrl\":\"\",\"updated\":\"Aug 5, 2017 5:57:54 PM\",\"price\":13}', 13, 'admin'),

(24, '2017-08-06 06:35:53', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 2:35:53 PM\",\"price\":1}', 58, 'admin'),

(25, '2017-08-06 06:36:16', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.delete()', '删除商品', '[4]', 12, 'admin'),

(26, '2017-08-06 06:49:49', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 0, 'admin'),

(27, '2017-08-06 06:50:00', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 0, 'admin'),

(28, '2017-08-06 06:50:29', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 12653, 'admin'),

(29, '2017-08-06 07:11:44', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 32614, 'admin'),

(30, '2017-08-06 07:16:55', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 1, 'admin'),

(31, '2017-08-06 07:20:50', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 216296, 'admin'),

(32, '2017-08-06 07:29:10', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 10770, 'admin'),

(33, '2017-08-06 07:33:36', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"price\":1}', 23620, 'admin'),

(34, '2017-08-06 07:40:03', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 5090, 'admin'),

(35, '2017-08-06 08:45:09', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{}', 16522, 'admin'),

(36, '2017-08-06 09:33:28', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 5:33:28 PM\",\"price\":1}', 19128, 'admin'),

(37, '2017-08-06 09:44:25', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 5:44:25 PM\",\"price\":1}', 7907, 'admin'),

(38, '2017-08-06 09:45:09', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"price\":1}', 17761, 'admin'),

(39, '2017-08-06 09:49:08', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"vvv\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"price\":1}', 5009, 'admin'),

(40, '2017-08-06 10:01:31', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 6:01:31 PM\",\"price\":1}', 62, 'admin'),

(41, '2017-08-06 10:02:26', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 6:02:26 PM\",\"price\":1}', 21, 'admin'),

(42, '2017-08-06 10:03:58', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"dsf\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 6:03:58 PM\",\"price\":1}', 21, 'admin'),

(43, '2017-08-06 10:05:52', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 6:05:52 PM\",\"price\":1}', 9, 'admin'),

(44, '2017-08-06 10:06:52', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 6:06:52 PM\",\"price\":1}', 17, 'admin'),

(45, '2017-08-06 10:11:19', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 6, 2017 6:11:19 PM\",\"price\":1}', 14, 'admin'),

(46, '2017-08-07 07:49:52', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 7, 2017 3:49:51 PM\",\"price\":1}', 72, 'admin'),

(47, '2017-08-07 07:50:45', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 7, 2017 3:50:45 PM\",\"price\":1}', 17, 'admin'),

(48, '2017-08-07 07:51:01', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"updated\":\"Aug 7, 2017 3:51:01 PM\",\"price\":1}', 9, 'admin'),

(49, '2017-08-07 07:57:59', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":1}', 15, 'admin'),

(50, '2017-08-07 07:58:37', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":1}', 9, 'admin'),

(51, '2017-08-07 07:58:48', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":1}', 11, 'admin'),

(52, '2017-08-07 07:59:38', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":1}', 12, 'admin'),

(53, '2017-08-07 08:00:04', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":1}', 6819, 'admin'),

(54, '2017-08-07 08:00:34', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":1}', 2538, 'admin'),

(55, '2017-08-07 08:00:44', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":1}', 9, 'admin'),

(56, '2017-08-07 09:12:44', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003ewvsd\\u003c/p\\u003e\\u003cp\\u003esdfds\\u003c/p\\u003e\\u003cp\\u003efsd\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\",\"price\":1}', 28, 'admin'),

(57, '2017-08-07 09:28:37', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003easf\\u003c/p\\u003e\",\"price\":1}', 7, 'admin'),

(58, '2017-08-07 09:29:12', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003easf\\u003c/p\\u003e\",\"price\":1}', 7, 'admin'),

(59, '2017-08-07 09:51:36', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003easf\\u003c/p\\u003e\",\"price\":1}', 7, 'admin'),

(60, '2017-08-08 03:29:27', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003evasdasdsa\\u003c/p\\u003e\",\"price\":1}', 54, 'admin'),

(61, '2017-08-08 03:29:33', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 11, 'admin'),

(62, '2017-08-08 03:35:30', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 8, 'admin'),

(63, '2017-08-08 03:41:42', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 25232, 'admin'),

(64, '2017-08-08 06:47:28', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 1, 'admin'),

(65, '2017-08-08 06:47:55', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 10027, 'admin'),

(66, '2017-08-08 06:48:27', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 3645, 'admin'),

(67, '2017-08-08 06:52:05', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 16990, 'admin'),

(68, '2017-08-08 06:53:28', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1}', 73371, 'admin'),

(69, '2017-08-08 07:01:07', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1,\"gallery\":[{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5}]}', 69, 'admin'),

(70, '2017-08-08 07:02:00', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"id\":5,\"title\":\"r\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1,\"gallery\":[{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5}]}', 16, 'admin'),

(71, '2017-08-09 07:52:40', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"raq\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1},\"gallery\":[{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5}]}', 91, 'admin'),

(72, '2017-08-09 07:52:48', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"raq\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1},\"gallery\":[{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5}]}', 19, 'admin'),

(73, '2017-08-09 08:34:19', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"raq\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1},\"gallery\":[{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5}]}', 87, 'admin'),

(74, '2017-08-09 08:38:01', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"raq\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1},\"gallery\":[{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5}]}', 68, 'admin'),

(75, '2017-08-09 08:38:06', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"raq\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1},\"gallery\":[{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5}]}', 18, 'admin'),

(76, '2017-08-09 08:44:33', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":35,\"name\":\"商品标签\",\"url\":\"/modules/shop/goodsTags.html\",\"type\":1,\"orderNum\":0,\"parentId\":33}', 6, 'admin'),

(77, '2017-08-09 09:34:03', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"raq\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003eregergerg\\u003c/p\\u003e\",\"price\":1},\"gallery\":[{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5}],\"goodsTagsIdList\":[2,1]}', 90, 'admin'),

(78, '2017-08-09 09:36:05', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":34,\"name\":\"商品列表\",\"url\":\"/modules/shop/goods.html\",\"perms\":\"\",\"type\":1,\"icon\":\"fa fa-user-secret\",\"orderNum\":0,\"parentId\":33}', 12, 'admin'),

(79, '2017-08-09 09:36:24', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":33,\"name\":\"商城管理\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"fa fa-cog\",\"orderNum\":0}', 7, 'admin'),

(80, '2017-08-09 09:37:02', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"手机\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003e但是 v山东 v粉丝 v\\u003c/p\\u003e\",\"price\":134},\"gallery\":[{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5}],\"goodsTagsIdList\":[1,2]}', 30, 'admin'),

(81, '2017-08-09 09:41:32', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"title\":\"werewr\",\"imgUrl\":\"/upload/image/20170806/1502009572661075950.png\",\"content\":\"\",\"price\":12},\"gallery\":[],\"goodsTagsIdList\":[]}', 13, 'admin'),

(82, '2017-08-09 09:42:04', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":6,\"title\":\"电脑\",\"imgUrl\":\"/upload/image/20170806/1502009572661075950.png\",\"content\":\"\\u003cp\\u003e山东 v 水淀粉\\u003c/p\\u003e\",\"price\":12},\"gallery\":[{\"imgUrl\":\"/upload/image/20170806/1502009572661075950.png\"},{\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\"},{\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\"}],\"goodsTagsIdList\":[2,1]}', 39, 'admin'),

(83, '2017-08-10 06:21:08', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":34,\"name\":\"商品列表\",\"url\":\"/modules/shop/goods.html\",\"perms\":\"\",\"type\":1,\"icon\":\"fa fa-user-secret\",\"orderNum\":0,\"parentId\":33}', 44, 'admin'),

(84, '2017-08-10 06:21:21', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":35,\"name\":\"商品标签\",\"url\":\"/modules/shop/goodsTags.html\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0,\"parentId\":33}', 5, 'admin'),

(85, '2017-08-10 06:22:08', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"手机\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003e但是 v山东 v粉丝 v\\u003c/p\\u003e\",\"price\":134},\"gallery\":[{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5}],\"goodsTagsIdList\":[2,1]}', 47, 'admin'),

(86, '2017-08-10 06:22:33', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":6,\"title\":\"电脑\",\"imgUrl\":\"/upload/image/20170806/1502009572661075950.png\",\"content\":\"\\u003cp\\u003e山东 v 水淀粉\\u003c/p\\u003e\",\"price\":12},\"gallery\":[{\"id\":12,\"imgUrl\":\"/upload/image/20170806/1502009572661075950.png\",\"goodsId\":6},{\"id\":10,\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"goodsId\":6},{\"id\":11,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":6}],\"goodsTagsIdList\":[2,1]}', 20, 'admin'),

(87, '2017-08-10 06:30:00', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":35,\"name\":\"商品标签\",\"url\":\"/modules/shop/goodsTags.html\",\"perms\":\"\",\"type\":1,\"icon\":\"fa fa-bug\",\"orderNum\":0,\"parentId\":33}', 6, 'admin'),

(88, '2017-08-13 07:41:19', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":34,\"name\":\"商品列表\",\"url\":\"modules/shop/goods.html\",\"perms\":\"\",\"type\":1,\"icon\":\"fa fa-user-secret\",\"orderNum\":0,\"parentId\":33}', 50, 'admin'),

(89, '2017-08-13 07:41:25', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":35,\"name\":\"商品标签\",\"url\":\"modules/shop/goodsTags.html\",\"perms\":\"\",\"type\":1,\"icon\":\"fa fa-bug\",\"orderNum\":0,\"parentId\":33}', 6, 'admin'),

(90, '2017-08-16 07:41:23', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":36,\"name\":\"幻灯片\",\"url\":\"modules/shop/goods.html\",\"type\":1,\"orderNum\":0,\"parentId\":33}', 32, 'admin'),

(91, '2017-08-16 07:41:42', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":36,\"name\":\"幻灯片\",\"url\":\"modules/shop/slide.html\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0,\"parentId\":33}', 27, 'admin'),

(92, '2017-08-16 08:01:00', '0:0:0:0:0:0:0:1', 'com.shop.modules.sys.controller.SysMenuController.save()', '保存菜单', '{\"id\":36,\"name\":\"幻灯片\",\"url\":\"modules/shop/slide.html\",\"perms\":\"\",\"type\":1,\"icon\":\"fa fa-user-secret\",\"orderNum\":0,\"parentId\":33}', 13, 'admin'),

(93, '2017-08-17 08:16:33', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"title\":\"玩儿\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":23},\"gallery\":[],\"goodsTagsIdList\":[]}', 70, 'admin'),

(94, '2017-08-17 08:17:09', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"title\":\"发的\",\"imgUrl\":\"/upload/image/20170806/1502009651795014629.jpg\",\"content\":\"\",\"price\":23},\"gallery\":[],\"goodsTagsIdList\":[]}', 24, 'admin'),

(95, '2017-08-17 08:17:30', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"title\":\"adfsd\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":123},\"gallery\":[],\"goodsTagsIdList\":[]}', 14, 'admin'),

(96, '2017-08-17 09:21:10', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"title\":\"vv\",\"imgUrl\":\"/upload/image/20170806/1502009572661075950.png\",\"content\":\"\",\"price\":234},\"gallery\":[],\"goodsTagsIdList\":[]}', 84, 'admin'),

(97, '2017-08-18 03:09:32', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"手机\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003e但是 v山东 v粉丝 v\\u003c/p\\u003e\",\"price\":134},\"gallery\":[{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5}],\"goodsTagsIdList\":[1]}', 79, 'admin'),

(98, '2017-08-18 03:09:40', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":7,\"title\":\"阿斯顿\",\"imgUrl\":\"/upload/image/20170806/1502009651795014629.jpg\",\"content\":\"\",\"price\":123},\"gallery\":[],\"goodsTagsIdList\":[1]}', 16, 'admin'),

(99, '2017-08-18 03:11:06', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":12,\"title\":\"电脑\",\"imgUrl\":\"/upload/image/20170806/1502009572661075950.png\",\"content\":\"\\u003cp\\u003e山东 v 水淀粉\\u003c/p\\u003e\",\"price\":12},\"gallery\":[],\"goodsTagsIdList\":[1,2]}', 41, 'admin'),

(100, '2017-08-18 03:11:11', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":14,\"title\":\"玩儿\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":23},\"gallery\":[],\"goodsTagsIdList\":[1,2]}', 29, 'admin'),

(101, '2017-08-18 03:11:20', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":13,\"title\":\"阿斯顿\",\"imgUrl\":\"/upload/image/20170806/1502009651795014629.jpg\",\"content\":\"\",\"price\":123},\"gallery\":[],\"goodsTagsIdList\":[2,1]}', 14, 'admin'),

(102, '2017-08-18 03:11:33', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":11,\"title\":\"手机\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003e但是 v山东 v粉丝 v\\u003c/p\\u003e\",\"price\":134},\"gallery\":[],\"goodsTagsIdList\":[1,2]}', 15, 'admin'),

(103, '2017-08-18 03:11:44', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":8,\"title\":\"玩儿\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":23},\"gallery\":[],\"goodsTagsIdList\":[1,2]}', 14, 'admin'),

(104, '2017-08-18 03:25:23', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":23,\"title\":\"手机\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003e但是 v山东 v粉丝 v\\u003c/p\\u003e\",\"price\":134},\"gallery\":[],\"goodsTagsIdList\":[1,2]}', 77, 'admin'),

(105, '2017-08-18 03:25:59', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":20,\"title\":\"玩儿\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":23},\"gallery\":[],\"goodsTagsIdList\":[1,2]}', 28, 'admin'),

(106, '2017-08-18 03:26:04', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":16,\"title\":\"adfsd\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\",\"price\":123},\"gallery\":[],\"goodsTagsIdList\":[1,2]}', 18, 'admin'),

(107, '2017-08-18 06:51:03', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"手机\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003e但是 v山东 v粉丝 vds\\u003c/p\\u003e\\u003cp\\u003efds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003eds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003eds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003eds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003egrg\\u003c/p\\u003e\\u003cp\\u003ee\\u003c/p\\u003e\\u003cp\\u003eg\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003edsg\\u003c/p\\u003e\\u003cp\\u003edf\\u003c/p\\u003e\\u003cp\\u003eg\\u003c/p\\u003e\\u003cp\\u003esdf\\u003c/p\\u003e\\u003cp\\u003eas\\u003c/p\\u003e\\u003cp\\u003e\\u003cbr/\\u003e\\u003c/p\\u003e\\u003cp\\u003edfas\\u003c/p\\u003e\\u003cp\\u003ed\\u003c/p\\u003e\\u003cp\\u003eas\\u003c/p\\u003e\\u003cp\\u003ed\\u003c/p\\u003e\\u003cp\\u003eas\\u003c/p\\u003e\\u003cp\\u003ed\\u003c/p\\u003e\\u003cp\\u003easd\\u003c/p\\u003e\",\"price\":134},\"gallery\":[{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5}],\"goodsTagsIdList\":[1]}', 83, 'admin'),

(108, '2017-08-18 06:55:52', '0:0:0:0:0:0:0:1', 'com.shop.modules.shop.controller.admin.GoodsAdminController.save()', '保存商品', '{\"goods\":{\"id\":5,\"title\":\"手机\",\"imgUrl\":\"/upload/image/20170806/1502001294088085179.jpg\",\"content\":\"\\u003cp\\u003e但是 v山东 v粉丝 vds\\u003c/p\\u003e\\u003cp\\u003efds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003eds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003eds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003eds\\u003c/p\\u003e\\u003cp\\u003ef\\u003c/p\\u003e\\u003cp\\u003e\\u003cimg src\\u003d\\\"/upload/image/20170806/1502009572661075950.png\\\" alt\\u003d\\\"1502009572661075950.png\\\"/\\u003e\\u003c/p\\u003e\\u003cp\\u003esdf\\u003c/p\\u003e\\u003cp\\u003eas\\u003c/p\\u003e\\u003cp\\u003e\\u003cbr/\\u003e\\u003c/p\\u003e\\u003cp\\u003edfas\\u003c/p\\u003e\\u003cp\\u003ed\\u003c/p\\u003e\\u003cp\\u003eas\\u003c/p\\u003e\\u003cp\\u003ed\\u003c/p\\u003e\\u003cp\\u003eas\\u003c/p\\u003e\\u003cp\\u003ed\\u003c/p\\u003e\\u003cp\\u003easd\\u003c/p\\u003e\",\"price\":134},\"gallery\":[{\"id\":2,\"imgUrl\":\"/upload/image/20170806/1502013665519066525.png\",\"goodsId\":5},{\"id\":1,\"imgUrl\":\"/upload/image/20170806/1502009685898084150.png\",\"goodsId\":5},{\"id\":4,\"imgUrl\":\"/upload/image/20170808/1502163318461042370.jpg\",\"goodsId\":5}],\"goodsTagsIdList\":[1]}', 21, 'admin');



-- --------------------------------------------------------



--

-- 表的结构 `sys_menu`

--



CREATE TABLE `sys_menu` (

  `id` bigint(20) NOT NULL,

  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `order_num` int(11) DEFAULT NULL,

  `parent_id` bigint(20) DEFAULT NULL,

  `perms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `type` int(11) DEFAULT NULL,

  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `parent` tinyblob

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `sys_menu`

--



INSERT INTO `sys_menu` (`id`, `icon`, `name`, `order_num`, `parent_id`, `perms`, `type`, `url`, `parent`) VALUES

(1, 'fa fa-cog', '系统管理', 0, NULL, NULL, 0, NULL, NULL),

(2, 'fa fa-user', '管理员列表', 1, 1, NULL, 1, 'modules/sys/user.html', NULL),

(3, 'fa fa-user-secret', '角色管理', 2, 1, NULL, 1, 'modules/sys/role.html', NULL),

(4, 'fa fa-th-list', '菜单管理', 3, 1, NULL, 1, 'modules/sys/menu.html', NULL),

(5, 'fa fa-bug', 'SQL监控', 4, 1, NULL, 1, 'druid/sql.html', NULL),

(6, 'fa fa-tasks', '定时任务', 5, 1, NULL, 1, 'modules/job/schedule.html', NULL),

(7, NULL, '查看', 0, 6, 'sys:schedule:list,sys:schedule:info', 2, NULL, NULL),

(8, NULL, '新增', 0, 6, 'sys:schedule:save', 2, NULL, NULL),

(9, NULL, '修改', 0, 6, 'sys:schedule:update', 2, NULL, NULL),

(10, NULL, '删除', 0, 6, 'sys:schedule:delete', 2, NULL, NULL),

(11, NULL, '暂停', 0, 6, 'sys:schedule:pause', 2, NULL, NULL),

(12, NULL, '恢复', 0, 6, 'sys:schedule:resume', 2, NULL, NULL),

(13, NULL, '立即执行', 0, 6, 'sys:schedule:run', 2, NULL, NULL),

(14, NULL, '日志列表', 0, 6, 'sys:schedule:log', 2, NULL, NULL),

(15, NULL, '查看', 0, 2, 'sys:user:list,sys:user:info', 2, NULL, NULL),

(16, NULL, '新增', 0, 2, 'sys:user:save,sys:role:select', 2, NULL, NULL),

(17, NULL, '修改', 0, 2, 'sys:user:update,sys:role:select', 2, NULL, NULL),

(18, NULL, '删除', 0, 2, 'sys:user:delete', 2, NULL, NULL),

(19, NULL, '查看', 0, 3, 'sys:role:list,sys:role:info', 2, NULL, NULL),

(20, NULL, '新增', 0, 3, 'sys:role:save,sys:menu:list', 2, NULL, NULL),

(21, NULL, '修改', 0, 3, 'sys:role:update,sys:menu:list', 2, NULL, NULL),

(22, NULL, '删除', 0, 3, 'sys:role:delete', 2, NULL, NULL),

(23, NULL, '查看', 0, 4, 'sys:menu:list,sys:menu:info', 2, NULL, NULL),

(24, NULL, '新增', 0, 4, 'sys:menu:save,sys:menu:select', 2, NULL, NULL),

(25, NULL, '修改', 0, 4, 'sys:menu:update,sys:menu:select', 2, NULL, NULL),

(26, NULL, '删除', 0, 4, 'sys:menu:delete', 2, NULL, NULL),

(27, 'fa fa-sun-o', '参数管理', 6, 1, 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'modules/sys/config.html', NULL),

(29, 'fa fa-file-text-o', '系统日志', 7, 1, 'sys:log:list', 1, 'modules/sys/log.html', NULL),

(30, 'fa fa-file-image-o', '文件上传', 6, 1, 'sys:oss:all', 1, 'modules/oss/oss.html', NULL),

(33, 'fa fa-cog', '商城管理', 0, NULL, '', 0, '', NULL),

(34, 'fa fa-user-secret', '商品列表', 0, 33, '', 1, 'modules/shop/goods.html', NULL),

(35, 'fa fa-bug', '商品标签', 0, 33, '', 1, 'modules/shop/goodsTags.html', NULL),

(36, 'fa fa-user-secret', '幻灯片', 0, 33, '', 1, 'modules/shop/slide.html', NULL);



-- --------------------------------------------------------



--

-- 表的结构 `sys_role`

--



CREATE TABLE `sys_role` (

  `id` bigint(20) NOT NULL,

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `user_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `sys_role`

--



INSERT INTO `sys_role` (`id`, `created`, `name`, `remark`, `user_id`) VALUES

(1, '2017-07-31 07:40:50', 'vvvaad', 'asd', 1),

(2, '2017-07-31 07:49:39', 'heuyji', 'asd', 1);



-- --------------------------------------------------------



--

-- 表的结构 `sys_role_menu`

--



CREATE TABLE `sys_role_menu` (

  `menu_id` bigint(20) NOT NULL,

  `role_id` bigint(20) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `sys_role_menu`

--



INSERT INTO `sys_role_menu` (`menu_id`, `role_id`) VALUES

(3, 1),

(3, 2);



-- --------------------------------------------------------



--

-- 表的结构 `sys_role_user`

--



CREATE TABLE `sys_role_user` (

  `role_id` bigint(20) NOT NULL,

  `user_id` bigint(20) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `sys_role_user`

--



INSERT INTO `sys_role_user` (`role_id`, `user_id`) VALUES

(2, 1);



-- --------------------------------------------------------



--

-- 表的结构 `sys_user`

--



CREATE TABLE `sys_user` (

  `id` bigint(20) NOT NULL,

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `status` int(11) DEFAULT NULL,

  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `user_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `sys_user`

--



INSERT INTO `sys_user` (`id`, `created`, `email`, `mobile`, `password`, `status`, `username`, `user_id`) VALUES

(1, '2017-07-27 07:56:02', 'a', 'da', 'ad', NULL, 'admin', NULL),

(3, '2017-07-31 08:17:15', 'asd@qq.com', '123', '123456', 1, 'avad', 1);



-- --------------------------------------------------------



--

-- 表的结构 `y_address`

--



CREATE TABLE `y_address` (

  `id` bigint(20) NOT NULL,

  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `is_default` tinyint(1) NOT NULL,

  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `user_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_address`

--



INSERT INTO `y_address` (`id`, `address`, `area`, `is_default`, `phone`, `user_id`) VALUES

(1, 'aaaa', '北京 北京市 东城区', 0, '32', 1),

(2, 'vvvv', '北京 北京市 东城区', 1, '24', 1),

(3, '4324', '北京 北京市 东城区', 0, '24', 1),

(4, 'aasv2', '北京 北京市 东城区', 0, '123', 1);



-- --------------------------------------------------------



--

-- 表的结构 `y_cart`

--



CREATE TABLE `y_cart` (

  `id` bigint(20) NOT NULL,

  `number` int(11) UNSIGNED NOT NULL DEFAULT '0',

  `goods_id` bigint(20) DEFAULT NULL,

  `user_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_cart`

--



INSERT INTO `y_cart` (`id`, `number`, `goods_id`, `user_id`) VALUES

(38, 1, 5, 1);



-- --------------------------------------------------------



--

-- 表的结构 `y_goods`

--



CREATE TABLE `y_goods` (

  `id` bigint(20) NOT NULL,

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `img_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `price` decimal(10,2) NOT NULL,

  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `content` text COLLATE utf8mb4_unicode_ci,

  `sale_count` int(11) NOT NULL DEFAULT '0'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_goods`

--



INSERT INTO `y_goods` (`id`, `created`, `img_url`, `price`, `title`, `updated`, `content`, `sale_count`) VALUES

(5, '2017-08-07 07:51:01', '/upload/image/20170806/1502001294088085179.jpg', '134.00', '手机', '2017-08-18 06:55:52', '<p>但是 v山东 v粉丝 vds</p><p>fds</p><p>f</p><p>ds</p><p>f</p><p>ds</p><p>f</p><p>ds</p><p>f</p><p><img src=\"/upload/image/20170806/1502009572661075950.png\" alt=\"1502009572661075950.png\"/></p><p>sdf</p><p>as</p><p><br/></p><p>dfas</p><p>d</p><p>as</p><p>d</p><p>as</p><p>d</p><p>asd</p>', 0),

(6, '2017-08-09 09:41:32', '/upload/image/20170806/1502001294088085179.jpg', '12.00', '电脑', '2017-08-10 06:22:34', '<p>山东 v 水淀粉</p>', 0),

(7, '2017-08-17 08:15:22', '/upload/image/20170806/1502001294088085179.jpg', '123.00', '阿斯顿', '2017-08-18 03:09:41', '', 0),

(8, '2017-08-17 08:16:33', '/upload/image/20170806/1502001294088085179.jpg', '23.00', '玩儿', '2017-08-18 03:11:44', '', 0),

(9, '2017-08-17 08:17:09', '/upload/image/20170806/1502001294088085179.jpg', '23.00', '发的', '2017-08-17 08:17:09', '', 0),

(10, '2017-08-17 08:17:30', '/upload/image/20170806/1502001294088085179.jpg', '123.00', 'adfsd', '2017-08-17 08:17:30', '', 0),

(11, '2017-08-07 07:51:01', '/upload/image/20170806/1502001294088085179.jpg', '134.00', '手机', '2017-08-18 03:11:33', '<p>但是 v山东 v粉丝 v</p>', 0),

(12, '2017-08-09 09:41:32', '/upload/image/20170806/1502001294088085179.jpg', '12.00', '电脑', '2017-08-18 03:11:06', '<p>山东 v 水淀粉</p>', 0),

(13, '2017-08-17 08:15:22', '/upload/image/20170806/1502001294088085179.jpg', '123.00', '阿斯顿', '2017-08-18 03:11:20', '', 0),

(14, '2017-08-17 08:16:33', '/upload/image/20170806/1502001294088085179.jpg', '23.00', '玩儿', '2017-08-18 03:11:11', '', 0),

(15, '2017-08-17 08:17:09', '/upload/image/20170806/1502001294088085179.jpg', '23.00', '发的', '2017-08-17 08:17:09', '', 0),

(16, '2017-08-17 08:17:30', '/upload/image/20170806/1502001294088085179.jpg', '123.00', 'adfsd', '2017-08-18 03:26:04', '', 0),

(17, '2017-08-07 07:51:01', '/upload/image/20170806/1502001294088085179.jpg', '134.00', '手机', '2017-08-10 06:22:09', '<p>但是 v山东 v粉丝 v</p>', 0),

(18, '2017-08-09 09:41:32', '/upload/image/20170806/1502001294088085179.jpg', '12.00', '电脑', '2017-08-10 06:22:34', '<p>山东 v 水淀粉</p>', 0),

(19, '2017-08-17 08:15:22', '/upload/image/20170806/1502001294088085179.jpg', '123.00', '阿斯顿', '2017-08-17 08:15:22', '', 0),

(20, '2017-08-17 08:16:33', '/upload/image/20170806/1502001294088085179.jpg', '23.00', '玩儿', '2017-08-18 03:26:00', '', 0),

(21, '2017-08-17 08:17:09', '/upload/image/20170806/1502001294088085179.jpg', '23.00', '发的', '2017-08-18 03:15:37', '', 0),

(23, '2017-08-07 07:51:01', '/upload/image/20170806/1502001294088085179.jpg', '134.00', '手机', '2017-08-18 03:25:21', '<p>但是 v山东 v粉丝 v</p>', 0),

(24, '2017-08-09 09:41:32', '/upload/image/20170806/1502001294088085179.jpg', '12.00', '电脑', '2017-08-10 06:22:34', '<p>山东 v 水淀粉</p>', 0),

(25, '2017-08-17 08:15:22', '/upload/image/20170806/1502001294088085179.jpg', '123.00', '阿斯顿', '2017-08-17 08:15:22', '', 0),

(27, '2017-08-17 08:17:09', '/upload/image/20170806/1502001294088085179.jpg', '23.00', '发的', '2017-08-17 08:17:09', '', 0),

(28, '2017-08-17 08:17:30', '/upload/image/20170806/1502001294088085179.jpg', '123.00', 'adfsd', '2017-08-17 08:17:30', '', 0),

(29, '2017-08-17 09:18:52', '/upload/image/20170806/1502001294088085179.jpg', '123.00', 'dfs', '2017-08-17 09:18:52', '', 0),

(30, '2017-08-17 09:19:58', '/upload/image/20170806/1502001294088085179.jpg', '123.00', 'dfs', '2017-08-17 09:19:58', '', 0),

(31, '2017-08-17 09:21:10', '/upload/image/20170806/1502001294088085179.jpg', '234.00', 'vv', '2017-08-18 03:23:51', '', 0);



-- --------------------------------------------------------



--

-- 表的结构 `y_goods_gallery`

--



CREATE TABLE `y_goods_gallery` (

  `id` bigint(20) NOT NULL,

  `img_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `goods_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_goods_gallery`

--



INSERT INTO `y_goods_gallery` (`id`, `img_url`, `goods_id`) VALUES

(1, '/upload/image/20170806/1502009685898084150.png', NULL),

(2, '/upload/image/20170806/1502013665519066525.png', NULL),

(3, '/upload/image/20170808/1502162949917077108.png', NULL),

(4, '/upload/image/20170808/1502163318461042370.jpg', NULL),

(5, '/upload/image/20170806/1502009572661075950.png', NULL),

(6, '/upload/image/20170806/1502001294088085179.jpg', NULL),

(7, '/upload/image/20170806/1502009651795014629.jpg', NULL),

(8, '/upload/image/20170806/1502012103699079223.jpg', NULL),

(9, '/upload/image/20170808/1502163318461042370.jpg', NULL),

(10, '/upload/image/20170806/1502001294088085179.jpg', NULL),

(11, '/upload/image/20170808/1502163318461042370.jpg', NULL),

(12, '/upload/image/20170806/1502009572661075950.png', NULL);



-- --------------------------------------------------------



--

-- 表的结构 `y_goods_spec`

--



CREATE TABLE `y_goods_spec` (

  `id` bigint(20) NOT NULL,

  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `goods_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- --------------------------------------------------------



--

-- 表的结构 `y_goods_tag`

--



CREATE TABLE `y_goods_tag` (

  `id` bigint(20) NOT NULL,

  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `is_hot` tinyint(1) NOT NULL,

  `is_show` tinyint(1) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_goods_tag`

--



INSERT INTO `y_goods_tag` (`id`, `title`, `is_hot`, `is_show`) VALUES

(1, '生活', 1, 1),

(2, '家具', 1, 1);



-- --------------------------------------------------------



--

-- 表的结构 `y_goods_tags_goods`

--



CREATE TABLE `y_goods_tags_goods` (

  `tags_id` bigint(20) NOT NULL,

  `goods_id` bigint(20) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_goods_tags_goods`

--



INSERT INTO `y_goods_tags_goods` (`tags_id`, `goods_id`) VALUES

(1, 7),

(1, 12),

(1, 13),

(1, 14),

(1, 16),

(1, 20),

(1, 21),

(1, 31),

(2, 12),

(2, 13),

(2, 14),

(2, 16),

(2, 20),

(2, 21),

(2, 31);



-- --------------------------------------------------------



--

-- 表的结构 `y_order`

--



CREATE TABLE `y_order` (

  `id` bigint(20) NOT NULL,

  `address_str` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `price` decimal(10,2) DEFAULT NULL,

  `status` int(11) DEFAULT NULL,

  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `user_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_order`

--



INSERT INTO `y_order` (`id`, `address_str`, `created`, `number`, `price`, `status`, `updated`, `user_id`) VALUES

(1, '北京 北京市 东城区vvvv', '2017-08-22 06:23:37', '503383017621714', '414.00', 0, '2017-08-22 06:23:37', 1),

(2, '北京 北京市 东城区vvvv', '2017-08-22 06:26:12', '503383172292524', '414.00', 0, '2017-08-22 06:26:12', 1),

(3, '北京 北京市 东城区vvvv', '2017-08-22 06:26:14', '503383174963652', '414.00', 0, '2017-08-22 06:26:14', 1),

(4, '北京 北京市 东城区vvvv', '2017-08-22 06:26:49', '503383209972477', '414.00', 0, '2017-08-22 06:26:49', 1),

(5, '北京 北京市 东城区vvvv', '2017-08-22 06:26:52', '503383212480247', '414.00', 0, '2017-08-22 06:26:52', 1),

(6, '北京 北京市 东城区vvvv', '2017-08-22 06:27:19', '503383239829105', '414.00', 0, '2017-08-22 06:27:19', 1),

(7, '北京 北京市 东城区vvvv', '2017-08-23 01:43:39', '503452619531036', '414.00', 0, '2017-08-23 01:43:39', 1);



-- --------------------------------------------------------



--

-- 表的结构 `y_order_goods`

--



CREATE TABLE `y_order_goods` (

  `id` bigint(20) NOT NULL,

  `goods_img_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `goods_num` int(11) DEFAULT NULL,

  `goods_price` decimal(10,2) DEFAULT NULL,

  `goods_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `goods_id` bigint(20) DEFAULT NULL,

  `order_id` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_order_goods`

--



INSERT INTO `y_order_goods` (`id`, `goods_img_url`, `goods_num`, `goods_price`, `goods_title`, `goods_id`, `order_id`) VALUES

(1, '/upload/image/20170806/1502001294088085179.jpg', 3, '402.00', '手机', 5, 1),

(2, '/upload/image/20170806/1502009572661075950.png', 1, '12.00', '电脑', 6, 1),

(3, '/upload/image/20170806/1502001294088085179.jpg', 3, '402.00', '手机', 5, 2),

(4, '/upload/image/20170806/1502009572661075950.png', 1, '12.00', '电脑', 6, 2),

(5, '/upload/image/20170806/1502001294088085179.jpg', 3, '402.00', '手机', 5, 3),

(6, '/upload/image/20170806/1502009572661075950.png', 1, '12.00', '电脑', 6, 3),

(7, '/upload/image/20170806/1502001294088085179.jpg', 3, '402.00', '手机', 5, 4),

(8, '/upload/image/20170806/1502009572661075950.png', 1, '12.00', '电脑', 6, 4),

(9, '/upload/image/20170806/1502009572661075950.png', 1, '12.00', '电脑', 6, 5),

(10, '/upload/image/20170806/1502001294088085179.jpg', 3, '402.00', '手机', 5, 5),

(11, '/upload/image/20170806/1502009572661075950.png', 1, '12.00', '电脑', 6, 6),

(12, '/upload/image/20170806/1502001294088085179.jpg', 3, '402.00', '手机', 5, 6),

(13, '/upload/image/20170806/1502001294088085179.jpg', 3, '402.00', '手机', 5, 7),

(14, '/upload/image/20170806/1502009572661075950.png', 1, '12.00', '电脑', 6, 7);



-- --------------------------------------------------------



--

-- 表的结构 `y_slide`

--



CREATE TABLE `y_slide` (

  `id` bigint(20) NOT NULL,

  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `is_show` tinyint(1) NOT NULL,

  `type` tinyint(1) NOT NULL,

  `img_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_slide`

--



INSERT INTO `y_slide` (`id`, `title`, `url`, `is_show`, `type`, `img_url`) VALUES

(1, 'a', 'www.baidu.com', 1, 0, '/upload/image/20170806/1502001294088085179.jpg'),

(2, 'b', 'b', 1, 0, '/upload/image/20170806/1502001294088085179.jpg');



-- --------------------------------------------------------



--

-- 表的结构 `y_user`

--



CREATE TABLE `y_user` (

  `id` bigint(20) NOT NULL,

  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `created` datetime DEFAULT NULL,

  `headimgurl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `openid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `province` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `sex` tinyint(4) DEFAULT '0',

  `unionid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--

-- 转存表中的数据 `y_user`

--



INSERT INTO `y_user` (`id`, `city`, `country`, `created`, `headimgurl`, `nickname`, `openid`, `province`, `sex`, `unionid`) VALUES

(1, '深圳', '中国', '2017-08-01 16:24:22', '/upload/image/20170806/1502001294088085179.jpg', 'jiaHey', 'otY8Fs7xXKszYKzwdmmwdjbuYPAI', '广东', 1, NULL);



--

-- Indexes for dumped tables

--



--

-- Indexes for table `sys_config`

--

ALTER TABLE `sys_config`

  ADD PRIMARY KEY (`name`);



--

-- Indexes for table `sys_log`

--

ALTER TABLE `sys_log`

  ADD PRIMARY KEY (`id`);



--

-- Indexes for table `sys_menu`

--

ALTER TABLE `sys_menu`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FK2jrf4gb0gjqi8882gxytpxnhe` (`parent_id`);



--

-- Indexes for table `sys_role`

--

ALTER TABLE `sys_role`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKce4uus2biaik6iv5wtwteetb2` (`user_id`);



--

-- Indexes for table `sys_role_menu`

--

ALTER TABLE `sys_role_menu`

  ADD PRIMARY KEY (`role_id`,`menu_id`),

  ADD KEY `FKf3mud4qoc7ayew8nml4plkevo` (`menu_id`);



--

-- Indexes for table `sys_role_user`

--

ALTER TABLE `sys_role_user`

  ADD PRIMARY KEY (`role_id`,`user_id`),

  ADD KEY `FK1qf7bu5lhwt9y00uesmcgnbxd` (`user_id`);



--

-- Indexes for table `sys_user`

--

ALTER TABLE `sys_user`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKrg8wsmjn9ruu4k700hnq3oxtm` (`user_id`);



--

-- Indexes for table `y_address`

--

ALTER TABLE `y_address`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKini0e7s2nlxcguuyt32q5lbl0` (`user_id`);



--

-- Indexes for table `y_cart`

--

ALTER TABLE `y_cart`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKip1856jt94eo54j97qdrq3bil` (`goods_id`),

  ADD KEY `FKtbj7ccvhwn3dtlb675cq3apid` (`user_id`);



--

-- Indexes for table `y_goods`

--

ALTER TABLE `y_goods`

  ADD PRIMARY KEY (`id`);



--

-- Indexes for table `y_goods_gallery`

--

ALTER TABLE `y_goods_gallery`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKfol7rag41cnavd8owb63n9mf5` (`goods_id`);



--

-- Indexes for table `y_goods_spec`

--

ALTER TABLE `y_goods_spec`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKqiwsepfal7ia08hm3e3py294o` (`goods_id`);



--

-- Indexes for table `y_goods_tag`

--

ALTER TABLE `y_goods_tag`

  ADD PRIMARY KEY (`id`);



--

-- Indexes for table `y_goods_tags_goods`

--

ALTER TABLE `y_goods_tags_goods`

  ADD PRIMARY KEY (`goods_id`,`tags_id`),

  ADD KEY `FKd35qcvwe90s48utep3vtu05o1` (`tags_id`);



--

-- Indexes for table `y_order`

--

ALTER TABLE `y_order`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKg87q234wyqwr6mbjlwqeco86q` (`user_id`);



--

-- Indexes for table `y_order_goods`

--

ALTER TABLE `y_order_goods`

  ADD PRIMARY KEY (`id`),

  ADD KEY `FKjdtasvaejqw2tqgxacgqxgsx2` (`goods_id`),

  ADD KEY `FK1t1tfnuuygtyhb5e4psc5ulg` (`order_id`);



--

-- Indexes for table `y_slide`

--

ALTER TABLE `y_slide`

  ADD PRIMARY KEY (`id`);



--

-- Indexes for table `y_user`

--

ALTER TABLE `y_user`

  ADD PRIMARY KEY (`id`);



--

-- 在导出的表使用AUTO_INCREMENT

--



--

-- 使用表AUTO_INCREMENT `sys_log`

--

ALTER TABLE `sys_log`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;

--

-- 使用表AUTO_INCREMENT `sys_menu`

--

ALTER TABLE `sys_menu`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--

-- 使用表AUTO_INCREMENT `sys_role`

--

ALTER TABLE `sys_role`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--

-- 使用表AUTO_INCREMENT `sys_user`

--

ALTER TABLE `sys_user`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--

-- 使用表AUTO_INCREMENT `y_address`

--

ALTER TABLE `y_address`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--

-- 使用表AUTO_INCREMENT `y_cart`

--

ALTER TABLE `y_cart`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--

-- 使用表AUTO_INCREMENT `y_goods`

--

ALTER TABLE `y_goods`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--

-- 使用表AUTO_INCREMENT `y_goods_gallery`

--

ALTER TABLE `y_goods_gallery`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--

-- 使用表AUTO_INCREMENT `y_goods_spec`

--

ALTER TABLE `y_goods_spec`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--

-- 使用表AUTO_INCREMENT `y_goods_tag`

--

ALTER TABLE `y_goods_tag`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--

-- 使用表AUTO_INCREMENT `y_order`

--

ALTER TABLE `y_order`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--

-- 使用表AUTO_INCREMENT `y_order_goods`

--

ALTER TABLE `y_order_goods`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--

-- 使用表AUTO_INCREMENT `y_slide`

--

ALTER TABLE `y_slide`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--

-- 使用表AUTO_INCREMENT `y_user`

--

ALTER TABLE `y_user`

  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--

-- 限制导出的表

--



--

-- 限制表 `sys_menu`

--

ALTER TABLE `sys_menu`

  ADD CONSTRAINT `FK2jrf4gb0gjqi8882gxytpxnhe` FOREIGN KEY (`parent_id`) REFERENCES `sys_menu` (`id`);



--

-- 限制表 `sys_role`

--

ALTER TABLE `sys_role`

  ADD CONSTRAINT `FKce4uus2biaik6iv5wtwteetb2` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`);



--

-- 限制表 `sys_role_menu`

--

ALTER TABLE `sys_role_menu`

  ADD CONSTRAINT `FK1cdbccagpnub6v0c34lgya014` FOREIGN KEY (`menu_id`) REFERENCES `sys_user` (`id`),

  ADD CONSTRAINT `FKf3mud4qoc7ayew8nml4plkevo` FOREIGN KEY (`menu_id`) REFERENCES `sys_menu` (`id`),

  ADD CONSTRAINT `FKkeitxsgxwayackgqllio4ohn5` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`);



--

-- 限制表 `sys_role_user`

--

ALTER TABLE `sys_role_user`

  ADD CONSTRAINT `FK1qf7bu5lhwt9y00uesmcgnbxd` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),

  ADD CONSTRAINT `FKe853e1gbgbb6ov7al35mfd3nm` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`);



--

-- 限制表 `sys_user`

--

ALTER TABLE `sys_user`

  ADD CONSTRAINT `FKrg8wsmjn9ruu4k700hnq3oxtm` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`);



--

-- 限制表 `y_address`

--

ALTER TABLE `y_address`

  ADD CONSTRAINT `FKini0e7s2nlxcguuyt32q5lbl0` FOREIGN KEY (`user_id`) REFERENCES `y_user` (`id`);



--

-- 限制表 `y_cart`

--

ALTER TABLE `y_cart`

  ADD CONSTRAINT `FKip1856jt94eo54j97qdrq3bil` FOREIGN KEY (`goods_id`) REFERENCES `y_goods` (`id`),

  ADD CONSTRAINT `FKtbj7ccvhwn3dtlb675cq3apid` FOREIGN KEY (`user_id`) REFERENCES `y_user` (`id`);



--

-- 限制表 `y_goods_gallery`

--

ALTER TABLE `y_goods_gallery`

  ADD CONSTRAINT `FKfol7rag41cnavd8owb63n9mf5` FOREIGN KEY (`goods_id`) REFERENCES `y_goods` (`id`);



--

-- 限制表 `y_goods_spec`

--

ALTER TABLE `y_goods_spec`

  ADD CONSTRAINT `FKqiwsepfal7ia08hm3e3py294o` FOREIGN KEY (`goods_id`) REFERENCES `y_goods` (`id`);



--

-- 限制表 `y_goods_tags_goods`

--

ALTER TABLE `y_goods_tags_goods`

  ADD CONSTRAINT `FK5xkqq6pgxbwv38b7gsff5inqh` FOREIGN KEY (`goods_id`) REFERENCES `y_goods` (`id`),

  ADD CONSTRAINT `FKd35qcvwe90s48utep3vtu05o1` FOREIGN KEY (`tags_id`) REFERENCES `y_goods_tag` (`id`);



--

-- 限制表 `y_order`

--

ALTER TABLE `y_order`

  ADD CONSTRAINT `FKg87q234wyqwr6mbjlwqeco86q` FOREIGN KEY (`user_id`) REFERENCES `y_user` (`id`);



--

-- 限制表 `y_order_goods`

--

ALTER TABLE `y_order_goods`

  ADD CONSTRAINT `FK1t1tfnuuygtyhb5e4psc5ulg` FOREIGN KEY (`order_id`) REFERENCES `y_order` (`id`),

  ADD CONSTRAINT `FKjdtasvaejqw2tqgxacgqxgsx2` FOREIGN KEY (`goods_id`) REFERENCES `y_goods` (`id`);



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/paste/yjshop.git
git@gitee.com:paste/yjshop.git
paste
yjshop
yjshop
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部