Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement