ICQ.comデータベース構造

サイトページのエラーに「感謝」するという噂がネットワークに現れ 、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:







All Articles