乐商网(LWSCMS) 系统版本更新SQL记录

ALTER TABLE lw_goods ADD COLUMN `beizhu` varchar(255) DEFAULT '' COMMENT '备注' AFTER pay_type;
ALTER TABLE lw_order ADD COLUMN tongdao tinyint(5) DEFAULT 0 COMMENT '查单通道' AFTER cha_time;
ALTER TABLE lw_api_list ADD COLUMN is_update_title tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_img tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_price tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_kucun tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_desc tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN is_update_status tinyint(5) DEFAULT 1 COMMENT '' AFTER is_status;
ALTER TABLE lw_api_list ADD COLUMN tongdao tinyint(5) DEFAULT 0 COMMENT '' AFTER is_status;
ALTER TABLE lw_liushui ADD INDEX order_no ( order_no );
ALTER TABLE lw_goods ADD COLUMN order_time int(11) DEFAULT 0 COMMENT '过期时间' AFTER pay_type;
DELETE FROM `lw_setinfo` WHERE name = "ONECLASS";
INSERT INTO `lw_setinfo`(`name`, `info`) VALUES ('ONECLASS','{"1":{"name":"热门推荐","ico":"<svg t="1670658508495" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="18306" width="16" height="16"><path d="M914.432 818.389333l-114.858667 16.362667-72.533333 91.733333a43.242667 43.242667 0 0 1-59.093333-15.829333l-109.226667-189.162667a339.392 339.392 0 0 1-48.021333 3.776 343.872 343.872 0 0 1-49.941334-4.053333l-109.525333 189.696a42.666667 42.666667 0 0 1-58.282667 15.616l-71.466666-90.517333-113.28-16.149334a42.666667 42.666667 0 0 1-15.616-58.282666l121.109333-209.770667a341.333333 341.333333 0 1 1 595.413333-2.368l121.130667 209.792a43.264 43.264 0 0 1-15.808 59.157333zM158.72 775.168l94.805333 5.461333 52.992 79.872 89.6-155.285333a341.525333 341.525333 0 0 1-141.589333-96zM510.741333 106.666667a277.333333 277.333333 0 1 0 277.333334 277.333333 277.333333 277.333333 0 0 0-277.333334-277.333333zM768 608a341.333333 341.333333 0 0 1-143.488 97.6l88.917333 154.026667 53.76-81.066667 96.128-5.546667z" fill="#5C8EF3" p-id="18307"><\/path><path d="M512 576a192 192 0 1 1 192-192 192 192 0 0 1-192 192z m-0.661333-320.661333a128 128 0 1 0 128 128 128 128 0 0 0-128-128z" fill="#EB9E52" p-id="18308"><\/path><\/svg>","sort":"1"},"2":{"name":"视频会员","ico":"<svg t="1670657646255" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="3452" width="16" height="16"><path d="M355.328 329.216c-25.6-19.456-46.592-9.216-46.592 23.04v318.976c0 32.256 20.992 42.496 46.592 23.04l193.024-146.944a42.496 42.496 0 0 0 0-71.168zM193.024 158.208h-5.632a122.88 122.88 0 0 0-158.72 74.24 1392.128 1392.128 0 0 0 0 558.592 122.88 122.88 0 0 0 160.768 75.264 2186.24 2186.24 0 0 1 3.584-708.096z" fill="#d81e06" p-id="3453"><\/path><path d="M983.552 414.208A1837.056 1837.056 0 0 0 367.616 47.616a129.536 129.536 0 0 0-172.544 98.816v11.776a1792 1792 0 0 1 563.2 278.528 88.576 88.576 0 0 1-3.584 146.944 2108.928 2108.928 0 0 1-562.688 281.6v10.752A129.536 129.536 0 0 0 369.664 972.8a2179.584 2179.584 0 0 0 609.792-369.152 130.048 130.048 0 0 0 4.096-189.44z" fill="#d81e06" p-id="3454"><\/path><\/svg>","sort":"3"},"3":{"name":"音频盛宴","ico":"<svg t="1670658458334" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="17002" width="16" height="16"><path d="M0 0v1024h839.68V839.68h184.32V0H0z" fill="#F45D5D" p-id="17003"><\/path><path d="M839.68 1024V839.68h184.32L839.68 1024z" fill="#EA4747" p-id="17004"><\/path><path d="M482.3552 455.68a115.2 115.2 0 1 1-115.2 115.2 115.328 115.328 0 0 1 115.2-115.2m0-76.8a192 192 0 1 0 192 192 192 192 0 0 0-192-192z" fill="#FFEBEB" p-id="17005"><\/path><path d="M488.73728 251.24736l72.16896-26.26688 102.1312 280.6016-72.16896 26.26816z" fill="#FFEBEB" p-id="17006"><\/path><path d="M538.176 387.0848l52.6848 144.768L663.04 505.6a192.4992 192.4992 0 0 0-124.864-118.5152z" fill="#FFFFFF" p-id="17007"><\/path><path d="M733.6448 271.36l-19.8784 74.176-211.5584-57.28-13.4784-37.0176 71.8208-26.2656L733.6448 271.36z" fill="#FFEBEB" p-id="17008"><\/path><path d="M592.8704 312.8064l-31.9232-87.7184-0.192-0.0512-72.0256 26.2016 13.4784 37.0176 90.6624 24.5504z" fill="#FFFFFF" p-id="17009"><\/path><\/svg>","sort":"4"},"4":{"name":"美食餐饮","ico":"<svg t="1670658010250" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="7612" width="16" height="16"><path d="M196.608 788.992v133.12c4.608 30.208 31.232 51.712 61.44 51.2h517.632c30.72 0 56.32-30.72 56.32-61.44v-133.12H196.608v10.24z" fill="#AEC9FF" p-id="7613"><\/path><path d="M1016.832 327.68c-9.216-28.672-24.576-55.296-46.08-76.8-20.48-27.136-49.152-47.104-81.92-56.32-46.08-15.36-87.04-10.24-128 5.12-5.12 0-10.24 5.12-15.36 5.12-51.2-97.28-128.512-153.6-236.032-153.6s-184.32 51.2-230.4 153.6c-51.2-25.6-107.52-30.72-163.84-5.12s-92.16 66.56-107.52 128c-15.36 56.32-5.12 107.52 20.48 153.6 35.84 66.56 97.28 92.16 163.84 97.28v128h640.512v-133.12h5.12c20.48 0 35.84-5.12 56.32-10.24 46.08-15.36 81.92-40.96 102.4-87.04 20.48-35.84 25.6-76.8 25.6-117.76 5.12-5.12 0-20.48-5.12-30.72z" fill="#3366FF" p-id="7614"><\/path><\/svg>","sort":"5"},"5":{"name":"知识教育","ico":"<svg t="1670658043772" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="9581" width="16" height="16"><path d="M352.6144 816.896V300.3136h158.848V512l79.232-52.9408L669.9008 512v-211.6864h105.9072v463.616c0 53.76-25.856 52.9664-39.6032 52.9664-259.5072 0.4096-383.5904 0-383.5904 0z" fill="#27AD9A" p-id="9582"><\/path><path d="M766.5152 226.3552a9.0112 9.0112 0 0 1-6.8608 14.5408H311.7824a22.2208 22.2208 0 0 0-23.04 23.04c-0.4096 8.0896 0 12.928 0 18.176 0 11.3408 8.8832 19.0208 23.8592 19.0208h4.8384a8.96 8.96 0 0 1 8.8832 8.7552v498.4064a8.8064 8.8064 0 0 1-9.2928 8.8832c-53.76-2.304-56.9856-28.5696-56.9856-51.2V248.576c0 2.0224-1.6128-39.7312 39.6032-39.7312h436.9664c12.544-1.1008 21.8112 6.9888 29.9008 17.5104z" fill="#27AD9A" p-id="9583"><\/path><path d="M538.1376 274.048h105.9072v185.3952a1983.872 1983.872 0 0 0-52.9664-39.6032s-32.7168 23.8592-52.9408 39.6032v-185.3952z" fill="#27AD9A" p-id="9584"><\/path><\/svg>","sort":"6"},"6":{"name":"运动健身","ico":"<svg t="1670658099276" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="13434" width="16" height="16"><path d="M512 1024a512 512 0 1 1 512-512 512 512 0 0 1-512 512zM250.368 329.856l99.968 352.256-99.968 11.776v98.048h539.008v-179.2l-146.048 25.6v-25.6l60.672-10.24a27.648 27.648 0 0 0 23.424-27.392 15.744 15.744 0 0 0 0-2.432A20.864 20.864 0 0 0 704 554.24l-66.816 7.936-96.256 36.608 9.984 24.32h60.416v20.48l-48.768 7.552 23.68 54.656-53.76 29.312-49.152-73.728-92.928 13.824-65.152-223.104h35.328l-44.544-122.24z m113.664 86.528l12.8 31.104L512 400.128l45.44 94.08-76.8 45.056a51.2 51.2 0 0 0-18.432 70.144l1.536 2.432 70.144 105.728 35.328-17.536-49.152-108.416 101.248-31.488a76.8 76.8 0 0 0 50.56-96.128 64 64 0 0 0-3.584-9.344L617.472 345.6a64 64 0 0 0-84.864-31.36 66.688 66.688 0 0 0-6.656 3.584zM492.8 307.2a44.8 44.8 0 1 0-44.8-44.8 44.8 44.8 0 0 0 44.8 44.8z" fill="#CB894D" p-id="13435"><\/path><\/svg>","sort":"7"},"7":{"name":"加速下载","ico":"<svg t="1670658112994" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="14578" width="16" height="16"><path d="M1024 748.544q0 25.6-8.704 48.128t-24.064 40.96-36.352 30.208-45.568 15.872l0 2.048-21.504 0-1.024 0-664.576 0q-2.048 0-2.56 0.512t-2.56 0.512-3.072-0.512-3.072-0.512l-6.144 0 0-1.024q-43.008-2.048-80.384-19.456t-65.024-46.592-43.52-67.584-15.872-81.408 15.872-80.896 43.008-66.56 63.488-47.104 78.336-21.504q7.168-66.56 36.864-124.416t76.288-100.864 107.008-67.584 129.024-24.576q72.704 0 137.216 27.648t112.128 75.776 75.264 112.128 27.648 136.704q0 32.768-6.144 64t-17.408 59.904q2.048 0 4.608-0.512t4.608-0.512q28.672 0 53.248 10.752t43.008 29.184 29.184 43.52 10.752 53.76zM687.104 596.992q12.288-20.48 7.168-23.552t-25.6-3.072q-12.288 0-34.304-0.512t-33.28-0.512q-16.384 0-20.992-13.312t-4.608-36.864q0-32.768-0.512-52.736t-0.512-43.52q0-26.624-3.584-38.912t-29.184-12.288q-18.432 0-27.648 0.512t-25.6 0.512q-27.648 0-34.304 15.872t-6.656 31.232l0 32.768q0 13.312 0.512 25.6t0.512 25.6l0 29.696q0 16.384-4.096 25.088t-19.456 8.704q-6.144 1.024-16.896 1.536t-22.016 1.024-21.504 0.512l-16.384 0q-21.504 0-25.6 13.312t13.312 33.792q17.408 21.504 37.376 46.592t39.424 50.688 37.376 49.664 33.28 41.472q27.648 30.72 53.248-1.024 15.36-17.408 35.84-45.056t41.984-57.856 40.96-58.368 31.744-46.592z" p-id="14579" fill="#1296db"><\/path><\/svg>","sort":"8"},"8":{"name":"漫画阅读","ico":"<svg t="1670658529854" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="19447" width="16" height="16"><path d="M445 347.9H199.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8H445c8.7 0 15.8 7.1 15.8 15.8 0 8.7-7 15.8-15.8 15.8zM436.3 478.1H199.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h237.2c8.7 0 15.8 7.1 15.8 15.8 0 8.7-7.1 15.8-15.8 15.8zM357.4 608.2H199.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h158.3c8.7 0 15.8 7.1 15.8 15.8 0 8.8-7.1 15.8-15.8 15.8z" fill="#E86262" p-id="19448"><\/path><path d="M484 853.6c-0.8 0-1.6 0-2.4-0.1l-284.1-13.3c-47.6-2.2-84.9-45-84.9-97.5v-502c0-28.3 11.1-55.2 30.6-73.7 17.1-16.4 39.1-24.6 61.9-23.8l281.4 13.1c30.3 1.4 54 28.6 54 61.9v573.2c0 18-7.1 35-19.4 46.8-10.5 10.1-23.5 15.4-37.1 15.4zM201.2 174.9c-13.2 0-26 5.3-36.3 15.1-13.2 12.6-20.8 31.1-20.8 50.8v502c0 35.5 24.1 64.5 54.8 65.9L483 822c8.1 0.7 12.8-3.3 16.1-6.4 6.1-5.8 9.6-14.6 9.6-23.9V218.4c0-16.1-10.7-29.7-23.8-30.3L203.5 175c-0.8-0.1-1.5-0.1-2.3-0.1z" fill="#E86262" p-id="19449"><\/path><path d="M463.4 858.7c-1 0-2.1 0-3.1-0.1l-328.2-13C76.6 843.5 33 800.1 33 746.9V237c0-26.3 10.7-51.1 30.1-69.7 20.4-19.6 48.8-30 77.5-29l335.1 13.2c36.3 1.4 64.7 29.9 64.7 64.8v568.6c0 19.7-8 38.2-22.5 52.1-14.4 13.9-34.1 21.7-54.5 21.7z m-1.9-31.6c13 0.6 25.5-4.2 34.5-12.8 8.2-7.9 12.8-18.3 12.8-29.3V216.3c0-17.8-15.1-32.4-34.4-33.2l-335.1-13.2c-20.5-0.7-40.2 6.6-54.4 20.2-13.1 12.6-20.4 29.3-20.4 46.9v509.9c0 36.2 30.2 65.7 68.7 67.2l328.3 13z" fill="#E86262" p-id="19450"><\/path><path d="M845.1 347.9h-246c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8H845c8.7 0 15.8 7.1 15.8 15.8 0.1 8.7-7 15.8-15.7 15.8zM836.3 478.1H599.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h237.2c8.7 0 15.8 7.1 15.8 15.8 0 8.7-7 15.8-15.8 15.8zM757.4 608.2H599.1c-8.7 0-15.8-7.1-15.8-15.8 0-8.7 7.1-15.8 15.8-15.8h158.3c8.7 0 15.8 7.1 15.8 15.8 0 8.8-7.1 15.8-15.8 15.8z" fill="#E86262" p-id="19451"><\/path><path d="M560.2 853.6c-13.6 0-26.7-5.3-36.9-15.2-12.3-11.8-19.4-28.8-19.4-46.8V218.4c0-33.3 23.7-60.5 54-61.9l281.4-13.1c22.8-1 44.7 7.4 61.9 23.8 19.4 18.5 30.6 45.4 30.6 73.7v502c0 52.4-37.3 95.2-84.9 97.5l-284.1 13.3c-1-0.1-1.8-0.1-2.6-0.1z m282.7-678.7c-0.8 0-1.5 0-2.3 0.1l-281.4 13.1c-13.1 0.6-23.8 14.2-23.8 30.3v573.2c0 9.4 3.5 18.1 9.6 23.9 3.3 3.1 9 7 16.1 6.4l284.1-13.3c30.7-1.4 54.8-30.4 54.8-65.9v-502c0-19.7-7.6-38.2-20.8-50.8-10.2-9.7-23-15-36.3-15z" fill="#E86262" p-id="19452"><\/path><path d="M580.7 858.7c-20.4 0-40.1-7.8-54.5-21.7-14.5-13.9-22.5-32.4-22.5-52.1V216.3c0-34.9 28.4-63.3 64.7-64.8l335.1-13.2c28.9-0.9 57.1 9.4 77.5 29 19.4 18.6 30.1 43.4 30.1 69.7v509.9c0 53.2-43.5 96.6-99.1 98.8l-328.2 13h-3.1z m327.1-688.9c-1 0-2 0-3 0.1l-335.1 13.2c-19.3 0.8-34.4 15.3-34.4 33.2v568.6c0 11 4.5 21.4 12.8 29.3 9 8.7 21.8 13.4 34.5 12.8l328.2-13c38.5-1.5 68.7-31 68.7-67.2V237c0-17.6-7.2-34.3-20.4-46.9-13.5-13-32.1-20.3-51.3-20.3z" fill="#E86262" p-id="19453"><\/path><\/svg>","sort":"9"},"9":{"name":"活动大全","ico":"<svg t="1670658600164" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="20661" width="16" height="16"><path d="M820.819484 273.272897 793.987373 273.272897c13.606903-23.070438 19.577894-45.074591 17.669428-65.485457-1.583055-17.083074-9.679453-41.514509-39.347147-60.98598-24.597211-16.181541-56.228629-20.149922-91.321892-11.383258-56.909128 14.288424-124.261095 63.410192-168.546717 122.774231-44.312228-59.363016-111.610984-108.485807-168.518065-122.774231-35.121915-8.823969-66.780963-4.827959-91.375104 11.383258-29.642111 19.47147-37.739533 43.902906-39.321564 60.98598-1.907443 20.410865 4.00829 42.416042 17.669428 65.485457l-26.832112 0c-40.628326 0-73.692373 33.089629-73.692373 73.747631l0 94.988398c0 32.162514 21.214161 60.588937 51.90516 70.134337-2.917446 8.070816-4.444219 16.413831-4.444219 24.868387l0 284.980543c0 40.630373 33.101909 73.733305 73.733305 73.733305l521.833973 0c40.628326 0 73.678046-33.101909 73.678046-73.733305l0-284.981566c0-8.508791-1.471514-16.878412-4.38896-24.89704 30.645974-9.598612 51.809993-38.025035 51.809993-70.106708l0-94.963839C894.498554 306.389132 861.448834 273.272897 820.819484 273.272897M773.399475 843.208401 538.674523 843.208401 538.674523 515.76986l234.725976 0c11.698436 0 21.185508 9.543354 21.185508 21.24179l0 284.980543C794.584983 833.691653 785.097912 843.208401 773.399475 843.208401M567.57883 273.272897c37.33021-43.058678 86.329181-76.896344 126.116349-86.877673 20.667715-5.179976 37.573757-3.761674 49.818639 4.310166 13.008268 8.546653 15.322987 16.168238 15.842827 21.923312 2.070148 21.104667-20.561291 49.558719-31.249725 60.645219L567.57883 273.272897zM841.97941 347.046111l0 94.963839c0 11.698436-9.461489 21.213137-21.159926 21.213137L538.674523 463.223087 538.674523 325.818647l282.144962 0C832.516898 325.818647 841.97941 335.349721 841.97941 347.046111M486.181985 515.76986l0 327.437517L251.565503 843.207377c-11.727089 0-21.216207-9.516748-21.216207-21.215184l0-284.980543c0-11.698436 9.490142-21.24179 21.216207-21.24179L486.181985 515.76986zM265.527492 212.628702c0.51677-5.756097 2.863211-13.377682 15.816221-21.923312 12.159948-8.071839 29.065989-9.559727 49.846268-4.310166 39.565111 9.925047 88.511893 43.765783 125.923968 86.877673L296.721959 273.272897C287.150976 263.579117 263.426645 234.238882 265.527492 212.628702M182.849468 347.046111c0-11.695367 9.490142-21.228487 21.213137-21.228487l282.118356 0 0 137.40444L204.062606 463.222063c-11.724019 0-21.213137-9.513678-21.213137-21.213137L182.849468 347.046111z" p-id="20662" fill="#1296db"><\/path><\/svg>","sort":"10"},"10":{"name":"建站服务","ico":"<svg t="1670658620548" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="21714" width="16" height="16"><path d="M640 896v64h-256v-64H64v-64h320v-64h256v64h320v64H640zM64 64h896v640H64V64z m128 512h640V192H192v384z" fill="#0590DF" p-id="21715"><\/path><\/svg>","sort":"11"},"11":{"name":"增值业务","ico":"<svg t="1670658673530" class="icon" viewBox="0 0 1024 1024" version="1.1" xm<x>lns="http:\/\/www.w3.org\/2000\/svg" p-id="22652" width="16" height="16"><path d="M512 65.311495c-246.699682 0-446.688505 199.989847-446.688505 446.688505s199.989847 446.688505 446.688505 446.688505S958.688505 758.699682 958.688505 512 758.698658 65.311495 512 65.311495zM309.953308 567.255465c-30.517037 0-55.255465-24.738427-55.255465-55.255465s24.738427-55.255465 55.255465-55.255465 55.255465 24.738427 55.255465 55.255465S340.470345 567.255465 309.953308 567.255465zM512 567.255465c-30.517037 0-55.255465-24.738427-55.255465-55.255465s24.738427-55.255465 55.255465-55.255465c30.517037 0 55.255465 24.738427 55.255465 55.255465S542.517037 567.255465 512 567.255465zM714.046692 567.255465c-30.517037 0-55.255465-24.738427-55.255465-55.255465s24.738427-55.255465 55.255465-55.255465 55.255465 24.738427 55.255465 55.255465S744.56373 567.255465 714.046692 567.255465z" p-id="22653" fill="#1296db"><\/path><\/svg>","sort":"2"}}');
ALTER TABLE lw_goods ADD COLUMN pay_type varchar(255) DEFAULT '' COMMENT '支付类型' AFTER is_local;
ALTER TABLE lw_order ADD COLUMN pay_channel varchar(255) DEFAULT '' COMMENT '支付类型' AFTER cha_time;
ALTER TABLE lw_order ADD COLUMN is_read tinyint(3) DEFAULT 0 COMMENT '是否已读' AFTER cha_time;
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (604, '官方货源', 'goods/goodsadmin', '2097152', '0', '600', '1', '0', '600');
ALTER TABLE lw_user ADD COLUMN is_send_email tinyint(3) DEFAULT 1 COMMENT '是否接收邮件' AFTER money_t;
UPDATE `lw_plugs` SET `templateform` = '{"appid":"易支付ID","appkey":"易支付密钥","appurl":"易支付地址","alipay":1,"wxpay":2,"qqpay":3}'  WHERE `lw_plugs`.`plug_sign` = 'yi_pay';
ALTER TABLE lw_goods ADD COLUMN img_time int(11) DEFAULT 0 COMMENT '图片检测' AFTER is_local;
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (410, '密价组别', 'goods/mijiagroup', '131072', '0', '400', '1', '0', '400');
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (411, '密价组操作', 'goods/mijiagroupajax', '131072', '0', '400', '0', '0', '410');
INSERT INTO `lw_manager_class` (`manager_id`, `manager_name`, `manager_url`, `manager_type`, `create_time`, `pid`, `is_open`, `delete_time`, `top_id`) VALUES (412, '密价组商品', 'goods/mijiagroupgoods', '131072', '0', '400', '0', '0', '410');
CREATE TABLE `lw_mijia_group`  (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`status` int(3) NULL DEFAULT 1,`create_time` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `lw_mijia_goods_group`  (  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,  `goods_id` int(11) NULL DEFAULT NULL,  `group_id` int(11) NULL DEFAULT NULL,  `create_time` int(11) NULL DEFAULT 0,  `price` decimal(10, 2) NULL DEFAULT 0.00,  PRIMARY KEY (`id`) USING BTREE,  INDEX `goods_id`(`goods_id`) USING BTREE,  INDEX `group_id`(`group_id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
ALTER TABLE lw_user ADD COLUMN mi_group int(11) DEFAULT 0 COMMENT '密价组id' AFTER money_t;
DROP TABLE IF EXISTS `lw_invitation`;CREATE TABLE `lw_invitation`  (`id` int(11) NOT NULL AUTO_INCREMENT,`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`create_time` int(11) NULL DEFAULT NULL,`status` int(11) NULL DEFAULT 0,`update_time` int(11) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;
UPDATE `lw_manager_class` SET `manager_name` = '对接配置' WHERE `lw_manager_class`.`manager_id` = 600;
UPDATE `lw_manager_class` SET `manager_name` = '对接商品' WHERE `lw_manager_class`.`manager_id` = 601;
UPDATE `lw_manager_class` SET `manager_name` = '对接平台' WHERE `lw_manager_class`.`manager_id` = 610;
ALTER TABLE lw_api_goods modify column goods_api_good varchar(50);
ALTER TABLE lw_card modify column card_content text;
UPDATE `lw_plugs` SET `templateform` = '{\"appid\":\"云宝APPID\",\"appkey\":\"云宝密钥\",\"appzfb\":\"支付宝账号写1关闭转账\",\"appname\":\"支付宝姓名\",\"alipay\":1,\"wxpay\":3,\"qqpay\":2}' , `plug_name`='优云宝' WHERE `lw_plugs`.`plug_sign` = 'huanxi_pay';
ALTER TABLE lw_liushui ADD COLUMN money_info text  COMMENT '充值信息' AFTER time;
ALTER TABLE lw_api_list ADD COLUMN is_status tinyint(3) DEFAULT 0 COMMENT '状态' AFTER time;
ALTER TABLE lw_api_list ADD COLUMN cha_time int(10) DEFAULT 0 COMMENT '查单时间' AFTER time;
ALTER TABLE lw_api_list ADD COLUMN s_money decimal(12,2) DEFAULT 0 COMMENT '剩余金额' AFTER time;
ALTER TABLE lw_user ADD COLUMN t_username varchar(50) DEFAULT '' COMMENT '推荐注册人' AFTER token;
ALTER TABLE lw_order ADD COLUMN t_profit_status tinyint(3) DEFAULT 0 COMMENT '退款状态' AFTER t_money;
ALTER TABLE lw_user ADD COLUMN money_t int(11) DEFAULT 0 COMMENT '金额预警' AFTER token;
ALTER TABLE lw_api_goods ADD COLUMN is_open int(11) DEFAULT 0 COMMENT '是否比价' AFTER update_desc;
ALTER TABLE lw_api_goods ADD COLUMN b_time int(11) DEFAULT 0 COMMENT '比价时间' AFTER update_desc;
ALTER TABLE lw_order ADD COLUMN goods_api_type int(5) DEFAULT 0 COMMENT '对接类型' AFTER notebook;
ALTER TABLE lw_order ADD COLUMN goods_api_id int(11) DEFAULT 0 COMMENT 'api对接id' AFTER notebook;
DROP INDEX goods_id ON lw_api_goods;
ALTER TABLE lw_api_goods ADD UNIQUE goods_id(goods_id,goods_api_id,goods_api_good);
ALTER TABLE lw_goods ADD COLUMN is_local tinyint(3) DEFAULT 2 COMMENT '优先本地' AFTER goods_recommend;
ALTER TABLE lw_order ADD COLUMN notebook varchar(255) DEFAULT '' COMMENT '记事本' AFTER ua;
alter table lw_order modify column templates text;
ALTER TABLE lw_order ADD COLUMN t_money decimal(12, 2) DEFAULT 0 COMMENT '退款记录' AFTER ordermsg_type;
ALTER TABLE lw_order ADD COLUMN t_site_money decimal(12, 2) DEFAULT 0 COMMENT '分站t记录' AFTER ordermsg_type;
ALTER TABLE lw_order ADD COLUMN t_status int(3) DEFAULT 2 COMMENT '退款状态 2 人工处理 1网站余额' AFTER ordermsg_type;
ALTER TABLE lw_goods ADD COLUMN j_api int(3) DEFAULT 1 COMMENT '是否需要监控价格 1监控 2 不监控' AFTER goods_str3;
ALTER TABLE lw_order ADD COLUMN t_s int(3) DEFAULT 0 COMMENT '推送提醒 0 未推送 1 已推送 ' AFTER ordermsg_type;
alter table lw_order alter column t_s drop default;
alter table lw_order alter column t_s set default 0;
图片[1]-乐商网(LWSCMS) 系统版本更新SQL记录-乐商网络

© 版权声明
THE END
喜欢就支持一下吧
点赞8赞赏 分享
评论 抢沙发
头像
欢迎您留下宝贵的见解!
提交
头像

昵称

取消
昵称表情代码图片

    暂无评论内容