etrade / dili-xtrade · Files

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

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

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

INSERT INTO dili_xtrade.market_location VALUES (30, '2024-07-19 10:32:05', '2024-07-19 10:32:05', 30, 'HGZX', '杭州杭果甄选科技有限公司', NULL, NULL, NULL);