-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathxian-tao.sql
25 lines (6 loc) · 5.94 KB
/
xian-tao.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
INSERT INTO `goods` VALUES (1,'草莓','很不错的草莓'),(2,'葡萄','很不错的葡萄'),(3,'柠檬','很不错的柠檬'),(4,'奇异果','很不错的奇异果'),(5,'大青虾','新鲜的大青虾'),(6,'秋刀鱼',''),(7,'扇贝',''),(8,'基围虾',''),(9,'猪肉',''),(10,'牛肉',''),(11,'羊肉',''),(12,'牛排',''),(13,'鸡蛋',''),(14,'鸡肉',''),(15,'鸭蛋',''),(16,'鸡腿',''),(17,'白菜',''),(18,'芹菜',''),(19,'香菜',''),(20,'冬瓜',''),(21,'鱼丸',''),(22,'蟹棒',''),(23,'虾丸',''),(24,'速冻水饺',''),(25,'芒果',''),(26,'鹌鹑蛋',''),(27,'鹅蛋',''),(28,'红辣椒','');
INSERT INTO `goods_type` VALUES (1,'新鲜水果','fruit','group1/M00/00/00/rBCzg1oKeNKAEl87AAAmv27pX4k4942898'),(2,'海鲜水产','seafood','group1/M00/00/00/rBCzg1oKeWCAOQBsAABHr3RQqFs4497074'),(3,'猪牛羊肉','meet','group1/M00/00/00/rBCzg1oKeZ6AA5HjAAAy1Tlm9So7276786'),(4,'禽类蛋品','egg','group1/M00/00/00/rBCzg1oKebaAcEWVAAAqR4DoSUg3788077'),(5,'新鲜蔬菜','vegetables','group1/M00/00/00/rBCzg1oKediAdUaaAAA-0ZoYkpM9419116'),(6,'速冻食品','ice','group1/M00/00/00/rBCzg1oKee-AGMXLAAA3sZPrVzQ0297876');
INSERT INTO `goods_s_k_u` VALUES (1,1,1,'草莓 500g','草莓简介',10.00,'500g','group1/M00/00/00/rBCzg1oKqFGAR2tjAAAljHPuXJg4272079',98,0,1,'2017-11-15 04:10:14.045538'),(2,1,1,'盒装草莓','草莓简介',20.00,'盒','group1/M00/00/00/rBCzg1oKrPuAKse1AAEc8FlxEvU2553153',10,0,1,'2017-11-15 05:10:14.045538'),(3,2,1,'葡萄','葡萄简介',20.00,'500g','group1/M00/00/00/rBCzg1oKqHKAYfXaAAAjjiYTEkw5436358',7,0,1,'2017-11-15 06:10:14.045538'),(4,3,1,'柠檬','简介',32.00,'500g','group1/M00/00/00/rBCzg1oKqH6AMZt_AAAgnaeGwNQ6246033',12,0,1,'2017-11-15 07:10:14.045538'),(5,4,1,'奇异果','简介',12.12,'500g','group1/M00/00/00/rBCzg1oKqJSAS1xIAAAeuLYy0pU6253560',12,0,1,'2017-11-15 08:10:14.045538'),(6,5,2,'大青虾','简介',34.00,'500g','group1/M00/00/00/rBCzg1oKqKGAFAV-AAA5OS4Kl4c4097622',12,0,1,'2017-11-15 09:10:14.045538'),(7,6,2,'北海道秋刀鱼','简介',50.00,'500g','group1/M00/00/00/rBCzg1oKqKuAavf8AAAkaP_7_187862565',15,0,1,'2017-11-15 03:11:14.045538'),(8,7,2,'扇贝','简介',56.60,'500g','group1/M00/00/00/rBCzg1oKqLeATLQAAAAk8WCqqmI2968215',13,0,1,'2017-11-15 03:12:14.045538'),(9,8,2,'基围虾','简介',100.90,'500g','group1/M00/00/00/rBCzg1oKqNKANQKOAAAk0DN4-yE7007770',14,0,1,'2017-11-15 03:13:14.045538'),(10,9,3,'猪肉','简介',23.99,'500g','group1/M00/00/00/rBCzg1oKqYSASWr0AAEVpb1YHUE4011268',100,0,1,'2017-11-15 03:14:14.045538'),(11,10,3,'牛肉','简介',34.99,'500g','group1/M00/00/00/rBCzg1oKqd-AUsoBAAEExAU4yXU2908730',100,0,1,'2017-11-15 03:15:14.045538'),(12,11,3,'羊肉','简介',56.99,'500g','group1/M00/00/00/rBCzg1oKqhaAKgwkAAB6NOQDrpk3374052',100,0,1,'2017-11-15 03:16:14.045538'),(13,12,3,'牛排','简介',99.99,'500g','group1/M00/00/00/rBCzg1oKqkuAUD0WAACwa3rCDPQ3064181',100,0,1,'2017-11-15 03:17:14.045538'),(14,13,4,'盒装鸡蛋','简介',23.00,'500g','group1/M00/00/00/rBCzg1oKqpeAZnSEAADUKbwLSqY1972845',100,0,1,'2017-11-15 03:18:14.045538'),(15,14,4,'鸡肉','简介',32.00,'500g','group1/M00/00/00/rBCzg1oKqsmAVxzcAADUY5hC_sI5143658',100,0,1,'2017-11-15 03:19:14.045538'),(16,15,4,'鸭蛋','简介',45.00,'盒','group1/M00/00/00/rBCzg1oKq0eAMxKFAAFC_2tSkFo4950479',121,0,1,'2017-11-15 03:20:14.045538'),(17,16,4,'鸡腿','简介',45.00,'500g','group1/M00/00/00/rBCzg1oKq3CADiewAAA2_p7G96w3860045',12,0,1,'2017-11-15 03:30:14.045538'),(18,17,5,'白菜','简介',4.50,'500g','group1/M00/00/00/rBCzg1oKq5WAQnWDAADWHYeKaNI7952227',100,0,1,'2017-11-15 03:40:14.045538'),(19,18,5,'芹菜','简介',3.50,'500g','group1/M00/00/00/rBCzg1oKq8yAa_CvAACIrzuaK646641688',12,0,1,'2017-11-15 03:50:14.045538'),(20,19,5,'香菜','简介',7.90,'500g','group1/M00/00/00/rBCzg1oKq-iAUG8xAACNpHC0IEY3849954',100,0,1,'2017-11-15 03:10:11.045538'),(21,20,5,'冬瓜','简介',12.99,'500g','group1/M00/00/00/rBCzg1oKrAaAN1Z6AAENHrNG1-s8874196',100,0,1,'2017-11-15 03:10:12.045538'),(22,21,6,'鱼丸','简介',66.00,'500g','group1/M00/00/00/rBCzg1oKrC-ACdOBAADZQphQJ2o3748807',12,0,1,'2017-11-15 03:10:13.045538'),(23,22,6,'蟹棒','简介',68.00,'500g','group1/M00/00/00/rBCzg1oKrFeAJ9PuAABxy5vKkgY2006901',100,0,1,'2017-11-15 03:10:16.045538'),(24,23,6,'虾丸','简介',89.99,'500g','group1/M00/00/00/rBCzg1oKrHGADF7jAABICav_wjk1418828',100,0,1,'2017-11-15 03:10:15.045538'),(25,24,6,'速冻水饺','简介',20.00,'袋','group1/M00/00/00/rBCzg1oKrKaAFrRTAACMoBJXjDs3577358',100,0,1,'2017-11-15 03:10:17.045538'),(26,25,1,'越南芒果','新鲜越南芒果',29.90,'2.5kg','group1/M00/00/00/rBCzg1oKruyABIIzAAByzTJcTjM7085820',100,0,1,'2017-11-15 03:10:18.045538'),(27,26,4,'鹌鹑蛋','简介',39.80,'126枚','group1/M00/00/00/rBCzg1oOlkyAHiH3AAGZ6KapWiA5556935',100,0,1,'2017-11-15 03:10:19.045538'),(28,27,4,'鹅蛋','简介',49.90,'6枚','group1/M00/00/00/rBCzg1oOlpqAOZ8gAADg_NUp5b47679136',80,0,1,'2017-11-15 04:10:14.045538'),(29,28,5,'红辣椒','简介',11.00,'2.5kg','group1/M00/00/00/rBCzg1oOlvWAB6BMAAHXO8pdocY9345486',150,0,1,'2017-11-15 05:10:14.045538');
INSERT INTO `index_goods_banner` VALUES (1,5,'group1/M00/00/00/rBCzg1oKrcWAX7y-AACpB-LsCdE6038911',0),(2,26,'group1/M00/00/00/rBCzg1oKrwaAUerYAAC3B-z8J2c2488703',1),(3,13,'group1/M00/00/00/rBCzg1oKrxSAac1BAAETwXb_pso9132934',2),(4,9,'group1/M00/00/00/rBCzg1oKryqAPjmzAAD0akkXmFo4923405',3);
INSERT INTO `index_promotion_banner` VALUES (1,'吃货暑假趴','#','group1/M00/00/00/rBCzg1oKr7aAdR-2AAA2pLUeB609027808',0),(2,'盛夏尝鲜季','#','group1/M00/00/00/rBCzg1oKr9WADLksAAA98yvCs1I5148432',1);
INSERT INTO `index_type_goods_banner` VALUES (1,1,1,1,0),(2,1,3,1,1),(3,1,5,1,2),(4,1,4,1,3),(5,1,2,0,0),(6,1,4,0,1),(7,2,6,1,0),(8,2,7,1,1),(9,2,8,1,2),(10,2,9,1,3),(11,2,9,0,0),(12,2,8,0,1),(13,3,10,1,0),(15,3,12,1,2),(16,3,13,1,3),(17,3,15,0,0),(18,3,17,1,1),(19,4,14,1,0),(20,4,16,1,1),(21,4,14,0,0),(22,4,16,0,1),(23,5,18,1,0),(24,5,19,1,1),(25,5,20,1,2),(26,5,20,0,0),(27,5,19,0,1),(28,6,22,1,0),(29,6,23,1,1),(30,6,24,1,2),(31,6,25,1,3),(32,6,23,0,0),(33,6,25,0,1),(34,4,27,1,2),(35,4,28,1,3),(36,5,29,1,3);