etrade / zr-etrade · Files

etrade_admin_data.sql 1.78 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 
USE dili_etrade;
INSERT INTO `banner_type`(`creater_id`, `creater`, `sort`, `name`, `state`) VALUES (57, '超级管理员', 1, '公告', 1);
INSERT INTO `banner_type`(`creater_id`, `creater`, `sort`, `name`, `state`) VALUES (57, '超级管理员', 2, '活动', 1);
INSERT INTO `banner_type`(`creater_id`, `creater`, `sort`, `name`, `state`) VALUES (57, '超级管理员', 3, '广告', 1);
INSERT INTO `banner_type`(`creater_id`, `creater`, `sort`, `name`, `state`) VALUES (57, '超级管理员', 4, '其他', 1);

INSERT INTO dili_etrade.setting_payment_method_type (id, classification_code, code, name) VALUES (1, 1, 1, '现金');
INSERT INTO dili_etrade.setting_payment_method_type (id, classification_code, code, name) VALUES (2, 1, 2, '微信*');
INSERT INTO dili_etrade.setting_payment_method_type (id, classification_code, code, name) VALUES (3, 1, 3, '支付宝*');
INSERT INTO dili_etrade.setting_payment_method_type (id, classification_code, code, name) VALUES (4, 2, 4, '地利通扫码付');
INSERT INTO dili_etrade.setting_payment_method_type (id, classification_code, code, name) VALUES (5, 3, 5, '赊销二维码');
INSERT INTO dili_etrade.setting_payment_method_type (id, classification_code, code, name) VALUES (6, 3, 6, '赊销');

INSERT INTO dili_etrade.setting_payment_method_classification (id, code, name) VALUES (1, 1, '卖方自行收款');
INSERT INTO dili_etrade.setting_payment_method_classification (id, code, name) VALUES (2, 2, '园区卡收款');
INSERT INTO dili_etrade.setting_payment_method_classification (id, code, name) VALUES (3, 3, '赊销');

INSERT INTO dili_etrade.market_location VALUES (9, '2023-10-30 11:39:28', '2023-10-31 11:33:17', 9, 'sy', '沈阳地利', 41.823945, 123.522344, 'https://basic-config.oss-cn-beijing.aliyuncs.com/img/etrade/background/city/shenyang.png');