大数据2201

DROP TABLE IF EXISTS bumen;
CREATE TABLE bumen (
id int NULL DEFAULT NULL,
bumen varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

– Records of bumen

INSERT INTO bumen VALUES (1, ‘aa’);
INSERT INTO bumen VALUES (2, ‘bb’);
INSERT INTO bumen VALUES (3, ‘vv’);
INSERT INTO bumen VALUES (4, ‘dd’);

– Table structure for jbc

DROP TABLE IF EXISTS jbc;
CREATE TABLE jbc (
id int NULL DEFAULT NULL,
bumen varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

– Records of jbc

INSERT INTO jbc VALUES (1, ‘aa’);
INSERT INTO jbc VALUES (2, ‘bb’);
INSERT INTO jbc VALUES (3, ‘cc’);
INSERT INTO jbc VALUES (4, ‘dd’);

– Table structure for shangpin

DROP TABLE IF EXISTS shangpin;
CREATE TABLE shangpin (
id int NULL DEFAULT NULL,
text varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
pic varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
num int NULL DEFAULT NULL,
pid int NULL DEFAULT NULL,
price varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

– Records of shangpin

INSERT INTO shangpin VALUES (1, ‘’, ‘img/90.png’, 0, NULL, ‘$50’);
INSERT INTO shangpin VALUES (2, ‘’, ‘img/2.png’, 0, NULL, ‘$50’);
INSERT INTO shangpin VALUES (3, ‘’, ‘img/3.png’, 0, NULL, ‘$508’);
INSERT INTO shangpin VALUES (4, ‘’, ‘img/4.png’, 0, NULL, ‘$50’);
INSERT INTO shangpin VALUES (5, ‘’, ‘img/5.png’, 0, NULL, ‘$504’);
INSERT INTO shangpin VALUES (6, ‘’, ‘img/6.png’, 0, NULL, ‘$507’);
INSERT INTO shangpin VALUES (7, ‘’, ‘’, 0, NULL, ‘$508’);
INSERT INTO shangpin VALUES (8, ‘太空重量级6L背包’, ‘img/p1.webp’, NULL, 1, ‘$208’);
INSERT INTO shangpin VALUES (9, ‘格子衫衬衣’, ‘img/p2.webp’, NULL, 1, ‘$209’);
INSERT INTO shangpin VALUES (10, ‘战术胸挂’, ‘img/p3.webp’, NULL, 1, ‘$109’);
INSERT INTO shangpin VALUES (11, ‘511/AT手套’, ‘img/p4.webp’, NULL, 1, ‘$109’);
INSERT INTO shangpin VALUES (12, ‘沙漠色丝巾’, ‘img/p5.webp’, NULL, 1, ‘$509’);
INSERT INTO shangpin VALUES (13, ‘薯条魔术贴’, ‘img/p6.webp’, NULL, 1, ‘$50’);
INSERT INTO shangpin VALUES (14, ‘战术腰带’, ‘img/p7.webp’, NULL, 1, ‘$50’);
INSERT INTO shangpin VALUES (15, ‘511/AT-1登山鞋’, ‘img/p8.webp’, NULL, 1, ‘$129’);
INSERT INTO shangpin VALUES (16, ‘511/AT-2运动鞋’, ‘img/p9.webp’, NULL, 1, ‘$129’);
INSERT INTO shangpin VALUES (17, ‘511/AT-3徒步鞋’, ‘img/p10.webp’, NULL, 1, ‘$129’);
INSERT INTO shangpin VALUES (18, ‘日常衬衫衣’, ‘img/p11.webp’, NULL, 1, ‘$150’);
INSERT INTO shangpin VALUES (19, ‘防水冲锋衣’, ‘img/p12.webp’, NULL, 1, ‘$150’);
INSERT INTO shangpin VALUES (NULL, ‘深蓝格子长衫’, ‘img/m1.webp’, NULL, 2, ‘$208’);
INSERT INTO shangpin VALUES (21, ‘511衬衫’, ‘img/w1.webp’, NULL, 3, ‘$208’);
INSERT INTO shangpin VALUES (22, ‘RUSH24 36L背包’, ‘img/ba2.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (23, ‘深黑长筒皮鞋’, ‘img/f1.webp’, NULL, 5, ‘$208’);
INSERT INTO shangpin VALUES (24, ‘511/ATyt-1登山鞋’, ‘img/p9.webp’, NULL, 6, ‘$208’);
INSERT INTO shangpin VALUES (25, ‘卡其色长衫’, ‘img/m2.webp’, NULL, 2, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘花样Tshirt’, ‘img/w2.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘纯色衬衫’, ‘img/w3.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘运动内衣’, ‘img/w4.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘花纹运动内衣’, ‘img/w5.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘卡其色短衫’, ‘img/w6.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘纯白衬衫’, ‘img/w7.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘黑色印花衬衫’, ‘img/w8.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘蓝色印花衬衫’, ‘img/w9.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘深蓝印花衬衫’, ‘img/w10.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘浅红色长衫’, ‘img/w11.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘卡其色短裤’, ‘img/w12.webp’, NULL, 3, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘蓝绿色长衫’, ‘img/m3.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘海蓝色短衫’, ‘img/m4.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘511Logo短衫’, ‘img/m5.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘印花短衫’, ‘img/m6.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘深红格子长衫’, ‘img/m7.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘藏黄色短衫’, ‘img/m8.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘深灰格子长衫’, ‘img/m9.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘深灰印花短衫’, ‘img/m10.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘纯黑长衫’, ‘img/m11.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘拼色印花集短衫’, ‘img/m12.webp’, NULL, 2, ‘$129’);
INSERT INTO shangpin VALUES (NULL, ‘RUSH48 72L背包’, ‘img/ba3.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘MOllify 背包’, ‘img/ba4.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘深灰长途旅行包’, ‘img/ba5.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘软壳旅行箱’, ‘img/ba6.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘卡其56L旅行包’, ‘img/ba7.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘游骑兵胸包’, ‘img/ba8.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘16L日常挎包’, ‘img/ba9.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘卡其色胸包’, ‘img/ba10.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘24L日常挎包’, ‘img/ba11.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘藏绿胸包’, ‘img/ba12.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘藏绿魔术贴副包’, ‘img/ba13.webp’, NULL, 4, ‘$208’);
INSERT INTO shangpin VALUES (NULL, ‘白灰拼色运动鞋’, ‘img/f2.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘短桶皮鞋’, ‘img/f3.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘深灰长筒靴’, ‘img/f4.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘沙色运动鞋’, ‘img/f5.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘深绿运动鞋’, ‘img/f6.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘511logo长筒袜’, ‘img/f7.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘卡其色运动鞋’, ‘img/f8.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘拼色运动鞋’, ‘img/f9.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘白灰拼花运动鞋’, ‘img/f10.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘深黑运动鞋’, ‘img/f11.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘卡其印花长筒袜’, ‘img/f12.webp’, NULL, 5, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘511/AT-2运动鞋’, ‘img/p9.webp’, NULL, 6, ‘$105’);
INSERT INTO shangpin VALUES (NULL, ‘深绿拼色鸭舌帽’, ‘img/v13.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘黑白拼色鸭舌帽’, ‘img/v2.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘黄绿拼色鸭舌帽’, ‘img/v3.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘黑绿拼色鸭舌帽’, ‘img/v4.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘蓝红拼色鸭舌帽’, ‘img/v5.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘卡其拼色鸭舌帽’, ‘img/v6.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘橘黑拼色鸭舌帽’, ‘img/v7.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘黑色纯色鸭舌帽’, ‘img/v8.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘印花鸭舌帽’, ‘img/v9.webp’, NULL, 6, ‘$30’);
INSERT INTO shangpin VALUES (NULL, ‘511logo鸭舌帽’, ‘img/v10.webp’, NULL, 6, ‘$30’);

– Table structure for user

DROP TABLE IF EXISTS user;
CREATE TABLE user (
uname varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
pwd varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;