UrShop小程序商城 基于 微信小程序 + NetCore + layui 技术

/* Navicat Premium Data Transfer Source Server : 192.168.110.20 Source Server Type : MySQL Source Server Version : 50734 Source Host : 192.168.110.20:3306 Source Schema : demo.urshop.cn Target Server Type : MySQL Target Server Version : 50734 File Encoding : 65001 Date: 16/05/2022 16:45:44 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for __efmigrationshistory -- ---------------------------- DROP TABLE IF EXISTS `__efmigrationshistory`; CREATE TABLE `__efmigrationshistory` ( `MigrationId` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ProductVersion` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`MigrationId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of __efmigrationshistory -- ---------------------------- INSERT INTO `__efmigrationshistory` VALUES ('20180916150841_customattr', '2.1.1-rtm-30846'); -- ---------------------------- -- Table structure for activitylog -- ---------------------------- DROP TABLE IF EXISTS `activitylog`; CREATE TABLE `activitylog` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `ActivityLogTypeId` int(11) NOT NULL, `UserId` int(11) NOT NULL, `Comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `CreateTime` datetime(0) NOT NULL, PRIMARY KEY (`Id`) USING BTREE, UNIQUE INDEX `Id`(`Id`) USING BTREE, INDEX `ActivityLogTypeId`(`ActivityLogTypeId`) USING BTREE, INDEX `CustomerId`(`UserId`) USING BTREE, CONSTRAINT `ActivityLog_ActivityLogType` FOREIGN KEY (`ActivityLogTypeId`) REFERENCES `activitylogtype` (`Id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `ActivityLog_Customer` FOREIGN KEY (`UserId`) REFERENCES `user` (`Id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 26759 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of activitylog -- ---------------------------- INSERT INTO `activitylog` VALUES (23000, 52, 1, '登录', '2019-08-05 17:33:03'); INSERT INTO `activitylog` VALUES (23001, 52, 1, '登录', '2019-08-06 19:30:50'); INSERT INTO `activitylog` VALUES (23002, 52, 1, '登录', '2019-08-07 15:48:18'); INSERT INTO `activitylog` VALUES (23003, 40, 1, '编辑设置', '2019-08-07 16:31:34'); INSERT INTO `activitylog` VALUES (23004, 52, 1, '登录', '2019-08-08 14:35:10'); INSERT INTO `activitylog` VALUES (23005, 52, 1, '登录', '2019-08-09 13:44:29'); INSERT INTO `activitylog` VALUES (23006, 52, 1, '登录', '2019-08-09 17:29:45'); INSERT INTO `activitylog` VALUES (23007, 11, 1, '添加新闻设置', '2019-08-09 17:35:35'); INSERT INTO `activitylog` VALUES (23008, 11, 1, '添加新闻设置', '2019-08-09 17:35:52'); INSERT INTO `activitylog` VALUES (23009, 11, 1, '添加新闻设置', '2019-08-09 17:36:27'); INSERT INTO `activitylog` VALUES (23010, 52, 1, '登录', '2019-08-09 17:41:28'); INSERT INTO `activitylog` VALUES (23011, 16, 1, '删除用户(ID = 284801)', '2019-08-09 18:18:04'); INSERT INTO `activitylog` VALUES (23012, 8, 1, '新增', '2019-08-09 18:31:13'); INSERT INTO `activitylog` VALUES (23014, 52, 1, '登录', '2019-08-09 19:07:50'); INSERT INTO `activitylog` VALUES (23015, 52, 1, '登录', '2019-08-09 19:07:58'); INSERT INTO `activitylog` VALUES (23016, 52, 1, '登录', '2019-08-09 20:59:55'); INSERT INTO `activitylog` VALUES (23017, 52, 1, '登录', '2019-08-10 13:27:19'); INSERT INTO `activitylog` VALUES (23018, 52, 1, '登录', '2019-08-11 21:13:33'); INSERT INTO `activitylog` VALUES (23019, 52, 1, '登录', '2019-08-11 21:34:22'); INSERT INTO `activitylog` VALUES (23020, 52, 1, '登录', '2019-08-11 21:36:09'); INSERT INTO `activitylog` VALUES (23021, 52, 1, '登录', '2019-08-12 09:51:08'); INSERT INTO `activitylog` VALUES (23022, 52, 1, '登录', '2019-08-12 10:39:29'); INSERT INTO `activitylog` VALUES (23023, 52, 1, '登录', '2019-08-12 14:19:11'); INSERT INTO `activitylog` VALUES (23025, 52, 1, '登录', '2019-08-12 14:33:13'); INSERT INTO `activitylog` VALUES (23027, 52, 1, '登录', '2019-08-12 14:36:18'); INSERT INTO `activitylog` VALUES (23028, 52, 1, '登录', '2019-08-12 14:56:46'); INSERT INTO `activitylog` VALUES (23029, 52, 1, '登录', '2019-08-12 15:57:24'); INSERT INTO `activitylog` VALUES (23030, 52, 1, '登录', '2019-08-12 15:58:07'); INSERT INTO `activitylog` VALUES (23031, 52, 1, '登录', '2019-08-12 17:57:59'); INSERT INTO `activitylog` VALUES (23032, 52, 1, '登录', '2019-08-12 18:04:01'); INSERT INTO `activitylog` VALUES (23033, 52, 1, '登录', '2019-08-12 20:50:25'); INSERT INTO `activitylog` VALUES (23035, 52, 1, '登录', '2019-08-13 01:30:46'); INSERT INTO `activitylog` VALUES (23036, 52, 1, '登录', '2019-08-13 09:06:32'); INSERT INTO `activitylog` VALUES (23039, 52, 1, '登录', '2019-08-13 10:16:19'); INSERT INTO `activitylog` VALUES (23040, 52, 1, '登录', '2019-08-13 10:22:36'); INSERT INTO `activitylog` VALUES (23041, 52, 1, '登录', '2019-08-13 10:22:36'); INSERT INTO `activitylog` VALUES (23042, 52, 1, '登录', '2019-08-13 10:22:36'); INSERT INTO `activitylog` VALUES (23044, 52, 1, '登录', '2019-08-13 12:09:25'); INSERT INTO `activitylog` VALUES (23045, 52, 1, '登录', '2019-08-13 12:17:37'); INSERT INTO `activitylog` VALUES (23046, 52, 1, '登录', '2019-08-13 15:13:45'); INSERT INTO `activitylog` VALUES (23048, 52, 1, '登录', '2019-08-13 23:03:12'); INSERT INTO `activitylog` VALUES (23049, 52, 1, '登录', '2019-08-14 01:41:14'); INSERT INTO `activitylog` VALUES (23050, 52, 1, '登录', '2019-08-14 02:40:42'); INSERT INTO `activitylog` VALUES (23051, 40, 1, '编辑设置', '2019-08-14 03:06:21'); INSERT INTO `activitylog` VALUES (23052, 40, 1, '编辑设置', '2019-08-14 03:17:40'); INSERT INTO `activitylog` VALUES (23053, 40, 1, '编辑设置', '2019-08-14 03:17:55'); INSERT INTO `activitylog` VALUES (23054, 52, 1, '登录', '2019-08-14 10:53:17'); INSERT INTO `activitylog` VALUES (23055, 52, 1, '登录', '2019-08-14 13:04:26'); INSERT INTO `activitylog` VALUES (23056, 52, 1, '登录', '2019-08-14 13:19:50'); INSERT INTO `activitylog` VALUES (23057, 52, 1, '登录', '2019-08-14 15:31:39'); INSERT INTO `activitylog` VALUES (23058, 52, 1, '登录', '2019-08-14 17:14:05'); INSERT INTO `activitylog` VALUES (23059, 52, 1, '登录', '2019-08-14 17:52:49'); INSERT INTO `activitylog` VALUES (23060, 52, 1, '登录', '2019-08-14 17:52:51'); INSERT INTO `activitylog` VALUES (23061, 40, 1, '编辑设置', '2019-08-14 18:03:50'); INSERT INTO `activitylog` VALUES (23062, 40, 1, '编辑设置', '2019-08-14 18:04:00'); INSERT INTO `activitylog` VALUES (23063, 52, 1, '登录', '2019-08-14 18:09:33'); INSERT INTO `activitylog` VALUES (23065, 52, 1, '登录', '2019-08-14 18:48:09'); INSERT INTO `activitylog` VALUES (23066, 52, 1, '登录', '2019-08-14 19:39:58'); INSERT INTO `activitylog` VALUES (23067, 52, 1, '登录', '2019-08-15 08:05:46'); INSERT INTO `activitylog` VALUES (23068, 52, 1, '登录', '2019-08-15 11:57:07'); INSERT INTO `activitylog` VALUES (23069, 52, 1, '登录', '2019-08-15 19:35:59'); INSERT INTO `activitylog` VALUES (23070, 52, 1, '登录', '2019-08-16 15:45:36'); INSERT INTO `activitylog` VALUES (23431, 52, 1, '登录', '2019-08-19 11:17:39'); INSERT INTO `activitylog` VALUES (23432, 52, 1, '登录', '2019-08-19 12:44:21'); INSERT INTO `activitylog` VALUES (23433, 52, 1, '登录', '2019-08-19 13:31:20'); INSERT INTO `activitylog` VALUES (23434, 52, 1, '登录', '2019-08-21 17:46:55'); INSERT INTO `activitylog` VALUES (23435, 52, 1, '登录', '2019-08-21 17:51:49'); INSERT INTO `activitylog` VALUES (23436, 52, 1, '登录', '2019-08-21 17:52:56'); INSERT INTO `activitylog` VALUES (23437, 35, 1, '编辑', '2019-08-21 17:53:31'); INSERT INTO `activitylog` VALUES (23438, 35, 1, '编辑', '2019-08-21 18:02:21'); INSERT INTO `activitylog