From Social Networking Software - Online Social Network Software
Jump to: navigation, search

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

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
idtinyint(3)_PRINULLY
accept_member_in_community_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_a_question_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_a_question_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_album_photo_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_album_photo_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_answer_to_question_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_answer_to_question_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_article_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_article_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_blog_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_blog_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_blogs_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_blog_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_blogs_to_readers_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_blog_to_readers_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_classfied_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_classified_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_community_photo_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_community_photo_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_community_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_community_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_directory_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_directory_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_forum_community_owner_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_forum_community_owner_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_forum_owner_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_forum_owner_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_friend_request_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_friend_request_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_guestbook_message_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_guestbook_message_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_guestbook_message_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_guestbook_message_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_link_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_link_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
zh_descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_links_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_link_template_namevarchar(32)__NULL_
descriptionblob__NULL_
zh_descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_set_status_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_set_status_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: add_video_comment_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
add_video_comment_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: admin_files

Description here

Field Type Null Key Default Auto Increment
admin_files_idint(11)_PRINULLY
admin_files_namevarchar(64)__NULL_
admin_files_is_boxestinyint(5)__0_
admin_files_to_boxesint(11)__0_
admin_groups_idset('1','2')__1_

Table: admin_groups

Description here

Field Type Null Key Default Auto Increment
admin_groups_idint(11)_PRINULLY
admin_groups_namevarchar(64)__NULL_

Table: admin_user_point_mail

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
user_idint(10)__0_
pointint(10)__0_
datedate__0000-00-00_
inserteddatetime__0000-00-00 00:00:00_

Table: administrator

Description here

Field Type Null Key Default Auto Increment
admin_idint(11)_PRINULLY
admin_groups_idint(11)__0_
inserteddatetime__0000-00-00 00:00:00_
updateddatetimeY_NULL_
admin_firstnamevarchar(32)__NULL_
admin_lastnamevarchar(32)__NULL_
admin_namevarchar(32)_UNINULL_
admin_passwordvarchar(50)__NULL_
admin_email_addressvarchar(128)_UNINULL_
last_ip_addressvarchar(255)Y_NULL_
ip_addressvarchar(255)Y_NULL_
last_login_timedatetimeY_NULL_
is_adminenum('No','Yes')__No_
number_of_logonint(11)__0_

Table: album

Description here

Field Type Null Key Default Auto Increment
album_idint(10)_PRINULLY
user_idint(10)__0_
title_namevarchar(30)__NULL_
descriptiontext__NULL_
inserteddate__0000-00-00_

Table: album_photo

Description here

Field Type Null Key Default Auto Increment
photo_idint(10)_PRINULLY
album_idint(10)__0_
user_idint(10)__0_
titlevarchar(30)__NULL_
photovarchar(60)__NULL_
hitsint(10)__0_
photo_sizeint(10)__NULL_
statusenum('Y','N')__Y_
featuredenum('Y','N')__N_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__NULL_

Table: album_photo_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
album_photo_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: answer

Description here

Field Type Null Key Default Auto Increment
a_idint(10)_PRINULLY
qidint(10)__0_
user_idint(10)__0_
answertext__NULL_
category_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_
updateddate__0000-00-00_
featuredenum('yes','no')__no_
statusenum('active','inactive')__active_

Table: answer_rating

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
answer_idint(11)__0_
question_idint(10)Y_NULL_
user_idint(10)__0_
ipaddressvarchar(200)__NULL_
ratingint(11)__0_
inserteddate__0000-00-00_

Table: answer_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
answer_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: article

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
category_idint(11)__0_
titlevarchar(255)__NULL_
authorvarchar(255)__NULL_
show_datedate__0000-00-00_
descriptionblob__NULL_
short_descriptiontext__NULL_
article_photovarchar(255)__NULL_
hitsint(8)__0_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_
is_showenum('Yes','No')__Yes_
featuredenum('Y','N')__N_

Table: article_categories

Description here

Field Type Null Key Default Auto Increment
idint(5) unsigned_PRINULLY
sub_cat_idvarchar(32)__NULL_
category_namevarchar(255)YMULNULL_

Table: article_comment

Description here

Field Type Null Key Default Auto Increment
recommend_idint(10)_PRINULLY
user_idint(10)__0_
article_idint(10)__0_
commenttext__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
inserteddate__0000-00-00_

Table: article_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
article_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: audio

Description here

Field Type Null Key Default Auto Increment
audio_idint(9)_PRINULLY
user_idint(9)_MULNULL_
titlevarchar(64)__NULL_
audiovarchar(128)__NULL_
updateddatetime__NULL_
inserteddatetime__NULL_

Table: banner

Description here

Field Type Null Key Default Auto Increment
idint(5)_PRINULLY
banner_typeenum('image','script')__NULL_
titlevarchar(150)__NULL_
hrefvarchar(255)__NULL_
srcvarchar(255)__NULL_
altvarchar(255)Y_NULL_
scripttext__NULL_
adviewsint(10)Y_0_
adclicksint(10)Y_0_
activeenum('T','F')__T_
locationint(5)__1_
banner_datedate__0000-00-00_
b_orderint(10)__1_
company_namevarchar(50)Y_NULL_
company_contactvarchar(50)Y_NULL_
company_emailvarchar(50)Y_NULL_
company_commentsvarchar(100)Y_NULL_
banner_duration_fromdateY_NULL_
banner_duration_todateY_NULL_
banner_costingvarchar(40)Y_NULL_
duration_unlimitedenum('T','F')__T_
deletedenum('T','F')__F_

Table: banner_location

Description here

Field Type Null Key Default Auto Increment
banner_location_idint(5)_PRINULLY
banner_location_namevarchar(100)__NULL_

Table: best_feature

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
best_featurevarchar(255)__NULL_
prioritysmallint(2)__0_

Table: block_user

Description here

Field Type Null Key Default Auto Increment
block_idint(10)_PRINULLY
user_idint(10)__0_
block_user_idint(10)__0_
inserteddate__0000-00-00_

Table: blog_comment

Description here

Field Type Null Key Default Auto Increment
recommend_idint(10)_PRINULLY
user_idint(10)__0_
article_idint(10)__0_
ratingvarchar(20)__NULL_
commenttext__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
inserteddate__0000-00-00_

Table: blog_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
blog_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: blogs

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
category_idint(11)__0_
email_idvarchar(150)__NULL_
titlevarchar(255)_MULNULL_
authorvarchar(255)__NULL_
upload_filesvarchar(100)__NULL_
short_descriptiontext__NULL_
descriptionblob__NULL_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_
is_showenum('Yes','No')__Yes_
hitsint(11)__0_
user_idint(10)__0_
featuredenum('N','Y')__NULL_

Table: blogs_categories

Description here

Field Type Null Key Default Auto Increment
idint(5) unsigned_PRINULLY
category_namevarchar(255)YMULNULL_
prioritysmallint(5)__0_

Table: blogs_rating

Description here

Field Type Null Key Default Auto Increment
article_idint(11)__0_
user_idint(10)__0_
ipaddressvarchar(200)__NULL_
ratingint(11)__0_
inserteddate__0000-00-00_

Table: blogs_subscribe

Description here

Field Type Null Key Default Auto Increment
idint(10)_MULNULLY
user_idint(10)__0_
subscribe_idint(10)__0_
inserteddate__0000-00-00_
updateddate__0000-00-00_

Table: body_art

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
body_artvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: build

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
buildvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: children

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
childrenvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: classified

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
user_idint(10)__0_
photovarchar(60)__NULL_
videovarchar(255)__NULL_
category_idint(10)__0_
sub_category_idint(10)__NULL_
countrysmallint(4)__0_
state_idint(10)__NULL_
statevarchar(50)__NULL_
city_idint(10)__NULL_
cityvarchar(30)__0_
titlevarchar(100)__NULL_
currency_pricevarchar(10)__NULL_
pricevarchar(20)__NULL_
descriptiontext__NULL_
statusenum('active','inactive')__active_
end_datedatetime__NULL_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_

Table: classified_category

Description here

Field Type Null Key Default Auto Increment
idsmallint(5)_PRINULLY
sub_cat_idint(11)Y_NULL_
category_namevarchar(255)_PRINULL_
prioritysmallint(5)__0_

Table: classified_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
classified_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_


Table: community

Description here

Field Type Null Key Default Auto Increment
community_idint(10)_PRINULLY
user_idint(10)__0_
community_namevarchar(100)__NULL_
categoryint(10)__0_
typevarchar(30)__NULL_
languageint(10)__0_
countryint(10)__0_
stateint(10)__0_
cityvarchar(40)__NULL_
postal_codevarchar(40)__NULL_
imagevarchar(255)__NULL_
descriptiontext__NULL_
featuredenum('Y','N')__N_
hitsint(10)__NULL_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_

Table: community_category

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
category_namevarchar(255)__NULL_
prioritysmallint(2)__0_

Table: community_event_report_spam

Description here

Field Type Null Key Default Auto Increment
spam_idint(10)_PRINULLY
user_idint(10)__0_
community_idint(10)__0_
event_idint(10)__0_
inserteddate__0000-00-00_

Table: community_events

Description here

Field Type Null Key Default Auto Increment
event_idint(11)_PRINULLY
community_idint(11)__0_
user_idint(10)__0_
titlevarchar(255)__NULL_
datevarchar(100)__NULL_
timevarchar(100)__NULL_
time_valueenum('am','pm')__am_
locationvarchar(100)__NULL_
cityvarchar(40)__NULL_
descriptiontext__NULL_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_

Table: community_members

Description here

Field Type Null Key Default Auto Increment
member_idint(10)_PRINULLY
community_idint(10)__0_
user_idint(10)__0_
statusenum('active','pending')__pending_
inserteddate__0000-00-00_
updateddate__0000-00-00_

Table: community_photo

Description here

Field Type Null Key Default Auto Increment
photo_idint(10)_PRINULLY
community_idint(10)__0_
user_idint(10)__0_
titlevarchar(30)__NULL_
photovarchar(60)__NULL_
statusenum('Y','N')__Y_
hitsint(10)__0_
inserteddate__0000-00-00_

Table: community_photo_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
community_photo_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: community_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
community_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: compose_message_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
compose_message_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: configuration

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
configuration_group_idint(11)__0_
inserteddatetime__0000-00-00 00:00:00_
updateddatetimeY_NULL_
configuration_titlevarchar(64)__NULL_
configuration_namevarchar(64)__NULL_
configuration_valuevarchar(255)__NULL_
configuration_descriptionvarchar(255)Y_NULL_
priorityint(5)__0_
use_functionvarchar(255)Y_NULL_
set_functionvarchar(255)Y_NULL_

Table: configuration_group

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
configuration_group_titlevarchar(64)__NULL_
configuration_group_descriptionvarchar(255)__NULL_
priorityint(5)__0_
visibleenum('Yes','No')__Yes_

Table: contact_info

Description here

Field Type Null Key Default Auto Increment
user_idint(10)_PRI0_
secondary_email_1varchar(30)__NULL_
secondary_email_2varchar(30)__NULL_
countryint(10)__0_
stateint(10)__0_
state1varchar(64)__NULL_
cityvarchar(50)__NULL_
postal_codevarchar(50)__NULL_
home_phonevarchar(30)__NULL_
cell_phonevarchar(30)__NULL_
address1varchar(30)__NULL_
address2varchar(30)__NULL_
updateddate__0000-00-00_

Table: countries

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
continent_idint(11)__0_
country_namevarchar(64)_MULNULL_
priorityint(5)__0_

Table: currencies

Description here

Field Type Null Key Default Auto Increment
currencies_idint(11)_PRINULLY
titlevarchar(32)__NULL_
codechar(3)__NULL_
symbol_leftvarchar(12)Y_NULL_
symbol_rightvarchar(12)Y_NULL_
decimal_pointchar(1)Y_NULL_
thousands_pointchar(1)Y_NULL_
decimal_placeschar(1)Y_NULL_
valuefloat(13,8)Y_NULL_
last_updateddatetimeY_NULL_

Table: dating_with

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
dating_withvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: degree

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
degreevarchar(255)__NULL_
prioritysmallint(2)__0_

Table: directory_category

Description here

Field Type Null Key Default Auto Increment
category_idint(10)_PRINULLY
sub_cat_idsmallint(5)__0_
category_namevarchar(50)__NULL_
hitsint(10)__0_
inserteddate__0000-00-00_

Table: directory_url

Description here

Field Type Null Key Default Auto Increment
url_idint(11)_PRINULLY
user_idint(11)__0_
url_typeenum('general','international')__general_
urlvarchar(50)__NULL_
url_titlevarchar(100)__NULL_
url_descriptiontext__NULL_
category_idint(10)__0_
sub_category_idint(10)__0_
sub_sub_category_idint(10)__0_
tagsvarchar(100)__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
page_rankint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: drinking

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
drinkingvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: education

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
educationvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: education_info

Description here

Field Type Null Key Default Auto Increment
education_idint(10)_PRINULLY
user_idint(10)__0_
institutevarchar(50)__0_
degreeint(10)__0_
specializationvarchar(50)__NULL_
cityvarchar(50)__NULL_
statevarchar(50)__NULL_
state_idint(10)__0_
countryint(10)__0_
yearint(10)__0_
descriptiontext__NULL_
updateddate__0000-00-00_

Table: ethnicity

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
ethnicityvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: event_categories

Description here

Field Type Null Key Default Auto Increment
idint(5) unsigned_PRINULLY
category_namevarchar(255)YMULNULL_
prioritysmallint(5)__0_

Table: event_members

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
event_idint(10)__NULL_
user_idint(10)__NULL_
inserteddatetime__NULL_

Table: events

new content

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
category_idint(11)__0_
email_idvarchar(150)__NULL_
titlevarchar(255)_MULNULL_
websitevarchar(100)__NULL_
authorvarchar(255)__NULL_
upload_filesvarchar(100)__NULL_
descriptionblob__NULL_
start_datedate__NULL_
end_datedate__NULL_
locationvarchar(50)__NULL_
streetvarchar(50)__NULL_
cityvarchar(50)__NULL_
countryint(10)__NULL_
event_contactvarchar(50)__NULL_
phonevarchar(50)__NULL_
adminenum('N','Y')__N_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_
is_showenum('Yes','No')__Yes_
hitsint(11)__0_
user_idint(10)__0_
featuredenum('N','Y')__N_

Table: eye_color

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
eye_colorvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: fashion

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
fashionvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: feedback

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
full_namevarchar(128)__NULL_
email_addressvarchar(255)__NULL_
subjecttext__NULL_
messagetext__NULL_
inserted_datedatetime__0000-00-00 00:00:00_
feedback_statusenum('Yes','No')__No_

Table: forum_message

Description here

Field Type Null Key Default Auto Increment
message_idint(10)_PRINULLY
forum_idint(10)__0_
community_idint(10)__0_
user_idint(10)__0_
authorvarchar(30)__NULL_
subjectvarchar(50)__NULL_
messagetext__NULL_
inserteddatetime__0000-00-00 00:00:00_

Table: forum_report_spam

Description here

Field Type Null Key Default Auto Increment
spam_idint(10)_PRINULLY
user_idint(10)__0_
community_idint(10)__0_
forum_idint(10)__0_
inserteddate__0000-00-00_

Table: forum_topic

Description here

Field Type Null Key Default Auto Increment
forum_idint(10)_PRINULLY
community_idint(10)__0_
user_idint(10)__0_
authorvarchar(30)__NULL_
subjectvarchar(50)__NULL_
messagetext__NULL_
featuredenum('N','Y')__N_
inserteddatetime__0000-00-00 00:00:00_

Table: friends

Description here

Field Type Null Key Default Auto Increment
user_idint(10)__0_
friend_idint(10)__0_
statusenum('active','pending')__pending_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_

Table: general_info

Description here

Field Type Null Key Default Auto Increment
user_idint(10)_PRINULLY
first_namevarchar(50)__NULL_
last_namevarchar(50)__NULL_
genderenum('male','female')__male_
birthdaydate__0000-00-00_
set_statustext__NULL_
language_speakvarchar(40)__0_
interested_invarchar(30)__NULL_
cityvarchar(50)__NULL_
stateint(10)__0_
state1varchar(64)__NULL_
countryint(10)__0_
user_imagevarchar(255)__NULL_
user_newsletterenum('Yes','No')__Yes_
privacy_memberenum('private','public')__public_
privacy_profileint(10)__2_
privacy_photoint(10)__2_
privacy_videoint(10)__2_
privacy_blogint(10)__2_
privacy_linksmallint(2)__2_
privacy_internal_messageint(10)__2_
privacy_create_groupenum('Y','N')__Y_
privacy_create_forumenum('Y','N')__Y_
privacy_create_messageenum('Y','N')__Y_
privacy_create_pollenum('Y','N')__Y_
privacy_create_eventenum('Y','N')__Y_
privacy_create_community_photoenum('Y','N')__Y_
privacy_create_photoenum('Y','N')__Y_
privacy_create_videoenum('Y','N')__Y_
privacy_create_blogsenum('Y','N')__Y_
privacy_create_linksenum('Y','N')__Y_
privacy_create_classifiedenum('Y','N')__Y_
privacy_create_questionenum('Y','N')__Y_
privacy_create_answerenum('Y','N')__Y_
privacy_create_directoryenum('Y','N')__Y_
uploaded_sizeint(10)__NULL_
updateddate__0000-00-00_
hitsint(10)__0_

Table: global_poll

Description here

Field Type Null Key Default Auto Increment
poll_idint(11)_PRINULLY
admin_idint(10)__0_
questionvarchar(255)__NULL_
option1varchar(100)__NULL_
option2varchar(100)__NULL_
option3varchar(100)__NULL_
option4varchar(100)__NULL_
selected_optionenum('one','multiple')__one_
featuredenum('Y','N')__N_
end_date_formatenum('unlimited','fixed')__unlimited_
end_datevarchar(20)__NULL_
inserteddatetime__0000-00-00 00:00:00_

Table: global_poll_vote

Description here

Field Type Null Key Default Auto Increment
vote_idint(10)_PRINULLY
poll_idmediumint(10)__0_
user_idint(10)__0_
answervarchar(20)__NULL_
inserteddate__0000-00-00_

Table: guestbook

Description here

Field Type Null Key Default Auto Increment
guestbook_idint(10)_PRINULLY
sender_user_idint(10)__0_
reciver_user_idint(10)__0_
messagetext__NULL_
inserteddatetime__0000-00-00 00:00:00_

Table: guestbook_message_comment

Description here

Field Type Null Key Default Auto Increment
guestbook_comment_idint(10)_PRINULLY
user_idint(10)__0_
guestbook_idint(10)__0_
commenttext__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
inserteddate__0000-00-00_

Table: hair_color

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
hair_colorvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: humor

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
humorvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: im_user

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
im_uservarchar(255)__NULL_
prioritysmallint(2)__0_

Table: industry

Description here

Field Type Null Key Default Auto Increment
idint(5)_PRINULLY
sub_ind_idint(11)Y_NULL_
industry_namevarchar(120)__NULL_
prioritysmallint(5)__0_

Table: interested_in

Description here

Field Type Null Key Default Auto Increment
idint(5)_PRINULLY
type_namevarchar(255)_MULNULL_
prioritysmallint(5)__0_

Table: invite_friends_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
invite_friends_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: ipaddress_block

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
ip_address1varchar(15)__NULL_
ip_address2varchar(15)Y_NULL_
priorityint(11)__0_

Table: language_speak

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
language_speakvarchar(255)__NULL_
prioritysmallint(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_idint(11)_PRINULLY
namevarchar(32)_MULNULL_
codechar(2)__NULL_
imagevarchar(64)Y_NULL_
directoryvarchar(32)Y_NULL_
sort_orderint(3)Y_NULL_

Table: link_category

Description here

Field Type Null Key Default Auto Increment
idsmallint(5)_PRINULLY
sub_cat_idint(11)Y_NULL_
category_namevarchar(255)_PRINULL_
zh_category_namevarchar(255)__NULL_
statusenum('Y','N')__NULL_
show_in_headerenum('Y','N')__N_
prioritysmallint(5)__0_

Table: link_comment

Description here

Field Type Null Key Default Auto Increment
comment_idint(10)_PRINULLY
user_idint(10)__0_
link_idint(10)__0_
commenttext__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
inserteddate__0000-00-00_

Table: link_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
link_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
zh_descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: links

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
category_idint(11)__0_
sub_category_idint(10)__NULL_
titlevarchar(255)_MULNULL_
urlvarchar(100)__NULL_
authorvarchar(255)__NULL_
descriptionblob__NULL_
upload_filesvarchar(255)__NULL_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_
statusenum('Y','N')__Y_
hitsint(11)__0_
pointsint(11)__NULL_
user_idint(10)__0_
featuredenum('N','Y')__NULL_

Table: links_point

Description here

Field Type Null Key Default Auto Increment
point_idint(11)_PRINULLY
link_idint(11)__0_
user_idint(10)__0_
ipaddressvarchar(200)__NULL_
pointenum('up','down')__NULL_
inserteddate__0000-00-00_

Table: living

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
livingvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: looks

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
looksvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: member_request_in_community_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
member_request_in_community_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: module

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
module_namevarchar(30)__NULL_

Table: newsletters

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
titlevarchar(255)__NULL_
contenttext__NULL_
attachment_filevarchar(255)Y_NULL_
modulevarchar(255)__NULL_
date_addeddatetime__0000-00-00 00:00:00_
date_sentdatetimeY_NULL_
statusint(1)Y_NULL_
lockedint(1)Y_0_

Table: newsletters_history

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
titlevarchar(255)__NULL_
contenttext__NULL_
attachment_filevarchar(255)Y_NULL_
send_tovarchar(10)__NULL_
date_senddatetimeY_NULL_

Table: personal_info

Description here

Field Type Null Key Default Auto Increment
user_idint(10)_PRI0_
headlinevarchar(255)__NULL_
notice_about_mevarchar(255)__NULL_
heightint(4)__0_
eye_colorint(10)__0_
hair_colorint(10)__0_
buildint(10)__0_
body_artvarchar(30)__NULL_
looksint(10)__0_
best_featureint(10)__0_
turns_onvarchar(30)__NULL_
turns_offvarchar(40)__NULL_
my_ideatext__NULL_
interesttext__NULL_
ideal_matchtext__NULL_
updateddate__0000-00-00_

Table: pets

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
petsvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: photo_comment

Description here

Field Type Null Key Default Auto Increment
photo_comment_idint(10)_PRINULLY
user_idint(10)__0_
photo_idint(10)__0_
album_idint(11)__NULL_
community_idint(11)__NULL_
commenttext__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
inserteddate__0000-00-00_

Table: plan_type

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
plan_type_namevarchar(64)_MULNULL_
priorityint(5)__0_
time_periodsmallint(3)__0_
time_period1varchar(5)__NULL_
feefloat(10,2)__0.00_
currencyvarchar(4)__GBP_
jobint(5)__0_
cvint(5)__0_
smsint(5)__0_

Table: point_allocation

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
module_idsmallint(3)__0_
pointssmallint(3)__1_

Table: political_view

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
political_viewvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: poll

Description here

Field Type Null Key Default Auto Increment
poll_idint(11)_PRINULLY
community_idint(11)__0_
user_idint(10)__0_
questionvarchar(255)__NULL_
option1varchar(100)__NULL_
option2varchar(100)__NULL_
option3varchar(100)__NULL_
option4varchar(100)__NULL_
selected_optionenum('one','multiple')__one_
allowed_voteenum('member','all')__member_
end_date_formatenum('unlimited','fixed')__unlimited_
end_datevarchar(20)__NULL_
inserteddatetime__0000-00-00 00:00:00_

Table: poll_vote

Description here

Field Type Null Key Default Auto Increment
vote_idint(10)_PRINULLY
poll_idmediumint(10)__0_
community_idint(10)__0_
user_idint(10)__0_
answervarchar(20)__NULL_
inserteddate__0000-00-00_

Table: privacy_status

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
privacy_statusvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: profile_view

Description here

Field Type Null Key Default Auto Increment
user_idint(10)__0_
view_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__0000-00-00 00:00:00_

Table: q_a_comment

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
answer_idint(10)__0_
user_idint(10)__0_
question_idint(10)__0_
commenttext__NULL_
inserteddatetime__0000-00-00 00:00:00_

Table: question

Description here

Field Type Null Key Default Auto Increment
qidint(10)_PRINULLY
user_idint(10)__0_
questiontext__NULL_
category_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_
updateddate__0000-00-00_
hitsint(12)__0_
statusenum('active','inactive')__active_

Table: question_category

Description here

Field Type Null Key Default Auto Increment
idint(5) unsigned_PRINULLY
sub_cat_idvarchar(32)__NULL_
category_namevarchar(255)YMULNULL_
priorityint(5)__0_

Table: question_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
question_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: regions

Description here

Field Type Null Key Default Auto Increment
region_idint(11)_PRINULLY
zone_region_idint(11)__102_
region_namevarchar(32)__NULL_
region_codevarchar(5)__NULL_
prioritysmallint(5)__0_

Table: relationship_status

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
relationship_statusvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: religion

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
religionvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: reply_to_classified_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
reply_to_classified_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: report_abuse_article

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_idint(5)__0_
article_idint(10)__0_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_abuse_blog

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_idint(5)__0_
blog_idint(10)__0_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_abuse_classified

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_idint(5)__0_
classified_idint(10)__0_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_abuse_community

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_idint(5)__0_
community_idint(10)__0_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_abuse_link

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_idint(5)__0_
link_idint(10)__0_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_abuse_photo

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_idint(5)__0_
photo_idint(10)__0_
album_idint(11)__NULL_
community_idint(11)__NULL_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_abuse_q_and_a

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_typeint(5)__0_
question_idint(10)__0_
answer_idint(10)__0_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_abuse_video

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
report_idint(5)__0_
video_idint(10)__0_
user_idint(10)__0_
inserteddatetime__0000-00-00 00:00:00_

Table: report_category

Description here

Field Type Null Key Default Auto Increment
idint(6)_PRINULLY
sub_cat_idint(5)__0_
category_namevarchar(10)__NULL_
priorityint(6)__0_

Table: salutation

Description here

Field Type Null Key Default Auto Increment
idsmallint(5)_PRINULLY
salutation_namevarchar(255)__NULL_
prioritysmallint(5)__0_

Table: set_status_comment

Description here

Field Type Null Key Default Auto Increment
comment_idint(10)_PRINULLY
user_idint(11)__NULL_
from_user_idint(10)__0_
commenttext__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
inserteddate__0000-00-00_

Table: sexual_orientation

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
sexual_orientationvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: smoking

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
smokingvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: social_info

Description here

Field Type Null Key Default Auto Increment
user_idint(10)_PRI0_
relationship_statusint(10)__0_
childrenint(10)__0_
ethnicityint(10)__0_
religionint(10)__0_
political_viewint(10)__0_
humorvarchar(30)__NULL_
sexual_orientationint(10)__0_
fashionvarchar(100)__NULL_
smokingint(10)__0_
drinkingint(10)__0_
petsint(10)__0_
livingvarchar(30)__NULL_
home_townvarchar(30)__NULL_
web_pagevarchar(30)__NULL_
about_metext__NULL_
passionstext__NULL_
sportstext__NULL_
activitiestext__NULL_
bookstext__NULL_
musictext__NULL_
tv_showtext__NULL_
moviestext__NULL_
cuisinestext__NULL_
updateddate__0000-00-00_

Table: subscribe_blog_update

Description here

Field Type Null Key Default Auto Increment
idint(10)_MULNULLY
user_idint(10)__0_
subscribed_idint(10)__0_
blog_idint(10)__0_
inserteddate__0000-00-00_
updateddate__0000-00-00_

Table: title_keywordmetatype

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
file_namevarchar(255)__NULL_
titlevarchar(255)__NULL_
meta_keywordtext__NULL_

Table: turn_ons

Description here

Field Type Null Key Default Auto Increment
idsmallint(2)_PRINULLY
turn_onsvarchar(255)__NULL_
prioritysmallint(2)__0_

Table: user_chat

Description here

Field Type Null Key Default Auto Increment
chat_idint(11)_PRINULLY
sender_idint(11)__NULL_
receiver_idint(11)__NULL_
messagestext__NULL_
interestedenum('Y','N')__Y_
inserteddatetime_MULNULL_

Table: user_contact

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
user_idint(11)__0_
user_first_namevarchar(32)__NULL_
user_middle_namevarchar(32)__NULL_
user_last_namevarchar(32)__NULL_
user_email_addressvarchar(64)__NULL_
user_address1varchar(128)__NULL_
user_address2varchar(128)__NULL_
user_country_idint(3)__0_
user_statevarchar(32)__NULL_
user_state_idint(11)__0_
user_cityvarchar(64)__NULL_
user_zipvarchar(10)__NULL_
user_phonevarchar(24)__NULL_
user_mobilevarchar(24)__NULL_

Table: user_login

Description here

Field Type Null Key Default Auto Increment
user_idint(11)_PRINULLY
user_email_addressvarchar(64)__NULL_
user_passwordvarchar(48)__NULL_
inserteddatetime__0000-00-00 00:00:00_
updateddatetimeY_NULL_
ip_addressvarchar(15)Y_NULL_
last_ip_addressvarchar(15)Y_NULL_
last_login_timedatetimeY_NULL_
number_of_logonint(11)__0_
user_statusenum('Y','N')__Y_
user_featuredenum('Y','N')__N_
termsenum('Yes','No')__Yes_

Table: user_mails

Description here

Field Type Null Key Default Auto Increment
idint(15)_PRINULLY
sender_idint(15)_MUL0_
receiver_idint(11)_MUL0_
subjectvarchar(255)__NULL_
messageblob__NULL_
attachment_filevarchar(255)__NULL_
sender_markenum('No','Yes')__No_
receiver_markenum('No','Yes')__No_
receiver_seeenum('No','Yes')_MULNo_
sender_seeenum('Yes','No')_MULNo_
receiver_mail_statusenum('active','inactive','deleted')__active_
sender_mail_statusenum('active','inactive','deleted')__active_
receiver_deleteddateY_NULL_
sender_deleteddateY_NULL_
receiver_replyenum('No','Yes')__No_
sender_replyenum('No','Yes')__No_
inserteddatetime__0000-00-00 00:00:00_

Table: user_point

Description here

Field Type Null Key Default Auto Increment
idint(10)_PRINULLY
user_idint(10)__0_
no_of_groupint(10) unsigned__0_
no_of_forumint(10) unsigned__0_
no_of_messageint(10) unsigned__0_
no_of_pollint(10) unsigned__0_
no_of_eventint(10) unsigned__0_
no_of_group_photoint(10) unsigned__0_
no_of_photoint(10) unsigned__0_
no_of_videoint(10) unsigned__0_
no_of_blogint(10) unsigned__0_
no_of_linkint(10) unsigned__0_
no_of_questionint(10) unsigned__0_
no_of_answerint(10) unsigned__0_
no_of_classifiedint(10) unsigned__0_
no_of_directoryint(10) unsigned__0_

Table: user_registration_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
user_registration_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: video

Description here

Field Type Null Key Default Auto Increment
video_idint(10)_PRINULLY
user_idint(10)__0_
titlevarchar(30)__NULL_
videovarchar(60)__NULL_
hitsint(10)__0_
featuredenum('N','Y')__NULL_
statusenum('Y','N')__Y_
inserteddatetime__0000-00-00 00:00:00_
updateddatetime__NULL_

Table: video_comment

Description here

Field Type Null Key Default Auto Increment
video_comment_idint(10)_PRINULLY
user_idint(10)__0_
video_idint(10)__0_
commenttext__NULL_
statusenum('Y','N')__N_
featuredenum('Y','N')__N_
inserteddate__0000-00-00_

Table: video_report_it_email_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)_PRINULLY
video_report_it_email_template_namevarchar(32)__NULL_
descriptionblob__NULL_
prioritytinyint(3)__0_
alert_defaultenum('No','Yes')__No_

Table: whos_online

Description here

Field Type Null Key Default Auto Increment
user_idint(11)Y_NULL_
uservarchar(13)__NULL_
session_idvarchar(32)__NULL_
ip_addressvarchar(15)__NULL_
time_entryvarchar(14)__NULL_
time_last_clickvarchar(14)__NULL_

Table: word_censor

Description here

Field Type Null Key Default Auto Increment
idint(11)_PRINULLY
wordvarchar(255)__NULL_
replaced_wordvarchar(255)__NULL_
case_sensitiveenum('N','Y')__N_
partialenum('N','Y')__N_

Table: work_info

Description here

Field Type Null Key Default Auto Increment
work_idint(10)_PRINULLY
user_idint(10)__0_
companyvarchar(50)__NULL_
cityvarchar(40)__NULL_
statevarchar(50)__NULL_
state_idint(10)__0_
countryint(10)__0_
job_titlevarchar(50)__NULL_
salaryvarchar(15)__NULL_
salary_pervarchar(20)__NULL_
start_monthint(2)__0_
start_yearint(4)__0_
end_monthint(2)__0_
end_yearint(4)__0_
still_workenum('Yes','No')__Yes_
descriptiontext__NULL_
company_webpagevarchar(40)__NULL_
work_emailvarchar(40)__NULL_
work_phonevarchar(40)__NULL_
updateddate__0000-00-00_

Table: zones

Description here

Field Type Null Key Default Auto Increment
zone_idint(11)_PRINULLY
zone_country_idint(11)__0_
zone_codevarchar(32)__NULL_
zone_namevarchar(32)__NULL_
Main Page
About SNS
Developer Documentation
Personal tools