Database:[*] brazzers[*] information_schema[*] mansefcom[*] manwin_cy[*] manwin_de[*] manwin_lu[*] updates[*] updates_dds[*] updates_tmp

Database: brazzers
Table: vbbusernote
[8 columns]
+--------------+------------------+
| Column | Type |
+--------------+------------------+
| allowsmilies | smallint(6) |
| dateline | int(10) unsigned |
| message | mediumtext |
| posterid | int(10) unsigned |
| title | varchar(255) |
| userid | int(10) unsigned |
| username | varchar(100) |
| usernoteid | int(10) unsigned |
+--------------+------------------+

Database: brazzers
Table: vbbsmilie
[6 columns]
+-----------------+----------------------+
| Column | Type |
+-----------------+----------------------+
| displayorder | smallint(5) unsigned |
| imagecategoryid | smallint(5) unsigned |
| smilieid | smallint(5) unsigned |
| smiliepath | char(100) |
| smilietext | char(20) |
| title | char(100) |
+-----------------+----------------------+

Database: brazzers
Table: poll_votes
[6 columns]
+----------------+--------------+
| Column | Type |
+----------------+--------------+
| date_added | int(11) |
| poll_id | int(11) |
| poll_option_id | int(11) |
| poll_vote_id | int(11) |
| user_id | int(11) |
| user_type | varchar(255) |
+----------------+--------------+

Database: brazzers
Table: poll_options
[4 columns]
+----------------+---------+
| Column | Type |
+----------------+---------+
| option_text | text |
| poll_id | int(11) |
| poll_option_id | int(11) |
| total_votes | int(11) |
+----------------+---------+

Database: brazzers
Table: feedback
[8 columns]
+---------------+--------------+
| Column | Type |
+---------------+--------------+
| date_added | int(11) |
| description | text |
| feedback_id | int(11) |
| feedback_type | varchar(255) |
| site_id | int(11) |
| user_id | int(11) |
| user_nickname | varchar(255) |
| user_type | varchar(255) |
+---------------+--------------+

Database: brazzers
Table: profile_fields
[5 columns]
+------------------+--------------+
| Column | Type |
+------------------+--------------+
| field | varchar(255) |
| profile_field_id | int(11) |
| user_id | int(11) |
| user_type | varchar(255) |
| value | varchar(255) |
+------------------+--------------+

Database: brazzers
Table: vbbsubscribethread
[6 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| canview | smallint(5) unsigned |
| emailupdate | smallint(5) unsigned |
| folderid | int(10) unsigned |
| subscribethreadid | int(10) unsigned |
| threadid | int(10) unsigned |
| userid | int(10) unsigned |
+-------------------+----------------------+

Database: brazzers
Table: vbbexternalcache
[5 columns]
+-----------+------------------+
| Column | Type |
+-----------+------------------+
| cachehash | varchar(32) |
| dateline | int(10) unsigned |
| forumid | int(10) unsigned |
| headers | mediumtext |
| text | mediumtext |
+-----------+------------------+

Database: brazzers
Table: featured_models
[4 columns]
+-------------------+--------+
| Column | Type |
+-------------------+--------+
| featured_model_id | int(6) |
| model_id | int(6) |
| position | int(2) |
| site_id | int(6) |
+-------------------+--------+

Database: brazzers
Table: themes
[3 columns]
+-------------+--------------+
| Column | Type |
+-------------+--------------+
| description | varchar(255) |
| path | varchar(255) |
| theme_id | int(11) |
+-------------+--------------+

Database: brazzers
Table: vbbsubscribeevent
[5 columns]
+------------------+------------------+
| Column | Type |
+------------------+------------------+
| eventid | int(10) unsigned |
| lastreminder | int(10) unsigned |
| reminder | int(10) unsigned |
| subscribeeventid | int(10) unsigned |
| userid | int(10) unsigned |
+------------------+------------------+

Database: brazzers
Table: site_custom_fields
[3 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| custom_field_id | int(11) |
| site_id | int(11) |
| title | varchar(255) |
+-----------------+--------------+

Database: brazzers
Table: favorites_switchboard
[4 columns]
+--------------------------+--------------+
| Column | Type |
+--------------------------+--------------+
| favorite_id | int(11) |
| favorite_type | varchar(255) |
| favorites_switchboard_id | int(11) |
| folder_id | int(11) |
+--------------------------+--------------+

Database: brazzers
Table: vbbsubscriptionlog
[7 columns]
+-------------------+-----------------------+
| Column | Type |
+-------------------+-----------------------+
| expirydate | int(10) unsigned |
| pusergroupid | smallint(6) |
| regdate | int(10) unsigned |
| status | smallint(6) |
| subscriptionid | smallint(6) |
| subscriptionlogid | mediumint(8) unsigned |
| userid | int(10) unsigned |
+-------------------+-----------------------+

Database: brazzers
Table: vbbmoderation
[4 columns]
+----------+------------------------+
| Column | Type |
+----------+------------------------+
| dateline | int(10) unsigned |
| postid | int(10) unsigned |
| threadid | int(10) unsigned |
| type | enum('thread','reply') |
+----------+------------------------+

Database: brazzers
Table: rating_durations
[6 columns]
+------------------------+-------------+
| Column | Type |
+------------------------+-------------+
| dynamic_model_duration | int(11) |
| dynamic_scene_duration | int(11) |
| dynamic_video_duration | tinyint(11) |
| min_num_model_ratings | int(11) |
| min_num_scene_ratings | int(11) |
| min_num_video_ratings | tinyint(11) |
+------------------------+-------------+

Database: brazzers
Table: blog_posts
[9 columns]
+----------------+--------------+
| Column | Type |
+----------------+--------------+
| allow_comments | tinyint(1) |
| blog_id | int(11) |
| blog_post_id | int(11) |
| date_added | int(11) |
| post | text |
| title | varchar(255) |
| user_id | int(11) |
| user_nickname | varchar(255) |
| user_type | varchar(255) |
+----------------+--------------+

Database: brazzers
Table: vbbmailqueue
[7 columns]
+-------------+------------------+
| Column | Type |
+-------------+------------------+
| dateline | int(10) unsigned |
| fromemail | mediumtext |
| header | mediumtext |
| mailqueueid | int(10) unsigned |
| message | mediumtext |
| subject | mediumtext |
| toemail | mediumtext |
+-------------+------------------+

Database: brazzers
Table: vbbusergrouprequest
[5 columns]
+--------------------+----------------------+
| Column | Type |
+--------------------+----------------------+
| dateline | int(10) unsigned |
| reason | varchar(250) |
| usergroupid | smallint(5) unsigned |
| usergrouprequestid | int(10) unsigned |
| userid | int(10) unsigned |
+--------------------+----------------------+

Database: brazzers
Table: bonus_sites
[5 columns]
+---------------+--------------+
| Column | Type |
+---------------+--------------+
| bonus_site_id | int(11) |
| description | varchar(255) |
| image | varchar(255) |
| name | varchar(255) |
| url | varchar(255) |
+---------------+--------------+

Database: brazzers
Table: vbbtemplate
[10 columns]
+--------------+-------------------------------------------------+
| Column | Type |
+--------------+-------------------------------------------------+
| dateline | int(10) unsigned |
| product | varchar(25) |
| styleid | smallint(6) |
| template | mediumtext |
| template_un | mediumtext |
| templateid | int(10) unsigned |
| templatetype | enum('template','stylevar','css','replacement') |
| title | varchar(100) |
| username | varchar(100) |
| version | varchar(30) |
+--------------+-------------------------------------------------+

Database: brazzers
Table: vbbdeletionlog
[6 columns]
+-----------+-----------------------+
| Column | Type |
+-----------+-----------------------+
| dateline | int(10) unsigned |
| primaryid | int(10) unsigned |
| reason | varchar(125) |
| type | enum('post','thread') |
| userid | int(10) unsigned |
| username | varchar(100) |
+-----------+-----------------------+

Database: brazzers
Table: video_forms
[5 columns]
+---------------+---------------------+
| Column | Type |
+---------------+---------------------+
| extension | varchar(255) |
| length | int(11) |
| size | bigint(32) unsigned |
| video_form_id | int(11) |
| video_id | int(11) |
+---------------+---------------------+

Database: brazzers
Table: vbbranks
[8 columns]
+-------------+----------------------+
| Column | Type |
+-------------+----------------------+
| display | smallint(5) unsigned |
| minposts | int(10) unsigned |
| rankid | smallint(5) unsigned |
| rankimg | mediumtext |
| ranklevel | smallint(5) unsigned |
| stack | smallint(5) unsigned |
| type | smallint(5) unsigned |
| usergroupid | smallint(5) unsigned |
+-------------+----------------------+

Database: brazzers
Table: vbbmoderatorlog
[12 columns]
+----------------+----------------------+
| Column | Type |
+----------------+----------------------+
| action | varchar(250) |
| attachmentid | int(10) unsigned |
| dateline | int(10) unsigned |
| forumid | smallint(5) unsigned |
| ipaddress | varchar(15) |
| moderatorlogid | int(10) unsigned |
| pollid | int(10) unsigned |
| postid | int(10) unsigned |
| threadid | int(10) unsigned |
| threadtitle | varchar(250) |
| type | smallint(5) unsigned |
| userid | int(10) unsigned |
+----------------+----------------------+

Database: brazzers
Table: visitor_trailer_count
[2 columns]
+------------+-------------+
| Column | Type |
+------------+-------------+
| time_view | datetime |
| visitor_ip | varchar(32) |
+------------+-------------+

Database: brazzers
Table: spot_buyer_scenes
[11 columns]
+---------------------+---------+
| Column | Type |
+---------------------+---------+
| date_added | int(11) |
| last_no_clicks | int(11) |
| last_no_sales | int(11) |
| no_clicks | int(11) |
| no_sales | int(11) |
| position | int(11) |
| scene_id | int(11) |
| spot_buyer_id | int(11) |
| spot_buyer_scene_id | int(11) |
| total_no_clicks | int(11) |
| total_no_sales | int(11) |
+---------------------+---------+

Database: brazzers
Table: vbbattachmentviews
[1 column]
+--------------+------------------+
| Column | Type |
+--------------+------------------+
| attachmentid | int(10) unsigned |
+--------------+------------------+

Database: brazzers
Table: dvds
[2 columns]
+--------+--------------+
| Column | Type |
+--------+--------------+
| dvd_id | int(11) |
| name | varchar(255) |
+--------+--------------+

Database: brazzers
Table: vbbevent
[15 columns]
+---------------+------------------+
| Column | Type |
+---------------+------------------+
| allowsmilies | smallint(6) |
| calendarid | int(10) unsigned |
| customfields | mediumtext |
| dateline | int(10) unsigned |
| dateline_from | int(10) unsigned |
| dateline_to | int(10) unsigned |
| dst | smallint(6) |
| event | mediumtext |
| eventid | int(10) unsigned |
| recuroption | varchar(6) |
| recurring | smallint(6) |
| title | varchar(250) |
| userid | int(10) unsigned |
| utc | smallint(6) |
| visible | smallint(6) |
+---------------+------------------+

Database: brazzers
Table: vbbadminlog
[7 columns]
+------------+------------------+
| Column | Type |
+------------+------------------+
| action | varchar(20) |
| adminlogid | int(10) unsigned |
| dateline | int(10) unsigned |
| extrainfo | varchar(200) |
| ipaddress | varchar(15) |
| script | varchar(50) |
| userid | int(10) unsigned |
+------------+------------------+

Database: brazzers
Table: vbbaccess
[3 columns]
+------------+----------------------+
| Column | Type |
+------------+----------------------+
| accessmask | smallint(5) unsigned |
| forumid | smallint(5) unsigned |
| userid | int(10) unsigned |
+------------+----------------------+

Database: brazzers
Table: vbbphrase
[9 columns]
+------------+------------------+
| Column | Type |
+------------+------------------+
| dateline | int(10) unsigned |
| fieldname | varchar(20) |
| languageid | smallint(6) |
| phraseid | int(10) unsigned |
| product | varchar(25) |
| text | mediumtext |
| username | varchar(100) |
| varname | varchar(250) |
| version | varchar(30) |
+------------+------------------+

Database: brazzers
Table: vbbreminder
[8 columns]
+---------------+----------------------+
| Column | Type |
+---------------+----------------------+
| adminonly | smallint(5) unsigned |
| completedby | int(10) unsigned |
| completedtime | int(10) unsigned |
| duedate | int(10) unsigned |
| reminderid | int(10) unsigned |
| text | mediumtext |
| title | varchar(50) |
| userid | int(10) unsigned |
+---------------+----------------------+

Database: brazzers
Table: vbbuserlist
[3 columns]
+------------+------------------------+
| Column | Type |
+------------+------------------------+
| relationid | int(10) unsigned |
| type | enum('buddy','ignore') |
| userid | int(10) unsigned |
+------------+------------------------+

Database: brazzers
Table: job_logs
[4 columns]
+------------+---------+
| Column | Type |
+------------+---------+
| date_added | int(11) |
| job_id | int(11) |
| log | text |
| log_id | int(11) |
+------------+---------+

Database: brazzers
Table: permissions
[3 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| id | int(11) |
| permission_path | varchar(255) |
| type | varchar(16) |
+-----------------+--------------+

Database: brazzers
Table: spot_buyers
[28 columns]
+---------------------------+--------------+
| Column | Type |
+---------------------------+--------------+
| bg_color | varchar(7) |
| casted_scene_position | int(11) |
| clicks | int(11) |
| css_code | text |
| current_rotation | int(11) |
| cutoff | int(11) |
| date_added | int(11) |
| first_spot_buyer_scene_id | int(11) |
| footer_code | blob |
| header_code | blob |
| height | int(11) |
| impressions | int(11) |
| max_clicks | int(11) |
| max_impressions | int(11) |
| name | varchar(100) |
| no_clicks_coefficient | float |
| no_sales_coefficient | float |
| num_scenes_final_round | int(11) |
| pic_size | int(11) |
| pic_text | text |
| pic_type | varchar(25) |
| rotations_per_round | int(11) |
| spot_buyer_id | int(11) |
| total_clicks | int(11) |
| total_impressions | int(11) |
| url | blob |
| watermark | varchar(255) |
| width | int(11) |
+---------------------------+--------------+

Database: brazzers
Table: vbbcalendarmoderator
[5 columns]
+---------------------+------------------+
| Column | Type |
+---------------------+------------------+
| calendarid | int(10) unsigned |
| calendarmoderatorid | int(10) unsigned |
| neweventemail | smallint(6) |
| permissions | int(10) unsigned |
| userid | int(10) unsigned |
+---------------------+------------------+

Database: brazzers
Table: vbbcpsession
[3 columns]
+----------+------------------+
| Column | Type |
+----------+------------------+
| dateline | int(10) unsigned |
| hash | varchar(32) |
| userid | int(10) unsigned |
+----------+------------------+

Database: brazzers
Table: xscore_rotation_ratios
[4 columns]
+--------------------+---------+
| Column | Type |
+--------------------+---------+
| date_added | int(11) |
| number_of_joins | int(11) |
| number_of_visitors | int(11) |
| site_id | int(11) |
+--------------------+---------+

Database: brazzers
Table: vbbpollvote
[5 columns]
+------------+------------------+
| Column | Type |
+------------+------------------+
| pollid | int(10) unsigned |
| pollvoteid | int(10) unsigned |
| userid | int(10) unsigned |
| votedate | int(10) unsigned |
| voteoption | int(10) unsigned |
+------------+------------------+

Database: brazzers
Table: vbbproduct
[7 columns]
+-----------------+----------------------+
| Column | Type |
+-----------------+----------------------+
| active | smallint(5) unsigned |
| description | varchar(250) |
| productid | varchar(25) |
| title | varchar(50) |
| url | varchar(250) |
| version | varchar(25) |
| versioncheckurl | varchar(250) |
+-----------------+----------------------+

Database: brazzers
Table: vbbsearch
[19 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| announceids | mediumtext |
| completed | smallint(5) unsigned |
| dateline | int(10) unsigned |
| displayterms | mediumtext |
| forumchoice | mediumtext |
| ipaddress | varchar(15) |
| orderedids | mediumtext |
| personal | smallint(5) unsigned |
| query | varchar(200) |
| searchhash | varchar(32) |
| searchid | int(10) unsigned |
| searchterms | mediumtext |
| searchtime | float |
| searchuser | varchar(200) |
| showposts | smallint(5) unsigned |
| sortby | varchar(200) |
| sortorder | varchar(4) |
| titleonly | smallint(5) unsigned |
| userid | int(10) unsigned |
+--------------+----------------------+

Database: brazzers
Table: vbbpostindex
[4 columns]
+---------+----------------------+
| Column | Type |
+---------+----------------------+
| intitle | smallint(5) unsigned |
| postid | int(10) unsigned |
| score | smallint(5) unsigned |
| wordid | int(10) unsigned |
+---------+----------------------+

Database: brazzers
Table: vbbuser
[55 columns]
+--------------------+----------------------+
| Column | Type |
+--------------------+----------------------+
| adminoptions | int(10) unsigned |
| aim | varchar(20) |
| autosubscribe | smallint(6) |
| avatarid | smallint(6) |
| avatarrevision | int(10) unsigned |
| birthday | varchar(10) |
| birthday_search | date |
| customtitle | smallint(6) |
| daysprune | smallint(6) |
| displaygroupid | smallint(5) unsigned |
| email | varchar(100) |
| emailstamp | int(10) unsigned |
| homepage | varchar(100) |
| icq | varchar(20) |
| infractiongroupid | smallint(5) unsigned |
| infractiongroupids | varchar(255) |
| infractions | int(10) unsigned |
| ipaddress | varchar(15) |
| ipoints | int(10) unsigned |
| joindate | int(10) unsigned |
| languageid | smallint(5) unsigned |
| lastactivity | int(10) unsigned |
| lastpost | int(10) unsigned |
| lastpostid | int(10) unsigned |
| lastvisit | int(10) unsigned |
| maxposts | smallint(6) |
| membergroupids | varchar(250) |
| msn | varchar(100) |
| options | int(10) unsigned |
| parentemail | varchar(50) |
| password | varchar(32) |
| passworddate | date |
| pmpopup | smallint(6) |
| pmtotal | smallint(5) unsigned |
| pmunread | smallint(5) unsigned |
| posts | int(10) unsigned |
| profilepicrevision | int(10) unsigned |
| referrerid | int(10) unsigned |
| reputation | int(11) |
| reputationlevelid | int(10) unsigned |
| salt | char(3) |
| showbirthday | smallint(5) unsigned |
| showvbcode | smallint(5) unsigned |
| sigpicrevision | int(10) unsigned |
| skype | varchar(32) |
| startofweek | smallint(6) |
| styleid | smallint(5) unsigned |
| threadedmode | smallint(5) unsigned |
| timezoneoffset | varchar(4) |
| usergroupid | smallint(5) unsigned |
| userid | int(10) unsigned |
| username | varchar(100) |
| usertitle | varchar(250) |
| warnings | int(10) unsigned |
| yahoo | varchar(32) |
+--------------------+----------------------+

Database: brazzers
Table: vbbtachyforumpost
[8 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| forumid | int(10) unsigned |
| lasticonid | smallint(5) unsigned |
| lastpost | int(10) unsigned |
| lastposter | varchar(100) |
| lastpostid | int(10) unsigned |
| lastthread | varchar(250) |
| lastthreadid | int(10) unsigned |
| userid | int(10) unsigned |
+--------------+----------------------+

Database: brazzers
Table: vbbsubscriptionpermission
[3 columns]
+--------------------------+------------------+
| Column | Type |
+--------------------------+------------------+
| subscriptionid | int(10) unsigned |
| subscriptionpermissionid | int(10) unsigned |
| usergroupid | int(10) unsigned |
+--------------------------+------------------+

Database: brazzers
Table: vbbadminmessage
[10 columns]
+----------------+-----------------------------------+
| Column | Type |
+----------------+-----------------------------------+
| action | varchar(20) |
| adminmessageid | int(10) unsigned |
| dateline | int(10) unsigned |
| dismissable | smallint(5) unsigned |
| execurl | mediumtext |
| method | enum('get','post') |
| script | varchar(50) |
| status | enum('undone','done','dismissed') |
| statususerid | int(10) unsigned |
| varname | varchar(250) |
+----------------+-----------------------------------+

Database: brazzers
Table: tour_visitor_ips
[2 columns]
+------------+-------------+
| Column | Type |
+------------+-------------+
| site_id | int(11) |
| visitor_ip | varchar(32) |
+------------+-------------+

Database: brazzers
Table: vbbattachmentpermission
[7 columns]
+------------------------+----------------------+
| Column | Type |
+------------------------+----------------------+
| attachmentpermissionid | int(10) unsigned |
| attachmentpermissions | int(10) unsigned |
| extension | varchar(20) |
| height | smallint(5) unsigned |
| size | int(10) unsigned |
| usergroupid | int(10) unsigned |
| width | smallint(5) unsigned |
+------------------------+----------------------+

Database: brazzers
Table: vbbannouncement
[9 columns]
+---------------------+----------------------+
| Column | Type |
+---------------------+----------------------+
| announcementid | smallint(5) unsigned |
| announcementoptions | int(10) unsigned |
| enddate | int(10) unsigned |
| forumid | smallint(6) |
| pagetext | mediumtext |
| startdate | int(10) unsigned |
| title | varchar(250) |
| userid | int(10) unsigned |
| views | int(10) unsigned |
+---------------------+----------------------+

Database: brazzers
Table: vbbposthash
[5 columns]
+----------+------------------+
| Column | Type |
+----------+------------------+
| dateline | int(10) unsigned |
| dupehash | char(32) |
| postid | int(10) unsigned |
| threadid | int(10) unsigned |
| userid | int(10) unsigned |
+----------+------------------+

Database: brazzers
Table: model_searches
[4 columns]
+---------------+---------+
| Column | Type |
+---------------+---------+
| model_id | int(11) |
| num_searches | int(11) |
| site_id | int(11) |
| temp_searches | int(11) |
+---------------+---------+

Database: brazzers
Table: vbbstrikes
[3 columns]
+------------+------------------+
| Column | Type |
+------------+------------------+
| strikeip | varchar(15) |
| striketime | int(10) unsigned |
| username | varchar(100) |
+------------+------------------+

Database: brazzers
Table: vbbicon
[5 columns]
+-----------------+----------------------+
| Column | Type |
+-----------------+----------------------+
| displayorder | smallint(5) unsigned |
| iconid | smallint(5) unsigned |
| iconpath | varchar(100) |
| imagecategoryid | smallint(5) unsigned |
| title | varchar(100) |
+-----------------+----------------------+

Database: brazzers
Table: pictures
[5 columns]
+------------+--------------+
| Column | Type |
+------------+--------------+
| extension | varchar(255) |
| filename | varchar(255) |
| picture_id | int(11) |
| scene_id | int(11) |
| size | int(11) |
+------------+--------------+

Database: brazzers
Table: tags
[4 columns]
+----------+--------------+
| Column | Type |
+----------+--------------+
| is_major | tinyint(4) |
| name | varchar(255) |
| tag_id | int(11) |
| tag_type | varchar(255) |
+----------+--------------+

Database: brazzers
Table: sites
[30 columns]
+------------------------+--------------+
| Column | Type |
+------------------------+--------------+
| bin | varchar(255) |
| brazzers_site_position | int(11) |
| content_site | tinyint(1) |
| email | varchar(255) |
| ftp_password | varchar(255) |
| ftp_server | varchar(255) |
| ftp_username | varchar(255) |
| home | varchar(255) |
| htp_pass_logs | varchar(255) |
| is_active | tinyint(1) |
| live_cam_category | varchar(255) |
| max_description_length | int(11) |
| mega_tour_position | int(11) |
| nats_join_code | varchar(255) |
| nats_site_id | int(11) |
| num_tour_updates | int(11) |
| program | varchar(255) |
| root | varchar(255) |
| short_name | varchar(255) |
| site_description | text |
| site_id | int(11) |
| site_name | varchar(255) |
| site_short_description | text |
| slogan | varchar(255) |
| tour_folder_name | varchar(255) |
| tour_num_per_page | int(11) |
| track_code | varchar(255) |
| url | varchar(255) |
| uses_xscore | tinyint(1) |
| which_mega_site | varchar(255) |
+------------------------+--------------+

Database: brazzers
Table: comments
[8 columns]
+---------------------+--------------+
| Column | Type |
+---------------------+--------------+
| comment | text |
| comment_id | int(11) |
| date_added | int(11) |
| item_commented_id | int(11) |
| item_commented_type | varchar(255) |
| user_id | int(11) |
| user_nickname | varchar(255) |
| user_type | varchar(255) |
+---------------------+--------------+

Database: brazzers
Table: vbbcustomprofilepic
[8 columns]
+----------+----------------------+
| Column | Type |
+----------+----------------------+
| dateline | int(10) unsigned |
| filedata | mediumblob |
| filename | varchar(100) |
| filesize | int(10) unsigned |
| height | smallint(5) unsigned |
| userid | int(10) unsigned |
| visible | smallint(6) |
| width | smallint(5) unsigned |
+----------+----------------------+

Database: brazzers
Table: vbbsigpic
[8 columns]
+----------+----------------------+
| Column | Type |
+----------+----------------------+
| dateline | int(10) unsigned |
| filedata | mediumblob |
| filename | varchar(100) |
| filesize | int(10) unsigned |
| height | smallint(5) unsigned |
| userid | int(10) unsigned |
| visible | smallint(6) |
| width | smallint(5) unsigned |
+----------+----------------------+

Database: brazzers
Table: vbbupgradelog
[7 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| dateline | int(10) unsigned |
| perpage | smallint(5) unsigned |
| script | varchar(50) |
| startat | int(10) unsigned |
| step | smallint(5) unsigned |
| steptitle | varchar(250) |
| upgradelogid | int(10) unsigned |
+--------------+----------------------+

Database: brazzers
Table: scene_custom_fields
[4 columns]
+-----------------------+---------+
| Column | Type |
+-----------------------+---------+
| scene_custom_field_id | int(11) |
| scene_id | int(11) |
| site_custom_field_id | int(11) |
| value | text |
+-----------------------+---------+

Database: brazzers
Table: vbbcalendarpermission
[4 columns]
+----------------------+----------------------+
| Column | Type |
+----------------------+----------------------+
| calendarid | int(10) unsigned |
| calendarpermissionid | int(10) unsigned |
| calendarpermissions | int(10) unsigned |
| usergroupid | smallint(5) unsigned |
+----------------------+----------------------+

Database: brazzers
Table: models_scenes
[2 columns]
+----------+---------+
| Column | Type |
+----------+---------+
| model_id | int(11) |
| scene_id | int(11) |
+----------+---------+

Database: brazzers
Table: jobs
[12 columns]
+------------------+--------------+
| Column | Type |
+------------------+--------------+
| days_to_keep_log | int(11) |
| interval_offset | int(11) |
| is_enabled | tinyint(1) |
| job_id | int(11) |
| max_concurrent | int(11) |
| minute_interval | int(11) |
| module | varchar(30) |
| mutex | int(11) |
| name | varchar(60) |
| run_location | varchar(255) |
| run_mode | varchar(255) |
| title | varchar(255) |
+------------------+--------------+

Database: brazzers
Table: vbbpmreceipt
[8 columns]
+------------+----------------------+
| Column | Type |
+------------+----------------------+
| denied | smallint(5) unsigned |
| pmid | int(10) unsigned |
| readtime | int(10) unsigned |
| sendtime | int(10) unsigned |
| title | varchar(250) |
| touserid | int(10) unsigned |
| tousername | varchar(100) |
| userid | int(10) unsigned |
+------------+----------------------+

Database: brazzers
Table: last_insert_id
[2 columns]
+------------+--------------+
| Column | Type |
+------------+--------------+
| id | int(11) |
| table_name | varchar(255) |
+------------+--------------+

Database: brazzers
Table: subscriptions
[7 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| initial_days | int(11) |
| initial_pay | int(11) |
| name | varchar(255) |
| rebill_days | int(11) |
| rebill_pay | int(11) |
| site_id | int(11) |
| subscription_id | int(11) |
+-----------------+--------------+

Database: brazzers
Table: vbbrsslog
[8 columns]
+----------------------+-------------------------------+
| Column | Type |
+----------------------+-------------------------------+
| contenthash | char(32) |
| dateline | int(10) unsigned |
| itemid | int(10) unsigned |
| itemtype | enum('thread','announcement') |
| rssfeedid | int(10) unsigned |
| threadactioncomplete | tinyint(3) unsigned |
| threadactiontime | int(10) unsigned |
| uniquehash | char(32) |
+----------------------+-------------------------------+

Database: brazzers
Table: vbbpmtext
[10 columns]
+---------------+----------------------+
| Column | Type |
+---------------+----------------------+
| allowsmilie | smallint(5) unsigned |
| dateline | int(10) unsigned |
| fromuserid | int(10) unsigned |
| fromusername | varchar(100) |
| iconid | smallint(5) unsigned |
| message | mediumtext |
| pmtextid | int(10) unsigned |
| showsignature | smallint(5) unsigned |
| title | varchar(250) |
| touserarray | mediumtext |
+---------------+----------------------+

Database: brazzers
Table: vbbadminhelp
[7 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| action | varchar(25) |
| adminhelpid | int(10) unsigned |
| displayorder | smallint(5) unsigned |
| optionname | varchar(100) |
| product | varchar(25) |
| script | varchar(50) |
| volatile | smallint(5) unsigned |
+--------------+----------------------+

Database: brazzers
Table: affiliates
[8 columns]
+------------+--------------+
| Column | Type |
+------------+--------------+
| email | varchar(128) |
| is_special | binary(1) |
| member_id | bigint(20) |
| password | varchar(16) |
| program | varchar(16) |
| stamp | timestamp |
| status | binary(1) |
| username | varchar(16) |
+------------+--------------+

Database: brazzers
Table: vbbreputationlevel
[2 columns]
+-------------------+------------------+
| Column | Type |
+-------------------+------------------+
| minimumreputation | int(11) |
| reputationlevelid | int(10) unsigned |
+-------------------+------------------+

Database: brazzers
Table: top_models
[5 columns]
+---------------+---------+
| Column | Type |
+---------------+---------+
| model_id | int(11) |
| position | int(11) |
| site_id | int(11) |
| top_model_id | int(11) |
| top_update_id | int(11) |
+---------------+---------+

Database: brazzers
Table: vbbword
[2 columns]
+--------+------------------+
| Column | Type |
+--------+------------------+
| title | char(50) |
| wordid | int(10) unsigned |
+--------+------------------+

Database: brazzers
Table: vbbplugin
[8 columns]
+----------------+----------------------+
| Column | Type |
+----------------+----------------------+
| active | smallint(6) |
| devkey | varchar(25) |
| executionorder | smallint(5) unsigned |
| hookname | varchar(250) |
| phpcode | text |
| pluginid | int(10) unsigned |
| product | varchar(25) |
| title | varchar(250) |
+----------------+----------------------+

Database: brazzers
Table: vbbthreadredirect
[2 columns]
+----------+------------------+
| Column | Type |
+----------+------------------+
| expires | int(10) unsigned |
| threadid | int(10) unsigned |
+----------+------------------+

Database: brazzers
Table: members
[21 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| active | tinyint(1) |
| affiliate | varchar(255) |
| affiliate_db_id | int(11) |
| avatar | varchar(255) |
| date_joined | int(11) |
| email | varchar(255) |
| ets_co_code | varchar(255) |
| ets_email | varchar(255) |
| ets_member_idx | int(11) |
| ets_password | varchar(255) |
| ets_pi_code | varchar(255) |
| ets_username | varchar(255) |
| first_name | varchar(255) |
| last_name | varchar(255) |
| member_id | int(11) |
| nats_site_id | int(11) |
| nickname | varchar(255) |
| password | varchar(255) |
| site_id | int(11) |
| subscription_id | int(11) |
| username | varchar(255) |
+-----------------+--------------+

Database: brazzers
Table: vbbusertitle
[3 columns]
+-------------+----------------------+
| Column | Type |
+-------------+----------------------+
| minposts | int(10) unsigned |
| title | char(250) |
| usertitleid | smallint(5) unsigned |
+-------------+----------------------+

Database: brazzers
Table: vbbuseractivation
[7 columns]
+------------------+----------------------+
| Column | Type |
+------------------+----------------------+
| activationid | bigint(20) unsigned |
| dateline | int(10) unsigned |
| emailchange | smallint(5) unsigned |
| type | smallint(5) unsigned |
| useractivationid | int(10) unsigned |
| usergroupid | smallint(5) unsigned |
| userid | int(10) unsigned |
+------------------+----------------------+

Database: brazzers
Table: vbbdatastore
[3 columns]
+-------------+-------------+
| Column | Type |
+-------------+-------------+
| data | mediumtext |
| title | varchar(50) |
| unserialize | smallint(6) |
+-------------+-------------+

Database: brazzers
Table: tour_site_order
[3 columns]
+---------------+---------+
| Column | Type |
+---------------+---------+
| order_index | int(11) |
| owner_site_id | int(11) |
| site_id | int(11) |
+---------------+---------+

Database: brazzers
Table: employees
[15 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| active | tinyint(1) |
| avatar | varchar(255) |
| date_joined | int(11) |
| display_on_site | tinyint(4) |
| email | varchar(255) |
| employee_id | int(11) |
| first_name | varchar(255) |
| gender | char(1) |
| last_name | varchar(255) |
| nickname | varchar(255) |
| password | varchar(255) |
| photo_site | text |
| position | varchar(255) |
| theme_id | int(11) |
| username | varchar(255) |
+-----------------+--------------+

Database: brazzers
Table: vbbrssfeed
[17 columns]
+-------------------+-------------------------------+
| Column | Type |
+-------------------+-------------------------------+
| bodytemplate | mediumtext |
| endannouncement | int(10) unsigned |
| forumid | smallint(5) unsigned |
| iconid | smallint(5) unsigned |
| itemtype | enum('thread','announcement') |
| lastrun | int(10) unsigned |
| maxresults | smallint(6) |
| options | int(10) unsigned |
| port | smallint(5) unsigned |
| rssfeedid | int(10) unsigned |
| searchwords | mediumtext |
| threadactiondelay | smallint(5) unsigned |
| title | varchar(250) |
| titletemplate | mediumtext |
| ttl | smallint(5) unsigned |
| url | varchar(250) |
| userid | int(10) unsigned |
+-------------------+-------------------------------+

Database: brazzers
Table: vbbtachythreadpost
[5 columns]
+------------+------------------+
| Column | Type |
+------------+------------------+
| lastpost | int(10) unsigned |
| lastposter | varchar(100) |
| lastpostid | int(10) unsigned |
| threadid | int(10) unsigned |
| userid | int(10) unsigned |
+------------+------------------+

Database: brazzers
Table: livecam_categories
[2 columns]
+---------------------+--------------+
| Column | Type |
+---------------------+--------------+
| category_name | varchar(255) |
| livecam_category_id | int(11) |
+---------------------+--------------+

Database: brazzers
Table: vbbpasswordhistory
[3 columns]
+--------------+------------------+
| Column | Type |
+--------------+------------------+
| password | varchar(50) |
| passworddate | date |
| userid | int(10) unsigned |
+--------------+------------------+

Database: brazzers
Table: vbbsubscription
[10 columns]
+----------------+----------------------+
| Column | Type |
+----------------+----------------------+
| active | smallint(5) unsigned |
| adminoptions | int(10) unsigned |
| cost | mediumtext |
| displayorder | smallint(5) unsigned |
| forums | mediumtext |
| membergroupids | varchar(255) |
| nusergroupid | smallint(6) |
| options | int(10) unsigned |
| subscriptionid | smallint(5) unsigned |
| varname | varchar(100) |
+----------------+----------------------+

Database: brazzers
Table: xscore_tour_ratings
[5 columns]
+-------------------+-------------+
| Column | Type |
+-------------------+-------------+
| number_of_ratings | int(11) |
| rating_id | int(11) |
| rating_type | varchar(32) |
| scene_id | int(11) |
| sum_of_ratings | int(11) |
+-------------------+-------------+

Database: brazzers
Table: vbbusergroupleader
[3 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| usergroupid | smallint(5) unsigned |
| usergroupleaderid | smallint(5) unsigned |
| userid | int(10) unsigned |
+-------------------+----------------------+

Database: brazzers
Table: vbbimagecategorypermission
[2 columns]
+-----------------+----------------------+
| Column | Type |
+-----------------+----------------------+
| imagecategoryid | smallint(5) unsigned |
| usergroupid | smallint(5) unsigned |
+-----------------+----------------------+

Database: brazzers
Table: vbbcustomavatar
[8 columns]
+----------+----------------------+
| Column | Type |
+----------+----------------------+
| dateline | int(10) unsigned |
| filedata | mediumblob |
| filename | varchar(100) |
| filesize | int(10) unsigned |
| height | smallint(5) unsigned |
| userid | int(10) unsigned |
| visible | smallint(6) |
| width | smallint(5) unsigned |
+----------+----------------------+

Database: brazzers
Table: job_list
[5 columns]
+------------+------------+
| Column | Type |
+------------+------------+
| command | text |
| job_id | int(11) |
| priority | int(3) |
| running | tinyint(1) |
| time_added | int(11) |
+------------+------------+

Database: brazzers
Table: vbbforum
[27 columns]
+-------------------+-----------------------+
| Column | Type |
+-------------------+-----------------------+
| childlist | text |
| daysprune | smallint(6) |
| defaultsortfield | varchar(50) |
| defaultsortorder | enum('asc','desc') |
| description | text |
| description_clean | text |
| displayorder | smallint(6) |
| forumid | smallint(5) unsigned |
| lasticonid | smallint(6) |
| lastpost | int(11) |
| lastposter | varchar(100) |
| lastpostid | int(10) unsigned |
| lastthread | varchar(250) |
| lastthreadid | int(10) unsigned |
| link | varchar(200) |
| newpostemail | text |
| newthreademail | text |
| options | int(10) unsigned |
| parentid | smallint(6) |
| parentlist | varchar(250) |
| password | varchar(50) |
| replycount | int(10) unsigned |
| showprivate | tinyint(3) unsigned |
| styleid | smallint(5) unsigned |
| threadcount | mediumint(8) unsigned |
| title | varchar(100) |
| title_clean | varchar(100) |
+-------------------+-----------------------+

Database: brazzers
Table: tags_switchboard
[7 columns]
+--------------------+--------------+
| Column | Type |
+--------------------+--------------+
| date_added | int(11) |
| is_active | smallint(1) |
| item_tagged_id | int(11) |
| item_tagged_type | varchar(255) |
| tag_id | int(11) |
| tag_switchboard_id | int(11) |
| tag_type | varchar(255) |
+--------------------+--------------+

Database: brazzers
Table: vbbpaymenttransaction
[10 columns]
+----------------------+----------------------+
| Column | Type |
+----------------------+----------------------+
| amount | double unsigned |
| currency | varchar(5) |
| dateline | int(10) unsigned |
| paymentapiid | int(10) unsigned |
| paymentinfoid | int(10) unsigned |
| paymenttransactionid | int(10) unsigned |
| request | mediumtext |
| reversed | int(10) unsigned |
| state | smallint(5) unsigned |
| transactionid | varchar(250) |
+----------------------+----------------------+

Database: brazzers
Table: vbbuserban
[9 columns]
+----------------+----------------------+
| Column | Type |
+----------------+----------------------+
| adminid | int(10) unsigned |
| bandate | int(10) unsigned |
| customtitle | smallint(6) |
| displaygroupid | smallint(5) unsigned |
| liftdate | int(10) unsigned |
| reason | varchar(250) |
| usergroupid | smallint(5) unsigned |
| userid | int(10) unsigned |
| usertitle | varchar(250) |
+----------------+----------------------+

Database: brazzers
Table: groups
[2 columns]
+------------+--------------+
| Column | Type |
+------------+--------------+
| group_id | int(11) |
| group_name | varchar(255) |
+------------+--------------+

Database: brazzers
Table: vbblanguage
[66 columns]
+------------------------------+----------------------+
| Column | Type |
+------------------------------+----------------------+
| calformat1override | varchar(50) |
| calformat2override | varchar(50) |
| charset | varchar(15) |
| dateoverride | varchar(50) |
| decimalsep | char(1) |
| imagesoverride | varchar(150) |
| languagecode | varchar(12) |
| languageid | smallint(5) unsigned |
| locale | varchar(20) |
| logdateoverride | varchar(50) |
| options | smallint(5) unsigned |
| phrasegroup_accessmask | mediumtext |
| phrasegroup_attachment_image | mediumtext |
| phrasegroup_banning | mediumtext |
| phrasegroup_bbcode | mediumtext |
| phrasegroup_calendar | mediumtext |
| phrasegroup_cpglobal | mediumtext |
| phrasegroup_cphome | mediumtext |
| phrasegroup_cpoption | mediumtext |
| phrasegroup_cppermission | mediumtext |
| phrasegroup_cprank | mediumtext |
| phrasegroup_cprofilefield | mediumtext |
| phrasegroup_cpuser | mediumtext |
| phrasegroup_cpusergroup | mediumtext |
| phrasegroup_cron | mediumtext |
| phrasegroup_diagnostic | mediumtext |
| phrasegroup_forum | mediumtext |
| phrasegroup_forumdisplay | mediumtext |
| phrasegroup_fronthelp | mediumtext |
| phrasegroup_global | mediumtext |
| phrasegroup_help_faq | mediumtext |
| phrasegroup_holiday | mediumtext |
| phrasegroup_infraction | mediumtext |
| phrasegroup_infractionlevel | mediumtext |
| phrasegroup_inlinemod | mediumtext |
| phrasegroup_language | mediumtext |
| phrasegroup_logging | mediumtext |
| phrasegroup_maintenance | mediumtext |
| phrasegroup_messaging | mediumtext |
| phrasegroup_moderator | mediumtext |
| phrasegroup_plugins | mediumtext |
| phrasegroup_pm | mediumtext |
| phrasegroup_poll | mediumtext |
| phrasegroup_postbit | mediumtext |
| phrasegroup_posting | mediumtext |
| phrasegroup_profilefield | mediumtext |
| phrasegroup_promotion | mediumtext |
| phrasegroup_register | mediumtext |
| phrasegroup_reputation | mediumtext |
| phrasegroup_reputationlevel | mediumtext |
| phrasegroup_search | mediumtext |
| phrasegroup_showthread | mediumtext |
| phrasegroup_sql | mediumtext |
| phrasegroup_stats | mediumtext |
| phrasegroup_style | mediumtext |
| phrasegroup_subscription | mediumtext |
| phrasegroup_thread | mediumtext |
| phrasegroup_threadmanage | mediumtext |
| phrasegroup_timezone | mediumtext |
| phrasegroup_user | mediumtext |
| phrasegroup_wol | mediumtext |
| registereddateoverride | varchar(50) |
| thousandsep | char(1) |
| timeoverride | varchar(50) |
| title | varchar(50) |
| userselect | smallint(5) unsigned |
+------------------------------+----------------------+

Database: brazzers
Table: vbbprofilefieldcategory
[2 columns]
+------------------------+----------------------+
| Column | Type |
+------------------------+----------------------+
| displayorder | smallint(6) |
| profilefieldcategoryid | smallint(5) unsigned |
+------------------------+----------------------+

Database: brazzers
Table: vbbuserfield
[6 columns]
+--------+------------------+
| Column | Type |
+--------+------------------+
| field1 | mediumtext |
| field2 | mediumtext |
| field3 | mediumtext |
| field4 | mediumtext |
| temp | mediumtext |
| userid | int(10) unsigned |
+--------+------------------+

Database: brazzers
Table: vbbreputation
[7 columns]
+--------------+------------------+
| Column | Type |
+--------------+------------------+
| dateline | int(11) |
| postid | int(11) |
| reason | varchar(250) |
| reputation | int(11) |
| reputationid | int(10) unsigned |
| userid | int(11) |
| whoadded | int(11) |
+--------------+------------------+

Database: brazzers
Table: vbbpodcast
[12 columns]
+------------+------------------+
| Column | Type |
+------------+------------------+
| author | varchar(255) |
| category | varchar(255) |
| categoryid | smallint(6) |
| enabled | smallint(6) |
| explicit | smallint(6) |
| forumid | int(10) unsigned |
| image | varchar(255) |
| keywords | varchar(255) |
| owneremail | varchar(255) |
| ownername | varchar(255) |
| subtitle | varchar(255) |
| summary | mediumtext |
+------------+------------------+

Database: brazzers
Table: playlists_pictures
[2 columns]
+-------------+---------+
| Column | Type |
+-------------+---------+
| picture_id | int(11) |
| playlist_id | int(11) |
+-------------+---------+

Database: brazzers
Table: forums
[3 columns]
+------------+--------------+
| Column | Type |
+------------+--------------+
| forum_id | int(11) |
| forum_name | varchar(255) |
| url | varchar(255) |
+------------+--------------+

Database: brazzers
Table: vbbinfractionlevel
[6 columns]
+-------------------+-----------------------+
| Column | Type |
+-------------------+-----------------------+
| expires | int(10) unsigned |
| extend | smallint(5) unsigned |
| infractionlevelid | int(10) unsigned |
| period | enum('H','D','M','N') |
| points | int(10) unsigned |
| warning | smallint(5) unsigned |
+-------------------+-----------------------+

Database: brazzers
Table: vbbsubscribeforum
[4 columns]
+------------------+----------------------+
| Column | Type |
+------------------+----------------------+
| emailupdate | smallint(5) unsigned |
| forumid | smallint(5) unsigned |
| subscribeforumid | int(10) unsigned |
| userid | int(10) unsigned |
+------------------+----------------------+

Database: brazzers
Table: vbbadministrator
[7 columns]
+------------------+----------------------+
| Column | Type |
+------------------+----------------------+
| adminpermissions | int(10) unsigned |
| cssprefs | varchar(250) |
| dismissednews | text |
| languageid | smallint(5) unsigned |
| navprefs | mediumtext |
| notes | mediumtext |
| userid | int(10) unsigned |
+------------------+----------------------+

Database: brazzers
Table: vbbadminutil
[2 columns]
+--------+-------------+
| Column | Type |
+--------+-------------+
| text | mediumtext |
| title | varchar(50) |
+--------+-------------+

Database: brazzers
Table: vbbpm
[5 columns]
+-------------+----------------------+
| Column | Type |
+-------------+----------------------+
| folderid | smallint(6) |
| messageread | smallint(5) unsigned |
| pmid | int(10) unsigned |
| pmtextid | int(10) unsigned |
| userid | int(10) unsigned |
+-------------+----------------------+

Database: brazzers
Table: vbbmoderator
[4 columns]
+-------------+----------------------+
| Column | Type |
+-------------+----------------------+
| forumid | smallint(6) |
| moderatorid | smallint(5) unsigned |
| permissions | int(10) unsigned |
| userid | int(10) unsigned |
+-------------+----------------------+

Database: brazzers
Table: vbbsetting
[12 columns]
+----------------+-------------------------------------------------------+
| Column | Type |
+----------------+-------------------------------------------------------+
| advanced | smallint(6) |
| blacklist | smallint(6) |
| datatype | enum('free','number','boolean','bitfield','usernam e') |
| defaultvalue | mediumtext |
| displayorder | smallint(5) unsigned |
| grouptitle | varchar(50) |
| optioncode | mediumtext |
| product | varchar(25) |
| validationcode | text |
| value | mediumtext |
| varname | varchar(100) |
| volatile | smallint(5) unsigned |
+----------------+-------------------------------------------------------+

Database: brazzers
Table: spot_buyer_sites
[4 columns]
+---------------+------------+
| Column | Type |
+---------------+------------+
| onclick_url | text |
| site_id | int(11) |
| spot_buyer_id | int(11) |
| trailer | tinyint(1) |
+---------------+------------+

Database: brazzers
Table: vbbsettinggroup
[4 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| displayorder | smallint(5) unsigned |
| grouptitle | varchar(50) |
| product | varchar(25) |
| volatile | smallint(5) unsigned |
+--------------+----------------------+

Database: brazzers
Table: upsells
[5 columns]
+------------------+--------------+
| Column | Type |
+------------------+--------------+
| is_global | tinyint(1) |
| program | varchar(255) |
| upsell_html_code | text |
| upsell_id | int(11) |
| upsell_name | varchar(255) |
+------------------+--------------+

Database: brazzers
Table: vbbannouncementread
[2 columns]
+----------------+------------------+
| Column | Type |
+----------------+------------------+
| announcementid | int(10) unsigned |
| userid | int(10) unsigned |
+----------------+------------------+

Database: brazzers
Table: vbbthreadrate
[5 columns]
+--------------+------------------+
| Column | Type |
+--------------+------------------+
| ipaddress | char(15) |
| threadid | int(10) unsigned |
| threadrateid | int(10) unsigned |
| userid | int(10) unsigned |
| vote | smallint(6) |
+--------------+------------------+

Database: brazzers
Table: vbbinfractiongroup
[5 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| infractiongroupid | int(10) unsigned |
| orusergroupid | smallint(5) unsigned |
| override | smallint(5) unsigned |
| pointlevel | int(10) unsigned |
| usergroupid | int(11) |
+-------------------+----------------------+

Database: brazzers
Table: vbbfaq
[5 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| displayorder | smallint(5) unsigned |
| faqname | varchar(250) |
| faqparent | varchar(50) |
| product | varchar(25) |
| volatile | smallint(5) unsigned |
+--------------+----------------------+

Database: brazzers
Table: vbbproductcode
[5 columns]
+---------------+------------------+
| Column | Type |
+---------------+------------------+
| installcode | mediumtext |
| productcodeid | int(10) unsigned |
| productid | varchar(25) |
| uninstallcode | mediumtext |
| version | varchar(25) |
+---------------+------------------+

Database: brazzers
Table: sites_upsells
[3 columns]
+-----------+------------+
| Column | Type |
+-----------+------------+
| on_home | tinyint(1) |
| site_id | int(11) |
| upsell_id | int(11) |
+-----------+------------+

Database: brazzers
Table: vbbpaymentinfo
[6 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| completed | smallint(6) |
| hash | varchar(32) |
| paymentinfoid | int(10) unsigned |
| subscriptionid | smallint(5) unsigned |
| subscriptionsubid | smallint(5) unsigned |
| userid | int(10) unsigned |
+-------------------+----------------------+

Database: brazzers
Table: vbbpoll
[12 columns]
+---------------+----------------------+
| Column | Type |
+---------------+----------------------+
| active | smallint(6) |
| dateline | int(10) unsigned |
| lastvote | int(10) unsigned |
| multiple | smallint(5) unsigned |
| numberoptions | smallint(5) unsigned |
| options | text |
| pollid | int(10) unsigned |
| public | smallint(6) |
| question | varchar(100) |
| timeout | smallint(5) unsigned |
| voters | smallint(5) unsigned |
| votes | text |
+---------------+----------------------+

Database: brazzers
Table: polls
[6 columns]
+------------+--------------+
| Column | Type |
+------------+--------------+
| date_added | int(11) |
| end_date | int(11) |
| poll_id | int(11) |
| poll_name | varchar(255) |
| question | varchar(255) |
| start_date | int(11) |
+------------+--------------+

Database: brazzers
Table: polls_sites
[2 columns]
+---------+---------+
| Column | Type |
+---------+---------+
| poll_id | int(11) |
| site_id | int(11) |
+---------+---------+

Database: brazzers
Table: scenes
[31 columns]
+--------------------------+--------------+
| Column | Type |
+--------------------------+--------------+
| date_added | int(11) |
| description | text |
| dynamic_rating_num_votes | int(11) |
| dynamic_rating_sum_votes | int(11) |
| featured_position | int(11) |
| folder_name | varchar(255) |
| has_preview | tinyint(4) |
| has_trailer | tinyint(1) |
| health | double |
| is_accessible | tinyint(1) |
| is_active | tinyint(1) |
| is_on_mega_site_tour | tinyint(1) |
| is_on_tour | tinyint(1) |
| is_trial_scene | tinyint(1) |
| num_of_hq_pics | int(11) |
| num_of_screen_caps | int(11) |
| num_times_viewed | int(11) |
| rating_total | double |
| scene_id | int(11) |
| scene_name | varchar(255) |
| scene_title | varchar(255) |
| scene_type | varchar(255) |
| show_search_trailer | tinyint(1) |
| site_active | tinyint(1) |
| site_id | int(11) |
| total_ratings | int(11) |
| tour_position | int(4) |
| xs_episode_joins | int(11) |
| xs_score | double |
| xs_trailer_hits | int(11) |
| xs_trailer_joins | int(11) |
+--------------------------+--------------+

Database: brazzers
Table: vbbproductdependency
[6 columns]
+---------------------+-------------+
| Column | Type |
+---------------------+-------------+
| dependencytype | varchar(25) |
| maxversion | varchar(50) |
| minversion | varchar(50) |
| parentproductid | varchar(25) |
| productdependencyid | int(11) |
| productid | varchar(25) |
+---------------------+-------------+

Database: brazzers
Table: vbbpost
[16 columns]
+----------------+----------------------+
| Column | Type |
+----------------+----------------------+
| allowsmilie | smallint(6) |
| attach | smallint(5) unsigned |
| dateline | int(10) unsigned |
| iconid | smallint(5) unsigned |
| infraction | smallint(5) unsigned |
| ipaddress | varchar(15) |
| pagetext | mediumtext |
| parentid | int(10) unsigned |
| postid | int(10) unsigned |
| reportthreadid | int(10) unsigned |
| showsignature | smallint(6) |
| threadid | int(10) unsigned |
| title | varchar(250) |
| userid | int(10) unsigned |
| username | varchar(100) |
| visible | smallint(6) |
+----------------+----------------------+

Database: brazzers
Table: vbbcronlog
[5 columns]
+-------------+----------------------+
| Column | Type |
+-------------+----------------------+
| cronlogid | int(10) unsigned |
| dateline | int(10) unsigned |
| description | mediumtext |
| type | smallint(5) unsigned |
| varname | varchar(100) |
+-------------+----------------------+

Database: brazzers
Table: vbbphrasetype
[5 columns]
+-----------+----------------------+
| Column | Type |
+-----------+----------------------+
| editrows | smallint(5) unsigned |
| fieldname | varchar(20) |
| product | varchar(25) |
| special | smallint(5) unsigned |
| title | varchar(50) |
+-----------+----------------------+

Database: brazzers
Table: vbbprofilefield
[19 columns]
+------------------------+------------------------------------------------------------------------+
| Column | Type |
+------------------------+------------------------------------------------------------------------+
| data | mediumtext |
| def | smallint(6) |
| displayorder | smallint(6) |
| editable | smallint(6) |
| form | smallint(6) |
| height | smallint(6) |
| hidden | smallint(6) |
| html | smallint(6) |
| maxlength | smallint(6) |
| memberlist | smallint(6) |
| optional | smallint(5) unsigned |
| perline | smallint(6) |
| profilefieldcategoryid | smallint(5) unsigned |
| profilefieldid | smallint(5) unsigned |
| regex | varchar(255) |
| required | smallint(6) |
| searchable | smallint(6) |
| size | smallint(6) |
| type | enum('input','select','radio','textarea','checkbox ','select_multiple') |
+------------------------+------------------------------------------------------------------------+

Database: brazzers
Table: vbbholiday
[5 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| allowsmilies | smallint(6) |
| holidayid | int(10) unsigned |
| recuroption | varchar(6) |
| recurring | smallint(5) unsigned |
| varname | varchar(100) |
+--------------+----------------------+

Database: brazzers
Table: blogs
[6 columns]
+---------------+--------------+
| Column | Type |
+---------------+--------------+
| blog_id | int(11) |
| blog_name | varchar(255) |
| date_added | int(11) |
| user_id | int(11) |
| user_nickname | varchar(255) |
| user_type | varchar(255) |
+---------------+--------------+

Database: brazzers
Table: vbbinfraction
[15 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| action | smallint(5) unsigned |
| actiondateline | int(10) unsigned |
| actionreason | varchar(255) |
| actionuserid | int(10) unsigned |
| customreason | varchar(255) |
| dateline | int(10) unsigned |
| expires | int(10) unsigned |
| infractionid | int(10) unsigned |
| infractionlevelid | int(10) unsigned |
| note | varchar(255) |
| points | int(10) unsigned |
| postid | int(10) unsigned |
| threadid | int(10) unsigned |
| userid | int(10) unsigned |
| whoadded | int(10) unsigned |
+-------------------+----------------------+

Database: brazzers
Table: playlists
[5 columns]
+---------------+--------------+
| Column | Type |
+---------------+--------------+
| date_added | int(11) |
| is_shared | tinyint(1) |
| member_id | int(11) |
| playlist_id | int(11) |
| playlist_name | varchar(255) |
+---------------+--------------+

Database: brazzers
Table: vbbpodcastitem
[7 columns]
+----------+----------------------+
| Column | Type |
+----------+----------------------+
| author | varchar(255) |
| explicit | smallint(5) unsigned |
| keywords | varchar(255) |
| length | int(10) unsigned |
| postid | int(10) unsigned |
| subtitle | varchar(255) |
| url | varchar(255) |
+----------+----------------------+

Database: brazzers
Table: videos
[8 columns]
+----------------------+------------------+
| Column | Type |
+----------------------+------------------+
| dynamic_rating_total | int(11) unsigned |
| dynamic_total_rating | int(11) unsigned |
| filename | varchar(255) |
| rating_total | int(11) unsigned |
| scene_id | int(11) |
| total_ratings | int(11) unsigned |
| type | varchar(255) |
| video_id | int(11) |
+----------------------+------------------+

Database: brazzers
Table: vbbcalendarcustomfield
[8 columns]
+-----------------------+----------------------+
| Column | Type |
+-----------------------+----------------------+
| allowentry | smallint(6) |
| calendarcustomfieldid | int(10) unsigned |
| calendarid | int(10) unsigned |
| description | mediumtext |
| length | smallint(5) unsigned |
| options | mediumtext |
| required | smallint(6) |
| title | varchar(255) |
+-----------------------+----------------------+

Database: brazzers
Table: vbbregimage
[4 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| dateline | int(10) unsigned |
| imagestamp | char(6) |
| regimagehash | char(32) |
| viewed | smallint(5) unsigned |
+--------------+----------------------+

Database: brazzers
Table: xscore_variables
[24 columns]
+-------------------------------+------------+
| Column | Type |
+-------------------------------+------------+
| age_coefficient | double |
| desired_ratio | float |
| episode_rating_buff | int(3) |
| episode_to_join_coefficient | double |
| good_segments | int(5) |
| joins_at_last_good_segment | int(11) |
| joins_at_start | int(11) |
| last_rotation | int(11) |
| member_rating_coefficient | double |
| midnight | tinyint(1) |
| minimum_trailer_rating | float |
| number_of_home_trailers | int(11) |
| rated_scene_position | int(11) |
| scene_rating_coefficient | double |
| site_id | int(11) |
| trailer_rating_buff | int(3) |
| trailer_rating_coefficient | double |
| trailer_to_join_coefficient | double |
| trailer_visits_coefficient | double |
| unique_tour_visitors | bigint(11) |
| unique_tour_visitors_temp | bigint(11) |
| visitors_at_last_good_segment | int(11) |
| visitors_at_start | int(11) |
| visits_per_rotation | int(11) |
+-------------------------------+------------+

Database: brazzers
Table: vbbattachment
[15 columns]
+--------------------+----------------------+
| Column | Type |
+--------------------+----------------------+
| attachmentid | int(10) unsigned |
| counter | int(10) unsigned |
| dateline | int(10) unsigned |
| extension | varchar(20) |
| filedata | mediumblob |
| filehash | varchar(32) |
| filename | varchar(100) |
| filesize | int(10) unsigned |
| posthash | varchar(32) |
| postid | int(10) unsigned |
| thumbnail | mediumblob |
| thumbnail_dateline | int(10) unsigned |
| thumbnail_filesize | int(10) unsigned |
| userid | int(10) unsigned |
| visible | smallint(5) unsigned |
+--------------------+----------------------+

Database: brazzers
Table: vbbthread
[24 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| attach | smallint(5) unsigned |
| dateline | int(10) unsigned |
| deletedcount | int(10) unsigned |
| firstpostid | int(10) unsigned |
| forumid | smallint(5) unsigned |
| hiddencount | int(10) unsigned |
| iconid | smallint(5) unsigned |
| lastpost | int(10) unsigned |
| lastposter | varchar(50) |
| lastpostid | int(10) unsigned |
| notes | varchar(250) |
| open | smallint(6) |
| pollid | int(10) unsigned |
| postuserid | int(10) unsigned |
| postusername | varchar(100) |
| replycount | int(10) unsigned |
| similar | varchar(55) |
| sticky | smallint(6) |
| threadid | int(10) unsigned |
| title | varchar(250) |
| views | int(10) unsigned |
| visible | smallint(6) |
| votenum | smallint(5) unsigned |
| votetotal | smallint(5) unsigned |
+--------------+----------------------+

Database: brazzers
Table: completed_conversions
[2 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| folder_name | text |
| site_short_name | varchar(255) |
+-----------------+--------------+

Database: brazzers
Table: vbbattachmenttype
[9 columns]
+-----------+----------------------+
| Column | Type |
+-----------+----------------------+
| display | smallint(5) unsigned |
| enabled | smallint(5) unsigned |
| extension | varchar(20) |
| height | smallint(5) unsigned |
| mimetype | varchar(255) |
| newwindow | smallint(5) unsigned |
| size | int(10) unsigned |
| thumbnail | smallint(5) unsigned |
| width | smallint(5) unsigned |
+-----------+----------------------+

Database: brazzers
Table: vbbusertextfield
[8 columns]
+-------------+------------------+
| Column | Type |
+-------------+------------------+
| buddylist | mediumtext |
| ignorelist | mediumtext |
| pmfolders | mediumtext |
| rank | mediumtext |
| searchprefs | mediumtext |
| signature | mediumtext |
| subfolders | mediumtext |
| userid | int(10) unsigned |
+-------------+------------------+

Database: brazzers
Table: vbbusergroup
[35 columns]
+----------------------+----------------------+
| Column | Type |
+----------------------+----------------------+
| adminpermissions | int(10) unsigned |
| attachlimit | int(10) unsigned |
| avatarmaxheight | smallint(5) unsigned |
| avatarmaxsize | int(10) unsigned |
| avatarmaxwidth | smallint(5) unsigned |
| calendarpermissions | int(10) unsigned |
| canoverride | smallint(5) unsigned |
| closetag | varchar(100) |
| description | varchar(250) |
| forumpermissions | int(10) unsigned |
| genericoptions | int(10) unsigned |
| genericpermissions | int(10) unsigned |
| ispublicgroup | smallint(5) unsigned |
| opentag | varchar(100) |
| passwordexpires | smallint(5) unsigned |
| passwordhistory | smallint(5) unsigned |
| pmpermissions | int(10) unsigned |
| pmquota | smallint(5) unsigned |
| pmsendmax | smallint(5) unsigned |
| profilepicmaxheight | smallint(5) unsigned |
| profilepicmaxsize | int(10) unsigned |
| profilepicmaxwidth | smallint(5) unsigned |
| sigmaxchars | smallint(5) unsigned |
| sigmaximages | smallint(5) unsigned |
| sigmaxlines | smallint(5) unsigned |
| sigmaxrawchars | smallint(5) unsigned |
| sigmaxsizebbcode | smallint(5) unsigned |
| signaturepermissions | int(10) unsigned |
| sigpicmaxheight | smallint(5) unsigned |
| sigpicmaxsize | int(10) unsigned |
| sigpicmaxwidth | smallint(5) unsigned |
| title | varchar(100) |
| usergroupid | smallint(5) unsigned |
| usertitle | varchar(100) |
| wolpermissions | int(10) unsigned |
+----------------------+----------------------+

Database: brazzers
Table: vbbthreadread
[3 columns]
+----------+------------------+
| Column | Type |
+----------+------------------+
| readtime | int(10) unsigned |
| threadid | int(10) unsigned |
| userid | int(10) unsigned |
+----------+------------------+

Database: brazzers
Table: favorites_folders
[5 columns]
+------------------+--------------+
| Column | Type |
+------------------+--------------+
| folder_id | int(11) |
| folder_name | varchar(255) |
| folder_type | varchar(255) |
| member_id | int(11) |
| parent_folder_id | int(11) |
+------------------+--------------+

Database: brazzers
Table: vbbpaymentapi
[7 columns]
+--------------+------------------+
| Column | Type |
+--------------+------------------+
| active | smallint(6) |
| classname | varchar(250) |
| currency | varchar(250) |
| paymentapiid | int(10) unsigned |
| recurring | smallint(6) |
| settings | mediumtext |
| title | varchar(250) |
+--------------+------------------+

Database: brazzers
Table: vbbuserpromotion
[8 columns]
+-----------------+------------------+
| Column | Type |
+-----------------+------------------+
| date | int(10) unsigned |
| joinusergroupid | int(10) unsigned |
| posts | int(10) unsigned |
| reputation | int(11) |
| strategy | smallint(6) |
| type | smallint(6) |
| usergroupid | int(10) unsigned |
| userpromotionid | int(10) unsigned |
+-----------------+------------------+

Database: brazzers
Table: job_globals
[2 columns]
+---------+---------+
| Column | Type |
+---------+---------+
| minute | int(11) |
| site_id | int(11) |
+---------+---------+

Database: brazzers
Table: vbbinfractionban
[6 columns]
+-----------------+------------------------------+
| Column | Type |
+-----------------+------------------------------+
| amount | int(10) unsigned |
| banusergroupid | int(10) unsigned |
| infractionbanid | int(10) unsigned |
| method | enum('points','infractions') |
| period | char(5) |
| usergroupid | int(11) |
+-----------------+------------------------------+

Database: brazzers
Table: announcements
[7 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| announcement | text |
| announcement_id | int(11) |
| date_added | int(11) |
| employee_id | int(255) |
| end_date | int(11) |
| start_date | int(11) |
| subject | varchar(255) |
+-----------------+--------------+

Database: brazzers
Table: vbbstyle
[12 columns]
+--------------+----------------------+
| Column | Type |
+--------------+----------------------+
| css | mediumtext |
| csscolors | mediumtext |
| displayorder | smallint(5) unsigned |
| editorstyles | mediumtext |
| parentid | smallint(6) |
| parentlist | varchar(250) |
| replacements | mediumtext |
| styleid | smallint(5) unsigned |
| stylevars | mediumtext |
| templatelist | mediumtext |
| title | varchar(250) |
| userselect | smallint(5) unsigned |
+--------------+----------------------+

Database: brazzers
Table: models
[10 columns]
+--------------------------+--------------+
| Column | Type |
+--------------------------+--------------+
| bio | text |
| date_added | int(11) |
| dynamic_rating_num_votes | int(11) |
| dynamic_rating_sum_votes | int(11) |
| is_active | tinyint(1) |
| model_id | int(11) |
| model_name | varchar(255) |
| pic | varchar(255) |
| rating_total | double |
| total_ratings | int(11) |
+--------------------------+--------------+

Database: brazzers
Table: vbbforumpermission
[4 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| forumid | smallint(5) unsigned |
| forumpermissionid | smallint(5) unsigned |
| forumpermissions | int(10) unsigned |
| usergroupid | smallint(5) unsigned |
+-------------------+----------------------+

Database: brazzers
Table: vbbcalendar
[14 columns]
+---------------+----------------------+
| Column | Type |
+---------------+----------------------+
| birthdaycount | smallint(5) unsigned |
| calendarid | int(10) unsigned |
| cutoff | smallint(5) unsigned |
| description | varchar(100) |
| displayorder | smallint(6) |
| endyear | smallint(5) unsigned |
| eventcount | smallint(5) unsigned |
| holidays | int(10) unsigned |
| moderatenew | smallint(6) |
| neweventemail | text |
| options | int(10) unsigned |
| startofweek | smallint(6) |
| startyear | smallint(5) unsigned |
| title | varchar(255) |
+---------------+----------------------+

Database: brazzers
Table: vbbavatar
[6 columns]
+-----------------+----------------------+
| Column | Type |
+-----------------+----------------------+
| avatarid | smallint(5) unsigned |
| avatarpath | varchar(100) |
| displayorder | smallint(5) unsigned |
| imagecategoryid | smallint(5) unsigned |
| minimumposts | int(10) unsigned |
| title | varchar(100) |
+-----------------+----------------------+

Database: brazzers
Table: vbbpostparsed
[6 columns]
+---------------+----------------------+
| Column | Type |
+---------------+----------------------+
| dateline | int(10) unsigned |
| hasimages | smallint(6) |
| languageid | smallint(5) unsigned |
| pagetext_html | mediumtext |
| postid | int(10) unsigned |
| styleid | smallint(5) unsigned |
+---------------+----------------------+

Database: brazzers
Table: vbbsession
[16 columns]
+---------------+----------------------+
| Column | Type |
+---------------+----------------------+
| badlocation | smallint(5) unsigned |
| bypass | tinyint(4) |
| host | char(15) |
| idhash | char(32) |
| incalendar | smallint(5) unsigned |
| inforum | smallint(5) unsigned |
| inthread | int(10) unsigned |
| languageid | smallint(5) unsigned |
| lastactivity | int(10) unsigned |
| location | char(255) |
| loggedin | smallint(5) unsigned |
| profileupdate | smallint(5) unsigned |
| sessionhash | char(32) |
| styleid | smallint(5) unsigned |
| useragent | char(100) |
| userid | int(10) unsigned |
+---------------+----------------------+

Database: brazzers
Table: tags_switchboard_test
[7 columns]
+--------------------+--------------+
| Column | Type |
+--------------------+--------------+
| date_added | int(11) |
| is_active | tinyint(4) |
| item_tagged_id | int(11) |
| item_tagged_type | varchar(255) |
| tag_id | int(11) |
| tag_switchboard_id | int(11) |
| tag_type | varchar(255) |
+--------------------+--------------+

Database: brazzers
Table: vbbcron
[12 columns]
+----------+----------------------+
| Column | Type |
+----------+----------------------+
| active | smallint(6) |
| cronid | int(10) unsigned |
| day | smallint(6) |
| filename | varchar(50) |
| hour | smallint(6) |
| loglevel | smallint(6) |
| minute | varchar(100) |
| nextrun | int(10) unsigned |
| product | varchar(25) |
| varname | varchar(100) |
| volatile | smallint(5) unsigned |
| weekday | smallint(6) |
+----------+----------------------+

Database: brazzers
Table: static_uploads
[3 columns]
+------------------+--------------+
| Column | Type |
+------------------+--------------+
| folder_name | varchar(255) |
| last_update_time | int(11) |
| site_id | int(11) |
+------------------+--------------+

Database: brazzers
Table: vbbbbcode
[8 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| bbcodeexample | varchar(200) |
| bbcodeexplanation | mediumtext |
| bbcodeid | smallint(5) unsigned |
| bbcodereplacement | mediumtext |
| bbcodetag | varchar(200) |
| buttonimage | varchar(250) |
| title | varchar(100) |
| twoparams | smallint(6) |
+-------------------+----------------------+

Database: brazzers
Table: vbbthreadviews
[1 column]
+----------+------------------+
| Column | Type |
+----------+------------------+
| threadid | int(10) unsigned |
+----------+------------------+

Database: brazzers
Table: vbbstats
[5 columns]
+----------+-----------------------+
| Column | Type |
+----------+-----------------------+
| ausers | mediumint(8) unsigned |
| dateline | int(10) unsigned |
| npost | mediumint(8) unsigned |
| nthread | mediumint(8) unsigned |
| nuser | mediumint(8) unsigned |
+----------+-----------------------+

Database: brazzers
Table: playlists_videos
[2 columns]
+-------------+---------+
| Column | Type |
+-------------+---------+
| playlist_id | int(11) |
| video_id | int(11) |
+-------------+---------+

Database: brazzers
Table: xscore_scene_queue
[3 columns]
+----------+---------+
| Column | Type |
+----------+---------+
| rank | int(11) |
| scene_id | int(11) |
| site_id | int(11) |
+----------+---------+

Database: brazzers
Table: vbbeditlog
[5 columns]
+----------+------------------+
| Column | Type |
+----------+------------------+
| dateline | int(10) unsigned |
| postid | int(10) unsigned |
| reason | varchar(200) |
| userid | int(10) unsigned |
| username | varchar(100) |
+----------+------------------+

Database: brazzers
Table: vbbimagecategory
[4 columns]
+-----------------+----------------------+
| Column | Type |
+-----------------+----------------------+
| displayorder | smallint(5) unsigned |
| imagecategoryid | smallint(5) unsigned |
| imagetype | smallint(5) unsigned |
| title | varchar(255) |
+-----------------+----------------------+

Database: brazzers
Table: jobs_sites
[2 columns]
+---------+---------+
| Column | Type |
+---------+---------+
| job_id | int(11) |
| site_id | int(11) |
+---------+---------+

Database: brazzers
Table: vbbtemplatehistory
[8 columns]
+-------------------+----------------------+
| Column | Type |
+-------------------+----------------------+
| comment | varchar(255) |
| dateline | int(10) unsigned |
| styleid | smallint(5) unsigned |
| template | mediumtext |
| templatehistoryid | int(10) unsigned |
| title | varchar(100) |
| username | varchar(100) |
| version | varchar(30) |
+-------------------+----------------------+

Database: brazzers
Table: ratings_switchboard
[8 columns]
+-----------------------+--------------+
| Column | Type |
+-----------------------+--------------+
| date_added | int(11) |
| item_rated_id | int(11) |
| item_rated_type | varchar(255) |
| rating | double |
| rating_switchboard_id | int(11) |
| user_id | int(11) |
| user_ip | varchar(15) |
| user_type | varchar(255) |
+-----------------------+--------------+

Database: brazzers
Table: employees_groups
[2 columns]
+-------------+---------+
| Column | Type |
+-------------+---------+
| employee_id | int(11) |
| group_id | int(11) |
+-------------+---------+

Database: brazzers
Table: spot_buyer_scenes_potential_sales
[3 columns]
+---------------------+-------------+
| Column | Type |
+---------------------+-------------+
| date_added | int(11) |
| ip | varchar(15) |
| spot_buyer_scene_id | int(11) |
+---------------------+-------------+

Database: brazzers
Table: dvds_scenes
[2 columns]
+----------+---------+
| Column | Type |
+----------+---------+
| dvd_id | int(11) |
| scene_id | int(11) |
+----------+---------+

Database: brazzers
Table: vbbsigparsed
[5 columns]
+-----------------+----------------------+
| Column | Type |
+-----------------+----------------------+
| hasimages | smallint(5) unsigned |
| languageid | smallint(5) unsigned |
| signatureparsed | mediumtext |
| styleid | smallint(5) unsigned |
| userid | int(10) unsigned |
+-----------------+----------------------+

Database: brazzers
Table: vbbforumread
[3 columns]
+----------+----------------------+
| Column | Type |
+----------+----------------------+
| forumid | smallint(5) unsigned |
| readtime | int(10) unsigned |
| userid | int(10) unsigned |
+----------+----------------------+

More & Shell && Rooted.

// (c) r00tw0rm team, Xenu