Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save Enapiuz/3538c88ba9869425e600 to your computer and use it in GitHub Desktop.
Save Enapiuz/3538c88ba9869425e600 to your computer and use it in GitHub Desktop.
_log_pskb(date_created,link_id,logname,log)
account(id,uid,sum)
account_attach(account_id,file_id,name,orig_name)
account_transaction(user_id,yd)
activate_service(code,email,data)
admin_log_users(user_id,log_id,last_comment_view)
annoy(ip,last_req)
articles(title,short,msgtext,sign,logo,link)
articles_comments(from_id,parent_id,from_ip,created_time,article_id,msgtext,youtube_link)
articles_comments_files(comment_id,file_id,small,inline,temp)
articles_new(title,short,msgtext,user_id,logo)
articles_users(user_id,article_id,bookmark,bookmark_time,rate_value,lastviewtime,comments_cnt)
articles_word(article_id,word_id,pos)
attachedfiles(file_id,status,data,session,size)
attachedfiles(file_id,status,date,session,size)
autoresponse(user_id,descr,only_4_cust,filter_budget,filter_budget_currency,filter_budget_priceby,filter_category_id,filter_subcategory_id,price,total,remained,is_pro)
autoresponse_log(user_id,autoresponse_id,project_id,offer_id)
ban_promo(views,clicks,c_date,type_id)
ban_promo_types(name,from_date,to_date,location,is_activity,name_img,img_style,img_title,banner_link,link_style,advertising,linktext,type_ban,code_text,login_access,is_pro,is_role,page_target)
ban_specs(banner_id,spec_id)
ban_views(banner_id,page_id,page_type_id)
billing(id,uid,ammount,op_code)
birthday(uid,uname,usurname,utype,year)
birthday08(uid,name,surname,type,message)
blogs_blocked(thread_id,admin,reason,reason_id,blocked_time)
blogs_fav(thread_id,user_id,priority)
blogs_groups(t_name,link)
blogs_msgs(fromuser_id,reply_to,from_ip,post_time,thread_id,msgtext,title,attach,small)
blogs_msgs_2013(fromuser_id,reply_to,from_ip,post_time,thread_id,msgtext,title,yt_link,ontop,moderator_status)
blogs_msgs_2014(fromuser_id,reply_to,from_ip,post_time,thread_id,msgtext,title,yt_link,ontop,moderator_status)
blogs_msgs_2015(fromuser_id,reply_to,from_ip,post_time,thread_id,msgtext,title,yt_link,ontop,moderator_status)
blogs_poll(thread_id,question)
blogs_poll_answers(thread_id,answer)
blogs_proto(fromuser_id,reply_to,from_ip,post_time,item_id,msgtext,title,attach,small)
blogs_themes_watch_2013(theme_id,user_id,is_mail,status)
blogs_themes_watch_2014(theme_id,user_id,is_mail,status)
blogs_themes_watch_2015(theme_id,user_id,is_mail,status)
chatmessage(threadid,kind,message,created)
clients(name_client,link_client,logo)
commune(group_id,author_id,name,descr,image,restrict_type,small)
commune_attach(cid,fid,small,sort,is_deleted,inline,temp)
commune_attach(cid,fid,small,sort)
commune_blocked(commune_id,"admin",reason,reason_id,blocked_time)
commune_categories(name,is_only_for_admin,commune_id)
commune_groups(name,descr,n_order)
commune_members(commune_id,user_id,is_accepted)
commune_members_notes(commune_id,user_id,note)
commune_meta(commune_id,category_id,count,hidden_count,admin_hidden_count)
commune_poll(theme_id,question,closed,multiple)
commune_poll_answers(theme_id,answer)
commune_theme_blocked(theme_id,"admin",reason,reason_id,blocked_time)
commune_votes(commune_id,user_id,vote)
confa07(uid,name,surname,type,message)
contacts(name,surname,company,note,group_id)
contacts_fields(value,type,contact_id,is_main)
contacts_groups(id,title)
contacts_mails(subject,message,attaches,contact_ids,user_id)
corp_tags(tag_id,corp_id)
corporative_blog(title,yt_link,msg,id_blog,id_user,id_reply)
corporative_blog_attach(msg_id,name,small)
corporative_blog_attach(msg_id,name,small)
docs(name,desc,docs_sections_id,sort)
draft_attaches(draft_id,draft_type,file_id)
draft_attaches(draft_id,draft_type,file_id)
draft_attaches(draft_id,draft_type,file_id)
draft_attaches(draft_id,draft_type,file_id)
draft_blogs(category,title,msgtext,yt_link,is_close_comments,is_private,poll_question,poll_type,poll_answers,uid,post_id,date)
draft_communes(category,title,msg,yt_link,poll_question,poll_type,poll_answers,close_comments,is_private,ontop,uid,post_id,commune_id,date)
draft_contacts(msg,to_login,date,uid)
draft_projects(name,descr,cost,currency,kind,pro_only,end_date,win_date,country,city,categories,date,uid,prj_id,priceby,prefer_sbr,budget_type,strong_top,verify_only,contacts)
draft_projects(name,descr,cost,currency,kind,pro_only,end_date,win_date,country,city,categories,date,uid,prj_id,priceby,prefer_sbr,budget_type,strong_top,verify_only,urgent,hide,top_days,logo_id,logo_link,contacts)
employer()
employer_counters(user_id,projects,pay_projects)
exception_date(year,holidays,workdays)
exrates(id,val)
external_m_devices(device_id,device_type,data,user_id)
external_m_push_settings(device_id,device_type,user_id,message_new,project_response_new,project_select_candidate,project_select_performer,project_select_reject)
external_m_push_settings(device_id,device_type,user_id,message_new,project_response_new,project_select_candidate,project_select_performer,project_select_reject)
feedback(uc,dept_id,user_id,user_login,email,question,request_time)
feedback(uc,dept_id,user_id,user_login,email,question,request_time)
freelancer(fid,uid,country,is_banned,active,uname,usurname,login,role,is_pro,is_pro_test,is_team,photo,warn,email,reg_ip,last_ip,is_banned,ban_where,self_deleted,safety_phone,safety_only_phone,safety_bind_up,pop,phone,phone_1,phone_2,phone_3,spec_orig,param_spec,param_opinions,param_jobs,param_m_visits,param_w_visits,param_projects)
freelancers_filters(user_id,exp_from,exp_to,login,age_from,age_to,country,city,in_office,in_fav,only_free,is_pro,sbr_is_positive,sbr_not_negative,is_preview,success_sbr,kwords,sex,opi_is_positive,opi_not_negative,is_verify,only_tu)
freelancers_filters_cost(filter_id,cost_from,cost_to,cost_type,type_date)
freelancers_filters_group(filter_id,group_id,level)
help(anotation,name,text,num_order,category_id,views,is_draft,text_plain)
hh_currency(code,name,rate,freelancer_code)
hh_fields(id,name)
hh_filters(id,filter,last_used)
hh_regions(id,parent,name)
hh_regions_city(hh_region_id,city_id)
hh_regions_country(hh_region_id,country_id)
hh_specializations(id,field,name)
interview_new(user_id,txt,post_time,main_foto,is_jury)
interview_users(user_id,interview_id,lastviewtime)
intrates(id,val)
lenta(user_id,my_team_checked,all_profs_checked)
lenta_fav(lenta_user_id,portfolio_id,commune_message_id,priority,title,blog_id)
lenta_options(lenta_user_id,commune_id,prof_group_id,blog_group_id)
letters(title,date_add,user_add,user_1,user_2,user_3,group_id,delivery_cost,comment,delivery,date_change_status,parent,user_status_1,user_status_2,user_status_3,user_status_date_1,user_status_date_2,user_status_date_3,is_user_1_company,is_user_2_company,is_user_3_company,withoutourdoc)
letters_company(name,country,city,index,address,fio,frm_type)
letters_group(id,title)
letters_history(doc_id,type_field,val_old,val_new,change_date,user_id)
letters_template(id,title)
letters_template_doc(template_id,title,date_add,user_1,user_2,user_3,group_id,delivery_cost,comment,delivery,date_change_status,parent,user_status_1,user_status_2,user_status_3,user_status_date_1,user_status_date_2,user_status_date_3,is_user_1_company,is_user_2_company,is_user_3_company,withoutourdoc)
lm_docs(opid,user_id,docsend_time,docsend,docback_time,docback)
mass_sending_cities(mass_sending_id,country_id,city_id)
mass_sending_costs(mass_sending_id,cost_type,cost_period,cost_from,cost_to)
mass_sending_profs(mass_sending_id,group_id,prof_id)
mass_sending_tariffs(pro,no_pro)
mass_sending_users(mid,uid)
messages(from_id,to_id,msg_text,attach)
messages_allowed(to_id,from_id)
messages_files(mid,fid,fname)
messages_sendlog(uid,date,count)
nsync_crash(txid,crash_time,cmd_executed)
offers_filter(user_id,active)
opros(name,descr,flags,is_active,is_multi_page)
opros_answers(name,question_id,is_other,e_count,f_count,u_count,value,num,is_m_other,move_question_id,orig_answer_id,is_m_block,block_questions,is_m_number,block_answer)
opros_questions(name,opros_id,max_answer,page_num,num,type)
orders(from_id,to_date,tarif,ordered,billing_id,payed)
orders(from_id,to_date,tarif,ordered,billing_id,payed)
orders_freezing_pro(user_id,from_time,to_time,order_id)
partners_become(email,user_id)
permissions_groups(id,name)
permissions_groups_rights(group_id,right_id)
permissions_groups_users(group_id,user_id)
permissions_rights_users(right_id,user_id,is_allow)
pgq_last_batch(qname,consumer_id,batch_id)
pm_payments(id,account_id,merchant_type,invoice_req)
portf_choise_change(user_id,prof_id,ucolumn,stop_words_cnt,old_val,moderator_status)
portfolio(name,link,pict,prev_pict,static_preview,descr,cost,cost_type,time_type,time_value,prof_id,user_id,show_preview,prev_type,norder,in_shop,is_video,video_link,moderator_status)
portfolio_blocked(id,src_id,admin,reason,reason_id,blocked_time)
portfolio_fav(prf_id,user_id)
professions(name,prof_group,link)
professions_keywords(prof_id,keyword)
professions_seo_geo(profession_id,country_id,city_id,descr,title,descr_text,descr_text2)
professions_stats_money(prof_id,cost_month,cost_project,cost_hour)
project_attach(project_id,file_id)
project_attach(project_id,file_id)
project_exrates(id,val)
project_to_spec(project_id,category_id,subcategory_id)
projects(state,user_id,name,cost,descr,currency,kind,country,city,payed,pro_only,logo_id,link,is_color,is_bold,top_from,top_to,billing_id,payed_items,end_date,win_date,budget_type,priceby,prefer_sbr,moderator_status,strong_top,verify_only,contacts,urgent,hide,o_urgent,o_hide,videolnk)
projects_blocked(project_id,admin,reason,reason_id,blocked_time)
projects_complains(project_id,user_id,type,msg,files,exported)
projects_complains_types(moder,name,textarea,required,pos)
projects_contest_attach(offer_id,user_id,file_id,prev_id,orig_name,post_date,sort)
projects_contest_blocked(project_id,user_id,admin_id,post_date)
projects_contest_msgs(offer_id,user_id,reply_to,from_ip,msg,post_date,moderator_status)
projects_contest_offers(project_id,user_id,post_date,descr,comm_blocked,po_frl_read,msg_count,moderator_status)
projects_favorites(pid,uid)
projects_filters(user_id,page,active)
projects_history(id,name,cost,descr,currency,kind,files,specs,pro_only,prefer_sbr,end_date,win_date,country,city,priceby,verify_only,contacts,urgent,hide)
projects_offers(project_id,user_id,cost_from,cost_to,cost_type,time_from,time_to,time_type,portf_id1,portf_id2,portf_id3,pict1,pict2,pict3,prev_pict1,prev_pict2,prev_pict3,only_4_cust,prefer_sbr,po_emp_read,descr,is_color,payed_items,offer_contacts,po_frl_read,moderator_status,auto)
projects_offers_attach(offer_id,prev_pict,pict)
projects_offers_blocked(src_id,admin,reason,reason_id,blocked_time)
projects_offers_dialogue_blocked(src_id,admin,reason,reason_id,blocked_time)
projects_payments(project_id,opid,pay_type,ammount,trs_sum)
projects_rss(kind,category,last_created,last_modified,service,sub_category)
projects_watch(prj_id,user_id,status)
regions_groups(hh_parent,hh_id,nest)
reserves_payout_history(payout_id,reserve_id,price,status,error,date,last,cnt,techMessage,reqv_history_id)
reserves_payout_reqv_history(reserve_id,pay_type,fields,date,last)
sbr(id,emp_id,frl_id,project_id,name,cost_sys,is_draft,scheme_type)
sbr_admin_doc_ito(date_create,date_period,file_id)
sbr_calc(calc,hash)
sbr_docs(sbr_id,stage_id,file_id,name,status,access_role,type,owner_role,num)
sbr_docs_diff(first_doc_id,second_doc_id,type,stage_id)
sbr_feedbacks(descr,p_rate,n_rate,a_rate,rating)
sbr_reqv(user_id,rezdoc_comment,rezdoc_status,form_type,rez_type,is_agree_view_sbr,validate_status)
sbr_reqv_blocked(src_id,admin,reason,reason_id,blocked_time)
sbr_stages(sbr_id,name,descr,category,sub_category,status,cost,work_time,int_work_time,num)
sbr_stages_arbitrage(stage_id,user_id,descr)
sbr_stages_arbitrage_attach(arbitrage_id,file_id,orig_name)
sbr_stages_attach(stage_id,file_id,orig_name)
sbr_stages_msgs(stage_id,user_id,parent_id,msgtext,yt_link,is_admin)
sbr_stages_msgs_attach(msg_id,file_id,orig_name)
sbr_stages_payouts(stage_id,user_id,credit_sys,credit_sum,is_arbitrage,state)
search_kwords_top(index_type,query,match_cnt,cnt,rate)
seo_bind(section_id,subdomain_id,is_draft)
sessions(session_id,session_uid,is_tray,session_login)
settings(id,module,variable,value)
sms_operations(operation_id,profit,evt_id)
spec_add_choise(priority,user_id,prof_id,prof_origin)
spec_paid_acc_operations(billing_id,paid_from,paid_to)
spec_paid_choise(id,user_id,paid_from,paid_to)
stat_daily(user_id,_date,by_f_from_b,by_e_from_b,by_u_from_b,by_f_from_c,by_e_from_c,by_u_from_c,by_f_from_p,by_e_from_p,by_u_from_p,by_f_from_t,by_e_from_t,by_u_from_t,by_f_from_o,by_e_from_o,by_u_from_o,by_f_from_s,by_e_from_s,by_u_from_s,by_f,by_e,by_u)
stat_feedback(date,type,count)
stat_feedback(date,type,count)
stat_hourly(user_id,guest_id,guest_ip,by_e,_time,from_b,from_c,from_p,from_t,from_o,from_s)
stat_monthly(user_id,_date,by_f,by_e,by_u)
stat_word_daily(user_id,word_id,stat_date,emp_cnt,frl_cnt,user_cnt)
stat_word_hourly(user_id,word_id,emp_cnt,frl_cnt,user_cnt,stat_date)
stat_word_summary(user_id,word_id)
stat_word_tmp(user_id,word_id,emp_cnt,frl_cnt,user_cnt,stat_date)
stby_log2(master_cnt,standby_cnt,master_time,standby_time,ro_errors_cnt,day,opts,real_mask)
subscribe_missing_24h_stat(date_subscribe,bs,carusel,pro,payed_places,verify)
surveys(title,description,date_begin,date_end,code,visibility,thanks_text,u_count,e_count,f_count)
surveys_questions(title,description,type,is_visible,page,num,survey_id,max_answers,is_number,number_min,number_max)
surveys_questions_options(title,is_other,is_block,value,question_id,is_number,number_min,number_max,num,u_count,e_count,f_count)
swf_file_params(fid,wmode,table_name)
teams()
tservices_blocked(src_id,admin,reason,reason_id,blocked_time)
tservices_orders(emp_feedback_id,date_emp_last,frl_feedback_id,date_frl_last)
tservices_orders_feedbacks(order_id,user_id,feedback,rating,deleted)
tservices_sbr(service_id,sbr_id,stage_id)
ufp_description(title,descr,full_descr)
ufp_portfolio(portfolio_id,pict,ufp_description_id,n_order,jumptowork_count)
user_langs(lang_id,uid,quality)
users(login,uname,usurname,passwd,email,role,reg_date,reg_ip,last_time,last_ip,sex,active,subscr)
users_ban(uid,from,to,reason,comment,admin)
users_ban(uid,from,to,reason,comment,admin,where)
users_change_emails_log(uid,email,date)
users_change_pwd_log(uid,ip,date,service,modified_uid)
users_first_page(user_id,to_date,tarif,ordered,payed,billing_id,profession,skip_psum)
users_first_page_autopay(user_id,profession)
users_fuids(user_id,fuid)
users_login_attempt(user_id,cnt)
users_login_cnt(user_id,cnt)
users_loginip_log(uid,ip,date)
users_old(login,is_active,subscr,active)
users_pop(user_id,voter_id,vote,vote_time,voter_ip)
users_safety(uid,b_ip,e_ip)
users_subscribe_keys(uid,key)
users_suspicious_contacts(user_id,utable,ucolumn,rec_id)
users_suspicious_words(word,type)
users_visits(user_id,is_emp)
users_warns(uid,admin,reason,warn_time,reason_id,users_content)
variables(name,value)
verify_card(user_id,card,result,req_time)
winner(blog_id,proj_id)
wizard_fields(field_name,field_value,field_type,wiz_uid)
wm_payments(src_type,src_id,in_amt,is_locked)
wm_trs(payment_id,name,passport_serie,passport_number,passport_date,purse,price,cheque,kiosk_id,phone)
yd_payments(src_type,src_id,in_amt,is_locked)
yd_trs(payment_id,dstacnt_nr,tr_amt,cont)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment