/*
 Navicat Premium Data Transfer

 Source Server         : mongodb-localhost
 Source Server Type    : MongoDB
 Source Server Version : 30204
 Source Host           : localhost:27017
 Source Schema         : server_db2

 Target Server Type    : MongoDB
 Target Server Version : 30204
 File Encoding         : 65001

 Date: 04/08/2021 15:43:46
*/


 ----------------------------
 --Collection structure for categorys--
 ----------------------------
db.getCollection("categorys").drop();
db.createCollection("categorys");

----------------------------
--Documents of categorys--
----------------------------
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e12b8bce31bb727e4b0e348"),
    parentId: "0",
    name: "家用电器",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e130ec7e31bb727e4b0e34c"),
    parentId: "0",
    name: "洗衣机",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e130e60e31bb727e4b0e34b"),
    parentId: "0",
    name: "手机",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e1346533ed02518b4db0cd7"),
    parentId: "0",
    name: "图书",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e13467e3ed02518b4db0cd8"),
    parentId: "0",
    name: "杯具",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e144dc7297c1138787e96ab"),
    parentId: "0",
    name: "服装",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e1346c83ed02518b4db0cd9"),
    parentId: "0",
    name: "纸",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e144de1297c1138787e96ac"),
    parentId: "0",
    name: "玩具",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e16e37e49dc6b38d018fe28"),
    parentId: "0",
    name: "手机",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5e16e38949dc6b38d018fe29"),
    name: "三星",
    __v: NumberInt("0"),
    parentId: "0"
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc0bf33eb957f1b94f4a959"),
    parentId: "0",
    name: "医药",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc0bfa4eb957f1b94f4a95a"),
    parentId: "0",
    name: "食品",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc0bfcdeb957f1b94f4a95b"),
    parentId: "0",
    name: "发型",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc0bfd7eb957f1b94f4a95c"),
    parentId: "0",
    name: "水果",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc0bfdeeb957f1b94f4a95d"),
    parentId: "0",
    name: "发饰",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc30a1833fe4221c4546275"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "冰箱",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc0bfe6eb957f1b94f4a95e"),
    parentId: "0",
    name: "图纸",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc30a4133fe4221c4546276"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "微波炉",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc30a6533fe4221c4546279"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "消毒碗柜",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc30a5133fe4221c4546278"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "洗衣机",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc30a4a33fe4221c4546277"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "电饭煲",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc30a6f33fe4221c454627a"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "电视",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc30a7a33fe4221c454627b"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "抽油烟机",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc5a5ff4870c82a702c5efd"),
    parentId: "0",
    name: "bbb",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc5b24b4870c82a702c5f05"),
    parentId: "0",
    name: "2",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc5b2ae4870c82a702c5f06"),
    parentId: "0",
    name: "34",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc5b2b84870c82a702c5f07"),
    parentId: "5fc5b2ae4870c82a702c5f06",
    name: "222",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc74b650dd9b10798413162"),
    parentId: "5e12b8bce31bb727e4b0e348",
    name: "电脑",
    __v: NumberInt("0")
} ]);
db.getCollection("categorys").insert([ {
    _id: ObjectId("5fc9e7cc618171388c09b7eb"),
    parentId: "0",
    name: "哈哈哈",
    __v: NumberInt("0")
} ]);

// ----------------------------
// Collection structure for products
// ----------------------------
db.getCollection("products").drop();
db.createCollection("products");

 ----------------------------
 --Documents of products--
 ----------------------------
db.getCollection("products").insert([ {
    _id: ObjectId("5e12b97de31bb727e4b0e349"),
    status: NumberInt("2"),
    imgs: [
        "1578588737108-index.jpg"
    ],
    name: "联想ThinkPad 翼4809",
    desc: "年度重量级新品，X390、T490全新登场 更加轻薄机身设计9",
    price: NumberInt("6300"),
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    detail: "<p><span style=\"color: rgb(228,57,60);background-color: rgb(255,255,255);font-size: 12px;\">想你所需，超你所想！精致外观，轻薄便携带光驱，内置正版office杜绝盗版死机，全国联保两年！</span></p>\n<p><span style=\"color: rgb(102,102,102);background-color: rgb(255,255,255);font-size: 16px;\">联想（Lenovo）扬天V110 15.6英寸家用轻薄便携商务办公手提笔记本电脑 定制【E2-9010/4G/128G固态】 2G独显 内置</span></p>\n<p><span style=\"color: rgb(102,102,102);background-color: rgb(255,255,255);font-size: 16px;\"></span></p>\n",
    __v: NumberInt("0")
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e12b9d1e31bb727e4b0e34a"),
    status: NumberInt("1"),
    imgs: [
        "image-1559402448049.jpg",
        "image-1559402450480.jpg"
    ],
    name: "华硕(ASUS) 飞行堡垒",
    desc: "15.6英寸窄边框游戏笔记本电脑(i7-8750H 8G 256GSSD+1T GTX1050Ti 4G IPS)",
    price: NumberInt("6799"),
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    detail: "<p><span style=\"color: rgb(102,102,102);background-color: rgb(255,255,255);font-size: 16px;\">华硕(ASUS) 飞行堡垒6 15.6英寸窄边框游戏笔记本电脑(i7-8750H 8G 256GSSD+1T GTX1050Ti 4G IPS)火陨红黑</span>&nbsp;</p>\n<p><span style=\"color: rgb(228,57,60);background-color: rgb(255,255,255);font-size: 12px;\">【4.6-4.7号华硕集体放价，大牌够品质！】1T+256G高速存储组合！超窄边框视野无阻，强劲散热一键启动！</span>&nbsp;</p>\n",
    __v: NumberInt("0")
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e145c55d9ba8f39dc5f879f"),
    status: NumberInt("2"),
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "联想ThinkPad 翼4809",
    desc: "年度重量级新品，X390、T490全新登场 更加轻薄机身设计9",
    price: "65999",
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    __v: "0"
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e145c5ed9ba8f39dc5f87a1"),
    status: "1",
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "联想ThinkPad 翼4809",
    desc: "年度重量级新品，X390、T490全新登场 更加轻薄机身设计9",
    price: "65999",
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    __v: "0"
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e146b3cd9ba8f39dc5f87a2"),
    status: "1",
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "联想ThinkPad 翼4809",
    desc: "年度重量级新品，X390、T490全新登场 更加轻薄机身设计9",
    price: "65999",
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    detail: "",
    __v: "0"
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e146b40d9ba8f39dc5f87a3"),
    status: NumberInt("2"),
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "联想ThinkPad 翼4809",
    desc: "年度重量级新品，X390、T490全新登场 更加轻薄机身设计9",
    price: "65999",
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    detail: "",
    __v: "0"
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e146b44d9ba8f39dc5f87a4"),
    status: "1",
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "联想ThinkPad 翼4809",
    desc: "年度重量级新品，X390、T490全新登场 更加轻薄机身设计9",
    price: "65999",
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    detail: "",
    __v: "0"
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e17045939c375286459fc82"),
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "测试一号",
    desc: "哈哈哈哈哈哈",
    price: NumberInt("99999"),
    detail: "<p>少时诵诗书所所所</p>\n",
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    status: NumberInt("1"),
    __v: NumberInt("0")
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5fc7096f0dd9b10798413160"),
    status: NumberInt("1"),
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "美的(Midea) 213升-BCD-213TM",
    desc: "爆款直降!大容量三口之家优选! *节能养鲜,自动低温补偿,36分贝静音呵护",
    price: NumberInt("1388"),
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc30a1833fe4221c4546275",
    detail: "<p style=\"text-align:start;\"><span style=\"color: rgb(102,102,102);background-color: rgb(255,255,255);font-size: 16px;font-family: Arial, \"microsoft yahei;\">美的(Midea) 213升 节能静音家用三门小冰箱 阳光米 BCD-213TM(E)</span></p>\n<p><span style=\"color: rgb(228,57,60);background-color: rgb(255,255,255);font-size: 12px;font-family: tahoma, arial, \"Microsoft YaHei\", \"Hiragino Sans GB\", u5b8bu4f53, sans-serif;\">【4.8美的大牌秒杀日】爆款直降!大容量三口之家优选! *节能养鲜,自动低温补偿,36分贝静音呵护! *每天不到一度电,省钱又省心!</span>&nbsp;</p>\n",
    __v: NumberInt("0")
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5fc9ea2b1cb7c416c4fb7edc"),
    status: NumberInt("1"),
    imgs: [ ],
    categoryId: "5e12b8bce31bb727e4b0e348",
    pCategoryId: "0",
    name: "测试1",
    price: NumberInt("1000"),
    __v: NumberInt("0")
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5e146b4dd9ba8f39dc5f87a5"),
    status: NumberInt("2"),
    imgs: [
        "image-1559402396338.jpg"
    ],
    name: "联想ThinkPad 翼4809",
    desc: "年度重量级新品，X390、T490全新登场 更加轻薄机身设计9",
    price: "65999",
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    detail: "",
    __v: "0"
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5fc9eca01cb7c416c4fb7ee1"),
    status: NumberInt("1"),
    imgs: [ ],
    name: "123",
    desc: "213",
    price: NumberInt("213"),
    pCategoryId: "0",
    categoryId: "5e130e60e31bb727e4b0e34b",
    __v: NumberInt("0")
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5fc74fe10dd9b10798413163"),
    status: NumberInt("2"),
    imgs: [
        "image-1559402436395.jpg"
    ],
    name: "你不知道的JS（上卷）",
    desc: "图灵程序设计丛书： [You Don't Know JS:Scope & Closures] JavaScript开发经典入门图书 打通JavaScript的任督二脉",
    price: NumberInt("35"),
    pCategoryId: "0",
    categoryId: "5e1346533ed02518b4db0cd7",
    detail: "<p style=\"text-align:start;\"><span style=\"color: rgb(102,102,102);background-color: rgb(255,255,255);font-size: 16px;\">图灵程序设计丛书：你不知道的JavaScript（上卷）</span> <span style=\"color: rgb(102,102,102);background-color: rgb(255,255,255);font-size: 16px;\"><strong>[You Don't Know JS:Scope &amp; Closures]</strong></span></p>\n<p style=\"text-align:start;\"><span style=\"color: rgb(227,57,60);background-color: rgb(255,255,255);font-size: 12px;\">JavaScript开发经典入门图书 打通JavaScript的任督二脉 领略语言内部的绝美风光</span>&nbsp;</p>\n",
    __v: NumberInt("0")
} ]);
db.getCollection("products").insert([ {
    _id: ObjectId("5fc709a00dd9b10798413161"),
    status: NumberInt("1"),
    imgs: [
        "image-1554638676149.jpg",
        "image-1554638683746.jpg"
    ],
    name: "联想ThinkPad X1 Carbon",
    desc: "英特尔酷睿i5 14英寸轻薄笔记本电脑（i5-8250U 8G 256GSSD FHD）黑色",
    price: NumberInt("9999"),
    pCategoryId: "5e12b8bce31bb727e4b0e348",
    categoryId: "5fc74b650dd9b10798413162",
    detail: "<p style=\"text-align:start;\"><span style=\"color: rgb(102,102,102);background-color: rgb(255,255,255);font-size: 16px;font-family: Arial, \"microsoft yahei;\">联想ThinkPad X1 Carbon 2018（09CD）英特尔酷睿i5 14英寸轻薄笔记本电脑（i5-8250U 8G 256GSSD FHD）黑色</span></p>\n<p><span style=\"color: rgb(228,57,60);background-color: rgb(255,255,255);font-size: 12px;font-family: tahoma, arial, \"Microsoft YaHei\", \"Hiragino Sans GB\", u5b8bu4f53, sans-serif;\">年度重量级新品，X390、T490全新登场 更加轻薄机身设计，全面的配置升级，让工作更便捷，让生活更轻松</span><a href=\"https://pro.jd.com/mall/active/2M4o7NTzHH6jEJXS7VbpbTAANQB9/index.html\" target=\"_blank\"><span style=\"color: rgb(94,105,173);background-color: rgb(255,255,255);font-size: 12px;font-family: tahoma, arial, \"Microsoft YaHei\", \"Hiragino Sans GB\", u5b8bu4f53, sans-serif;\">4月9日京东震撼首发，火爆预约</span></a>&nbsp;</p>\n",
    __v: NumberInt("0")
} ]);

// ----------------------------
// Collection structure for roles
// ----------------------------
db.getCollection("roles").drop();
db.createCollection("roles");

// ----------------------------
// Documents of roles
// ----------------------------
db.getCollection("roles").insert([ {
    _id: ObjectId("5e0d7292bd72914ee8e714d4"),
    name: "测试",
    "auth_time": NumberLong("1607481252131"),
    "auth_name": "admin",
    "create_time": NumberLong("1554639521749"),
    menus: [
        "/category",
        "/home"
    ]
} ]);
db.getCollection("roles").insert([ {
    _id: ObjectId("5e175a134bce5e36d48fb4db"),
    menus: [
        "all",
        "/home",
        "/products",
        "/category",
        "/product",
        "/user",
        "/role",
        "/charts",
        "/charts/bar",
        "/charts/line",
        "/charts/pie"
    ],
    name: "管理员",
    "create_time": NumberLong("1578588691768"),
    "auth_name": "admin",
    "auth_time": NumberLong("1578588698490")
} ]);
db.getCollection("roles").insert([ {
    _id: ObjectId("5e188bb874c89321209fedda"),
    menus: [
        "/home",
        "/charts/bar",
        "/charts",
        "/charts/line",
        "/charts/pie",
        "/role"
    ],
    name: "员工",
    "create_time": NumberLong("1578666936202"),
    "auth_name": "admin",
    "auth_time": NumberLong("1607330722391")
} ]);
db.getCollection("roles").insert([ {
    _id: ObjectId("5fcdcb428e518d46807aa485"),
    menus: [ ],
    name: "哈哈哈",
    "create_time": NumberLong("1607322434116")
} ]);
db.getCollection("roles").insert([ {
    _id: ObjectId("5fcdca798e518d46807aa484"),
    menus: [
        "/category"
    ],
    name: "你好",
    "create_time": NumberLong("1607322233401"),
    "auth_time": NumberLong("1607411041057"),
    "auth_name": "admin"
} ]);
db.getCollection("roles").insert([ {
    _id: ObjectId("5fcdcb528e518d46807aa486"),
    menus: [ ],
    name: "哈哈啊",
    "create_time": NumberLong("1607322450051")
} ]);
db.getCollection("roles").insert([ {
    _id: ObjectId("5fcdcd638e518d46807aa488"),
    menus: [ ],
    name: "123",
    "create_time": NumberLong("1607322979807")
} ]);
db.getCollection("roles").insert([ {
    _id: ObjectId("5e171d55d59eb648d4ed66a8"),
    menus: [
        "/home",
        "/products",
        "/category",
        "/product",
        "/charts/pie"
    ],
    name: "测试",
    "create_time": NumberLong("1578573141547"),
    "auth_name": "admin",
    "auth_time": NumberLong("1607406938634")
} ]);

// ----------------------------
// Collection structure for users
// ----------------------------
db.getCollection("users").drop();
db.createCollection("users");

// ----------------------------
// Documents of users
// ----------------------------
db.getCollection("users").insert([ {
    _id: ObjectId("610a39764f93334154bb3520"),
    username: "admin",
    password: "21232f297a57a5a743894a0e4a801fc3",
    "create_time": 1628060022887,
    __v: NumberInt("0")
} ]);
db.getCollection("users").insert([ {
    _id: ObjectId("5fd06791fa244c0b10cadec9"),
    username: "Jim",
    password: "202cb962ac59075b964b07152d234b70",
    phone: "72612189",
    email: "feedback@outlook.com",
    "role_id": "5e0d7292bd72914ee8e714d4",
    "create_time": NumberLong("1552062212734"),
    __v: NumberInt("0")
} ]);
db.getCollection("users").insert([ {
    _id: ObjectId("5fd06735fa244c0b10cadec7"),
    username: "Tom",
    password: "202cb962ac59075b964b07152d234b70",
    phone: "123242434",
    email: "sd",
    "role_id": "5e188bb874c89321209fedda",
    "create_time": NumberLong("1555061512734"),
    __v: NumberInt("0")
} ]);
db.getCollection("users").insert([ {
    _id: ObjectId("5fd06aaf97daee1b6c09b1cd"),
    username: "admin",
    password: "21232f297a57a5a743894a0e4a801fc3",
    phone: "224249",
    email: "admin@outlook.com",
    "role_id": "5e175a134bce5e36d48fb4db",
    "create_time": NumberLong("1212062212734"),
    __v: NumberInt("0")
} ]);
db.getCollection("users").insert([ {
    _id: ObjectId("5fd067affa244c0b10cadeca"),
    username: "Kira",
    password: "202cb962ac59075b964b07152d234b70",
    phone: "224249",
    email: "wait@outlook.com",
    "role_id": "5fcdca798e518d46807aa484",
    "create_time": NumberLong("1252062212734"),
    __v: NumberInt("0")
} ]);
db.getCollection("users").insert([ {
    _id: ObjectId("5fd0675bfa244c0b10cadec8"),
    username: "Cindy",
    password: "202cb962ac59075b964b07152d234b70",
    phone: "12324233434",
    email: "plp",
    "role_id": "5e0d7292bd72914ee8e714d4",
    "create_time": NumberLong("1555062212734"),
    __v: NumberInt("0")
} ]);
db.getCollection("users").insert([ {
    _id: ObjectId("5fd09192efe9692bd0dd40de"),
    username: "test2",
    password: "202cb962ac59075b964b07152d234b70",
    phone: "123",
    email: "123",
    "role_id": "5e188bb874c89321209fedda",
    "create_time": NumberLong("1607504274441"),
    __v: NumberInt("0")
} ]);