_Pantera_
21.03.2007, 21:58
134 таблицы
COLLATIONS,COLLATION_CHARACTER_SET_APPLICABILITY,C OLUMNS,COLUMN_PRIVILEGES,KEY_COLUMN_USAGE,
ROUTINES,ROUTINES,SCHEMA_PRIVILEGES,STATISTICS,TAB LES,TABLE_CONSTRAINTS,TABLE_PRIVILEGES,
TRIGGERS,USER_PRIVILEGES,VIEWS,cards_cards,cards_c ats,cards_comments,cards_log,helen,
Admins,Articles,Banners,BannersClicks,BannersShows ,BlockList,Blog,BoughtContacts,
ContactDiscounts,DailyQuotes,FeaturedProfiles,Frie ndList,GlParams,GlParamsKateg,
Guestbook,HotList,IMessages,Links,MemActions,MemAc tionsTrack,MemLevelActions,
MemLevelPrices,MemLevels,Mem_credits,Messages,Modu les,News,NotifyEmails,NotifyMsgs,
NotifyQueue,PrivPhotosRequests,ProfileMemLevels,Pr ofiles,ProfilesDesc,ProfilesTrack,
VKisses,Votes,VotesPhotos,ZIPCodes,aff,aff_banners ,aff_members,alpha_admcategories,
alpha_admins,alpha_answers,alpha_comments,alpha_de velopers,alpha_files,alpha_forum_headers,
alpha_forums,alpha_games,alpha_genres,alpha_lost_p asswords,alpha_moder_logbook,alpha_moders,
alpha_news,alpha_newscategories,alpha_poll_ip,alph a_polls,alpha_posts,alpha_publishers,
alpha_received_news,alpha_topics,alpha_users,galle ry_alboms,gallery_categories,gallery_objects,
members_as_aff,moderators,mos_banner,mos_bannercli ent,mos_bannerfinish,mos_categories,
mos_comment,mos_components,mos_contact_details,mos _containers,mos_content,mos_content_frontpage,
mos_content_rating,mos_core_acl_aro,mos_core_acl_a ro_groups,mos_core_acl_aro_sections,
mos_core_acl_groups_aro_map,mos_core_log_items,mos _core_log_searches,mos_groups,mos_mambots,
mos_menu,mos_messages,mos_messages_cfg,mos_modules ,mos_modules_menu,mos_newsfeeds,
mos_parameters,mos_poll_data,mos_poll_date,mos_pol l_menu,mos_polls,mos_sections,mos_session,
mos_stats_agents,mos_template_positions,mos_templa tes_menu,mos_users,mos_usertypes,
mos_weblinks,polls_a,polls_q,pro_onlineq,pro_onlin eu,sdating_events,sdating_matches,
sdating_users
колонки
cards_udaff_com:Admins,aff_members,alpha_admins,al pha_forums,alpha_lost_passwords,
alpha_users,mos_users,sdating_users
test(Name,Password,ID,Date,Date,Text,ArticleFlag,U rl,Active,Created,campaign_start,campaign_end,
Position,lhshift,lvshift,rhshift,rvshift,IP,Profil e,branch,owner,author,subject,entry,
read_access,write_access,uri,IDBuyer,IDContact,Tra nsactionID,HideFromBuyer,HideFromContact,
num,dis,Check,VALUE,kateg,desc,Type,err_text,Sende r,Recipient,New,IDFrom,IDTo,When,Msg,
Description,AdditionalParamName,IDAction,IDMember, ValidSince,IDLevel,AllowedCount,
AllowedPeriodLen,AllowedPeriodStart,AllowedPeriodE nd,AdditionalParamValue,Days,Price,
Purchasable,Removable,amount,Conf,FuncAdd,FuncDel, FuncUpdate,Help,LogIn,Category,Header,
Email,EmailFlag,EmailText,Subj,HTML,Creation,From, MsgText,MsgSubj,IDauto,Grant,Hide,Arrived,
DateStarts,DateExpires,NickName,ProfileType,RealNa me,RealName2,Country,City,Children,
WhereChildren,Headline,DescriptionMe,DescriptionYo u,Sex,Sex2,DateOfBirth,DateOfBirth2,
Relationship,Height,Height2,BodyType,Religion,Reli gion2,Ethnicity,Ethnicity2,MaritalStatus,
Occupation,Occupation2,Language1,Language12,Langua ge2,Language22,Language3,Language32,
Education,Education2,Income,Income2,Smoker,Smoker2 ,Drinker,Drinker2,WantChildren,
MerchantPrice,EmailNotify,Phone,HomeAddress,IM,Icq UIN,LastLoggedIn,Status,LastModified,
LastReg,Priority,HomePage,LookingFor,LookingAge,Lo okingHeight,LookingBodyType,Picture,
Pic_0_addon,Pic_1_addon-Pic_10_addon,Sound,Sound_addon,Video,Video_addon,L astNavTime,
LastNavPage,Featured,aff_num,priv_passwd,PPNotify, seed,zip,GuestbookMode,GuestbookAccess,
namedisp,namenote,extra,order,join_page,profile_ty pe,visible,editable,because,group_mark,
group_text_b,group_text_a,to_db,show_on_page,get_v alue,get_value_db,search_type,search_cols,
search_hide,search_extra,search_order,search_defau lt,search_where,match_field,match_type,
match_extra,min_length,max_length,Member,Number,Ma rk,Pic,ZIPCode,ZIPCodeType,CityType,
County,CountyFIPS,State,StateCode,StateFIPS,MSA,Ar eaCode,TimeZone,GMTOffset,DST,Latitude,
Longitude,Percent,RegDate,www1,www2,XSize,YSize,Ba nner,BannerName,Added,idAff,idProfile,
category_id,admin_id,user_id,answer_id,answer,hit, poll_id,comment_id,news_id,username,
usermail,body,posted,developer_id,site,file_id,gam e_id,header_id,forum_id,pinned,publisher_id,
genre_id,realise_date,dateformat,metadescription,m etakeywords,password_id,hash,new_password,
log_id,log_id,what,when_,moder_id,creator_id,ip_id ,time,question,archive,makedate,post_id,
topic_id,creator,_user_status_,icq,regtime,about,i d_gallery_categories,date_modified,
access,comment,id_profiles,id_gallery_alboms,file_ name,approved,num_of_mem,num_of_mem,MID,
reg_date,bid,cid,imptotal,impmade,clicks,imageurl, clickurl,showBanner,checked_out,
checked_out_time,editor,custombannercode,contact,e xtrainfo,impressions,datestart,dateend,
parent_id,image,section,image_position,published,o rdering,count,params,articleid,comments,
startdate,link,menuid,parent,admin_menu_link,admin _menu_alt,option,admin_menu_img,iscore,
con_position,address,suburb,postcode,telephone,fax ,misc,imagepos,email_to,default_con,
catid,parentid,childcount,windowtitle,keywords,ico n,title_alias,introtext,fulltext,sectionid,
mask,created_by,created_by_alias,modified,modified _by,publish_up,publish_down,images,urls,
attribs,version,metakey,metadesc,hits,content_id,r ating_sum,rating_count,lastip,aro_id,
section_value,order_value,hidden,group_id,lft,rgt, section_id,time_stamp,item_table,item_id,
search_term,element,folder,client_id,menutype,comp onentid,sublevel,pollid,browserNav,
utaccess,message_id,user_id_from,user_id_to,folder _id,date_time,message,cfg_name,cfg_value,
content,module,numnews,showtitle,moduleid,filename ,numarticles,cache_time,param_name,
param_file,param_version,vote_id,voters,lag,scope, session_id,guest,userid,usertype,gid,
agent,template,block,sendEmail,registerDate,lastvi sitDate,activation,sid,archived,
IDanswer,Votes,user,Place,WhenStart,WhenStop,State Province,PhotoPlace,Responsible,
RespPhone,RespEmail,TicketsCountM,TicketsPriceM,Ti cketsCountF,TicketsPriceF,MatchesCount,
SaleStart,SaleStop,TicketsPriceC,TicketsCountC,id_ event,WhoChose,WhomHasChosen,id_profile,
id_match
ps мож кому понадобяться базы...
COLLATIONS,COLLATION_CHARACTER_SET_APPLICABILITY,C OLUMNS,COLUMN_PRIVILEGES,KEY_COLUMN_USAGE,
ROUTINES,ROUTINES,SCHEMA_PRIVILEGES,STATISTICS,TAB LES,TABLE_CONSTRAINTS,TABLE_PRIVILEGES,
TRIGGERS,USER_PRIVILEGES,VIEWS,cards_cards,cards_c ats,cards_comments,cards_log,helen,
Admins,Articles,Banners,BannersClicks,BannersShows ,BlockList,Blog,BoughtContacts,
ContactDiscounts,DailyQuotes,FeaturedProfiles,Frie ndList,GlParams,GlParamsKateg,
Guestbook,HotList,IMessages,Links,MemActions,MemAc tionsTrack,MemLevelActions,
MemLevelPrices,MemLevels,Mem_credits,Messages,Modu les,News,NotifyEmails,NotifyMsgs,
NotifyQueue,PrivPhotosRequests,ProfileMemLevels,Pr ofiles,ProfilesDesc,ProfilesTrack,
VKisses,Votes,VotesPhotos,ZIPCodes,aff,aff_banners ,aff_members,alpha_admcategories,
alpha_admins,alpha_answers,alpha_comments,alpha_de velopers,alpha_files,alpha_forum_headers,
alpha_forums,alpha_games,alpha_genres,alpha_lost_p asswords,alpha_moder_logbook,alpha_moders,
alpha_news,alpha_newscategories,alpha_poll_ip,alph a_polls,alpha_posts,alpha_publishers,
alpha_received_news,alpha_topics,alpha_users,galle ry_alboms,gallery_categories,gallery_objects,
members_as_aff,moderators,mos_banner,mos_bannercli ent,mos_bannerfinish,mos_categories,
mos_comment,mos_components,mos_contact_details,mos _containers,mos_content,mos_content_frontpage,
mos_content_rating,mos_core_acl_aro,mos_core_acl_a ro_groups,mos_core_acl_aro_sections,
mos_core_acl_groups_aro_map,mos_core_log_items,mos _core_log_searches,mos_groups,mos_mambots,
mos_menu,mos_messages,mos_messages_cfg,mos_modules ,mos_modules_menu,mos_newsfeeds,
mos_parameters,mos_poll_data,mos_poll_date,mos_pol l_menu,mos_polls,mos_sections,mos_session,
mos_stats_agents,mos_template_positions,mos_templa tes_menu,mos_users,mos_usertypes,
mos_weblinks,polls_a,polls_q,pro_onlineq,pro_onlin eu,sdating_events,sdating_matches,
sdating_users
колонки
cards_udaff_com:Admins,aff_members,alpha_admins,al pha_forums,alpha_lost_passwords,
alpha_users,mos_users,sdating_users
test(Name,Password,ID,Date,Date,Text,ArticleFlag,U rl,Active,Created,campaign_start,campaign_end,
Position,lhshift,lvshift,rhshift,rvshift,IP,Profil e,branch,owner,author,subject,entry,
read_access,write_access,uri,IDBuyer,IDContact,Tra nsactionID,HideFromBuyer,HideFromContact,
num,dis,Check,VALUE,kateg,desc,Type,err_text,Sende r,Recipient,New,IDFrom,IDTo,When,Msg,
Description,AdditionalParamName,IDAction,IDMember, ValidSince,IDLevel,AllowedCount,
AllowedPeriodLen,AllowedPeriodStart,AllowedPeriodE nd,AdditionalParamValue,Days,Price,
Purchasable,Removable,amount,Conf,FuncAdd,FuncDel, FuncUpdate,Help,LogIn,Category,Header,
Email,EmailFlag,EmailText,Subj,HTML,Creation,From, MsgText,MsgSubj,IDauto,Grant,Hide,Arrived,
DateStarts,DateExpires,NickName,ProfileType,RealNa me,RealName2,Country,City,Children,
WhereChildren,Headline,DescriptionMe,DescriptionYo u,Sex,Sex2,DateOfBirth,DateOfBirth2,
Relationship,Height,Height2,BodyType,Religion,Reli gion2,Ethnicity,Ethnicity2,MaritalStatus,
Occupation,Occupation2,Language1,Language12,Langua ge2,Language22,Language3,Language32,
Education,Education2,Income,Income2,Smoker,Smoker2 ,Drinker,Drinker2,WantChildren,
MerchantPrice,EmailNotify,Phone,HomeAddress,IM,Icq UIN,LastLoggedIn,Status,LastModified,
LastReg,Priority,HomePage,LookingFor,LookingAge,Lo okingHeight,LookingBodyType,Picture,
Pic_0_addon,Pic_1_addon-Pic_10_addon,Sound,Sound_addon,Video,Video_addon,L astNavTime,
LastNavPage,Featured,aff_num,priv_passwd,PPNotify, seed,zip,GuestbookMode,GuestbookAccess,
namedisp,namenote,extra,order,join_page,profile_ty pe,visible,editable,because,group_mark,
group_text_b,group_text_a,to_db,show_on_page,get_v alue,get_value_db,search_type,search_cols,
search_hide,search_extra,search_order,search_defau lt,search_where,match_field,match_type,
match_extra,min_length,max_length,Member,Number,Ma rk,Pic,ZIPCode,ZIPCodeType,CityType,
County,CountyFIPS,State,StateCode,StateFIPS,MSA,Ar eaCode,TimeZone,GMTOffset,DST,Latitude,
Longitude,Percent,RegDate,www1,www2,XSize,YSize,Ba nner,BannerName,Added,idAff,idProfile,
category_id,admin_id,user_id,answer_id,answer,hit, poll_id,comment_id,news_id,username,
usermail,body,posted,developer_id,site,file_id,gam e_id,header_id,forum_id,pinned,publisher_id,
genre_id,realise_date,dateformat,metadescription,m etakeywords,password_id,hash,new_password,
log_id,log_id,what,when_,moder_id,creator_id,ip_id ,time,question,archive,makedate,post_id,
topic_id,creator,_user_status_,icq,regtime,about,i d_gallery_categories,date_modified,
access,comment,id_profiles,id_gallery_alboms,file_ name,approved,num_of_mem,num_of_mem,MID,
reg_date,bid,cid,imptotal,impmade,clicks,imageurl, clickurl,showBanner,checked_out,
checked_out_time,editor,custombannercode,contact,e xtrainfo,impressions,datestart,dateend,
parent_id,image,section,image_position,published,o rdering,count,params,articleid,comments,
startdate,link,menuid,parent,admin_menu_link,admin _menu_alt,option,admin_menu_img,iscore,
con_position,address,suburb,postcode,telephone,fax ,misc,imagepos,email_to,default_con,
catid,parentid,childcount,windowtitle,keywords,ico n,title_alias,introtext,fulltext,sectionid,
mask,created_by,created_by_alias,modified,modified _by,publish_up,publish_down,images,urls,
attribs,version,metakey,metadesc,hits,content_id,r ating_sum,rating_count,lastip,aro_id,
section_value,order_value,hidden,group_id,lft,rgt, section_id,time_stamp,item_table,item_id,
search_term,element,folder,client_id,menutype,comp onentid,sublevel,pollid,browserNav,
utaccess,message_id,user_id_from,user_id_to,folder _id,date_time,message,cfg_name,cfg_value,
content,module,numnews,showtitle,moduleid,filename ,numarticles,cache_time,param_name,
param_file,param_version,vote_id,voters,lag,scope, session_id,guest,userid,usertype,gid,
agent,template,block,sendEmail,registerDate,lastvi sitDate,activation,sid,archived,
IDanswer,Votes,user,Place,WhenStart,WhenStop,State Province,PhotoPlace,Responsible,
RespPhone,RespEmail,TicketsCountM,TicketsPriceM,Ti cketsCountF,TicketsPriceF,MatchesCount,
SaleStart,SaleStop,TicketsPriceC,TicketsCountC,id_ event,WhoChose,WhomHasChosen,id_profile,
id_match
ps мож кому понадобяться базы...