Database Description

The following is an outline and description of the database tables created during the standard installation of SocialNetworkSoftware. Currently, the only database supported by SocialNetworkSoftware is MySQL version 4.1.2 or greater.

Contents 1 Database Description 1.1 Table Organisation 1.2 Database Diagram 1.3 Tables Description 1.3.1 Table: accept_member_in_community_template 1.3.2 Table: add_a_question_template 1.3.3 Table: add_album_photo_comment_template 1.3.4 Table: add_answer_to_question_template 1.3.5 Table: add_article_comment_template 1.3.6 Table: add_blog_comment_template 1.3.7 Table: add_blogs_template 1.3.8 Table: add_blogs_to_readers_template 1.3.9 Table: add_classfied_template 1.3.10 Table: add_community_photo_comment_template 1.3.11 Table: add_community_template 1.3.12 Table: add_directory_template 1.3.13 Table: add_forum_community_owner_template 1.3.14 Table: add_forum_owner_template 1.3.15 Table: add_friend_request_template 1.3.16 Table: add_guestbook_message_comment_template 1.3.17 Table: add_guestbook_message_template 1.3.18 Table: add_link_comment_template 1.3.19 Table: add_links_template 1.3.20 Table: add_set_status_comment_template 1.3.21 Table: add_video_comment_template 1.3.22 Table: admin_files 1.3.23 Table: admin_groups 1.3.24 Table: admin_user_point_mail 1.3.25 Table: administrator 1.3.26 Table: album 1.3.27 Table: album_photo 1.3.28 Table: album_photo_report_it_email_template 1.3.29 Table: answer 1.3.30 Table: answer_rating 1.3.31 Table: answer_report_it_email_template 1.3.32 Table: article 1.3.33 Table: article_categories 1.3.34 Table: article_comment 1.3.35 Table: article_report_it_email_template 1.3.36 Table: audio 1.3.37 Table: banner 1.3.38 Table: banner_location 1.3.39 Table: best_feature 1.3.40 Table: block_user 1.3.41 Table: blog_comment 1.3.42 Table: blog_report_it_email_template 1.3.43 Table: blogs 1.3.44 Table: blogs_categories 1.3.45 Table: blogs_rating 1.3.46 Table: blogs_subscribe 1.3.47 Table: body_art 1.3.48 Table: build 1.3.49 Table: children 1.3.50 Table: classified 1.3.51 Table: classified_category 1.3.52 Table: classified_report_it_email_template 1.3.53 Table: community 1.3.54 Table: community_category 1.3.55 Table: community_event_report_spam 1.3.56 Table: community_events 1.3.57 Table: community_members 1.3.58 Table: community_photo 1.3.59 Table: community_photo_report_it_email_template 1.3.60 Table: community_report_it_email_template 1.3.61 Table: compose_message_email_template 1.3.62 Table: configuration 1.3.63 Table: configuration_group 1.3.64 Table: contact_info 1.3.65 Table: countries 1.3.66 Table: currencies 1.3.67 Table: dating_with 1.3.68 Table: degree 1.3.69 Table: directory_category 1.3.70 Table: directory_url 1.3.71 Table: drinking 1.3.72 Table: education 1.3.73 Table: education_info 1.3.74 Table: ethnicity 1.3.75 Table: event_categories 1.3.76 Table: event_members 1.3.77 Table: events 1.3.78 Table: eye_color 1.3.79 Table: fashion 1.3.80 Table: feedback 1.3.81 Table: forum_message 1.3.82 Table: forum_report_spam 1.3.83 Table: forum_topic 1.3.84 Table: friends 1.3.85 Table: general_info 1.3.86 Table: global_poll 1.3.87 Table: global_poll_vote 1.3.88 Table: guestbook 1.3.89 Table: guestbook_message_comment 1.3.90 Table: hair_color 1.3.91 Table: humor 1.3.92 Table: im_user 1.3.93 Table: industry 1.3.94 Table: interested_in 1.3.95 Table: invite_friends_template 1.3.96 Table: ipaddress_block 1.3.97 Table: language_speak 1.3.98 Table: languages 1.3.99 Table: link_category 1.3.100 Table: link_comment 1.3.101 Table: link_report_it_email_template 1.3.102 Table: links 1.3.103 Table: links_point 1.3.104 Table: living 1.3.105 Table: looks 1.3.106 Table: member_request_in_community_template 1.3.107 Table: module 1.3.108 Table: newsletters 1.3.109 Table: newsletters_history 1.3.110 Table: personal_info 1.3.111 Table: pets 1.3.112 Table: photo_comment 1.3.113 Table: plan_type 1.3.114 Table: point_allocation 1.3.115 Table: political_view 1.3.116 Table: poll 1.3.117 Table: poll_vote 1.3.118 Table: privacy_status 1.3.119 Table: profile_view 1.3.120 Table: q_a_comment 1.3.121 Table: question 1.3.122 Table: question_category 1.3.123 Table: question_report_it_email_template 1.3.124 Table: regions 1.3.125 Table: relationship_status 1.3.126 Table: religion 1.3.127 Table: reply_to_classified_template 1.3.128 Table: report_abuse_article 1.3.129 Table: report_abuse_blog 1.3.130 Table: report_abuse_classified 1.3.131 Table: report_abuse_community 1.3.132 Table: report_abuse_link 1.3.133 Table: report_abuse_photo 1.3.134 Table: report_abuse_q_and_a 1.3.135 Table: report_abuse_video 1.3.136 Table: report_category 1.3.137 Table: salutation 1.3.138 Table: set_status_comment 1.3.139 Table: sexual_orientation 1.3.140 Table: smoking 1.3.141 Table: social_info 1.3.142 Table: subscribe_blog_update 1.3.143 Table: title_keywordmetatype 1.3.144 Table: turn_ons 1.3.145 Table: user_chat 1.3.146 Table: user_contact 1.3.147 Table: user_login 1.3.148 Table: user_mails 1.3.149 Table: user_point 1.3.150 Table: user_registration_template 1.3.151 Table: video 1.3.152 Table: video_comment 1.3.153 Table: video_report_it_email_template 1.3.154 Table: whos_online 1.3.155 Table: word_censor 1.3.156 Table: work_info 1.3.157 Table: zones

Table Organisation

category1
table1
table2
table3

category2
table1
table2
table3

category3
table1
table2
table3

Database Diagram

Database diagram below provides a visual overview of the SocialNetworkSoftware database and the relations between the tables created during its standard installation.

Tables Description

The following are the specific fields in each of the tables created during the standard SocialNetworkSoftware installation.

Table: accept_member_in_community_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
accept_member_in_community_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_a_question_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_a_question_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_album_photo_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_album_photo_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_answer_to_question_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_answer_to_question_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_article_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_article_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_blog_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_blog_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_blogs_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_blog_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_blogs_to_readers_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_blog_to_readers_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_classfied_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_classified_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_community_photo_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_community_photo_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_community_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_community_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_directory_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_directory_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_forum_community_owner_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_forum_community_owner_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_forum_owner_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_forum_owner_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_friend_request_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_friend_request_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_guestbook_message_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_guestbook_message_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_guestbook_message_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_guestbook_message_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_link_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_link_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
zh_description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_links_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_link_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
zh_description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_set_status_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_set_status_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: add_video_comment_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
add_video_comment_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: admin_files

Description here

Field	Type	Null	Key	Default	Auto Increment
admin_files_id	int(11)	_	PRI	NULL	Y
admin_files_name	varchar(64)	_	_	NULL	_
admin_files_is_boxes	tinyint(5)	_	_	0	_
admin_files_to_boxes	int(11)	_	_	0	_
admin_groups_id	set('1','2')	_	_	1	_

Table: admin_groups

Description here

Field	Type	Null	Key	Default	Auto Increment
admin_groups_id	int(11)	_	PRI	NULL	Y
admin_groups_name	varchar(64)	_	_	NULL	_

Table: admin_user_point_mail

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
point	int(10)	_	_	0	_
date	date	_	_	0000-00-00	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: administrator

Description here

Field	Type	Null	Key	Default	Auto Increment
admin_id	int(11)	_	PRI	NULL	Y
admin_groups_id	int(11)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	Y	_	NULL	_
admin_firstname	varchar(32)	_	_	NULL	_
admin_lastname	varchar(32)	_	_	NULL	_
admin_name	varchar(32)	_	UNI	NULL	_
admin_password	varchar(50)	_	_	NULL	_
admin_email_address	varchar(128)	_	UNI	NULL	_
last_ip_address	varchar(255)	Y	_	NULL	_
ip_address	varchar(255)	Y	_	NULL	_
last_login_time	datetime	Y	_	NULL	_
is_admin	enum('No','Yes')	_	_	No	_
number_of_logon	int(11)	_	_	0	_

Table: album

Description here

Field	Type	Null	Key	Default	Auto Increment
album_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
title_name	varchar(30)	_	_	NULL	_
description	text	_	_	NULL	_
inserted	date	_	_	0000-00-00	_

Table: album_photo

Description here

Field	Type	Null	Key	Default	Auto Increment
photo_id	int(10)	_	PRI	NULL	Y
album_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
title	varchar(30)	_	_	NULL	_
photo	varchar(60)	_	_	NULL	_
hits	int(10)	_	_	0	_
photo_size	int(10)	_	_	NULL	_
status	enum('Y','N')	_	_	Y	_
featured	enum('Y','N')	_	_	N	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	NULL	_

Table: album_photo_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
album_photo_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: answer

Description here

Field	Type	Null	Key	Default	Auto Increment
a_id	int(10)	_	PRI	NULL	Y
qid	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
answer	text	_	_	NULL	_
category_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	date	_	_	0000-00-00	_
featured	enum('yes','no')	_	_	no	_
status	enum('active','inactive')	_	_	active	_

Table: answer_rating

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
answer_id	int(11)	_	_	0	_
question_id	int(10)	Y	_	NULL	_
user_id	int(10)	_	_	0	_
ipaddress	varchar(200)	_	_	NULL	_
rating	int(11)	_	_	0	_
inserted	date	_	_	0000-00-00	_

Table: answer_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
answer_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: article

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
category_id	int(11)	_	_	0	_
title	varchar(255)	_	_	NULL	_
author	varchar(255)	_	_	NULL	_
show_date	date	_	_	0000-00-00	_
description	blob	_	_	NULL	_
short_description	text	_	_	NULL	_
article_photo	varchar(255)	_	_	NULL	_
hits	int(8)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_
is_show	enum('Yes','No')	_	_	Yes	_
featured	enum('Y','N')	_	_	N	_

Table: article_categories

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(5) unsigned	_	PRI	NULL	Y
sub_cat_id	varchar(32)	_	_	NULL	_
category_name	varchar(255)	Y	MUL	NULL	_

Table: article_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
recommend_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
article_id	int(10)	_	_	0	_
comment	text	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
inserted	date	_	_	0000-00-00	_

Table: article_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
article_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: audio

Description here

Field	Type	Null	Key	Default	Auto Increment
audio_id	int(9)	_	PRI	NULL	Y
user_id	int(9)	_	MUL	NULL	_
title	varchar(64)	_	_	NULL	_
audio	varchar(128)	_	_	NULL	_
updated	datetime	_	_	NULL	_
inserted	datetime	_	_	NULL	_

Table: banner

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(5)	_	PRI	NULL	Y
banner_type	enum('image','script')	_	_	NULL	_
title	varchar(150)	_	_	NULL	_
href	varchar(255)	_	_	NULL	_
src	varchar(255)	_	_	NULL	_
alt	varchar(255)	Y	_	NULL	_
script	text	_	_	NULL	_
adviews	int(10)	Y	_	0	_
adclicks	int(10)	Y	_	0	_
active	enum('T','F')	_	_	T	_
location	int(5)	_	_	1	_
banner_date	date	_	_	0000-00-00	_
b_order	int(10)	_	_	1	_
company_name	varchar(50)	Y	_	NULL	_
company_contact	varchar(50)	Y	_	NULL	_
company_email	varchar(50)	Y	_	NULL	_
company_comments	varchar(100)	Y	_	NULL	_
banner_duration_from	date	Y	_	NULL	_
banner_duration_to	date	Y	_	NULL	_
banner_costing	varchar(40)	Y	_	NULL	_
duration_unlimited	enum('T','F')	_	_	T	_
deleted	enum('T','F')	_	_	F	_

Table: banner_location

Description here

Field	Type	Null	Key	Default	Auto Increment
banner_location_id	int(5)	_	PRI	NULL	Y
banner_location_name	varchar(100)	_	_	NULL	_

Table: best_feature

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
best_feature	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: block_user

Description here

Field	Type	Null	Key	Default	Auto Increment
block_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
block_user_id	int(10)	_	_	0	_
inserted	date	_	_	0000-00-00	_

Table: blog_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
recommend_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
article_id	int(10)	_	_	0	_
rating	varchar(20)	_	_	NULL	_
comment	text	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
inserted	date	_	_	0000-00-00	_

Table: blog_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
blog_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: blogs

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
category_id	int(11)	_	_	0	_
email_id	varchar(150)	_	_	NULL	_
title	varchar(255)	_	MUL	NULL	_
author	varchar(255)	_	_	NULL	_
upload_files	varchar(100)	_	_	NULL	_
short_description	text	_	_	NULL	_
description	blob	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_
is_show	enum('Yes','No')	_	_	Yes	_
hits	int(11)	_	_	0	_
user_id	int(10)	_	_	0	_
featured	enum('N','Y')	_	_	NULL	_

Table: blogs_categories

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(5) unsigned	_	PRI	NULL	Y
category_name	varchar(255)	Y	MUL	NULL	_
priority	smallint(5)	_	_	0	_

Table: blogs_rating

Description here

Field	Type	Null	Key	Default	Auto Increment
article_id	int(11)	_	_	0	_
user_id	int(10)	_	_	0	_
ipaddress	varchar(200)	_	_	NULL	_
rating	int(11)	_	_	0	_
inserted	date	_	_	0000-00-00	_

Table: blogs_subscribe

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	MUL	NULL	Y
user_id	int(10)	_	_	0	_
subscribe_id	int(10)	_	_	0	_
inserted	date	_	_	0000-00-00	_
updated	date	_	_	0000-00-00	_

Table: body_art

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
body_art	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: build

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
build	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: children

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
children	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: classified

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
photo	varchar(60)	_	_	NULL	_
video	varchar(255)	_	_	NULL	_
category_id	int(10)	_	_	0	_
sub_category_id	int(10)	_	_	NULL	_
country	smallint(4)	_	_	0	_
state_id	int(10)	_	_	NULL	_
state	varchar(50)	_	_	NULL	_
city_id	int(10)	_	_	NULL	_
city	varchar(30)	_	_	0	_
title	varchar(100)	_	_	NULL	_
currency_price	varchar(10)	_	_	NULL	_
price	varchar(20)	_	_	NULL	_
description	text	_	_	NULL	_
status	enum('active','inactive')	_	_	active	_
end_date	datetime	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_

Table: classified_category

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(5)	_	PRI	NULL	Y
sub_cat_id	int(11)	Y	_	NULL	_
category_name	varchar(255)	_	PRI	NULL	_
priority	smallint(5)	_	_	0	_

Table: classified_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
classified_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: community

Description here

Field	Type	Null	Key	Default	Auto Increment
community_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
community_name	varchar(100)	_	_	NULL	_
category	int(10)	_	_	0	_
type	varchar(30)	_	_	NULL	_
language	int(10)	_	_	0	_
country	int(10)	_	_	0	_
state	int(10)	_	_	0	_
city	varchar(40)	_	_	NULL	_
postal_code	varchar(40)	_	_	NULL	_
image	varchar(255)	_	_	NULL	_
description	text	_	_	NULL	_
featured	enum('Y','N')	_	_	N	_
hits	int(10)	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_

Table: community_category

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
category_name	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: community_event_report_spam

Description here

Field	Type	Null	Key	Default	Auto Increment
spam_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
community_id	int(10)	_	_	0	_
event_id	int(10)	_	_	0	_
inserted	date	_	_	0000-00-00	_

Table: community_events

Description here

Field	Type	Null	Key	Default	Auto Increment
event_id	int(11)	_	PRI	NULL	Y
community_id	int(11)	_	_	0	_
user_id	int(10)	_	_	0	_
title	varchar(255)	_	_	NULL	_
date	varchar(100)	_	_	NULL	_
time	varchar(100)	_	_	NULL	_
time_value	enum('am','pm')	_	_	am	_
location	varchar(100)	_	_	NULL	_
city	varchar(40)	_	_	NULL	_
description	text	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_

Table: community_members

Description here

Field	Type	Null	Key	Default	Auto Increment
member_id	int(10)	_	PRI	NULL	Y
community_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
status	enum('active','pending')	_	_	pending	_
inserted	date	_	_	0000-00-00	_
updated	date	_	_	0000-00-00	_

Table: community_photo

Description here

Field	Type	Null	Key	Default	Auto Increment
photo_id	int(10)	_	PRI	NULL	Y
community_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
title	varchar(30)	_	_	NULL	_
photo	varchar(60)	_	_	NULL	_
status	enum('Y','N')	_	_	Y	_
hits	int(10)	_	_	0	_
inserted	date	_	_	0000-00-00	_

Table: community_photo_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
community_photo_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: community_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
community_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: compose_message_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
compose_message_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: configuration

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
configuration_group_id	int(11)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	Y	_	NULL	_
configuration_title	varchar(64)	_	_	NULL	_
configuration_name	varchar(64)	_	_	NULL	_
configuration_value	varchar(255)	_	_	NULL	_
configuration_description	varchar(255)	Y	_	NULL	_
priority	int(5)	_	_	0	_
use_function	varchar(255)	Y	_	NULL	_
set_function	varchar(255)	Y	_	NULL	_

Table: configuration_group

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
configuration_group_title	varchar(64)	_	_	NULL	_
configuration_group_description	varchar(255)	_	_	NULL	_
priority	int(5)	_	_	0	_
visible	enum('Yes','No')	_	_	Yes	_

Table: contact_info

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(10)	_	PRI	0	_
secondary_email_1	varchar(30)	_	_	NULL	_
secondary_email_2	varchar(30)	_	_	NULL	_
country	int(10)	_	_	0	_
state	int(10)	_	_	0	_
state1	varchar(64)	_	_	NULL	_
city	varchar(50)	_	_	NULL	_
postal_code	varchar(50)	_	_	NULL	_
home_phone	varchar(30)	_	_	NULL	_
cell_phone	varchar(30)	_	_	NULL	_
address1	varchar(30)	_	_	NULL	_
address2	varchar(30)	_	_	NULL	_
updated	date	_	_	0000-00-00	_

Table: countries

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
continent_id	int(11)	_	_	0	_
country_name	varchar(64)	_	MUL	NULL	_
priority	int(5)	_	_	0	_

Table: currencies

Description here

Field	Type	Null	Key	Default	Auto Increment
currencies_id	int(11)	_	PRI	NULL	Y
title	varchar(32)	_	_	NULL	_
code	char(3)	_	_	NULL	_
symbol_left	varchar(12)	Y	_	NULL	_
symbol_right	varchar(12)	Y	_	NULL	_
decimal_point	char(1)	Y	_	NULL	_
thousands_point	char(1)	Y	_	NULL	_
decimal_places	char(1)	Y	_	NULL	_
value	float(13,8)	Y	_	NULL	_
last_updated	datetime	Y	_	NULL	_

Table: dating_with

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
dating_with	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: degree

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
degree	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: directory_category

Description here

Field	Type	Null	Key	Default	Auto Increment
category_id	int(10)	_	PRI	NULL	Y
sub_cat_id	smallint(5)	_	_	0	_
category_name	varchar(50)	_	_	NULL	_
hits	int(10)	_	_	0	_
inserted	date	_	_	0000-00-00	_

Table: directory_url

Description here

Field	Type	Null	Key	Default	Auto Increment
url_id	int(11)	_	PRI	NULL	Y
user_id	int(11)	_	_	0	_
url_type	enum('general','international')	_	_	general	_
url	varchar(50)	_	_	NULL	_
url_title	varchar(100)	_	_	NULL	_
url_description	text	_	_	NULL	_
category_id	int(10)	_	_	0	_
sub_category_id	int(10)	_	_	0	_
sub_sub_category_id	int(10)	_	_	0	_
tags	varchar(100)	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
page_rank	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: drinking

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
drinking	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: education

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
education	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: education_info

Description here

Field	Type	Null	Key	Default	Auto Increment
education_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
institute	varchar(50)	_	_	0	_
degree	int(10)	_	_	0	_
specialization	varchar(50)	_	_	NULL	_
city	varchar(50)	_	_	NULL	_
state	varchar(50)	_	_	NULL	_
state_id	int(10)	_	_	0	_
country	int(10)	_	_	0	_
year	int(10)	_	_	0	_
description	text	_	_	NULL	_
updated	date	_	_	0000-00-00	_

Table: ethnicity

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
ethnicity	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: event_categories

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(5) unsigned	_	PRI	NULL	Y
category_name	varchar(255)	Y	MUL	NULL	_
priority	smallint(5)	_	_	0	_

Table: event_members

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
event_id	int(10)	_	_	NULL	_
user_id	int(10)	_	_	NULL	_
inserted	datetime	_	_	NULL	_

Table: events

new content

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
category_id	int(11)	_	_	0	_
email_id	varchar(150)	_	_	NULL	_
title	varchar(255)	_	MUL	NULL	_
website	varchar(100)	_	_	NULL	_
author	varchar(255)	_	_	NULL	_
upload_files	varchar(100)	_	_	NULL	_
description	blob	_	_	NULL	_
start_date	date	_	_	NULL	_
end_date	date	_	_	NULL	_
location	varchar(50)	_	_	NULL	_
street	varchar(50)	_	_	NULL	_
city	varchar(50)	_	_	NULL	_
country	int(10)	_	_	NULL	_
event_contact	varchar(50)	_	_	NULL	_
phone	varchar(50)	_	_	NULL	_
admin	enum('N','Y')	_	_	N	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_
is_show	enum('Yes','No')	_	_	Yes	_
hits	int(11)	_	_	0	_
user_id	int(10)	_	_	0	_
featured	enum('N','Y')	_	_	N	_

Table: eye_color

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
eye_color	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: fashion

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
fashion	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: feedback

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
full_name	varchar(128)	_	_	NULL	_
email_address	varchar(255)	_	_	NULL	_
subject	text	_	_	NULL	_
message	text	_	_	NULL	_
inserted_date	datetime	_	_	0000-00-00 00:00:00	_
feedback_status	enum('Yes','No')	_	_	No	_

Table: forum_message

Description here

Field	Type	Null	Key	Default	Auto Increment
message_id	int(10)	_	PRI	NULL	Y
forum_id	int(10)	_	_	0	_
community_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
author	varchar(30)	_	_	NULL	_
subject	varchar(50)	_	_	NULL	_
message	text	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: forum_report_spam

Description here

Field	Type	Null	Key	Default	Auto Increment
spam_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
community_id	int(10)	_	_	0	_
forum_id	int(10)	_	_	0	_
inserted	date	_	_	0000-00-00	_

Table: forum_topic

Description here

Field	Type	Null	Key	Default	Auto Increment
forum_id	int(10)	_	PRI	NULL	Y
community_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
author	varchar(30)	_	_	NULL	_
subject	varchar(50)	_	_	NULL	_
message	text	_	_	NULL	_
featured	enum('N','Y')	_	_	N	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: friends

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(10)	_	_	0	_
friend_id	int(10)	_	_	0	_
status	enum('active','pending')	_	_	pending	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_

Table: general_info

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(10)	_	PRI	NULL	Y
first_name	varchar(50)	_	_	NULL	_
last_name	varchar(50)	_	_	NULL	_
gender	enum('male','female')	_	_	male	_
birthday	date	_	_	0000-00-00	_
set_status	text	_	_	NULL	_
language_speak	varchar(40)	_	_	0	_
interested_in	varchar(30)	_	_	NULL	_
city	varchar(50)	_	_	NULL	_
state	int(10)	_	_	0	_
state1	varchar(64)	_	_	NULL	_
country	int(10)	_	_	0	_
user_image	varchar(255)	_	_	NULL	_
user_newsletter	enum('Yes','No')	_	_	Yes	_
privacy_member	enum('private','public')	_	_	public	_
privacy_profile	int(10)	_	_	2	_
privacy_photo	int(10)	_	_	2	_
privacy_video	int(10)	_	_	2	_
privacy_blog	int(10)	_	_	2	_
privacy_link	smallint(2)	_	_	2	_
privacy_internal_message	int(10)	_	_	2	_
privacy_create_group	enum('Y','N')	_	_	Y	_
privacy_create_forum	enum('Y','N')	_	_	Y	_
privacy_create_message	enum('Y','N')	_	_	Y	_
privacy_create_poll	enum('Y','N')	_	_	Y	_
privacy_create_event	enum('Y','N')	_	_	Y	_
privacy_create_community_photo	enum('Y','N')	_	_	Y	_
privacy_create_photo	enum('Y','N')	_	_	Y	_
privacy_create_video	enum('Y','N')	_	_	Y	_
privacy_create_blogs	enum('Y','N')	_	_	Y	_
privacy_create_links	enum('Y','N')	_	_	Y	_
privacy_create_classified	enum('Y','N')	_	_	Y	_
privacy_create_question	enum('Y','N')	_	_	Y	_
privacy_create_answer	enum('Y','N')	_	_	Y	_
privacy_create_directory	enum('Y','N')	_	_	Y	_
uploaded_size	int(10)	_	_	NULL	_
updated	date	_	_	0000-00-00	_
hits	int(10)	_	_	0	_

Table: global_poll

Description here

Field	Type	Null	Key	Default	Auto Increment
poll_id	int(11)	_	PRI	NULL	Y
admin_id	int(10)	_	_	0	_
question	varchar(255)	_	_	NULL	_
option1	varchar(100)	_	_	NULL	_
option2	varchar(100)	_	_	NULL	_
option3	varchar(100)	_	_	NULL	_
option4	varchar(100)	_	_	NULL	_
selected_option	enum('one','multiple')	_	_	one	_
featured	enum('Y','N')	_	_	N	_
end_date_format	enum('unlimited','fixed')	_	_	unlimited	_
end_date	varchar(20)	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: global_poll_vote

Description here

Field	Type	Null	Key	Default	Auto Increment
vote_id	int(10)	_	PRI	NULL	Y
poll_id	mediumint(10)	_	_	0	_
user_id	int(10)	_	_	0	_
answer	varchar(20)	_	_	NULL	_
inserted	date	_	_	0000-00-00	_

Table: guestbook

Description here

Field	Type	Null	Key	Default	Auto Increment
guestbook_id	int(10)	_	PRI	NULL	Y
sender_user_id	int(10)	_	_	0	_
reciver_user_id	int(10)	_	_	0	_
message	text	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: guestbook_message_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
guestbook_comment_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
guestbook_id	int(10)	_	_	0	_
comment	text	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
inserted	date	_	_	0000-00-00	_

Table: hair_color

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
hair_color	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: humor

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
humor	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: im_user

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
im_user	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: industry

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(5)	_	PRI	NULL	Y
sub_ind_id	int(11)	Y	_	NULL	_
industry_name	varchar(120)	_	_	NULL	_
priority	smallint(5)	_	_	0	_

Table: interested_in

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(5)	_	PRI	NULL	Y
type_name	varchar(255)	_	MUL	NULL	_
priority	smallint(5)	_	_	0	_

Table: invite_friends_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
invite_friends_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: ipaddress_block

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
ip_address1	varchar(15)	_	_	NULL	_
ip_address2	varchar(15)	Y	_	NULL	_
priority	int(11)	_	_	0	_

Table: language_speak

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
language_speak	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: languages

Stores all supported languages. Code field is language code and directory is the name of the directory inside languages folder which has requisite translation files. Sort order determines the sorting order of languages.

Field	Type	Null	Key	Default	Auto Increment
languages_id	int(11)	_	PRI	NULL	Y
name	varchar(32)	_	MUL	NULL	_
code	char(2)	_	_	NULL	_
image	varchar(64)	Y	_	NULL	_
directory	varchar(32)	Y	_	NULL	_
sort_order	int(3)	Y	_	NULL	_

Table: link_category

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(5)	_	PRI	NULL	Y
sub_cat_id	int(11)	Y	_	NULL	_
category_name	varchar(255)	_	PRI	NULL	_
zh_category_name	varchar(255)	_	_	NULL	_
status	enum('Y','N')	_	_	NULL	_
show_in_header	enum('Y','N')	_	_	N	_
priority	smallint(5)	_	_	0	_

Table: link_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
comment_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
link_id	int(10)	_	_	0	_
comment	text	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
inserted	date	_	_	0000-00-00	_

Table: link_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
link_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
zh_description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: links

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
category_id	int(11)	_	_	0	_
sub_category_id	int(10)	_	_	NULL	_
title	varchar(255)	_	MUL	NULL	_
url	varchar(100)	_	_	NULL	_
author	varchar(255)	_	_	NULL	_
description	blob	_	_	NULL	_
upload_files	varchar(255)	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_
status	enum('Y','N')	_	_	Y	_
hits	int(11)	_	_	0	_
points	int(11)	_	_	NULL	_
user_id	int(10)	_	_	0	_
featured	enum('N','Y')	_	_	NULL	_

Table: links_point

Description here

Field	Type	Null	Key	Default	Auto Increment
point_id	int(11)	_	PRI	NULL	Y
link_id	int(11)	_	_	0	_
user_id	int(10)	_	_	0	_
ipaddress	varchar(200)	_	_	NULL	_
point	enum('up','down')	_	_	NULL	_
inserted	date	_	_	0000-00-00	_

Table: living

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
living	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: looks

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
looks	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: member_request_in_community_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
member_request_in_community_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: module

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
module_name	varchar(30)	_	_	NULL	_

Table: newsletters

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
title	varchar(255)	_	_	NULL	_
content	text	_	_	NULL	_
attachment_file	varchar(255)	Y	_	NULL	_
module	varchar(255)	_	_	NULL	_
date_added	datetime	_	_	0000-00-00 00:00:00	_
date_sent	datetime	Y	_	NULL	_
status	int(1)	Y	_	NULL	_
locked	int(1)	Y	_	0	_

Table: newsletters_history

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
title	varchar(255)	_	_	NULL	_
content	text	_	_	NULL	_
attachment_file	varchar(255)	Y	_	NULL	_
send_to	varchar(10)	_	_	NULL	_
date_send	datetime	Y	_	NULL	_

Table: personal_info

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(10)	_	PRI	0	_
headline	varchar(255)	_	_	NULL	_
notice_about_me	varchar(255)	_	_	NULL	_
height	int(4)	_	_	0	_
eye_color	int(10)	_	_	0	_
hair_color	int(10)	_	_	0	_
build	int(10)	_	_	0	_
body_art	varchar(30)	_	_	NULL	_
looks	int(10)	_	_	0	_
best_feature	int(10)	_	_	0	_
turns_on	varchar(30)	_	_	NULL	_
turns_off	varchar(40)	_	_	NULL	_
my_idea	text	_	_	NULL	_
interest	text	_	_	NULL	_
ideal_match	text	_	_	NULL	_
updated	date	_	_	0000-00-00	_

Table: pets

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
pets	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: photo_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
photo_comment_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
photo_id	int(10)	_	_	0	_
album_id	int(11)	_	_	NULL	_
community_id	int(11)	_	_	NULL	_
comment	text	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
inserted	date	_	_	0000-00-00	_

Table: plan_type

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
plan_type_name	varchar(64)	_	MUL	NULL	_
priority	int(5)	_	_	0	_
time_period	smallint(3)	_	_	0	_
time_period1	varchar(5)	_	_	NULL	_
fee	float(10,2)	_	_	0.00	_
currency	varchar(4)	_	_	GBP	_
job	int(5)	_	_	0	_
cv	int(5)	_	_	0	_
sms	int(5)	_	_	0	_

Table: point_allocation

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
module_id	smallint(3)	_	_	0	_
points	smallint(3)	_	_	1	_

Table: political_view

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
political_view	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: poll

Description here

Field	Type	Null	Key	Default	Auto Increment
poll_id	int(11)	_	PRI	NULL	Y
community_id	int(11)	_	_	0	_
user_id	int(10)	_	_	0	_
question	varchar(255)	_	_	NULL	_
option1	varchar(100)	_	_	NULL	_
option2	varchar(100)	_	_	NULL	_
option3	varchar(100)	_	_	NULL	_
option4	varchar(100)	_	_	NULL	_
selected_option	enum('one','multiple')	_	_	one	_
allowed_vote	enum('member','all')	_	_	member	_
end_date_format	enum('unlimited','fixed')	_	_	unlimited	_
end_date	varchar(20)	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: poll_vote

Description here

Field	Type	Null	Key	Default	Auto Increment
vote_id	int(10)	_	PRI	NULL	Y
poll_id	mediumint(10)	_	_	0	_
community_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
answer	varchar(20)	_	_	NULL	_
inserted	date	_	_	0000-00-00	_

Table: privacy_status

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
privacy_status	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: profile_view

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(10)	_	_	0	_
view_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	0000-00-00 00:00:00	_

Table: q_a_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
answer_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
question_id	int(10)	_	_	0	_
comment	text	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: question

Description here

Field	Type	Null	Key	Default	Auto Increment
qid	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
question	text	_	_	NULL	_
category_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	date	_	_	0000-00-00	_
hits	int(12)	_	_	0	_
status	enum('active','inactive')	_	_	active	_

Table: question_category

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(5) unsigned	_	PRI	NULL	Y
sub_cat_id	varchar(32)	_	_	NULL	_
category_name	varchar(255)	Y	MUL	NULL	_
priority	int(5)	_	_	0	_

Table: question_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
question_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: regions

Description here

Field	Type	Null	Key	Default	Auto Increment
region_id	int(11)	_	PRI	NULL	Y
zone_region_id	int(11)	_	_	102	_
region_name	varchar(32)	_	_	NULL	_
region_code	varchar(5)	_	_	NULL	_
priority	smallint(5)	_	_	0	_

Table: relationship_status

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
relationship_status	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: religion

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
religion	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: reply_to_classified_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
reply_to_classified_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: report_abuse_article

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_id	int(5)	_	_	0	_
article_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_abuse_blog

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_id	int(5)	_	_	0	_
blog_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_abuse_classified

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_id	int(5)	_	_	0	_
classified_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_abuse_community

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_id	int(5)	_	_	0	_
community_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_abuse_link

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_id	int(5)	_	_	0	_
link_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_abuse_photo

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_id	int(5)	_	_	0	_
photo_id	int(10)	_	_	0	_
album_id	int(11)	_	_	NULL	_
community_id	int(11)	_	_	NULL	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_abuse_q_and_a

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_type	int(5)	_	_	0	_
question_id	int(10)	_	_	0	_
answer_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_abuse_video

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
report_id	int(5)	_	_	0	_
video_id	int(10)	_	_	0	_
user_id	int(10)	_	_	0	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: report_category

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(6)	_	PRI	NULL	Y
sub_cat_id	int(5)	_	_	0	_
category_name	varchar(10)	_	_	NULL	_
priority	int(6)	_	_	0	_

Table: salutation

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(5)	_	PRI	NULL	Y
salutation_name	varchar(255)	_	_	NULL	_
priority	smallint(5)	_	_	0	_

Table: set_status_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
comment_id	int(10)	_	PRI	NULL	Y
user_id	int(11)	_	_	NULL	_
from_user_id	int(10)	_	_	0	_
comment	text	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
inserted	date	_	_	0000-00-00	_

Table: sexual_orientation

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
sexual_orientation	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: smoking

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
smoking	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: social_info

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(10)	_	PRI	0	_
relationship_status	int(10)	_	_	0	_
children	int(10)	_	_	0	_
ethnicity	int(10)	_	_	0	_
religion	int(10)	_	_	0	_
political_view	int(10)	_	_	0	_
humor	varchar(30)	_	_	NULL	_
sexual_orientation	int(10)	_	_	0	_
fashion	varchar(100)	_	_	NULL	_
smoking	int(10)	_	_	0	_
drinking	int(10)	_	_	0	_
pets	int(10)	_	_	0	_
living	varchar(30)	_	_	NULL	_
home_town	varchar(30)	_	_	NULL	_
web_page	varchar(30)	_	_	NULL	_
about_me	text	_	_	NULL	_
passions	text	_	_	NULL	_
sports	text	_	_	NULL	_
activities	text	_	_	NULL	_
books	text	_	_	NULL	_
music	text	_	_	NULL	_
tv_show	text	_	_	NULL	_
movies	text	_	_	NULL	_
cuisines	text	_	_	NULL	_
updated	date	_	_	0000-00-00	_

Table: subscribe_blog_update

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	MUL	NULL	Y
user_id	int(10)	_	_	0	_
subscribed_id	int(10)	_	_	0	_
blog_id	int(10)	_	_	0	_
inserted	date	_	_	0000-00-00	_
updated	date	_	_	0000-00-00	_

Table: title_keywordmetatype

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
file_name	varchar(255)	_	_	NULL	_
title	varchar(255)	_	_	NULL	_
meta_keyword	text	_	_	NULL	_

Table: turn_ons

Description here

Field	Type	Null	Key	Default	Auto Increment
id	smallint(2)	_	PRI	NULL	Y
turn_ons	varchar(255)	_	_	NULL	_
priority	smallint(2)	_	_	0	_

Table: user_chat

Description here

Field	Type	Null	Key	Default	Auto Increment
chat_id	int(11)	_	PRI	NULL	Y
sender_id	int(11)	_	_	NULL	_
receiver_id	int(11)	_	_	NULL	_
messages	text	_	_	NULL	_
interested	enum('Y','N')	_	_	Y	_
inserted	datetime	_	MUL	NULL	_

Table: user_contact

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
user_id	int(11)	_	_	0	_
user_first_name	varchar(32)	_	_	NULL	_
user_middle_name	varchar(32)	_	_	NULL	_
user_last_name	varchar(32)	_	_	NULL	_
user_email_address	varchar(64)	_	_	NULL	_
user_address1	varchar(128)	_	_	NULL	_
user_address2	varchar(128)	_	_	NULL	_
user_country_id	int(3)	_	_	0	_
user_state	varchar(32)	_	_	NULL	_
user_state_id	int(11)	_	_	0	_
user_city	varchar(64)	_	_	NULL	_
user_zip	varchar(10)	_	_	NULL	_
user_phone	varchar(24)	_	_	NULL	_
user_mobile	varchar(24)	_	_	NULL	_

Table: user_login

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(11)	_	PRI	NULL	Y
user_email_address	varchar(64)	_	_	NULL	_
user_password	varchar(48)	_	_	NULL	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	Y	_	NULL	_
ip_address	varchar(15)	Y	_	NULL	_
last_ip_address	varchar(15)	Y	_	NULL	_
last_login_time	datetime	Y	_	NULL	_
number_of_logon	int(11)	_	_	0	_
user_status	enum('Y','N')	_	_	Y	_
user_featured	enum('Y','N')	_	_	N	_
terms	enum('Yes','No')	_	_	Yes	_

Table: user_mails

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(15)	_	PRI	NULL	Y
sender_id	int(15)	_	MUL	0	_
receiver_id	int(11)	_	MUL	0	_
subject	varchar(255)	_	_	NULL	_
message	blob	_	_	NULL	_
attachment_file	varchar(255)	_	_	NULL	_
sender_mark	enum('No','Yes')	_	_	No	_
receiver_mark	enum('No','Yes')	_	_	No	_
receiver_see	enum('No','Yes')	_	MUL	No	_
sender_see	enum('Yes','No')	_	MUL	No	_
receiver_mail_status	enum('active','inactive','deleted')	_	_	active	_
sender_mail_status	enum('active','inactive','deleted')	_	_	active	_
receiver_deleted	date	Y	_	NULL	_
sender_deleted	date	Y	_	NULL	_
receiver_reply	enum('No','Yes')	_	_	No	_
sender_reply	enum('No','Yes')	_	_	No	_
inserted	datetime	_	_	0000-00-00 00:00:00	_

Table: user_point

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
no_of_group	int(10) unsigned	_	_	0	_
no_of_forum	int(10) unsigned	_	_	0	_
no_of_message	int(10) unsigned	_	_	0	_
no_of_poll	int(10) unsigned	_	_	0	_
no_of_event	int(10) unsigned	_	_	0	_
no_of_group_photo	int(10) unsigned	_	_	0	_
no_of_photo	int(10) unsigned	_	_	0	_
no_of_video	int(10) unsigned	_	_	0	_
no_of_blog	int(10) unsigned	_	_	0	_
no_of_link	int(10) unsigned	_	_	0	_
no_of_question	int(10) unsigned	_	_	0	_
no_of_answer	int(10) unsigned	_	_	0	_
no_of_classified	int(10) unsigned	_	_	0	_
no_of_directory	int(10) unsigned	_	_	0	_

Table: user_registration_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
user_registration_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: video

Description here

Field	Type	Null	Key	Default	Auto Increment
video_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
title	varchar(30)	_	_	NULL	_
video	varchar(60)	_	_	NULL	_
hits	int(10)	_	_	0	_
featured	enum('N','Y')	_	_	NULL	_
status	enum('Y','N')	_	_	Y	_
inserted	datetime	_	_	0000-00-00 00:00:00	_
updated	datetime	_	_	NULL	_

Table: video_comment

Description here

Field	Type	Null	Key	Default	Auto Increment
video_comment_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
video_id	int(10)	_	_	0	_
comment	text	_	_	NULL	_
status	enum('Y','N')	_	_	N	_
featured	enum('Y','N')	_	_	N	_
inserted	date	_	_	0000-00-00	_

Table: video_report_it_email_template

Description here

Field	Type	Null	Key	Default	Auto Increment
id	tinyint(3)	_	PRI	NULL	Y
video_report_it_email_template_name	varchar(32)	_	_	NULL	_
description	blob	_	_	NULL	_
priority	tinyint(3)	_	_	0	_
alert_default	enum('No','Yes')	_	_	No	_

Table: whos_online

Description here

Field	Type	Null	Key	Default	Auto Increment
user_id	int(11)	Y	_	NULL	_
user	varchar(13)	_	_	NULL	_
session_id	varchar(32)	_	_	NULL	_
ip_address	varchar(15)	_	_	NULL	_
time_entry	varchar(14)	_	_	NULL	_
time_last_click	varchar(14)	_	_	NULL	_

Table: word_censor

Description here

Field	Type	Null	Key	Default	Auto Increment
id	int(11)	_	PRI	NULL	Y
word	varchar(255)	_	_	NULL	_
replaced_word	varchar(255)	_	_	NULL	_
case_sensitive	enum('N','Y')	_	_	N	_
partial	enum('N','Y')	_	_	N	_

Table: work_info

Description here

Field	Type	Null	Key	Default	Auto Increment
work_id	int(10)	_	PRI	NULL	Y
user_id	int(10)	_	_	0	_
company	varchar(50)	_	_	NULL	_
city	varchar(40)	_	_	NULL	_
state	varchar(50)	_	_	NULL	_
state_id	int(10)	_	_	0	_
country	int(10)	_	_	0	_
job_title	varchar(50)	_	_	NULL	_
salary	varchar(15)	_	_	NULL	_
salary_per	varchar(20)	_	_	NULL	_
start_month	int(2)	_	_	0	_
start_year	int(4)	_	_	0	_
end_month	int(2)	_	_	0	_
end_year	int(4)	_	_	0	_
still_work	enum('Yes','No')	_	_	Yes	_
description	text	_	_	NULL	_
company_webpage	varchar(40)	_	_	NULL	_
work_email	varchar(40)	_	_	NULL	_
work_phone	varchar(40)	_	_	NULL	_
updated	date	_	_	0000-00-00	_

Table: zones

Description here

Field	Type	Null	Key	Default	Auto Increment
zone_id	int(11)	_	PRI	NULL	Y
zone_country_id	int(11)	_	_	0	_
zone_code	varchar(32)	_	_	NULL	_
zone_name	varchar(32)	_	_	NULL	_