Erolaif.ru
Актуальность - 20.02.2024
Файл cms_shop_orders.sql
Строк - 49.215
Колонки -
`id`, `number`, `secret_key`, `date_created`, `date_payment`, `date_closed`, `date_canceled`, `date_canceled_user`, `customer_name`, `customer_org`, `customer_phone`, `customer_email`, `customer_address`, `customer_comment`, `customer_inn`, `send_method`, `send_another_customer`, `customer_name_2`, `customer_phone_2`, `customer_email_2`, `items`, `d_type`, `d_price`, `d_store_id`, `pickpoint`, `giftcode`, `gift_title`, `promocode`, `status`, `payment_status`, `delivery_status`, `summ`, `summ_original`, `bonuses_used`, `discount_title`, `user_id`, `comment`, `psys_id`, `psys_title`, `best2pay_order_id`, `best2pay_payment_url`, `payment_doc_num`, `customer_surname`, `customer_middlename`, `customer_address_region_id`, `customer_address_region_title`, `customer_address_address`, `customer_address_city`, `customer_address_postcode`, `customer_http_referer`, `customer_http_target`, `is_reserved`, `is_imported`, `status_change_date`, `need_export`, `external_id`, `sended`, `cms3_id`, `roistat_visit`, `tinkoff_credit_id`, `tinkoff_credit_link`, `tinkoff_credit_status`, `retail_id`, `is_quick_order`, `tinkoff_qr_link`, `dolyame_refund`
Файл cms_users.sql
Строк - 34.739
Колонки -
`id`, `group_id`, `login`, `nickname`, `password`, `email`, `icq`, `regdate`, `logdate`, `birthdate`, `is_locked`, `is_deleted`, `is_logged_once`, `http_referer`, `http_target`, `rating`, `points`, `last_ip`, `status`, `status_date`, `invited_by`, `invdate`, `openid`, `bonuses`, `bonuses_spent`, `discont_card`, `real_discont_card`, `moneybox`, `discount_proc`, `sinc_1c`, `cms3_id`, `retail_id`
Файл cms_user_profiles.sql
Строк - 34.736
Колонки -
`id`, `user_id`, `city`, `city_json`, `country_alfa2`, `country_title`, `region_id`, `region_title`, `description`, `showmail`, `showbirth`, `showicq`, `karma`, `imageurl`, `allow_who`, `signature`, `signature_html`, `gender`, `formsdata`, `email_newmsg`, `cm_subscribe`, `stats`, `postcode`, `address`, `phone`, `surname`, `middlename`
Скрытый текст. Для просмотра нужно [Local Link Removed for Guests]