基于Vue+Nodejs+Bootstrap实现的仿小米商城购物商城源码(前端+后端)+运行教程+数据库.zip

-- MySQL dump 10.13 Distrib 8.0.33, for Win64 (x86_64) -- -- Host: localhost Database: xiaomi_store -- ------------------------------------------------------ -- Server version 8.0.33 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `action_choices` -- DROP TABLE IF EXISTS `action_choices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8 */; CREATE TABLE `action_choices` ( `action_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `cid` varchar(200) COLLATE utf8_unicode_ci NOT NULL, KEY `cid` (`cid`), CONSTRAINT `action_choices_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `choices` (`cid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `action_choices` -- LOCK TABLES `action_choices` WRITE; /*!40000 ALTER TABLE `action_choices` DISABLE KEYS */; INSERT INTO `action_choices` VALUES ('63746edd-c769-4388-a711-5e3e9f752797','109db096-f4dd-4171-af9f-24fabf7e7142'),('63746edd-c769-4388-a711-5e3e9f752797','b0511aa5-c659-488b-8399-e622ac89da04'),('abf104f6-fc15-4b11-8f9e-cda7ace80cb3','a624b94b-b9bc-47e5-b355-72b7cc9a1f28'),('abf104f6-fc15-4b11-8f9e-cda7ace80cb3','232ef68b-b67b-4b4b-843b-e37bee69de7c'),('99e9be69-6183-4818-bc4c-9f333fc32e33','03cb6bd6-3eba-480f-87b8-5df76c15eee4'),('99e9be69-6183-4818-bc4c-9f333fc32e33','4b02d90a-4458-4cf3-82a4-0fda2cdc798c'),('615f2758-4d1a-488c-b48a-18ba5a7d788a','100f1485-9899-4ace-8eec-8c0da56c9e86'),('615f2758-4d1a-488c-b48a-18ba5a7d788a','72c514f0-317e-407e-b760-837c735597ce'),('35d56423-689c-4b81-833d-5f02edcf066c','82fecd4c-c10e-4347-ba6f-415598a3030e'),('35d56423-689c-4b81-833d-5f02edcf066c','c892d67f-94d6-45a3-a914-c08bad2d9b96'),('a92f88fc-e9a3-49f1-9bca-650d930f7b79','a624b94b-b9bc-47e5-b355-72b7cc9a1f28'),('a92f88fc-e9a3-49f1-9bca-650d930f7b79','232ef68b-b67b-4b4b-843b-e37bee69de7c'),('4320a9a1-942d-424a-962c-d58972a8d3de','03cb6bd6-3eba-480f-87b8-5df76c15eee4'),('4320a9a1-942d-424a-962c-d58972a8d3de','4b02d90a-4458-4cf3-82a4-0fda2cdc798c'),('da93a6bd-e5b6-4d76-97e4-286b58851266','027ab4d5-7900-4e67-8475-de8e595dd460'),('da93a6bd-e5b6-4d76-97e4-286b58851266','232ef68b-b67b-4b4b-843b-e37bee69de7c'),('1977f8a8-c93c-4848-8b2e-22f8e9478568','245b6d84-4226-453c-be4c-6bff38ab415b'),('0f70f20b-e2a7-47d4-a07e-28b4528f50a4','a98e0b0e-0750-4cd0-8d52-c29880d86da5'),('0f70f20b-e2a7-47d4-a07e-28b4528f50a4','a04a8157-e9b3-479f-8739-44ab995a0628'),('44a19a7b-839b-41b7-9aa2-0434347b8d47','196c1473-5890-4676-ad83-d550ecf3996f'),('44a19a7b-839b-41b7-9aa2-0434347b8d47','213147aa-4218-4e8b-b017-f2a3097a9af8'),('fdac691a-2b0f-4f77-a86f-830173637cf0','1457ad10-0488-4f15-893e-27f8df0f69b1'),('fdac691a-2b0f-4f77-a86f-830173637cf0','36a8bd59-b582-4250-83b5-08415a863449'),('09d8882a-2d47-4a18-a599-5f932a06b853','100f1485-9899-4ace-8eec-8c0da56c9e86'),('09d8882a-2d47-4a18-a599-5f932a06b853','72c514f0-317e-407e-b760-837c735597ce'),('457ea43f-a871-4fd8-a80d-271cb8ca2f33','1c7c9dcb-0804-4725-881a-ba9e37c495da'),('c255f6e7-fdd3-46b3-8700-df53b04dba1b','1c7c9dcb-0804-4725-881a-ba9e37c495da'),('7325846a-c3f0-407b-838e-1afae9359aa0','03cb6bd6-3eba-480f-87b8-5df76c15eee4'),('7325846a-c3f0-407b-838e-1afae9359aa0','4b02d90a-4458-4cf3-82a4-0fda2cdc798c'),('db666e92-0c5d-4a58-89e5-030167caf863','067d0423-09d0-4750-9049-fde0ca1a458d'),('db666e92-0c5d-4a58-89e5-030167caf863','292bbf5e-23c1-44fc-ab22-4d7001363cf0'),('87735b06-33d3-4c50-925d-1a0f8a5fa9f1','067d0423-09d0-4750-9049-fde0ca1a458d'),('87735b06-33d3-4c50-925d-1a0f8a5fa9f1','292bbf5e-23c1-44fc-ab22-4d7001363cf0'),('acb459cb-8019-4965-b2ca-fec0e0d986df','2a3ac513-4edf-4456-abc5-12e3acaffd09'),('121b36a0-920e-4a1b-a0ef-f08a8c72e57b','d616e696-1bdc-43b6-8cbc-cfc36f7c2546'),('ce983216-85ad-4384-a78c-b62b018a0f0e','189e493b-ed7c-4f97-a934-dd912e5076ae'),('ce983216-85ad-4384-a78c-b62b018a0f0e','c892d67f-94d6-45a3-a914-c08bad2d9b96'),('71492b41-1395-4fbd-8e67-21f067f35d42','1457ad10-0488-4f15-893e-27f8df0f69b1'),('71492b41-1395-4fbd-8e67-21f067f35d42','36a8bd59-b582-4250-83b5-08415a863449'),('4886b994-f1e5-48ac-a773-f27b75b50c50','05392da2-cdca-4d80-bd15-11b016044182'),('4886b994-f1e5-48ac-a773-f27b75b50c50','8cde6094-ac88-4ba3-b407-334154afbd5e'),('d16b4c01-7d0b-452a-ae17-eb09abdc7e9d','db03c37b-0e9e-4a32-acdd-496f34290f74'),('d16b4c01-7d0b-452a-ae17-eb09abdc7e9d','16be0bf1-ff8f-46bd-8c25-3b09e9cfd788'); /*!40000 ALTER TABLE `action_choices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cart` -- DROP TABLE IF EXISTS `cart`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8 */; CREATE TABLE `cart` ( `cart_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `uid` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `pid` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `quantity` int NOT NULL DEFAULT '1', `cart_full_name` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL, `myhash` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cart_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cart` -- LOCK TABLES `cart` WRITE; /*!40000 ALTER TABLE `cart` DISABLE KEYS */; /*!40000 ALTER TABLE `cart` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `choices` -- DROP TABLE IF EXISTS `choices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8 */; CREATE TABLE `choices` ( `choice_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cid` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `price` double NOT NULL, `old_price` double DEFAULT NULL, `oid` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`cid`), KEY `oid` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `choices` -- LOCK TABLES `choices` WRITE; /*!40000 ALTER TABLE `choices` DISABLE KEYS */; INSERT INTO `choices` VALUES ('i7-12700H/16G/512G/2.8k/120Hz/金属-灰色','000a83f2-c203-425b-9997-4be90f917dd9',1100,1000,'aa60f29c-d426-4cb1-b414-8ec7b392180f'),('双开','0048a7c5-222f-498a-a1bf-d42390ad4c9c',10,NULL,'b67e6c29-c071-4d55-abdc-3544ceef07f0'),('12GB+512GB','02101623-b246-4705-87d0-15ade91a2ef2',1200,1200,'88f0a091-cdf5-46ed-9f50-b7a6024add3e'),('8GB+256GB','027ab4d5-7900-4e67-8475-de8e595dd460',100,100,'2e105a4a-2506-4553-8fcb-018f5c7bd79f'),('冰羽白','033e6ca4-07d3-4fc3-b719-fe02d8eb00f1',0,0,'ad0a45f0-43bd-437d-8834-478d020e3551'),('白色','036983ea-f884-47af-9bf7-6fe6ce695eef',0,NULL,'ff020904-d3b6-4b0c-b1a5-009f2ed9e491'),('R7 6800H/集显/16G/512G','03b73dc7-24a8-495d-83b2-3f13a784eb98',400,600,'d905817b-2655-41ff-8490-b185f270ed8f'),('16GB+1TB','03cb6bd6-3eba-480f-87b8-5df76c15eee4',2000,NULL,'7c160fa3-e5f4-4a33-9fa8-ecfc14380da4'),('黑色','04a35ccc-9822-446e-8683-bee8869aa090',0,0,'e832c9d9-0d55-494d-b877-ff945ebc1257'),('黑色','04c5a345-9319-44d3-abeb-889d97c78d30',0,NULL,'ea89a0f9-37c6-43cd-a3eb-5cd14bc282b3'),('4GB+128GB','05185322-a887-4f6d-92c8-143c0d3bb972',0,NULL,'0c31bfcf-768a-4259-952a-3c59b4d7c1ff'),('8GB+128GB','05392da2-cdca-4d80-bd15-11b016044182',50,100,'e639eae3-5019-458f-bb48-959a4aa3e061'),('白','053b8a