Pull to refresh

Структура базы данных ICQ.com

Reading time 4 min
Views 2.2K
В сети появился слух, что «благодаря» ошибке на странице сайта была получена структура части базы данных icq.com, отвечающая за группы, форумы, открытки и прочие мелочи.

Если кому-то интересно, прошу под кат. Там, собственно, текст. Много.

- database: master^
- table_names:
jdbc_function_escapes
- column_names:
escape_name
map_string
syso_ICQWEB04MSG_OS
- column_names:
pool
pool_status
pool_mode
pool_cache
attr_username
attr_appname
attr_hostname
attr_type
primary_server
primary_status
primary_type
primary_cfgstore
primary_cmonuser
primary_cmonpwd
secondary_server
secondary_status
secondary_type
secondary_cfgstore
secondary_cmonuser
secondary_cmonpwd
replication_status
timestamp
updated_by
sequence_num
spt_values
- column_names:
name
number
type
ansi_w
low
high
msgnum
spt_monitor
- column_names:
lastrun
cpu_busy
io_busy
idle
pack_received
pack_sent
connections
pack_errors
total_read
total_write
total_errors
spt_limit_types
- column_names:
name
id
enforced
object_type
scope
units
syblicenseslog
- column_names:
status
logdate
maxlicenses
spt_ijdbc_table_types
- column_names:
TABLE_TYPE
spt_ijdbc_mda
- column_names:
mdinfo
querytype
pre_query
query
post_query
mdaver_start
mdaver_end
srvver_start
srvver_end
spt_ijdbc_conversion
- column_names:
datatype
conversion
ijdbc_function_escapes
- column_names:
escape_name
map_string
spt_jdbc_table_types
- column_names:
TABLE_TYPE
spt_mda
- column_names:
mdinfo
querytype
query
mdaver_start
mdaver_end
srvver_start
srvver_end
spt_jtext
- column_names:
mdinfo
value
spt_jdbc_conversion
- column_names:
datatype
conversion
- database: sybsystemdb^
- table_names:
spt_committab
- column_names:
commid
suid
start
lastchange
totnum
outnum
heur
status
xid
applname
xactname
password

- database: msgboard^read login for msgboard DB
- table_names:
greetings_events
- column_names:
event_id
event_name
date_from
date_to
event_flag
event_cat_id
greetings_view_cards
- column_names:
card_id
card_header
card_msg
card_footer
card_img
card_send_date
card_style
card_parent_id
card_img_height
card_img_width
card_code
card_creator
greetings_block_users
- column_names:
user_id
user_name
greetings_promos
- column_names:
promo_id
cat_id
card_1_id
card_2_id
event_id
event_title
event_text
event_promo_name
group_categories
- column_names:
cat_id
cat_name_en
cat_parent_id
cat_position
cat_flags
cat_group_count
cat_name_de
icq_alerts_blocked_users
- column_names:
screen_name
partner_id
status
group_main
- column_names:
group_id
group_name
group_desc
group_parent_id
group_created_date
group_type
group_language
group_num_users
group_flags
group_popularity
group_promotion
group_status
group_delete_date
group_forum_spam_words
master_uin
icq_alerts_categories
- column_names:
cat_id
cat_name
cat_desc
partner_id
blog_dir
- column_names:
blog_id
uin
blog_name
blog_subtitle
blog_desc
blog_creation_date
blog_status
blog_views
blog_rating
blog_raters
blog_post_display
blog_comment_display
blog_rating_display
blog_last_update
blog_alert_comment
icq_alerts_delivery_status
- column_names:
msg_id
part_id
status
group_photo
- column_names:
photo_id
group_id
photo_buffer
photo_url
photo_type
photo_status
photo_modify_date
icq_alerts_msg_log
- column_names:
msg_id
title
text
link
partner_id
date_sent
cat_id
facebook_greeting
- column_names:
id
uid_from
uid_to
msg_title
msg_body
msg_date
card_id
uin_from
uin_to
group_members
- column_names:
member_uin
group_id
member_permission
member_join_date
member_note
member_last_active
member_show_alerts
member_show_alerts_by
member_show_alerts_by_email
member_show_in_site
member_show_in_client
member_notify_approve_by
member_notify_approve_by_email
group_users_pref
- column_names:
gup_uin
gup_allow_invited
gup_allow_invited_by
gup_notify_invited
gup_notify_invited_by
gup_notify_approved
gup_notify_approved_by
gup_email
active_users_tb
- column_names:
uin
v_id
country_code
first_id
second_id
third_id
age
gender
lsp
lang_id
forum_main
- column_names:
forum_id
group_id
forum_name
forum_description
forum_post_count
active_users_tb_temp
- column_names:
uin
v_id
country_code
first_id
second_id
third_id
age
gender
lsp
lang_id
forum_topics
- column_names:
topic_id
forum_id
topic_uin
topic_subject
topic_status_flag
topic_sticky_flag
topic_anonymous
topic_start_date
topic_last_post_date
topic_last_post_uin
topic_num_posts
topic_num_views
delete_date
countries_tb
- column_names:
country_code
country_name
country_id
languages_tb
- column_names:
lang_id
lang_code
lang_name
forum_post
- column_names:
post_id
topic_id
forum_id
post_uin
post_ip
post_title
post_body
post_date
post_status_flag
post_edited_flag
post_anonymous
is_first_post
edit_date
edit_uin
delete_date
post_cma_status
blog_post_dir
- column_names:
post_id
blog_id
post_title
post_text
post_date
post_views
post_rating
post_raters
post_image
post_privacy
post_mood
post_status
post_comments
lsps_tb
- column_names:
lsp_id
lsp_name
forum_user_post_count
- column_names:
uin
post_count
cache_tpl
- column_names:
file_name
mod
mod_bits
html
blog_tags_dir
- column_names:
tag_id
tag_name
popularity
blog_tags
- column_names:
id
blog_id
post_id
tag_id
people_messages
- column_names:
message_id
uin_from
uin_to
message_date
message_type
message_seen
message_checked
message_title
message_body
talkback
- column_names:
id
tb_id
from_uin
from_name
tb_text
tb_date
tb_status
tb_view_status
blog_favorite
- column_names:
id
uin
blog_id
show_public
alert
talkback_dir
- column_names:
tb_id
tb_section
tb_mod
tb_notify_stat
icq_alerts_registered_users
- column_names:
user_id
screen_name
cat_id
rs_lastcommit
- column_names:
origin
origin_qid
secondary_qid
origin_time
dest_commit_time
pad1
pad2
pad3
pad4
pad5
pad6
pad7
pad8
rs_threads
- column_names:
id
seq
pad1
pad2
pad3
pad4
text_events
- column_names:
event_id
id
tableid
ownerid
columnid
event_date
event_type
event_status
srvid
post_photo
- column_names:
pp_id
pp_post_id
pp_img_path
pp_date
pp_status
greetings_category
- column_names:
cat_id
cat_name
cat_parent_id
cat_position
cat_flags
greetings_cards
- column_names:
card_id
card_name
card_parent_id
card_uin
card_big_img
card_small_img
card_img
card_rating
card_raters
card_created_date
card_delete_date
card_start_date
card_comments
card_description
card_creator
card_flags
card_img_width
card_img_height
card_popularity
i_blog_dir
- column_names:
id
score
max_docs
sort_by
index_any
summary
highlight
cluster_number
cluster_keywords
total_docs
i_blog_post_dir
- column_names:
id
score
max_docs
sort_by
index_any
summary
highlight
cluster_number
cluster_keywords
total_docs

- database: IWEBDB_D04A_RS_RSSD^
- table_names:
- column_names:
Tags:
Hubs:
+5
Comments 34
Comments Comments 34

Articles