testdata.sql 3.1 KB

123456
  1. INSERT INTO `__PREFIX__service_mini_template` (`id`, `user_notice_template`, `user_order_template`, `order_finish_template`, `user_sales_template`, `user_complaint_template`, `skill_order_template`, `skill_sales_template`, `shop_order_template`, `shop_finish_template`, `shop_sales_template`, `state`, `createtime`, `updatetime`) VALUES
  2. (1, '{\"template_id\":\"wh-Tf1K9BCulmYunVeo0I\",\"name\":\"name5\",\"cate\":\"thing14\",\"address\":\"thing2\",\"time\":\"date11\",\"note\":\"thing12\",\"url\":\"\\/service\\/orderdetail\\/orderdetail?id=\"}', '{\"template_id\":\"VdVVUljAy47J-63Wy_U\",\"status\":\"thing4\",\"cate\":\"thing10\",\"time\":\"date3\",\"note\":\"thing9\",\"url\":\"\\/service\\/orderdetail\\/orderdetail?id=\"}', '{\"template_id\":\"PfrBkPykVujjWXfjeY\",\"status\":\"thing3\",\"cate\":\"thing6\",\"time\":\"date4\",\"note\":\"thing16\",\"url\":\"\\/service\\/orderdetail\\/orderdetail?id=\"}', '{\"template_id\":\"Hu01nKDny9u5qBdQtY\",\"cate\":\"thing1\",\"status\":\"phrase2\",\"time\":\"time3\",\"note\":\"thing4\",\"url\":\"\\/service\\/orderdetail\\/orderdetail?id=\"}', '{\"template_id\":\"k0md6xBdU-jDGwE\",\"content\":\"thing2\",\"time\":\"time3\",\"res\":\"thing4\",\"note\":\"thing8\",\"url\":\"\\/service\\/orderdetail\\/orderdetail?id=\"}', '{\"template_id\":\"TvLP6DjGWEHOhzZqc\",\"price\":\"amount10\",\"cate\":\"thing4\",\"time\":\"date5\",\"address\":\"thing22\",\"note\":\"thing9\",\"url\":\"\\/pages\\/orderDetail\\/orderDetail?id=\"}', '{\"template_id\":\"G9hlX2ogpLtWVFVcq7t8\",\"cate\":\"thing2\",\"status\":\"phrase3\",\"note\":\"thing4\",\"url\":\"\\/pages\\/orderDetail\\/orderDetail?id=\"}', '{\"template_id\":\"hCkCJlrJBB3N3nEg2iK7hJaM\",\"price\":\"amount10\",\"cate\":\"thing4\",\"time\":\"thing7\",\"address\":\"thing22\",\"note\":\"thing9\",\"url\":\"\\/pages\\/orderDetail\\/orderDetail?order_id=\"}', '{\"template_id\":\"B4dFH-4UT_g2gWoO4\",\"status\":\"phrase11\",\"price\":\"amount6\",\"name\":\"thing16\",\"cate\":\"thing10\",\"url\":\"\\/pages\\/orderDetail\\/orderDetail?order_id=\"}', '{\"template_id\":\"xRflDWHpUaGq5Xw\",\"cate\":\"thing2\",\"status\":\"phrase3\",\"note\":\"thing4\",\"url\":\"\\/pages\\/orderDetail\\/orderDetail?order_id=\"}', 1, NULL, 1705303601);
  3. INSERT INTO `__PREFIX__service_project_configure` (`id`, `userappid`, `usersecret`, `skillappid`, `skillsecret`, `shopappid`, `shopsecret`, `gaodekey`, `state`, `createtime`, `updatetime`) VALUES
  4. (1, 'wxxxxxxxx1231434', 'wxxxxxxxx1231434', 'wxxxxxxxx1231434', 'wxxxxxxxx1231434', 'wxxxxxxxx1231434', 'wxxxxxxxx1231434', 'wxxxxxxxx1231434', 1, 1700275473, 1704865818);
  5. INSERT INTO `__PREFIX__service_project_config` (`id`, `service_mobile`, `cooperate_mobile`, `user_notice`, `skill_notice`, `shop_notice`, `refund_notice`, `cancel_minute`, `comment_day`, `state`, `createtime`, `updatetime`) VALUES
  6. (1, '18200000000', '18200000000', '切换到北京、上海、广州、成都、郑州体验效果更好', '这是一个服务端小广播', '这是一个商户端小广播', '1、这是一个退款注意事项.\r\n2、这是一个退款注意事项.\r\n3、这是一个退款注意事项.', 10, 7, 1, 1700130964, 1705391875);