addTopUser.sql 4.0 KB

1234
  1. INSERT INTO `AR_USER`(`ID`, `USER_NAME`, `PASSWORD_HASH`, `PAY_PASSWORD`, `NATION`, `REAL_NAME`, `ID_CARD`, `ID_TYPE`, `MOBILE`, `ADDRESS`, `ID_IMAGE`, `OPEN_BANK`, `BANK_ADDRESS`, `BANK_NO`, `BANK_PROVINCE`, `BANK_CITY`, `BANK_COUNTY`, `SPOUSE_NAME`, `SPOUSE_IDCARD`, `CREATED_AT`, `UPDATED_AT`, `STATUS`, `DEC_CLOSED`, `DEC_CLOSED_AT`, `DEC_LV`, `EMP_LV`, `PROVINCE`, `CITY`, `COUNTY`, `TEL`, `LOGIN_TIMES`, `LOGIN_IP`, `LOGIN_AT`, `PULL_MESSAGE_AT`, `SUB_COM_ID`, `AVATAR`, `DELETED`, `DELETED_AT`, `ALLOW_TRANSFER`, `TRANSFER_PROP`, `PARTITION_DATE`, `IS_DEC`, `DEC_ID`, `BIRTHDAY`, `DEC_ROLE_ID`, `PERIOD_AT`, `DEC_PROVINCE`, `DEC_CITY`, `DEC_COUNTY`, `IS_UNION`, `STATUS_AT`, `VERIFIED`, `VERIFIED_AT`, `ALLOW_LOGIN`, `NOT_OPERATING`, `REG_FROM`, `ID_CARD_PREFIX`, `ALLOW_BONUS_LOGIN`, `SEX`, `DEC_ACCOUNT_OLD`, `BANK_UPDATED_AT`, `IS_DIRECT_SELLER`, `DEC_LV_UPDATED_AT`, `DEC_LV_UPDATED_PERIOD`, `DEC_ADDRESS`, `DEC_PHONE`, `GUARANTOR`, `GUARANTOR_NAME`, `PART_FUNC_CLOSED`, `LAST_DEC_LV_UPDATED_PERIOD`, `USER_CREATOR`, `USER_UPDATER`, `LAST_DEC_LV_UPDATED_AT`, `DEC_CREATED_AT`, `PART_FUNC_CLOSED_REMARK`, `DEC_CREATED_PERIOD`, `PASSWORD_CHANGED`, `SUB_COM_LEADER`, `LOGIN_FAIL_TIMES`, `ZG_UPGRADE_PV`, `APP_CLIENT_ID`, `READ_AGREEMENT`, `LAST_DEC_LV`, `BONUS_APP_CLIENT_ID`, `IS_FIRST_OPEN`, `IS_ATLAS`, `IS_MODIFY_PASSWORD`) VALUES ('248339072886648832', 'gongsi3', '$2y$13$k6I/qq/k3JLojBHNEKApUOaMBhTMnAjch3eUllgXuu8Pj8rgT5JnG', '$2y$13$YIN9eFc7SSQiaGrq093xU.B2KpkavHkZDspPRq6gJhZb.3vXfphqm', 1, '会员1', '350521199012166535', 0, '15959956820', '秦皇岛市东山街1000001号', 'http://upload.ar.wqcms.com/files/2018/0606/e0013022694b11e8b1af10ddb1d0e3fd', '0010000', '鸽子窝110号', '6222***********0131', 130000, 130300, 130304, '瞬瞬', '130324198808081235', 1514736000, 1514736000, 1, 0, 0, '67ABCB8C1F7D5519E055736AECE8644D', '67BE1C6C21F81B32E055736AECE8644D', 110000, 110100, 110101, '13826545212', 2659, '106.118.113.61', 1578879390, 0, '953BF18AE3694BC4E053693418ACAC98', 'http://upload.ar.wqcms.com/cdn/avatar/1.png', 0, 0, 1, 1.01, '2020-02-29 01:07:09', 1, '670B84FD7C216D4EE055736AECE8644D', '1977-08-10', '810916A06B304162902408A6B9E5D177', 117, 130000, 130200, 130203, 0, 1608789294, 1, 1514736000, 1, 0, 1, NULL, 1, '女', NULL, 0, 0, 1573003331, 158, '123', '15098156582', NULL, NULL, 0, 0, 'adminty', 'adminty', 0, 1514736000, '报单中心货款/会员货款余额15132.00,600010.00高于参数\"100.00\"关闭', 158, 3, 0, 5, 12000.00, NULL, 1, '67ABCB8C1F7D5519E055736AECE8644D', NULL, 1, 0, 0);
  2. INSERT INTO `AR_USER_INFO`(`ID`, `USER_ID`, `USER_NAME`, `ZC_PV`, `CON_UID`, `REC_UID`, `CON_NUM`, `REC_NUM`, `NETWORK_DEEP`, `RELATION_DEEP`, `SYSTEM_ID`, `IS_GROUP_LEADER`, `IS_SYSTEM_LEADER`, `IS_TEAM`, `IS_BIND`, `IS_TEAM_MAIN`, `IS_BIND_MAIN`, `IS_AUTO_WITHDRAW`, `CLOSE_LOGIN`, `REG_TYPE`, `SHOULD_REG_TYPE`, `REG_NAME`, `CREDIT_CODE`, `PREMISES`, `LEGAL_PERSON`, `REG_EXPIRES`, `STORE_TYPE`, `INVOICE_BALANCE`, `HIGHEST_EMP_LV`, `CREATED_AT`, `UPDATED_AT`, `CLOSE_LOGIN_AT`, `PULLED_AT`, `DELETED`, `DELETED_AT`, `GROUP_LEADER_AT`, `ALLOW_TRANSFER`, `ALLOW_RECONSUME_SMS`, `ALLOW_RECONSUME_SMS_TO`, `HIGHEST_EMP_LV_PERIOD`, `TRANSFER_PROP`, `LOGIN_NUMS`, `FAIL_NUMS`, `LAST_LOGIN_IP`, `LAST_LOGIN_AT`, `SHOW_EMP_LV`, `ZC_AMOUNT`) VALUES ('248339072895037440', '248339072886648832', 'gongsi3', 980.000, '0', '0', 14, 1, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 1, 0, '56D9181C0F5D428FA2DBD4CAB263BF2F', '56D9181C0F5D428FA2DBD4CAB263BF2F', NULL, NULL, NULL, NULL, NULL, 0, 0.00, NULL, 1514736000, 0, 0, 1610599133, 0, 0, 0, 1, 0, 0, 1, 100.00, 69, 30, '121.34.50.1', 1610599133, '', 0.000);
  3. INSERT INTO `AR_USER_NETWORK_NEW`(`ID`, `USER_ID`, `PARENT_UID`, `LOCATION_TAG`, `RELATIVE_LOCATION`, `TOP_UID`, `TOP_DEEP`, `PARENT_UIDS`, `CREATED_AT`, `UPDATED_AT`) VALUES ('248339072895037441', '248339072886648832', '0', '1', 0, '248339072886648832', 0, '', 1514736000, 0);
  4. INSERT INTO `AR_USER_RELATION_NEW`(`ID`, `USER_ID`, `PARENT_UID`, `TOP_UID`, `TOP_DEEP`, `PARENT_UIDS`, `CREATED_AT`, `UPDATED_AT`) VALUES ('248339072895037442', '248339072886648832', '0', '248339072886648832', 0, '', 1514736000, 0);