精品--毕业设计项目，网上商城项目（SpringBoot）.zip

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for sp_account -- ---------------------------- DROP TABLE IF EXISTS `sp_account`; CREATE TABLE `sp_account` ( `aid` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `abalance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `abankcard` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`aid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sp_account -- ---------------------------- INSERT INTO `sp_account` VALUES (1, 1, 'test', 'test'); INSERT INTO `sp_account` VALUES (2, 2, '8630', '623333888888888888'); INSERT INTO `sp_account` VALUES (3, 2, '0', '623333888888888889'); INSERT INTO `sp_account` VALUES (8, 10, '1000', '537373273878373'); INSERT INTO `sp_account` VALUES (9, 11, '160640', '34573453453'); INSERT INTO `sp_account` VALUES (10, 12, '700', '1010104204724'); -- ---------------------------- -- Table structure for sp_address -- ---------------------------- DROP TABLE IF EXISTS `sp_address`; CREATE TABLE `sp_address` ( `arid` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `detailedarea` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `postalcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `consignee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `consigneephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`arid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sp_address -- ---------------------------- INSERT INTO `sp_address` VALUES (1, 1, 'test', 'test', 'test', 'test', 'test'); INSERT INTO `sp_address` VALUES (6, 2, '中国北京市市辖区西城区', '老北京人早上起来就是这一出', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (7, 2, '中国北京市市辖区西城区', '老北京人早上起来就是这一', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (8, 2, '中国北京市市辖区西城区', '老北京人早上起来就是这', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (9, 2, '中国北京市市辖区西城区', '老北京人早上起来就是', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (10, 2, '中国北京市市辖区西城区', '老北京人早上起来就', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (11, 2, '中国北京市市辖区西城区', '老北京人早上起来', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (12, 2, '中国北京市市辖区西城区', '老北京人早上起', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (13, 2, '中国北京市市辖区西城区', '老北京人早上', '000000', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (14, 2, '中国天津市市辖区和平区', '老北京人早', '111111', '老北京人', '18888888888'); INSERT INTO `sp_address` VALUES (17, 2, '中国河北省石家庄市长安区', '老北京', '555555', '老天津了', '16666666666'); INSERT INTO `sp_address` VALUES (18, 4, '中国山西省太原市小店区', '老山西人了', '000000', '老山西', '16547896321'); INSERT INTO `sp_address` VALUES (19, 12, '中国北京市市辖区西城区', '424534563', '450000', '245745345', '45345354'); -- ---------------------------- -- Table structure for sp_admin -- ---------------------------- DROP TABLE IF EXISTS `sp_admin`; CREATE TABLE `sp_admin` ( `adid` int(11) NOT NULL AUTO_INCREMENT, `adacct` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `adname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `adpawd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `ademail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `adtime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`adid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sp_admin -- ---------------------------- INSERT INTO `sp_admin` VALUES (1, 'root', 'Administrators', 'root', 'root@root.com', '2020-02-29'); INSERT INTO `sp_admin` VALUES (2, '100114578', '张三', 'zhangsan', 'zhangsan@qq.com', '2020-03-01 17:51'); INSERT INTO `sp_admin` VALUES (3, '100125896', '李四', 'lisi', 'lisi@qq.com', '2020-03-01 17:56'); INSERT INTO `sp_admin` VALUES (4, '100123984', '王五', 'wangwu', 'wangwu@qq.com', '2020-03-01 17:57'); INSERT INTO `sp_admin` VALUES (5, '100569874', '赵六', 'zhaoliu', 'zhaoliu@qq.com', ' 2020-03-01 18:00'); INSERT INTO `sp_admin` VALUES (6, '100996541', '巨魔战将', 'jumozhanjiang', 'jumozhanjiang@qq.com', ' 2020-03-01 18:02'); INSERT INTO `sp_admin` VALUES (7, '100995645', '老北京', 'laobeijing', 'laobeijing@qq,com', ' 2020-03-01 18:07'); INSERT INTO `sp_admin` VALUES (9, '100985415', 'giao哥', 'giaoge', 'giaoge@qq.com', ' 2020-03-01 18:33'); -- ---------------------------- -- Table structure for sp_aspiration -- ---------------------------- DROP TABLE IF EXISTS `sp_aspiration`; CREATE TABLE `sp_aspiration` ( `asid` int(11) NOT NULL AUTO_INCREMENT, `coid` int(11) NOT NULL, `uid` int(11) NOT NULL, PRIMARY KEY (`asid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sp_aspiration -- ---------------------------- INSERT INTO `sp_aspiration` VALUES (1, 1, 1); INSERT INTO `sp_aspiration` VALUES (2, 1, 2); INSERT INTO `sp_aspiration` VALUES (3, 2, 2); INSERT INTO `sp_aspiration` VALUES (4, 3, 2); INSERT INTO `sp_aspiration` VALUES (5, 4, 2); INSERT INTO `sp_aspiration` VALUES (6, 5, 2); INSERT INTO `sp_aspiration` VALUES (7, 6, 2); INSERT INTO `sp_aspiration` VALUES (9, 8, 2); INSERT INTO `sp_aspiration` VALUES (10, 12, 2); INSERT INTO `sp_aspiration` VALUES (11, 11, 2); INSERT INTO `sp_aspiration` VALUES (12, 10, 2); -- ---------------------------- -- Table structure for sp_car -- ---------------------------- DROP TABLE IF EXISTS `sp_car`; CREATE TABLE `sp_car` ( `cid` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `coid` int(11) NOT NULL, `cnum` int(11) NOT NULL, PRIMARY KEY (`cid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sp_car -- ---------------------------- INSERT INTO `sp_car` VALUES (1, 1, 1, 4); INSERT INTO `sp_car` VALUES (23, 12, 2, 2); INSERT INTO `sp_car` VALUES (24, 12, 3, 2); INSERT INTO `sp_car` VALUES (25, 1, 2, 1); INSERT INTO `sp_car` VALUES (26, 1, 3, 3); INSERT INTO `sp_car` VALUES (27, 1, 4, 1); -- ---------------------------- -- Table structure for sp_commodity -- ---------------------------- DROP TABLE IF EXISTS `sp_commodity`; CREATE TABLE `sp_commodity` ( `coid` int(11) NOT NULL AUTO_INCREMENT, `coname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `coprice` int(11) NOT NULL, `cogrounding` int(11) NOT NULL, `conum` int(11) NOT NULL, `cyid` int(11) NOT NULL, `coimage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`coid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_