Skip to content

MySQL Database

August 5, 2009
tags:
For installing forum, blog and videos ,there should be some component to run it. So, we went for joomla a open source content management system .
Fireboard is a component installed for forum , mojoblog is installed for blog and for videos seyret is installed.
Forums:
List of tables with their fieldnames. According to these ,fieldnames are mapped and are exceuted .
Jos_fb_announcements – id, title, sdescription, description, created, published, ordering, and show date.
Jos_fb_attachments ¬タモ id, title.
Jos_fb_categories ¬タモ id, parent, name, cat_emotion, locked, alert_admin, moderated, moderators, pub_access, pub_recurse, admin_access, admin_recurse, ordering, future2, published, checked_out, checked_out_time, review, hits, description, headerdesc, class_sfx, id_last_msg, numPosts, time_last_msg.
Jos_fb_favorites ¬タモ thread , userid.
Jos_fb_groups ¬タモ id, title.
Jos_fb_messages – id, parent, thread, catid, name, userid, email, subject, time, ip, topic_emoticon, locked, hold, ordering, hits, moved, modified_by, modified_time, modified_reason.
Jos_fb_messages_text ¬タモ mesid, message
Jos_fb_moderation ¬タモ catid, userid, future1, future2
Jos_fb_ranks ¬タモ rank_id , rank_title, rank_min, rank_special, rank_image.
Jos_fb_sessions ¬タモ userid, allowed, lasttime, readtopics, currvisit.
Jos_fb_smileys ¬タモ id,code,location,greylocation,emotionbar.
Jos_fb_subscriptions ¬タモ thread,userid,future1
Blogs:
Jos_wp_categories – Cat_id, cat_name, category_nicename, category_description, category_parent, category_count.
Jos_wp_comments ¬タモ comment_id, comment_post_id, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id.
Jos_wp_linkcategories ¬タモ cat_id, cat_name, auto_toggle, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, text_before_link, text_after_link, text_after_all, list_limit.
Jos_wp_links ¬タモ link_id, link_url, link_name, link_image, link_target, link_category, link_description, link_visible, link_owner, link_rating, link_updated, link_rel, link_notes,
link_rss.
Jos_wp_options ¬タモ option_id, blog_id, option_name, option_can_override, option_type, option_value, option_width, option_height, option_description, option_admin_level, autoload.
Jos_wp_post2cat ¬タモ rel_id, post_id, category_id.
Jos_wp_postmeta ¬タモ meta_id, post_id, meta_key, meta_value.
Jos_wp_posts ¬タモ id, post_author, post_date, post_date_gmt, post_content, post_title, post_category,
Post_title, post_category , post_excerpt, post_status, post_password , post_name, to_ping , pinged, post_modified , post_modified_gmt, post_content_filtered, post_parent , guid , menu_order , post_type , post_mime_type, comment_count.
Jos_wp_usermeta ¬タモ umeta_id, user_id, meta_key, meta_vlaue.
Videos :
Jos_seyret_ads ¬タモ id, catid, adlink, published.
Jos_seyret_categories ¬タモ id, categoryname, parentcat, categoryinfo, catid,
categoryfilesdirectory .
jos_seyret_check ¬タモ id, joomlaalemtrack, joomlaalemuserid, jalemdonated, seyrethelp, seyretsnippet, seyretpro, prophpdate, dfltdownloader, prophpmd5, accepttermsofuse, savedconfig, dbversion.
Jos_seyret_imageads ¬タモ id, catid, imageadlink, published, clicklink.
Jos_seyret_items ¬タモ id, catid, title, itemcomment, videoservertype, videoservercode, picturelink, ordering, hit, votetotal, voteclick, addedby, addeddate, published, downloadcount, accesslevel, hasbackup, isdownloadable, backupid, videourl, featured, fbthread, videotags, lastclicktime, playtime.
Jos_seyret_reports ¬タモ id, videoed, reportedby, reporteddate, reportreason, reportread, reportprocessed, reportprocessedby, reportreply, reportreplydate.
Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: