guanli
/
ngds


			
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546
							
DROP TABLE IF EXISTS `AR_DEAL_TYPE`;
CREATE TABLE `AR_DEAL_TYPE`  (
                                 `ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                                 `TYPE_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                                 `COMMENT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '说明',
                                 `CREATE_ADMIN` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                                 `UPDATE_ADMIN` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
                                 `CREATE_REMARK` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
                                 `UPDATE_REMARK` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
                                 `IS_PRESET` tinyint(1) NOT NULL DEFAULT 0,
                                 `IS_ENABLE` tinyint(1) NOT NULL DEFAULT 0,
                                 `CREATED_AT` int(10) NOT NULL,
                                 `UPDATED_AT` int(10) NOT NULL DEFAULT 0,
                                 `SORT_ORDER` int(10) NOT NULL DEFAULT 0,
                                 PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '交易类型表' ROW_FORMAT = Dynamic;


INSERT INTO `AR_DEAL_TYPE` VALUES ('01A753D2548F44FA99B847133C1B5F79', 'Withdrawl back', '提现退回', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('01C2916A2ECA4D1B9C29AA333C6D13E7', 'Transfer out reselling points', '复消积分转出', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('1145D8ABA7A7471FB59B6760BDB19019', 'Short Message Service Fee', '短信服务费', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('141E52002AAE43B7AC304F4BAEFDA268', 'Bonus payment', '奖金发放', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('265740542539862016', 'Others', '其他', '228762167820816384', '228762167820816384', '', NULL, 0, 1, 1628580370, 1632801596, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('316868755701501952', 'Exchange points grant', '兑换积分发放', '228762167820816384', NULL, '', NULL, 0, 1, 1640770286, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('316872011148300288', 'Exchange points exchange', '兑换积分兑换', '228762167820816384', NULL, '', NULL, 0, 1, 1640771062, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('364305038266470400', 'Travel points grant', '旅游积分发放', '', NULL, '', NULL, 1, 1, 1652079974, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('364305160249413632', 'Car/Villa points grant', '车房积分发放', '', NULL, '', NULL, 1, 1, 1652080003, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('365343018452127744', 'Travel points exchange', '旅游积分兑换', '', NULL, '', NULL, 1, 1, 1652327448, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('365343060634243072', 'Car/Villa points exchange', '车房积分兑换', '', NULL, '', NULL, 1, 1, 1652327459, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('365753533326299136', 'Adjust travel points balance', '旅游积分余额调整', '', NULL, '', NULL, 0, 1, 1652425322, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('365753643942678528', 'Adjust car/villa points balance', '车房积分余额调整', '', NULL, '', NULL, 0, 1, 1652425349, 0, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('37B81A45F38646A0A16499AB27B51923', 'Reissue', '补发', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('37EFF25E5E3F46A6BB84B8C55997F276', 'Permanent shutdown deduction', '永久关停扣除', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('6626ED606DB34A11B6CCEA768B6E36C2', 'Withdraw bonus', '奖金提现', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('74436530965450752', 'Test', '测试', '86f0113857b511ea95b9e8612aaeea8d', '76214522662227968', '23213', NULL, 0, 0, 1582969933, 1584503606, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('79486964226723840', 'Adjust balance', '余额调整', '76214522662227968', '228762167820816384', '', NULL, 0, 1, 1584174056, 1632801526, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('80630995400921088', 'Return freight', '返运费', '76214522662227968', '76214522662227968', '', NULL, 0, 1, 1584446815, 1584503878, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('80869032143753216', 'C Transfer into', 'c转入', '76214522662227968', '228762167820816384', '', NULL, 0, 0, 1584503567, 1632801673, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('80869123004960768', 'Deduct money', '扣币', '76214522662227968', '228762167820816384', '', NULL, 0, 1, 1584503589, 1632801581, 1);
INSERT INTO `AR_DEAL_TYPE` VALUES ('A1F1E76F34EE4981AB3BF4F8D20BB53E', 'Cancellation of deduction', '注销扣除', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('A6BDF8A2E5F7450B80CBF3B28D8010D2', 'Reselling points grant', '复消积分发放', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('DAA0FB1465F748908680D941D589326E', 'Transfer out', '转出', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('DB62879E6C6B4B2F8591FAD920A2822C', 'Transfer into', '转入', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('F6AA8D767E654D86917BBF1A5C24F439', 'Transfer reselling points', '复消积分转入', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('YA627DTHN81OBO7NIQ1OP8N3PGZX5C66', 'Exchange reselling points', '复消积分兑换', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);