daily pastebin goal
46%
SHARE
TWEET

Untitled

satsura Jan 16th, 2012 1,371 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Database:[*] brazzers[*] information_schema[*] mansefcom[*] manwin_cy[*] manwin_de[*] manwin_lu[*] updates[*] updates_dds[*] updates_tmp
  2.  
  3. Database: brazzers
  4. Table: vbbusernote
  5. [8 columns]
  6. +--------------+------------------+
  7. | Column | Type |
  8. +--------------+------------------+
  9. | allowsmilies | smallint(6) |
  10. | dateline | int(10) unsigned |
  11. | message | mediumtext |
  12. | posterid | int(10) unsigned |
  13. | title | varchar(255) |
  14. | userid | int(10) unsigned |
  15. | username | varchar(100) |
  16. | usernoteid | int(10) unsigned |
  17. +--------------+------------------+
  18.  
  19. Database: brazzers
  20. Table: vbbsmilie
  21. [6 columns]
  22. +-----------------+----------------------+
  23. | Column | Type |
  24. +-----------------+----------------------+
  25. | displayorder | smallint(5) unsigned |
  26. | imagecategoryid | smallint(5) unsigned |
  27. | smilieid | smallint(5) unsigned |
  28. | smiliepath | char(100) |
  29. | smilietext | char(20) |
  30. | title | char(100) |
  31. +-----------------+----------------------+
  32.  
  33. Database: brazzers
  34. Table: poll_votes
  35. [6 columns]
  36. +----------------+--------------+
  37. | Column | Type |
  38. +----------------+--------------+
  39. | date_added | int(11) |
  40. | poll_id | int(11) |
  41. | poll_option_id | int(11) |
  42. | poll_vote_id | int(11) |
  43. | user_id | int(11) |
  44. | user_type | varchar(255) |
  45. +----------------+--------------+
  46.  
  47. Database: brazzers
  48. Table: poll_options
  49. [4 columns]
  50. +----------------+---------+
  51. | Column | Type |
  52. +----------------+---------+
  53. | option_text | text |
  54. | poll_id | int(11) |
  55. | poll_option_id | int(11) |
  56. | total_votes | int(11) |
  57. +----------------+---------+
  58.  
  59. Database: brazzers
  60. Table: feedback
  61. [8 columns]
  62. +---------------+--------------+
  63. | Column | Type |
  64. +---------------+--------------+
  65. | date_added | int(11) |
  66. | description | text |
  67. | feedback_id | int(11) |
  68. | feedback_type | varchar(255) |
  69. | site_id | int(11) |
  70. | user_id | int(11) |
  71. | user_nickname | varchar(255) |
  72. | user_type | varchar(255) |
  73. +---------------+--------------+
  74.  
  75. Database: brazzers
  76. Table: profile_fields
  77. [5 columns]
  78. +------------------+--------------+
  79. | Column | Type |
  80. +------------------+--------------+
  81. | field | varchar(255) |
  82. | profile_field_id | int(11) |
  83. | user_id | int(11) |
  84. | user_type | varchar(255) |
  85. | value | varchar(255) |
  86. +------------------+--------------+
  87.  
  88. Database: brazzers
  89. Table: vbbsubscribethread
  90. [6 columns]
  91. +-------------------+----------------------+
  92. | Column | Type |
  93. +-------------------+----------------------+
  94. | canview | smallint(5) unsigned |
  95. | emailupdate | smallint(5) unsigned |
  96. | folderid | int(10) unsigned |
  97. | subscribethreadid | int(10) unsigned |
  98. | threadid | int(10) unsigned |
  99. | userid | int(10) unsigned |
  100. +-------------------+----------------------+
  101.  
  102. Database: brazzers
  103. Table: vbbexternalcache
  104. [5 columns]
  105. +-----------+------------------+
  106. | Column | Type |
  107. +-----------+------------------+
  108. | cachehash | varchar(32) |
  109. | dateline | int(10) unsigned |
  110. | forumid | int(10) unsigned |
  111. | headers | mediumtext |
  112. | text | mediumtext |
  113. +-----------+------------------+
  114.  
  115. Database: brazzers
  116. Table: featured_models
  117. [4 columns]
  118. +-------------------+--------+
  119. | Column | Type |
  120. +-------------------+--------+
  121. | featured_model_id | int(6) |
  122. | model_id | int(6) |
  123. | position | int(2) |
  124. | site_id | int(6) |
  125. +-------------------+--------+
  126.  
  127. Database: brazzers
  128. Table: themes
  129. [3 columns]
  130. +-------------+--------------+
  131. | Column | Type |
  132. +-------------+--------------+
  133. | description | varchar(255) |
  134. | path | varchar(255) |
  135. | theme_id | int(11) |
  136. +-------------+--------------+
  137.  
  138. Database: brazzers
  139. Table: vbbsubscribeevent
  140. [5 columns]
  141. +------------------+------------------+
  142. | Column | Type |
  143. +------------------+------------------+
  144. | eventid | int(10) unsigned |
  145. | lastreminder | int(10) unsigned |
  146. | reminder | int(10) unsigned |
  147. | subscribeeventid | int(10) unsigned |
  148. | userid | int(10) unsigned |
  149. +------------------+------------------+
  150.  
  151. Database: brazzers
  152. Table: site_custom_fields
  153. [3 columns]
  154. +-----------------+--------------+
  155. | Column | Type |
  156. +-----------------+--------------+
  157. | custom_field_id | int(11) |
  158. | site_id | int(11) |
  159. | title | varchar(255) |
  160. +-----------------+--------------+
  161.  
  162. Database: brazzers
  163. Table: favorites_switchboard
  164. [4 columns]
  165. +--------------------------+--------------+
  166. | Column | Type |
  167. +--------------------------+--------------+
  168. | favorite_id | int(11) |
  169. | favorite_type | varchar(255) |
  170. | favorites_switchboard_id | int(11) |
  171. | folder_id | int(11) |
  172. +--------------------------+--------------+
  173.  
  174. Database: brazzers
  175. Table: vbbsubscriptionlog
  176. [7 columns]
  177. +-------------------+-----------------------+
  178. | Column | Type |
  179. +-------------------+-----------------------+
  180. | expirydate | int(10) unsigned |
  181. | pusergroupid | smallint(6) |
  182. | regdate | int(10) unsigned |
  183. | status | smallint(6) |
  184. | subscriptionid | smallint(6) |
  185. | subscriptionlogid | mediumint(8) unsigned |
  186. | userid | int(10) unsigned |
  187. +-------------------+-----------------------+
  188.  
  189. Database: brazzers
  190. Table: vbbmoderation
  191. [4 columns]
  192. +----------+------------------------+
  193. | Column | Type |
  194. +----------+------------------------+
  195. | dateline | int(10) unsigned |
  196. | postid | int(10) unsigned |
  197. | threadid | int(10) unsigned |
  198. | type | enum('thread','reply') |
  199. +----------+------------------------+
  200.  
  201. Database: brazzers
  202. Table: rating_durations
  203. [6 columns]
  204. +------------------------+-------------+
  205. | Column | Type |
  206. +------------------------+-------------+
  207. | dynamic_model_duration | int(11) |
  208. | dynamic_scene_duration | int(11) |
  209. | dynamic_video_duration | tinyint(11) |
  210. | min_num_model_ratings | int(11) |
  211. | min_num_scene_ratings | int(11) |
  212. | min_num_video_ratings | tinyint(11) |
  213. +------------------------+-------------+
  214.  
  215. Database: brazzers
  216. Table: blog_posts
  217. [9 columns]
  218. +----------------+--------------+
  219. | Column | Type |
  220. +----------------+--------------+
  221. | allow_comments | tinyint(1) |
  222. | blog_id | int(11) |
  223. | blog_post_id | int(11) |
  224. | date_added | int(11) |
  225. | post | text |
  226. | title | varchar(255) |
  227. | user_id | int(11) |
  228. | user_nickname | varchar(255) |
  229. | user_type | varchar(255) |
  230. +----------------+--------------+
  231.  
  232. Database: brazzers
  233. Table: vbbmailqueue
  234. [7 columns]
  235. +-------------+------------------+
  236. | Column | Type |
  237. +-------------+------------------+
  238. | dateline | int(10) unsigned |
  239. | fromemail | mediumtext |
  240. | header | mediumtext |
  241. | mailqueueid | int(10) unsigned |
  242. | message | mediumtext |
  243. | subject | mediumtext |
  244. | toemail | mediumtext |
  245. +-------------+------------------+
  246.  
  247. Database: brazzers
  248. Table: vbbusergrouprequest
  249. [5 columns]
  250. +--------------------+----------------------+
  251. | Column | Type |
  252. +--------------------+----------------------+
  253. | dateline | int(10) unsigned |
  254. | reason | varchar(250) |
  255. | usergroupid | smallint(5) unsigned |
  256. | usergrouprequestid | int(10) unsigned |
  257. | userid | int(10) unsigned |
  258. +--------------------+----------------------+
  259.  
  260. Database: brazzers
  261. Table: bonus_sites
  262. [5 columns]
  263. +---------------+--------------+
  264. | Column | Type |
  265. +---------------+--------------+
  266. | bonus_site_id | int(11) |
  267. | description | varchar(255) |
  268. | image | varchar(255) |
  269. | name | varchar(255) |
  270. | url | varchar(255) |
  271. +---------------+--------------+
  272.  
  273. Database: brazzers
  274. Table: vbbtemplate
  275. [10 columns]
  276. +--------------+-------------------------------------------------+
  277. | Column | Type |
  278. +--------------+-------------------------------------------------+
  279. | dateline | int(10) unsigned |
  280. | product | varchar(25) |
  281. | styleid | smallint(6) |
  282. | template | mediumtext |
  283. | template_un | mediumtext |
  284. | templateid | int(10) unsigned |
  285. | templatetype | enum('template','stylevar','css','replacement') |
  286. | title | varchar(100) |
  287. | username | varchar(100) |
  288. | version | varchar(30) |
  289. +--------------+-------------------------------------------------+
  290.  
  291. Database: brazzers
  292. Table: vbbdeletionlog
  293. [6 columns]
  294. +-----------+-----------------------+
  295. | Column | Type |
  296. +-----------+-----------------------+
  297. | dateline | int(10) unsigned |
  298. | primaryid | int(10) unsigned |
  299. | reason | varchar(125) |
  300. | type | enum('post','thread') |
  301. | userid | int(10) unsigned |
  302. | username | varchar(100) |
  303. +-----------+-----------------------+
  304.  
  305. Database: brazzers
  306. Table: video_forms
  307. [5 columns]
  308. +---------------+---------------------+
  309. | Column | Type |
  310. +---------------+---------------------+
  311. | extension | varchar(255) |
  312. | length | int(11) |
  313. | size | bigint(32) unsigned |
  314. | video_form_id | int(11) |
  315. | video_id | int(11) |
  316. +---------------+---------------------+
  317.  
  318. Database: brazzers
  319. Table: vbbranks
  320. [8 columns]
  321. +-------------+----------------------+
  322. | Column | Type |
  323. +-------------+----------------------+
  324. | display | smallint(5) unsigned |
  325. | minposts | int(10) unsigned |
  326. | rankid | smallint(5) unsigned |
  327. | rankimg | mediumtext |
  328. | ranklevel | smallint(5) unsigned |
  329. | stack | smallint(5) unsigned |
  330. | type | smallint(5) unsigned |
  331. | usergroupid | smallint(5) unsigned |
  332. +-------------+----------------------+
  333.  
  334. Database: brazzers
  335. Table: vbbmoderatorlog
  336. [12 columns]
  337. +----------------+----------------------+
  338. | Column | Type |
  339. +----------------+----------------------+
  340. | action | varchar(250) |
  341. | attachmentid | int(10) unsigned |
  342. | dateline | int(10) unsigned |
  343. | forumid | smallint(5) unsigned |
  344. | ipaddress | varchar(15) |
  345. | moderatorlogid | int(10) unsigned |
  346. | pollid | int(10) unsigned |
  347. | postid | int(10) unsigned |
  348. | threadid | int(10) unsigned |
  349. | threadtitle | varchar(250) |
  350. | type | smallint(5) unsigned |
  351. | userid | int(10) unsigned |
  352. +----------------+----------------------+
  353.  
  354. Database: brazzers
  355. Table: visitor_trailer_count
  356. [2 columns]
  357. +------------+-------------+
  358. | Column | Type |
  359. +------------+-------------+
  360. | time_view | datetime |
  361. | visitor_ip | varchar(32) |
  362. +------------+-------------+
  363.  
  364. Database: brazzers
  365. Table: spot_buyer_scenes
  366. [11 columns]
  367. +---------------------+---------+
  368. | Column | Type |
  369. +---------------------+---------+
  370. | date_added | int(11) |
  371. | last_no_clicks | int(11) |
  372. | last_no_sales | int(11) |
  373. | no_clicks | int(11) |
  374. | no_sales | int(11) |
  375. | position | int(11) |
  376. | scene_id | int(11) |
  377. | spot_buyer_id | int(11) |
  378. | spot_buyer_scene_id | int(11) |
  379. | total_no_clicks | int(11) |
  380. | total_no_sales | int(11) |
  381. +---------------------+---------+
  382.  
  383. Database: brazzers
  384. Table: vbbattachmentviews
  385. [1 column]
  386. +--------------+------------------+
  387. | Column | Type |
  388. +--------------+------------------+
  389. | attachmentid | int(10) unsigned |
  390. +--------------+------------------+
  391.  
  392. Database: brazzers
  393. Table: dvds
  394. [2 columns]
  395. +--------+--------------+
  396. | Column | Type |
  397. +--------+--------------+
  398. | dvd_id | int(11) |
  399. | name | varchar(255) |
  400. +--------+--------------+
  401.  
  402. Database: brazzers
  403. Table: vbbevent
  404. [15 columns]
  405. +---------------+------------------+
  406. | Column | Type |
  407. +---------------+------------------+
  408. | allowsmilies | smallint(6) |
  409. | calendarid | int(10) unsigned |
  410. | customfields | mediumtext |
  411. | dateline | int(10) unsigned |
  412. | dateline_from | int(10) unsigned |
  413. | dateline_to | int(10) unsigned |
  414. | dst | smallint(6) |
  415. | event | mediumtext |
  416. | eventid | int(10) unsigned |
  417. | recuroption | varchar(6) |
  418. | recurring | smallint(6) |
  419. | title | varchar(250) |
  420. | userid | int(10) unsigned |
  421. | utc | smallint(6) |
  422. | visible | smallint(6) |
  423. +---------------+------------------+
  424.  
  425. Database: brazzers
  426. Table: vbbadminlog
  427. [7 columns]
  428. +------------+------------------+
  429. | Column | Type |
  430. +------------+------------------+
  431. | action | varchar(20) |
  432. | adminlogid | int(10) unsigned |
  433. | dateline | int(10) unsigned |
  434. | extrainfo | varchar(200) |
  435. | ipaddress | varchar(15) |
  436. | script | varchar(50) |
  437. | userid | int(10) unsigned |
  438. +------------+------------------+
  439.  
  440. Database: brazzers
  441. Table: vbbaccess
  442. [3 columns]
  443. +------------+----------------------+
  444. | Column | Type |
  445. +------------+----------------------+
  446. | accessmask | smallint(5) unsigned |
  447. | forumid | smallint(5) unsigned |
  448. | userid | int(10) unsigned |
  449. +------------+----------------------+
  450.  
  451. Database: brazzers
  452. Table: vbbphrase
  453. [9 columns]
  454. +------------+------------------+
  455. | Column | Type |
  456. +------------+------------------+
  457. | dateline | int(10) unsigned |
  458. | fieldname | varchar(20) |
  459. | languageid | smallint(6) |
  460. | phraseid | int(10) unsigned |
  461. | product | varchar(25) |
  462. | text | mediumtext |
  463. | username | varchar(100) |
  464. | varname | varchar(250) |
  465. | version | varchar(30) |
  466. +------------+------------------+
  467.  
  468. Database: brazzers
  469. Table: vbbreminder
  470. [8 columns]
  471. +---------------+----------------------+
  472. | Column | Type |
  473. +---------------+----------------------+
  474. | adminonly | smallint(5) unsigned |
  475. | completedby | int(10) unsigned |
  476. | completedtime | int(10) unsigned |
  477. | duedate | int(10) unsigned |
  478. | reminderid | int(10) unsigned |
  479. | text | mediumtext |
  480. | title | varchar(50) |
  481. | userid | int(10) unsigned |
  482. +---------------+----------------------+
  483.  
  484. Database: brazzers
  485. Table: vbbuserlist
  486. [3 columns]
  487. +------------+------------------------+
  488. | Column | Type |
  489. +------------+------------------------+
  490. | relationid | int(10) unsigned |
  491. | type | enum('buddy','ignore') |
  492. | userid | int(10) unsigned |
  493. +------------+------------------------+
  494.  
  495. Database: brazzers
  496. Table: job_logs
  497. [4 columns]
  498. +------------+---------+
  499. | Column | Type |
  500. +------------+---------+
  501. | date_added | int(11) |
  502. | job_id | int(11) |
  503. | log | text |
  504. | log_id | int(11) |
  505. +------------+---------+
  506.  
  507. Database: brazzers
  508. Table: permissions
  509. [3 columns]
  510. +-----------------+--------------+
  511. | Column | Type |
  512. +-----------------+--------------+
  513. | id | int(11) |
  514. | permission_path | varchar(255) |
  515. | type | varchar(16) |
  516. +-----------------+--------------+
  517.  
  518. Database: brazzers
  519. Table: spot_buyers
  520. [28 columns]
  521. +---------------------------+--------------+
  522. | Column | Type |
  523. +---------------------------+--------------+
  524. | bg_color | varchar(7) |
  525. | casted_scene_position | int(11) |
  526. | clicks | int(11) |
  527. | css_code | text |
  528. | current_rotation | int(11) |
  529. | cutoff | int(11) |
  530. | date_added | int(11) |
  531. | first_spot_buyer_scene_id | int(11) |
  532. | footer_code | blob |
  533. | header_code | blob |
  534. | height | int(11) |
  535. | impressions | int(11) |
  536. | max_clicks | int(11) |
  537. | max_impressions | int(11) |
  538. | name | varchar(100) |
  539. | no_clicks_coefficient | float |
  540. | no_sales_coefficient | float |
  541. | num_scenes_final_round | int(11) |
  542. | pic_size | int(11) |
  543. | pic_text | text |
  544. | pic_type | varchar(25) |
  545. | rotations_per_round | int(11) |
  546. | spot_buyer_id | int(11) |
  547. | total_clicks | int(11) |
  548. | total_impressions | int(11) |
  549. | url | blob |
  550. | watermark | varchar(255) |
  551. | width | int(11) |
  552. +---------------------------+--------------+
  553.  
  554. Database: brazzers
  555. Table: vbbcalendarmoderator
  556. [5 columns]
  557. +---------------------+------------------+
  558. | Column | Type |
  559. +---------------------+------------------+
  560. | calendarid | int(10) unsigned |
  561. | calendarmoderatorid | int(10) unsigned |
  562. | neweventemail | smallint(6) |
  563. | permissions | int(10) unsigned |
  564. | userid | int(10) unsigned |
  565. +---------------------+------------------+
  566.  
  567. Database: brazzers
  568. Table: vbbcpsession
  569. [3 columns]
  570. +----------+------------------+
  571. | Column | Type |
  572. +----------+------------------+
  573. | dateline | int(10) unsigned |
  574. | hash | varchar(32) |
  575. | userid | int(10) unsigned |
  576. +----------+------------------+
  577.  
  578. Database: brazzers
  579. Table: xscore_rotation_ratios
  580. [4 columns]
  581. +--------------------+---------+
  582. | Column | Type |
  583. +--------------------+---------+
  584. | date_added | int(11) |
  585. | number_of_joins | int(11) |
  586. | number_of_visitors | int(11) |
  587. | site_id | int(11) |
  588. +--------------------+---------+
  589.  
  590. Database: brazzers
  591. Table: vbbpollvote
  592. [5 columns]
  593. +------------+------------------+
  594. | Column | Type |
  595. +------------+------------------+
  596. | pollid | int(10) unsigned |
  597. | pollvoteid | int(10) unsigned |
  598. | userid | int(10) unsigned |
  599. | votedate | int(10) unsigned |
  600. | voteoption | int(10) unsigned |
  601. +------------+------------------+
  602.  
  603. Database: brazzers
  604. Table: vbbproduct
  605. [7 columns]
  606. +-----------------+----------------------+
  607. | Column | Type |
  608. +-----------------+----------------------+
  609. | active | smallint(5) unsigned |
  610. | description | varchar(250) |
  611. | productid | varchar(25) |
  612. | title | varchar(50) |
  613. | url | varchar(250) |
  614. | version | varchar(25) |
  615. | versioncheckurl | varchar(250) |
  616. +-----------------+----------------------+
  617.  
  618. Database: brazzers
  619. Table: vbbsearch
  620. [19 columns]
  621. +--------------+----------------------+
  622. | Column | Type |
  623. +--------------+----------------------+
  624. | announceids | mediumtext |
  625. | completed | smallint(5) unsigned |
  626. | dateline | int(10) unsigned |
  627. | displayterms | mediumtext |
  628. | forumchoice | mediumtext |
  629. | ipaddress | varchar(15) |
  630. | orderedids | mediumtext |
  631. | personal | smallint(5) unsigned |
  632. | query | varchar(200) |
  633. | searchhash | varchar(32) |
  634. | searchid | int(10) unsigned |
  635. | searchterms | mediumtext |
  636. | searchtime | float |
  637. | searchuser | varchar(200) |
  638. | showposts | smallint(5) unsigned |
  639. | sortby | varchar(200) |
  640. | sortorder | varchar(4) |
  641. | titleonly | smallint(5) unsigned |
  642. | userid | int(10) unsigned |
  643. +--------------+----------------------+
  644.  
  645. Database: brazzers
  646. Table: vbbpostindex
  647. [4 columns]
  648. +---------+----------------------+
  649. | Column | Type |
  650. +---------+----------------------+
  651. | intitle | smallint(5) unsigned |
  652. | postid | int(10) unsigned |
  653. | score | smallint(5) unsigned |
  654. | wordid | int(10) unsigned |
  655. +---------+----------------------+
  656.  
  657. Database: brazzers
  658. Table: vbbuser
  659. [55 columns]
  660. +--------------------+----------------------+
  661. | Column | Type |
  662. +--------------------+----------------------+
  663. | adminoptions | int(10) unsigned |
  664. | aim | varchar(20) |
  665. | autosubscribe | smallint(6) |
  666. | avatarid | smallint(6) |
  667. | avatarrevision | int(10) unsigned |
  668. | birthday | varchar(10) |
  669. | birthday_search | date |
  670. | customtitle | smallint(6) |
  671. | daysprune | smallint(6) |
  672. | displaygroupid | smallint(5) unsigned |
  673. | email | varchar(100) |
  674. | emailstamp | int(10) unsigned |
  675. | homepage | varchar(100) |
  676. | icq | varchar(20) |
  677. | infractiongroupid | smallint(5) unsigned |
  678. | infractiongroupids | varchar(255) |
  679. | infractions | int(10) unsigned |
  680. | ipaddress | varchar(15) |
  681. | ipoints | int(10) unsigned |
  682. | joindate | int(10) unsigned |
  683. | languageid | smallint(5) unsigned |
  684. | lastactivity | int(10) unsigned |
  685. | lastpost | int(10) unsigned |
  686. | lastpostid | int(10) unsigned |
  687. | lastvisit | int(10) unsigned |
  688. | maxposts | smallint(6) |
  689. | membergroupids | varchar(250) |
  690. | msn | varchar(100) |
  691. | options | int(10) unsigned |
  692. | parentemail | varchar(50) |
  693. | password | varchar(32) |
  694. | passworddate | date |
  695. | pmpopup | smallint(6) |
  696. | pmtotal | smallint(5) unsigned |
  697. | pmunread | smallint(5) unsigned |
  698. | posts | int(10) unsigned |
  699. | profilepicrevision | int(10) unsigned |
  700. | referrerid | int(10) unsigned |
  701. | reputation | int(11) |
  702. | reputationlevelid | int(10) unsigned |
  703. | salt | char(3) |
  704. | showbirthday | smallint(5) unsigned |
  705. | showvbcode | smallint(5) unsigned |
  706. | sigpicrevision | int(10) unsigned |
  707. | skype | varchar(32) |
  708. | startofweek | smallint(6) |
  709. | styleid | smallint(5) unsigned |
  710. | threadedmode | smallint(5) unsigned |
  711. | timezoneoffset | varchar(4) |
  712. | usergroupid | smallint(5) unsigned |
  713. | userid | int(10) unsigned |
  714. | username | varchar(100) |
  715. | usertitle | varchar(250) |
  716. | warnings | int(10) unsigned |
  717. | yahoo | varchar(32) |
  718. +--------------------+----------------------+
  719.  
  720. Database: brazzers
  721. Table: vbbtachyforumpost
  722. [8 columns]
  723. +--------------+----------------------+
  724. | Column | Type |
  725. +--------------+----------------------+
  726. | forumid | int(10) unsigned |
  727. | lasticonid | smallint(5) unsigned |
  728. | lastpost | int(10) unsigned |
  729. | lastposter | varchar(100) |
  730. | lastpostid | int(10) unsigned |
  731. | lastthread | varchar(250) |
  732. | lastthreadid | int(10) unsigned |
  733. | userid | int(10) unsigned |
  734. +--------------+----------------------+
  735.  
  736. Database: brazzers
  737. Table: vbbsubscriptionpermission
  738. [3 columns]
  739. +--------------------------+------------------+
  740. | Column | Type |
  741. +--------------------------+------------------+
  742. | subscriptionid | int(10) unsigned |
  743. | subscriptionpermissionid | int(10) unsigned |
  744. | usergroupid | int(10) unsigned |
  745. +--------------------------+------------------+
  746.  
  747. Database: brazzers
  748. Table: vbbadminmessage
  749. [10 columns]
  750. +----------------+-----------------------------------+
  751. | Column | Type |
  752. +----------------+-----------------------------------+
  753. | action | varchar(20) |
  754. | adminmessageid | int(10) unsigned |
  755. | dateline | int(10) unsigned |
  756. | dismissable | smallint(5) unsigned |
  757. | execurl | mediumtext |
  758. | method | enum('get','post') |
  759. | script | varchar(50) |
  760. | status | enum('undone','done','dismissed') |
  761. | statususerid | int(10) unsigned |
  762. | varname | varchar(250) |
  763. +----------------+-----------------------------------+
  764.  
  765. Database: brazzers
  766. Table: tour_visitor_ips
  767. [2 columns]
  768. +------------+-------------+
  769. | Column | Type |
  770. +------------+-------------+
  771. | site_id | int(11) |
  772. | visitor_ip | varchar(32) |
  773. +------------+-------------+
  774.  
  775. Database: brazzers
  776. Table: vbbattachmentpermission
  777. [7 columns]
  778. +------------------------+----------------------+
  779. | Column | Type |
  780. +------------------------+----------------------+
  781. | attachmentpermissionid | int(10) unsigned |
  782. | attachmentpermissions | int(10) unsigned |
  783. | extension | varchar(20) |
  784. | height | smallint(5) unsigned |
  785. | size | int(10) unsigned |
  786. | usergroupid | int(10) unsigned |
  787. | width | smallint(5) unsigned |
  788. +------------------------+----------------------+
  789.  
  790. Database: brazzers
  791. Table: vbbannouncement
  792. [9 columns]
  793. +---------------------+----------------------+
  794. | Column | Type |
  795. +---------------------+----------------------+
  796. | announcementid | smallint(5) unsigned |
  797. | announcementoptions | int(10) unsigned |
  798. | enddate | int(10) unsigned |
  799. | forumid | smallint(6) |
  800. | pagetext | mediumtext |
  801. | startdate | int(10) unsigned |
  802. | title | varchar(250) |
  803. | userid | int(10) unsigned |
  804. | views | int(10) unsigned |
  805. +---------------------+----------------------+
  806.  
  807. Database: brazzers
  808. Table: vbbposthash
  809. [5 columns]
  810. +----------+------------------+
  811. | Column | Type |
  812. +----------+------------------+
  813. | dateline | int(10) unsigned |
  814. | dupehash | char(32) |
  815. | postid | int(10) unsigned |
  816. | threadid | int(10) unsigned |
  817. | userid | int(10) unsigned |
  818. +----------+------------------+
  819.  
  820. Database: brazzers
  821. Table: model_searches
  822. [4 columns]
  823. +---------------+---------+
  824. | Column | Type |
  825. +---------------+---------+
  826. | model_id | int(11) |
  827. | num_searches | int(11) |
  828. | site_id | int(11) |
  829. | temp_searches | int(11) |
  830. +---------------+---------+
  831.  
  832. Database: brazzers
  833. Table: vbbstrikes
  834. [3 columns]
  835. +------------+------------------+
  836. | Column | Type |
  837. +------------+------------------+
  838. | strikeip | varchar(15) |
  839. | striketime | int(10) unsigned |
  840. | username | varchar(100) |
  841. +------------+------------------+
  842.  
  843. Database: brazzers
  844. Table: vbbicon
  845. [5 columns]
  846. +-----------------+----------------------+
  847. | Column | Type |
  848. +-----------------+----------------------+
  849. | displayorder | smallint(5) unsigned |
  850. | iconid | smallint(5) unsigned |
  851. | iconpath | varchar(100) |
  852. | imagecategoryid | smallint(5) unsigned |
  853. | title | varchar(100) |
  854. +-----------------+----------------------+
  855.  
  856. Database: brazzers
  857. Table: pictures
  858. [5 columns]
  859. +------------+--------------+
  860. | Column | Type |
  861. +------------+--------------+
  862. | extension | varchar(255) |
  863. | filename | varchar(255) |
  864. | picture_id | int(11) |
  865. | scene_id | int(11) |
  866. | size | int(11) |
  867. +------------+--------------+
  868.  
  869. Database: brazzers
  870. Table: tags
  871. [4 columns]
  872. +----------+--------------+
  873. | Column | Type |
  874. +----------+--------------+
  875. | is_major | tinyint(4) |
  876. | name | varchar(255) |
  877. | tag_id | int(11) |
  878. | tag_type | varchar(255) |
  879. +----------+--------------+
  880.  
  881. Database: brazzers
  882. Table: sites
  883. [30 columns]
  884. +------------------------+--------------+
  885. | Column | Type |
  886. +------------------------+--------------+
  887. | bin | varchar(255) |
  888. | brazzers_site_position | int(11) |
  889. | content_site | tinyint(1) |
  890. | email | varchar(255) |
  891. | ftp_password | varchar(255) |
  892. | ftp_server | varchar(255) |
  893. | ftp_username | varchar(255) |
  894. | home | varchar(255) |
  895. | htp_pass_logs | varchar(255) |
  896. | is_active | tinyint(1) |
  897. | live_cam_category | varchar(255) |
  898. | max_description_length | int(11) |
  899. | mega_tour_position | int(11) |
  900. | nats_join_code | varchar(255) |
  901. | nats_site_id | int(11) |
  902. | num_tour_updates | int(11) |
  903. | program | varchar(255) |
  904. | root | varchar(255) |
  905. | short_name | varchar(255) |
  906. | site_description | text |
  907. | site_id | int(11) |
  908. | site_name | varchar(255) |
  909. | site_short_description | text |
  910. | slogan | varchar(255) |
  911. | tour_folder_name | varchar(255) |
  912. | tour_num_per_page | int(11) |
  913. | track_code | varchar(255) |
  914. | url | varchar(255) |
  915. | uses_xscore | tinyint(1) |
  916. | which_mega_site | varchar(255) |
  917. +------------------------+--------------+
  918.  
  919. Database: brazzers
  920. Table: comments
  921. [8 columns]
  922. +---------------------+--------------+
  923. | Column | Type |
  924. +---------------------+--------------+
  925. | comment | text |
  926. | comment_id | int(11) |
  927. | date_added | int(11) |
  928. | item_commented_id | int(11) |
  929. | item_commented_type | varchar(255) |
  930. | user_id | int(11) |
  931. | user_nickname | varchar(255) |
  932. | user_type | varchar(255) |
  933. +---------------------+--------------+
  934.  
  935. Database: brazzers
  936. Table: vbbcustomprofilepic
  937. [8 columns]
  938. +----------+----------------------+
  939. | Column | Type |
  940. +----------+----------------------+
  941. | dateline | int(10) unsigned |
  942. | filedata | mediumblob |
  943. | filename | varchar(100) |
  944. | filesize | int(10) unsigned |
  945. | height | smallint(5) unsigned |
  946. | userid | int(10) unsigned |
  947. | visible | smallint(6) |
  948. | width | smallint(5) unsigned |
  949. +----------+----------------------+
  950.  
  951. Database: brazzers
  952. Table: vbbsigpic
  953. [8 columns]
  954. +----------+----------------------+
  955. | Column | Type |
  956. +----------+----------------------+
  957. | dateline | int(10) unsigned |
  958. | filedata | mediumblob |
  959. | filename | varchar(100) |
  960. | filesize | int(10) unsigned |
  961. | height | smallint(5) unsigned |
  962. | userid | int(10) unsigned |
  963. | visible | smallint(6) |
  964. | width | smallint(5) unsigned |
  965. +----------+----------------------+
  966.  
  967. Database: brazzers
  968. Table: vbbupgradelog
  969. [7 columns]
  970. +--------------+----------------------+
  971. | Column | Type |
  972. +--------------+----------------------+
  973. | dateline | int(10) unsigned |
  974. | perpage | smallint(5) unsigned |
  975. | script | varchar(50) |
  976. | startat | int(10) unsigned |
  977. | step | smallint(5) unsigned |
  978. | steptitle | varchar(250) |
  979. | upgradelogid | int(10) unsigned |
  980. +--------------+----------------------+
  981.  
  982. Database: brazzers
  983. Table: scene_custom_fields
  984. [4 columns]
  985. +-----------------------+---------+
  986. | Column | Type |
  987. +-----------------------+---------+
  988. | scene_custom_field_id | int(11) |
  989. | scene_id | int(11) |
  990. | site_custom_field_id | int(11) |
  991. | value | text |
  992. +-----------------------+---------+
  993.  
  994. Database: brazzers
  995. Table: vbbcalendarpermission
  996. [4 columns]
  997. +----------------------+----------------------+
  998. | Column | Type |
  999. +----------------------+----------------------+
  1000. | calendarid | int(10) unsigned |
  1001. | calendarpermissionid | int(10) unsigned |
  1002. | calendarpermissions | int(10) unsigned |
  1003. | usergroupid | smallint(5) unsigned |
  1004. +----------------------+----------------------+
  1005.  
  1006. Database: brazzers
  1007. Table: models_scenes
  1008. [2 columns]
  1009. +----------+---------+
  1010. | Column | Type |
  1011. +----------+---------+
  1012. | model_id | int(11) |
  1013. | scene_id | int(11) |
  1014. +----------+---------+
  1015.  
  1016. Database: brazzers
  1017. Table: jobs
  1018. [12 columns]
  1019. +------------------+--------------+
  1020. | Column | Type |
  1021. +------------------+--------------+
  1022. | days_to_keep_log | int(11) |
  1023. | interval_offset | int(11) |
  1024. | is_enabled | tinyint(1) |
  1025. | job_id | int(11) |
  1026. | max_concurrent | int(11) |
  1027. | minute_interval | int(11) |
  1028. | module | varchar(30) |
  1029. | mutex | int(11) |
  1030. | name | varchar(60) |
  1031. | run_location | varchar(255) |
  1032. | run_mode | varchar(255) |
  1033. | title | varchar(255) |
  1034. +------------------+--------------+
  1035.  
  1036. Database: brazzers
  1037. Table: vbbpmreceipt
  1038. [8 columns]
  1039. +------------+----------------------+
  1040. | Column | Type |
  1041. +------------+----------------------+
  1042. | denied | smallint(5) unsigned |
  1043. | pmid | int(10) unsigned |
  1044. | readtime | int(10) unsigned |
  1045. | sendtime | int(10) unsigned |
  1046. | title | varchar(250) |
  1047. | touserid | int(10) unsigned |
  1048. | tousername | varchar(100) |
  1049. | userid | int(10) unsigned |
  1050. +------------+----------------------+
  1051.  
  1052. Database: brazzers
  1053. Table: last_insert_id
  1054. [2 columns]
  1055. +------------+--------------+
  1056. | Column | Type |
  1057. +------------+--------------+
  1058. | id | int(11) |
  1059. | table_name | varchar(255) |
  1060. +------------+--------------+
  1061.  
  1062. Database: brazzers
  1063. Table: subscriptions
  1064. [7 columns]
  1065. +-----------------+--------------+
  1066. | Column | Type |
  1067. +-----------------+--------------+
  1068. | initial_days | int(11) |
  1069. | initial_pay | int(11) |
  1070. | name | varchar(255) |
  1071. | rebill_days | int(11) |
  1072. | rebill_pay | int(11) |
  1073. | site_id | int(11) |
  1074. | subscription_id | int(11) |
  1075. +-----------------+--------------+
  1076.  
  1077. Database: brazzers
  1078. Table: vbbrsslog
  1079. [8 columns]
  1080. +----------------------+-------------------------------+
  1081. | Column | Type |
  1082. +----------------------+-------------------------------+
  1083. | contenthash | char(32) |
  1084. | dateline | int(10) unsigned |
  1085. | itemid | int(10) unsigned |
  1086. | itemtype | enum('thread','announcement') |
  1087. | rssfeedid | int(10) unsigned |
  1088. | threadactioncomplete | tinyint(3) unsigned |
  1089. | threadactiontime | int(10) unsigned |
  1090. | uniquehash | char(32) |
  1091. +----------------------+-------------------------------+
  1092.  
  1093. Database: brazzers
  1094. Table: vbbpmtext
  1095. [10 columns]
  1096. +---------------+----------------------+
  1097. | Column | Type |
  1098. +---------------+----------------------+
  1099. | allowsmilie | smallint(5) unsigned |
  1100. | dateline | int(10) unsigned |
  1101. | fromuserid | int(10) unsigned |
  1102. | fromusername | varchar(100) |
  1103. | iconid | smallint(5) unsigned |
  1104. | message | mediumtext |
  1105. | pmtextid | int(10) unsigned |
  1106. | showsignature | smallint(5) unsigned |
  1107. | title | varchar(250) |
  1108. | touserarray | mediumtext |
  1109. +---------------+----------------------+
  1110.  
  1111. Database: brazzers
  1112. Table: vbbadminhelp
  1113. [7 columns]
  1114. +--------------+----------------------+
  1115. | Column | Type |
  1116. +--------------+----------------------+
  1117. | action | varchar(25) |
  1118. | adminhelpid | int(10) unsigned |
  1119. | displayorder | smallint(5) unsigned |
  1120. | optionname | varchar(100) |
  1121. | product | varchar(25) |
  1122. | script | varchar(50) |
  1123. | volatile | smallint(5) unsigned |
  1124. +--------------+----------------------+
  1125.  
  1126. Database: brazzers
  1127. Table: affiliates
  1128. [8 columns]
  1129. +------------+--------------+
  1130. | Column | Type |
  1131. +------------+--------------+
  1132. | email | varchar(128) |
  1133. | is_special | binary(1) |
  1134. | member_id | bigint(20) |
  1135. | password | varchar(16) |
  1136. | program | varchar(16) |
  1137. | stamp | timestamp |
  1138. | status | binary(1) |
  1139. | username | varchar(16) |
  1140. +------------+--------------+
  1141.  
  1142. Database: brazzers
  1143. Table: vbbreputationlevel
  1144. [2 columns]
  1145. +-------------------+------------------+
  1146. | Column | Type |
  1147. +-------------------+------------------+
  1148. | minimumreputation | int(11) |
  1149. | reputationlevelid | int(10) unsigned |
  1150. +-------------------+------------------+
  1151.  
  1152. Database: brazzers
  1153. Table: top_models
  1154. [5 columns]
  1155. +---------------+---------+
  1156. | Column | Type |
  1157. +---------------+---------+
  1158. | model_id | int(11) |
  1159. | position | int(11) |
  1160. | site_id | int(11) |
  1161. | top_model_id | int(11) |
  1162. | top_update_id | int(11) |
  1163. +---------------+---------+
  1164.  
  1165. Database: brazzers
  1166. Table: vbbword
  1167. [2 columns]
  1168. +--------+------------------+
  1169. | Column | Type |
  1170. +--------+------------------+
  1171. | title | char(50) |
  1172. | wordid | int(10) unsigned |
  1173. +--------+------------------+
  1174.  
  1175. Database: brazzers
  1176. Table: vbbplugin
  1177. [8 columns]
  1178. +----------------+----------------------+
  1179. | Column | Type |
  1180. +----------------+----------------------+
  1181. | active | smallint(6) |
  1182. | devkey | varchar(25) |
  1183. | executionorder | smallint(5) unsigned |
  1184. | hookname | varchar(250) |
  1185. | phpcode | text |
  1186. | pluginid | int(10) unsigned |
  1187. | product | varchar(25) |
  1188. | title | varchar(250) |
  1189. +----------------+----------------------+
  1190.  
  1191. Database: brazzers
  1192. Table: vbbthreadredirect
  1193. [2 columns]
  1194. +----------+------------------+
  1195. | Column | Type |
  1196. +----------+------------------+
  1197. | expires | int(10) unsigned |
  1198. | threadid | int(10) unsigned |
  1199. +----------+------------------+
  1200.  
  1201. Database: brazzers
  1202. Table: members
  1203. [21 columns]
  1204. +-----------------+--------------+
  1205. | Column | Type |
  1206. +-----------------+--------------+
  1207. | active | tinyint(1) |
  1208. | affiliate | varchar(255) |
  1209. | affiliate_db_id | int(11) |
  1210. | avatar | varchar(255) |
  1211. | date_joined | int(11) |
  1212. | email | varchar(255) |
  1213. | ets_co_code | varchar(255) |
  1214. | ets_email | varchar(255) |
  1215. | ets_member_idx | int(11) |
  1216. | ets_password | varchar(255) |
  1217. | ets_pi_code | varchar(255) |
  1218. | ets_username | varchar(255) |
  1219. | first_name | varchar(255) |
  1220. | last_name | varchar(255) |
  1221. | member_id | int(11) |
  1222. | nats_site_id | int(11) |
  1223. | nickname | varchar(255) |
  1224. | password | varchar(255) |
  1225. | site_id | int(11) |
  1226. | subscription_id | int(11) |
  1227. | username | varchar(255) |
  1228. +-----------------+--------------+
  1229.  
  1230. Database: brazzers
  1231. Table: vbbusertitle
  1232. [3 columns]
  1233. +-------------+----------------------+
  1234. | Column | Type |
  1235. +-------------+----------------------+
  1236. | minposts | int(10) unsigned |
  1237. | title | char(250) |
  1238. | usertitleid | smallint(5) unsigned |
  1239. +-------------+----------------------+
  1240.  
  1241. Database: brazzers
  1242. Table: vbbuseractivation
  1243. [7 columns]
  1244. +------------------+----------------------+
  1245. | Column | Type |
  1246. +------------------+----------------------+
  1247. | activationid | bigint(20) unsigned |
  1248. | dateline | int(10) unsigned |
  1249. | emailchange | smallint(5) unsigned |
  1250. | type | smallint(5) unsigned |
  1251. | useractivationid | int(10) unsigned |
  1252. | usergroupid | smallint(5) unsigned |
  1253. | userid | int(10) unsigned |
  1254. +------------------+----------------------+
  1255.  
  1256. Database: brazzers
  1257. Table: vbbdatastore
  1258. [3 columns]
  1259. +-------------+-------------+
  1260. | Column | Type |
  1261. +-------------+-------------+
  1262. | data | mediumtext |
  1263. | title | varchar(50) |
  1264. | unserialize | smallint(6) |
  1265. +-------------+-------------+
  1266.  
  1267. Database: brazzers
  1268. Table: tour_site_order
  1269. [3 columns]
  1270. +---------------+---------+
  1271. | Column | Type |
  1272. +---------------+---------+
  1273. | order_index | int(11) |
  1274. | owner_site_id | int(11) |
  1275. | site_id | int(11) |
  1276. +---------------+---------+
  1277.  
  1278. Database: brazzers
  1279. Table: employees
  1280. [15 columns]
  1281. +-----------------+--------------+
  1282. | Column | Type |
  1283. +-----------------+--------------+
  1284. | active | tinyint(1) |
  1285. | avatar | varchar(255) |
  1286. | date_joined | int(11) |
  1287. | display_on_site | tinyint(4) |
  1288. | email | varchar(255) |
  1289. | employee_id | int(11) |
  1290. | first_name | varchar(255) |
  1291. | gender | char(1) |
  1292. | last_name | varchar(255) |
  1293. | nickname | varchar(255) |
  1294. | password | varchar(255) |
  1295. | photo_site | text |
  1296. | position | varchar(255) |
  1297. | theme_id | int(11) |
  1298. | username | varchar(255) |
  1299. +-----------------+--------------+
  1300.  
  1301. Database: brazzers
  1302. Table: vbbrssfeed
  1303. [17 columns]
  1304. +-------------------+-------------------------------+
  1305. | Column | Type |
  1306. +-------------------+-------------------------------+
  1307. | bodytemplate | mediumtext |
  1308. | endannouncement | int(10) unsigned |
  1309. | forumid | smallint(5) unsigned |
  1310. | iconid | smallint(5) unsigned |
  1311. | itemtype | enum('thread','announcement') |
  1312. | lastrun | int(10) unsigned |
  1313. | maxresults | smallint(6) |
  1314. | options | int(10) unsigned |
  1315. | port | smallint(5) unsigned |
  1316. | rssfeedid | int(10) unsigned |
  1317. | searchwords | mediumtext |
  1318. | threadactiondelay | smallint(5) unsigned |
  1319. | title | varchar(250) |
  1320. | titletemplate | mediumtext |
  1321. | ttl | smallint(5) unsigned |
  1322. | url | varchar(250) |
  1323. | userid | int(10) unsigned |
  1324. +-------------------+-------------------------------+
  1325.  
  1326. Database: brazzers
  1327. Table: vbbtachythreadpost
  1328. [5 columns]
  1329. +------------+------------------+
  1330. | Column | Type |
  1331. +------------+------------------+
  1332. | lastpost | int(10) unsigned |
  1333. | lastposter | varchar(100) |
  1334. | lastpostid | int(10) unsigned |
  1335. | threadid | int(10) unsigned |
  1336. | userid | int(10) unsigned |
  1337. +------------+------------------+
  1338.  
  1339. Database: brazzers
  1340. Table: livecam_categories
  1341. [2 columns]
  1342. +---------------------+--------------+
  1343. | Column | Type |
  1344. +---------------------+--------------+
  1345. | category_name | varchar(255) |
  1346. | livecam_category_id | int(11) |
  1347. +---------------------+--------------+
  1348.  
  1349. Database: brazzers
  1350. Table: vbbpasswordhistory
  1351. [3 columns]
  1352. +--------------+------------------+
  1353. | Column | Type |
  1354. +--------------+------------------+
  1355. | password | varchar(50) |
  1356. | passworddate | date |
  1357. | userid | int(10) unsigned |
  1358. +--------------+------------------+
  1359.  
  1360. Database: brazzers
  1361. Table: vbbsubscription
  1362. [10 columns]
  1363. +----------------+----------------------+
  1364. | Column | Type |
  1365. +----------------+----------------------+
  1366. | active | smallint(5) unsigned |
  1367. | adminoptions | int(10) unsigned |
  1368. | cost | mediumtext |
  1369. | displayorder | smallint(5) unsigned |
  1370. | forums | mediumtext |
  1371. | membergroupids | varchar(255) |
  1372. | nusergroupid | smallint(6) |
  1373. | options | int(10) unsigned |
  1374. | subscriptionid | smallint(5) unsigned |
  1375. | varname | varchar(100) |
  1376. +----------------+----------------------+
  1377.  
  1378. Database: brazzers
  1379. Table: xscore_tour_ratings
  1380. [5 columns]
  1381. +-------------------+-------------+
  1382. | Column | Type |
  1383. +-------------------+-------------+
  1384. | number_of_ratings | int(11) |
  1385. | rating_id | int(11) |
  1386. | rating_type | varchar(32) |
  1387. | scene_id | int(11) |
  1388. | sum_of_ratings | int(11) |
  1389. +-------------------+-------------+
  1390.  
  1391. Database: brazzers
  1392. Table: vbbusergroupleader
  1393. [3 columns]
  1394. +-------------------+----------------------+
  1395. | Column | Type |
  1396. +-------------------+----------------------+
  1397. | usergroupid | smallint(5) unsigned |
  1398. | usergroupleaderid | smallint(5) unsigned |
  1399. | userid | int(10) unsigned |
  1400. +-------------------+----------------------+
  1401.  
  1402. Database: brazzers
  1403. Table: vbbimagecategorypermission
  1404. [2 columns]
  1405. +-----------------+----------------------+
  1406. | Column | Type |
  1407. +-----------------+----------------------+
  1408. | imagecategoryid | smallint(5) unsigned |
  1409. | usergroupid | smallint(5) unsigned |
  1410. +-----------------+----------------------+
  1411.  
  1412. Database: brazzers
  1413. Table: vbbcustomavatar
  1414. [8 columns]
  1415. +----------+----------------------+
  1416. | Column | Type |
  1417. +----------+----------------------+
  1418. | dateline | int(10) unsigned |
  1419. | filedata | mediumblob |
  1420. | filename | varchar(100) |
  1421. | filesize | int(10) unsigned |
  1422. | height | smallint(5) unsigned |
  1423. | userid | int(10) unsigned |
  1424. | visible | smallint(6) |
  1425. | width | smallint(5) unsigned |
  1426. +----------+----------------------+
  1427.  
  1428. Database: brazzers
  1429. Table: job_list
  1430. [5 columns]
  1431. +------------+------------+
  1432. | Column | Type |
  1433. +------------+------------+
  1434. | command | text |
  1435. | job_id | int(11) |
  1436. | priority | int(3) |
  1437. | running | tinyint(1) |
  1438. | time_added | int(11) |
  1439. +------------+------------+
  1440.  
  1441. Database: brazzers
  1442. Table: vbbforum
  1443. [27 columns]
  1444. +-------------------+-----------------------+
  1445. | Column | Type |
  1446. +-------------------+-----------------------+
  1447. | childlist | text |
  1448. | daysprune | smallint(6) |
  1449. | defaultsortfield | varchar(50) |
  1450. | defaultsortorder | enum('asc','desc') |
  1451. | description | text |
  1452. | description_clean | text |
  1453. | displayorder | smallint(6) |
  1454. | forumid | smallint(5) unsigned |
  1455. | lasticonid | smallint(6) |
  1456. | lastpost | int(11) |
  1457. | lastposter | varchar(100) |
  1458. | lastpostid | int(10) unsigned |
  1459. | lastthread | varchar(250) |
  1460. | lastthreadid | int(10) unsigned |
  1461. | link | varchar(200) |
  1462. | newpostemail | text |
  1463. | newthreademail | text |
  1464. | options | int(10) unsigned |
  1465. | parentid | smallint(6) |
  1466. | parentlist | varchar(250) |
  1467. | password | varchar(50) |
  1468. | replycount | int(10) unsigned |
  1469. | showprivate | tinyint(3) unsigned |
  1470. | styleid | smallint(5) unsigned |
  1471. | threadcount | mediumint(8) unsigned |
  1472. | title | varchar(100) |
  1473. | title_clean | varchar(100) |
  1474. +-------------------+-----------------------+
  1475.  
  1476. Database: brazzers
  1477. Table: tags_switchboard
  1478. [7 columns]
  1479. +--------------------+--------------+
  1480. | Column | Type |
  1481. +--------------------+--------------+
  1482. | date_added | int(11) |
  1483. | is_active | smallint(1) |
  1484. | item_tagged_id | int(11) |
  1485. | item_tagged_type | varchar(255) |
  1486. | tag_id | int(11) |
  1487. | tag_switchboard_id | int(11) |
  1488. | tag_type | varchar(255) |
  1489. +--------------------+--------------+
  1490.  
  1491. Database: brazzers
  1492. Table: vbbpaymenttransaction
  1493. [10 columns]
  1494. +----------------------+----------------------+
  1495. | Column | Type |
  1496. +----------------------+----------------------+
  1497. | amount | double unsigned |
  1498. | currency | varchar(5) |
  1499. | dateline | int(10) unsigned |
  1500. | paymentapiid | int(10) unsigned |
  1501. | paymentinfoid | int(10) unsigned |
  1502. | paymenttransactionid | int(10) unsigned |
  1503. | request | mediumtext |
  1504. | reversed | int(10) unsigned |
  1505. | state | smallint(5) unsigned |
  1506. | transactionid | varchar(250) |
  1507. +----------------------+----------------------+
  1508.  
  1509. Database: brazzers
  1510. Table: vbbuserban
  1511. [9 columns]
  1512. +----------------+----------------------+
  1513. | Column | Type |
  1514. +----------------+----------------------+
  1515. | adminid | int(10) unsigned |
  1516. | bandate | int(10) unsigned |
  1517. | customtitle | smallint(6) |
  1518. | displaygroupid | smallint(5) unsigned |
  1519. | liftdate | int(10) unsigned |
  1520. | reason | varchar(250) |
  1521. | usergroupid | smallint(5) unsigned |
  1522. | userid | int(10) unsigned |
  1523. | usertitle | varchar(250) |
  1524. +----------------+----------------------+
  1525.  
  1526. Database: brazzers
  1527. Table: groups
  1528. [2 columns]
  1529. +------------+--------------+
  1530. | Column | Type |
  1531. +------------+--------------+
  1532. | group_id | int(11) |
  1533. | group_name | varchar(255) |
  1534. +------------+--------------+
  1535.  
  1536. Database: brazzers
  1537. Table: vbblanguage
  1538. [66 columns]
  1539. +------------------------------+----------------------+
  1540. | Column | Type |
  1541. +------------------------------+----------------------+
  1542. | calformat1override | varchar(50) |
  1543. | calformat2override | varchar(50) |
  1544. | charset | varchar(15) |
  1545. | dateoverride | varchar(50) |
  1546. | decimalsep | char(1) |
  1547. | imagesoverride | varchar(150) |
  1548. | languagecode | varchar(12) |
  1549. | languageid | smallint(5) unsigned |
  1550. | locale | varchar(20) |
  1551. | logdateoverride | varchar(50) |
  1552. | options | smallint(5) unsigned |
  1553. | phrasegroup_accessmask | mediumtext |
  1554. | phrasegroup_attachment_image | mediumtext |
  1555. | phrasegroup_banning | mediumtext |
  1556. | phrasegroup_bbcode | mediumtext |
  1557. | phrasegroup_calendar | mediumtext |
  1558. | phrasegroup_cpglobal | mediumtext |
  1559. | phrasegroup_cphome | mediumtext |
  1560. | phrasegroup_cpoption | mediumtext |
  1561. | phrasegroup_cppermission | mediumtext |
  1562. | phrasegroup_cprank | mediumtext |
  1563. | phrasegroup_cprofilefield | mediumtext |
  1564. | phrasegroup_cpuser | mediumtext |
  1565. | phrasegroup_cpusergroup | mediumtext |
  1566. | phrasegroup_cron | mediumtext |
  1567. | phrasegroup_diagnostic | mediumtext |
  1568. | phrasegroup_forum | mediumtext |
  1569. | phrasegroup_forumdisplay | mediumtext |
  1570. | phrasegroup_fronthelp | mediumtext |
  1571. | phrasegroup_global | mediumtext |
  1572. | phrasegroup_help_faq | mediumtext |
  1573. | phrasegroup_holiday | mediumtext |
  1574. | phrasegroup_infraction | mediumtext |
  1575. | phrasegroup_infractionlevel | mediumtext |
  1576. | phrasegroup_inlinemod | mediumtext |
  1577. | phrasegroup_language | mediumtext |
  1578. | phrasegroup_logging | mediumtext |
  1579. | phrasegroup_maintenance | mediumtext |
  1580. | phrasegroup_messaging | mediumtext |
  1581. | phrasegroup_moderator | mediumtext |
  1582. | phrasegroup_plugins | mediumtext |
  1583. | phrasegroup_pm | mediumtext |
  1584. | phrasegroup_poll | mediumtext |
  1585. | phrasegroup_postbit | mediumtext |
  1586. | phrasegroup_posting | mediumtext |
  1587. | phrasegroup_profilefield | mediumtext |
  1588. | phrasegroup_promotion | mediumtext |
  1589. | phrasegroup_register | mediumtext |
  1590. | phrasegroup_reputation | mediumtext |
  1591. | phrasegroup_reputationlevel | mediumtext |
  1592. | phrasegroup_search | mediumtext |
  1593. | phrasegroup_showthread | mediumtext |
  1594. | phrasegroup_sql | mediumtext |
  1595. | phrasegroup_stats | mediumtext |
  1596. | phrasegroup_style | mediumtext |
  1597. | phrasegroup_subscription | mediumtext |
  1598. | phrasegroup_thread | mediumtext |
  1599. | phrasegroup_threadmanage | mediumtext |
  1600. | phrasegroup_timezone | mediumtext |
  1601. | phrasegroup_user | mediumtext |
  1602. | phrasegroup_wol | mediumtext |
  1603. | registereddateoverride | varchar(50) |
  1604. | thousandsep | char(1) |
  1605. | timeoverride | varchar(50) |
  1606. | title | varchar(50) |
  1607. | userselect | smallint(5) unsigned |
  1608. +------------------------------+----------------------+
  1609.  
  1610. Database: brazzers
  1611. Table: vbbprofilefieldcategory
  1612. [2 columns]
  1613. +------------------------+----------------------+
  1614. | Column | Type |
  1615. +------------------------+----------------------+
  1616. | displayorder | smallint(6) |
  1617. | profilefieldcategoryid | smallint(5) unsigned |
  1618. +------------------------+----------------------+
  1619.  
  1620. Database: brazzers
  1621. Table: vbbuserfield
  1622. [6 columns]
  1623. +--------+------------------+
  1624. | Column | Type |
  1625. +--------+------------------+
  1626. | field1 | mediumtext |
  1627. | field2 | mediumtext |
  1628. | field3 | mediumtext |
  1629. | field4 | mediumtext |
  1630. | temp | mediumtext |
  1631. | userid | int(10) unsigned |
  1632. +--------+------------------+
  1633.  
  1634. Database: brazzers
  1635. Table: vbbreputation
  1636. [7 columns]
  1637. +--------------+------------------+
  1638. | Column | Type |
  1639. +--------------+------------------+
  1640. | dateline | int(11) |
  1641. | postid | int(11) |
  1642. | reason | varchar(250) |
  1643. | reputation | int(11) |
  1644. | reputationid | int(10) unsigned |
  1645. | userid | int(11) |
  1646. | whoadded | int(11) |
  1647. +--------------+------------------+
  1648.  
  1649. Database: brazzers
  1650. Table: vbbpodcast
  1651. [12 columns]
  1652. +------------+------------------+
  1653. | Column | Type |
  1654. +------------+------------------+
  1655. | author | varchar(255) |
  1656. | category | varchar(255) |
  1657. | categoryid | smallint(6) |
  1658. | enabled | smallint(6) |
  1659. | explicit | smallint(6) |
  1660. | forumid | int(10) unsigned |
  1661. | image | varchar(255) |
  1662. | keywords | varchar(255) |
  1663. | owneremail | varchar(255) |
  1664. | ownername | varchar(255) |
  1665. | subtitle | varchar(255) |
  1666. | summary | mediumtext |
  1667. +------------+------------------+
  1668.  
  1669. Database: brazzers
  1670. Table: playlists_pictures
  1671. [2 columns]
  1672. +-------------+---------+
  1673. | Column | Type |
  1674. +-------------+---------+
  1675. | picture_id | int(11) |
  1676. | playlist_id | int(11) |
  1677. +-------------+---------+
  1678.  
  1679. Database: brazzers
  1680. Table: forums
  1681. [3 columns]
  1682. +------------+--------------+
  1683. | Column | Type |
  1684. +------------+--------------+
  1685. | forum_id | int(11) |
  1686. | forum_name | varchar(255) |
  1687. | url | varchar(255) |
  1688. +------------+--------------+
  1689.  
  1690. Database: brazzers
  1691. Table: vbbinfractionlevel
  1692. [6 columns]
  1693. +-------------------+-----------------------+
  1694. | Column | Type |
  1695. +-------------------+-----------------------+
  1696. | expires | int(10) unsigned |
  1697. | extend | smallint(5) unsigned |
  1698. | infractionlevelid | int(10) unsigned |
  1699. | period | enum('H','D','M','N') |
  1700. | points | int(10) unsigned |
  1701. | warning | smallint(5) unsigned |
  1702. +-------------------+-----------------------+
  1703.  
  1704. Database: brazzers
  1705. Table: vbbsubscribeforum
  1706. [4 columns]
  1707. +------------------+----------------------+
  1708. | Column | Type |
  1709. +------------------+----------------------+
  1710. | emailupdate | smallint(5) unsigned |
  1711. | forumid | smallint(5) unsigned |
  1712. | subscribeforumid | int(10) unsigned |
  1713. | userid | int(10) unsigned |
  1714. +------------------+----------------------+
  1715.  
  1716. Database: brazzers
  1717. Table: vbbadministrator
  1718. [7 columns]
  1719. +------------------+----------------------+
  1720. | Column | Type |
  1721. +------------------+----------------------+
  1722. | adminpermissions | int(10) unsigned |
  1723. | cssprefs | varchar(250) |
  1724. | dismissednews | text |
  1725. | languageid | smallint(5) unsigned |
  1726. | navprefs | mediumtext |
  1727. | notes | mediumtext |
  1728. | userid | int(10) unsigned |
  1729. +------------------+----------------------+
  1730.  
  1731. Database: brazzers
  1732. Table: vbbadminutil
  1733. [2 columns]
  1734. +--------+-------------+
  1735. | Column | Type |
  1736. +--------+-------------+
  1737. | text | mediumtext |
  1738. | title | varchar(50) |
  1739. +--------+-------------+
  1740.  
  1741. Database: brazzers
  1742. Table: vbbpm
  1743. [5 columns]
  1744. +-------------+----------------------+
  1745. | Column | Type |
  1746. +-------------+----------------------+
  1747. | folderid | smallint(6) |
  1748. | messageread | smallint(5) unsigned |
  1749. | pmid | int(10) unsigned |
  1750. | pmtextid | int(10) unsigned |
  1751. | userid | int(10) unsigned |
  1752. +-------------+----------------------+
  1753.  
  1754. Database: brazzers
  1755. Table: vbbmoderator
  1756. [4 columns]
  1757. +-------------+----------------------+
  1758. | Column | Type |
  1759. +-------------+----------------------+
  1760. | forumid | smallint(6) |
  1761. | moderatorid | smallint(5) unsigned |
  1762. | permissions | int(10) unsigned |
  1763. | userid | int(10) unsigned |
  1764. +-------------+----------------------+
  1765.  
  1766. Database: brazzers
  1767. Table: vbbsetting
  1768. [12 columns]
  1769. +----------------+-------------------------------------------------------+
  1770. | Column | Type |
  1771. +----------------+-------------------------------------------------------+
  1772. | advanced | smallint(6) |
  1773. | blacklist | smallint(6) |
  1774. | datatype | enum('free','number','boolean','bitfield','usernam e') |
  1775. | defaultvalue | mediumtext |
  1776. | displayorder | smallint(5) unsigned |
  1777. | grouptitle | varchar(50) |
  1778. | optioncode | mediumtext |
  1779. | product | varchar(25) |
  1780. | validationcode | text |
  1781. | value | mediumtext |
  1782. | varname | varchar(100) |
  1783. | volatile | smallint(5) unsigned |
  1784. +----------------+-------------------------------------------------------+
  1785.  
  1786. Database: brazzers
  1787. Table: spot_buyer_sites
  1788. [4 columns]
  1789. +---------------+------------+
  1790. | Column | Type |
  1791. +---------------+------------+
  1792. | onclick_url | text |
  1793. | site_id | int(11) |
  1794. | spot_buyer_id | int(11) |
  1795. | trailer | tinyint(1) |
  1796. +---------------+------------+
  1797.  
  1798. Database: brazzers
  1799. Table: vbbsettinggroup
  1800. [4 columns]
  1801. +--------------+----------------------+
  1802. | Column | Type |
  1803. +--------------+----------------------+
  1804. | displayorder | smallint(5) unsigned |
  1805. | grouptitle | varchar(50) |
  1806. | product | varchar(25) |
  1807. | volatile | smallint(5) unsigned |
  1808. +--------------+----------------------+
  1809.  
  1810. Database: brazzers
  1811. Table: upsells
  1812. [5 columns]
  1813. +------------------+--------------+
  1814. | Column | Type |
  1815. +------------------+--------------+
  1816. | is_global | tinyint(1) |
  1817. | program | varchar(255) |
  1818. | upsell_html_code | text |
  1819. | upsell_id | int(11) |
  1820. | upsell_name | varchar(255) |
  1821. +------------------+--------------+
  1822.  
  1823. Database: brazzers
  1824. Table: vbbannouncementread
  1825. [2 columns]
  1826. +----------------+------------------+
  1827. | Column | Type |
  1828. +----------------+------------------+
  1829. | announcementid | int(10) unsigned |
  1830. | userid | int(10) unsigned |
  1831. +----------------+------------------+
  1832.  
  1833. Database: brazzers
  1834. Table: vbbthreadrate
  1835. [5 columns]
  1836. +--------------+------------------+
  1837. | Column | Type |
  1838. +--------------+------------------+
  1839. | ipaddress | char(15) |
  1840. | threadid | int(10) unsigned |
  1841. | threadrateid | int(10) unsigned |
  1842. | userid | int(10) unsigned |
  1843. | vote | smallint(6) |
  1844. +--------------+------------------+
  1845.  
  1846. Database: brazzers
  1847. Table: vbbinfractiongroup
  1848. [5 columns]
  1849. +-------------------+----------------------+
  1850. | Column | Type |
  1851. +-------------------+----------------------+
  1852. | infractiongroupid | int(10) unsigned |
  1853. | orusergroupid | smallint(5) unsigned |
  1854. | override | smallint(5) unsigned |
  1855. | pointlevel | int(10) unsigned |
  1856. | usergroupid | int(11) |
  1857. +-------------------+----------------------+
  1858.  
  1859. Database: brazzers
  1860. Table: vbbfaq
  1861. [5 columns]
  1862. +--------------+----------------------+
  1863. | Column | Type |
  1864. +--------------+----------------------+
  1865. | displayorder | smallint(5) unsigned |
  1866. | faqname | varchar(250) |
  1867. | faqparent | varchar(50) |
  1868. | product | varchar(25) |
  1869. | volatile | smallint(5) unsigned |
  1870. +--------------+----------------------+
  1871.  
  1872. Database: brazzers
  1873. Table: vbbproductcode
  1874. [5 columns]
  1875. +---------------+------------------+
  1876. | Column | Type |
  1877. +---------------+------------------+
  1878. | installcode | mediumtext |
  1879. | productcodeid | int(10) unsigned |
  1880. | productid | varchar(25) |
  1881. | uninstallcode | mediumtext |
  1882. | version | varchar(25) |
  1883. +---------------+------------------+
  1884.  
  1885. Database: brazzers
  1886. Table: sites_upsells
  1887. [3 columns]
  1888. +-----------+------------+
  1889. | Column | Type |
  1890. +-----------+------------+
  1891. | on_home | tinyint(1) |
  1892. | site_id | int(11) |
  1893. | upsell_id | int(11) |
  1894. +-----------+------------+
  1895.  
  1896. Database: brazzers
  1897. Table: vbbpaymentinfo
  1898. [6 columns]
  1899. +-------------------+----------------------+
  1900. | Column | Type |
  1901. +-------------------+----------------------+
  1902. | completed | smallint(6) |
  1903. | hash | varchar(32) |
  1904. | paymentinfoid | int(10) unsigned |
  1905. | subscriptionid | smallint(5) unsigned |
  1906. | subscriptionsubid | smallint(5) unsigned |
  1907. | userid | int(10) unsigned |
  1908. +-------------------+----------------------+
  1909.  
  1910. Database: brazzers
  1911. Table: vbbpoll
  1912. [12 columns]
  1913. +---------------+----------------------+
  1914. | Column | Type |
  1915. +---------------+----------------------+
  1916. | active | smallint(6) |
  1917. | dateline | int(10) unsigned |
  1918. | lastvote | int(10) unsigned |
  1919. | multiple | smallint(5) unsigned |
  1920. | numberoptions | smallint(5) unsigned |
  1921. | options | text |
  1922. | pollid | int(10) unsigned |
  1923. | public | smallint(6) |
  1924. | question | varchar(100) |
  1925. | timeout | smallint(5) unsigned |
  1926. | voters | smallint(5) unsigned |
  1927. | votes | text |
  1928. +---------------+----------------------+
  1929.  
  1930. Database: brazzers
  1931. Table: polls
  1932. [6 columns]
  1933. +------------+--------------+
  1934. | Column | Type |
  1935. +------------+--------------+
  1936. | date_added | int(11) |
  1937. | end_date | int(11) |
  1938. | poll_id | int(11) |
  1939. | poll_name | varchar(255) |
  1940. | question | varchar(255) |
  1941. | start_date | int(11) |
  1942. +------------+--------------+
  1943.  
  1944. Database: brazzers
  1945. Table: polls_sites
  1946. [2 columns]
  1947. +---------+---------+
  1948. | Column | Type |
  1949. +---------+---------+
  1950. | poll_id | int(11) |
  1951. | site_id | int(11) |
  1952. +---------+---------+
  1953.  
  1954. Database: brazzers
  1955. Table: scenes
  1956. [31 columns]
  1957. +--------------------------+--------------+
  1958. | Column | Type |
  1959. +--------------------------+--------------+
  1960. | date_added | int(11) |
  1961. | description | text |
  1962. | dynamic_rating_num_votes | int(11) |
  1963. | dynamic_rating_sum_votes | int(11) |
  1964. | featured_position | int(11) |
  1965. | folder_name | varchar(255) |
  1966. | has_preview | tinyint(4) |
  1967. | has_trailer | tinyint(1) |
  1968. | health | double |
  1969. | is_accessible | tinyint(1) |
  1970. | is_active | tinyint(1) |
  1971. | is_on_mega_site_tour | tinyint(1) |
  1972. | is_on_tour | tinyint(1) |
  1973. | is_trial_scene | tinyint(1) |
  1974. | num_of_hq_pics | int(11) |
  1975. | num_of_screen_caps | int(11) |
  1976. | num_times_viewed | int(11) |
  1977. | rating_total | double |
  1978. | scene_id | int(11) |
  1979. | scene_name | varchar(255) |
  1980. | scene_title | varchar(255) |
  1981. | scene_type | varchar(255) |
  1982. | show_search_trailer | tinyint(1) |
  1983. | site_active | tinyint(1) |
  1984. | site_id | int(11) |
  1985. | total_ratings | int(11) |
  1986. | tour_position | int(4) |
  1987. | xs_episode_joins | int(11) |
  1988. | xs_score | double |
  1989. | xs_trailer_hits | int(11) |
  1990. | xs_trailer_joins | int(11) |
  1991. +--------------------------+--------------+
  1992.  
  1993. Database: brazzers
  1994. Table: vbbproductdependency
  1995. [6 columns]
  1996. +---------------------+-------------+
  1997. | Column | Type |
  1998. +---------------------+-------------+
  1999. | dependencytype | varchar(25) |
  2000. | maxversion | varchar(50) |
  2001. | minversion | varchar(50) |
  2002. | parentproductid | varchar(25) |
  2003. | productdependencyid | int(11) |
  2004. | productid | varchar(25) |
  2005. +---------------------+-------------+
  2006.  
  2007. Database: brazzers
  2008. Table: vbbpost
  2009. [16 columns]
  2010. +----------------+----------------------+
  2011. | Column | Type |
  2012. +----------------+----------------------+
  2013. | allowsmilie | smallint(6) |
  2014. | attach | smallint(5) unsigned |
  2015. | dateline | int(10) unsigned |
  2016. | iconid | smallint(5) unsigned |
  2017. | infraction | smallint(5) unsigned |
  2018. | ipaddress | varchar(15) |
  2019. | pagetext | mediumtext |
  2020. | parentid | int(10) unsigned |
  2021. | postid | int(10) unsigned |
  2022. | reportthreadid | int(10) unsigned |
  2023. | showsignature | smallint(6) |
  2024. | threadid | int(10) unsigned |
  2025. | title | varchar(250) |
  2026. | userid | int(10) unsigned |
  2027. | username | varchar(100) |
  2028. | visible | smallint(6) |
  2029. +----------------+----------------------+
  2030.  
  2031. Database: brazzers
  2032. Table: vbbcronlog
  2033. [5 columns]
  2034. +-------------+----------------------+
  2035. | Column | Type |
  2036. +-------------+----------------------+
  2037. | cronlogid | int(10) unsigned |
  2038. | dateline | int(10) unsigned |
  2039. | description | mediumtext |
  2040. | type | smallint(5) unsigned |
  2041. | varname | varchar(100) |
  2042. +-------------+----------------------+
  2043.  
  2044. Database: brazzers
  2045. Table: vbbphrasetype
  2046. [5 columns]
  2047. +-----------+----------------------+
  2048. | Column | Type |
  2049. +-----------+----------------------+
  2050. | editrows | smallint(5) unsigned |
  2051. | fieldname | varchar(20) |
  2052. | product | varchar(25) |
  2053. | special | smallint(5) unsigned |
  2054. | title | varchar(50) |
  2055. +-----------+----------------------+
  2056.  
  2057. Database: brazzers
  2058. Table: vbbprofilefield
  2059. [19 columns]
  2060. +------------------------+------------------------------------------------------------------------+
  2061. | Column | Type |
  2062. +------------------------+------------------------------------------------------------------------+
  2063. | data | mediumtext |
  2064. | def | smallint(6) |
  2065. | displayorder | smallint(6) |
  2066. | editable | smallint(6) |
  2067. | form | smallint(6) |
  2068. | height | smallint(6) |
  2069. | hidden | smallint(6) |
  2070. | html | smallint(6) |
  2071. | maxlength | smallint(6) |
  2072. | memberlist | smallint(6) |
  2073. | optional | smallint(5) unsigned |
  2074. | perline | smallint(6) |
  2075. | profilefieldcategoryid | smallint(5) unsigned |
  2076. | profilefieldid | smallint(5) unsigned |
  2077. | regex | varchar(255) |
  2078. | required | smallint(6) |
  2079. | searchable | smallint(6) |
  2080. | size | smallint(6) |
  2081. | type | enum('input','select','radio','textarea','checkbox ','select_multiple') |
  2082. +------------------------+------------------------------------------------------------------------+
  2083.  
  2084. Database: brazzers
  2085. Table: vbbholiday
  2086. [5 columns]
  2087. +--------------+----------------------+
  2088. | Column | Type |
  2089. +--------------+----------------------+
  2090. | allowsmilies | smallint(6) |
  2091. | holidayid | int(10) unsigned |
  2092. | recuroption | varchar(6) |
  2093. | recurring | smallint(5) unsigned |
  2094. | varname | varchar(100) |
  2095. +--------------+----------------------+
  2096.  
  2097. Database: brazzers
  2098. Table: blogs
  2099. [6 columns]
  2100. +---------------+--------------+
  2101. | Column | Type |
  2102. +---------------+--------------+
  2103. | blog_id | int(11) |
  2104. | blog_name | varchar(255) |
  2105. | date_added | int(11) |
  2106. | user_id | int(11) |
  2107. | user_nickname | varchar(255) |
  2108. | user_type | varchar(255) |
  2109. +---------------+--------------+
  2110.  
  2111. Database: brazzers
  2112. Table: vbbinfraction
  2113. [15 columns]
  2114. +-------------------+----------------------+
  2115. | Column | Type |
  2116. +-------------------+----------------------+
  2117. | action | smallint(5) unsigned |
  2118. | actiondateline | int(10) unsigned |
  2119. | actionreason | varchar(255) |
  2120. | actionuserid | int(10) unsigned |
  2121. | customreason | varchar(255) |
  2122. | dateline | int(10) unsigned |
  2123. | expires | int(10) unsigned |
  2124. | infractionid | int(10) unsigned |
  2125. | infractionlevelid | int(10) unsigned |
  2126. | note | varchar(255) |
  2127. | points | int(10) unsigned |
  2128. | postid | int(10) unsigned |
  2129. | threadid | int(10) unsigned |
  2130. | userid | int(10) unsigned |
  2131. | whoadded | int(10) unsigned |
  2132. +-------------------+----------------------+
  2133.  
  2134. Database: brazzers
  2135. Table: playlists
  2136. [5 columns]
  2137. +---------------+--------------+
  2138. | Column | Type |
  2139. +---------------+--------------+
  2140. | date_added | int(11) |
  2141. | is_shared | tinyint(1) |
  2142. | member_id | int(11) |
  2143. | playlist_id | int(11) |
  2144. | playlist_name | varchar(255) |
  2145. +---------------+--------------+
  2146.  
  2147. Database: brazzers
  2148. Table: vbbpodcastitem
  2149. [7 columns]
  2150. +----------+----------------------+
  2151. | Column | Type |
  2152. +----------+----------------------+
  2153. | author | varchar(255) |
  2154. | explicit | smallint(5) unsigned |
  2155. | keywords | varchar(255) |
  2156. | length | int(10) unsigned |
  2157. | postid | int(10) unsigned |
  2158. | subtitle | varchar(255) |
  2159. | url | varchar(255) |
  2160. +----------+----------------------+
  2161.  
  2162. Database: brazzers
  2163. Table: videos
  2164. [8 columns]
  2165. +----------------------+------------------+
  2166. | Column | Type |
  2167. +----------------------+------------------+
  2168. | dynamic_rating_total | int(11) unsigned |
  2169. | dynamic_total_rating | int(11) unsigned |
  2170. | filename | varchar(255) |
  2171. | rating_total | int(11) unsigned |
  2172. | scene_id | int(11) |
  2173. | total_ratings | int(11) unsigned |
  2174. | type | varchar(255) |
  2175. | video_id | int(11) |
  2176. +----------------------+------------------+
  2177.  
  2178. Database: brazzers
  2179. Table: vbbcalendarcustomfield
  2180. [8 columns]
  2181. +-----------------------+----------------------+
  2182. | Column | Type |
  2183. +-----------------------+----------------------+
  2184. | allowentry | smallint(6) |
  2185. | calendarcustomfieldid | int(10) unsigned |
  2186. | calendarid | int(10) unsigned |
  2187. | description | mediumtext |
  2188. | length | smallint(5) unsigned |
  2189. | options | mediumtext |
  2190. | required | smallint(6) |
  2191. | title | varchar(255) |
  2192. +-----------------------+----------------------+
  2193.  
  2194. Database: brazzers
  2195. Table: vbbregimage
  2196. [4 columns]
  2197. +--------------+----------------------+
  2198. | Column | Type |
  2199. +--------------+----------------------+
  2200. | dateline | int(10) unsigned |
  2201. | imagestamp | char(6) |
  2202. | regimagehash | char(32) |
  2203. | viewed | smallint(5) unsigned |
  2204. +--------------+----------------------+
  2205.  
  2206. Database: brazzers
  2207. Table: xscore_variables
  2208. [24 columns]
  2209. +-------------------------------+------------+
  2210. | Column | Type |
  2211. +-------------------------------+------------+
  2212. | age_coefficient | double |
  2213. | desired_ratio | float |
  2214. | episode_rating_buff | int(3) |
  2215. | episode_to_join_coefficient | double |
  2216. | good_segments | int(5) |
  2217. | joins_at_last_good_segment | int(11) |
  2218. | joins_at_start | int(11) |
  2219. | last_rotation | int(11) |
  2220. | member_rating_coefficient | double |
  2221. | midnight | tinyint(1) |
  2222. | minimum_trailer_rating | float |
  2223. | number_of_home_trailers | int(11) |
  2224. | rated_scene_position | int(11) |
  2225. | scene_rating_coefficient | double |
  2226. | site_id | int(11) |
  2227. | trailer_rating_buff | int(3) |
  2228. | trailer_rating_coefficient | double |
  2229. | trailer_to_join_coefficient | double |
  2230. | trailer_visits_coefficient | double |
  2231. | unique_tour_visitors | bigint(11) |
  2232. | unique_tour_visitors_temp | bigint(11) |
  2233. | visitors_at_last_good_segment | int(11) |
  2234. | visitors_at_start | int(11) |
  2235. | visits_per_rotation | int(11) |
  2236. +-------------------------------+------------+
  2237.  
  2238. Database: brazzers
  2239. Table: vbbattachment
  2240. [15 columns]
  2241. +--------------------+----------------------+
  2242. | Column | Type |
  2243. +--------------------+----------------------+
  2244. | attachmentid | int(10) unsigned |
  2245. | counter | int(10) unsigned |
  2246. | dateline | int(10) unsigned |
  2247. | extension | varchar(20) |
  2248. | filedata | mediumblob |
  2249. | filehash | varchar(32) |
  2250. | filename | varchar(100) |
  2251. | filesize | int(10) unsigned |
  2252. | posthash | varchar(32) |
  2253. | postid | int(10) unsigned |
  2254. | thumbnail | mediumblob |
  2255. | thumbnail_dateline | int(10) unsigned |
  2256. | thumbnail_filesize | int(10) unsigned |
  2257. | userid | int(10) unsigned |
  2258. | visible | smallint(5) unsigned |
  2259. +--------------------+----------------------+
  2260.  
  2261. Database: brazzers
  2262. Table: vbbthread
  2263. [24 columns]
  2264. +--------------+----------------------+
  2265. | Column | Type |
  2266. +--------------+----------------------+
  2267. | attach | smallint(5) unsigned |
  2268. | dateline | int(10) unsigned |
  2269. | deletedcount | int(10) unsigned |
  2270. | firstpostid | int(10) unsigned |
  2271. | forumid | smallint(5) unsigned |
  2272. | hiddencount | int(10) unsigned |
  2273. | iconid | smallint(5) unsigned |
  2274. | lastpost | int(10) unsigned |
  2275. | lastposter | varchar(50) |
  2276. | lastpostid | int(10) unsigned |
  2277. | notes | varchar(250) |
  2278. | open | smallint(6) |
  2279. | pollid | int(10) unsigned |
  2280. | postuserid | int(10) unsigned |
  2281. | postusername | varchar(100) |
  2282. | replycount | int(10) unsigned |
  2283. | similar | varchar(55) |
  2284. | sticky | smallint(6) |
  2285. | threadid | int(10) unsigned |
  2286. | title | varchar(250) |
  2287. | views | int(10) unsigned |
  2288. | visible | smallint(6) |
  2289. | votenum | smallint(5) unsigned |
  2290. | votetotal | smallint(5) unsigned |
  2291. +--------------+----------------------+
  2292.  
  2293. Database: brazzers
  2294. Table: completed_conversions
  2295. [2 columns]
  2296. +-----------------+--------------+
  2297. | Column | Type |
  2298. +-----------------+--------------+
  2299. | folder_name | text |
  2300. | site_short_name | varchar(255) |
  2301. +-----------------+--------------+
  2302.  
  2303. Database: brazzers
  2304. Table: vbbattachmenttype
  2305. [9 columns]
  2306. +-----------+----------------------+
  2307. | Column | Type |
  2308. +-----------+----------------------+
  2309. | display | smallint(5) unsigned |
  2310. | enabled | smallint(5) unsigned |
  2311. | extension | varchar(20) |
  2312. | height | smallint(5) unsigned |
  2313. | mimetype | varchar(255) |
  2314. | newwindow | smallint(5) unsigned |
  2315. | size | int(10) unsigned |
  2316. | thumbnail | smallint(5) unsigned |
  2317. | width | smallint(5) unsigned |
  2318. +-----------+----------------------+
  2319.  
  2320. Database: brazzers
  2321. Table: vbbusertextfield
  2322. [8 columns]
  2323. +-------------+------------------+
  2324. | Column | Type |
  2325. +-------------+------------------+
  2326. | buddylist | mediumtext |
  2327. | ignorelist | mediumtext |
  2328. | pmfolders | mediumtext |
  2329. | rank | mediumtext |
  2330. | searchprefs | mediumtext |
  2331. | signature | mediumtext |
  2332. | subfolders | mediumtext |
  2333. | userid | int(10) unsigned |
  2334. +-------------+------------------+
  2335.  
  2336. Database: brazzers
  2337. Table: vbbusergroup
  2338. [35 columns]
  2339. +----------------------+----------------------+
  2340. | Column | Type |
  2341. +----------------------+----------------------+
  2342. | adminpermissions | int(10) unsigned |
  2343. | attachlimit | int(10) unsigned |
  2344. | avatarmaxheight | smallint(5) unsigned |
  2345. | avatarmaxsize | int(10) unsigned |
  2346. | avatarmaxwidth | smallint(5) unsigned |
  2347. | calendarpermissions | int(10) unsigned |
  2348. | canoverride | smallint(5) unsigned |
  2349. | closetag | varchar(100) |
  2350. | description | varchar(250) |
  2351. | forumpermissions | int(10) unsigned |
  2352. | genericoptions | int(10) unsigned |
  2353. | genericpermissions | int(10) unsigned |
  2354. | ispublicgroup | smallint(5) unsigned |
  2355. | opentag | varchar(100) |
  2356. | passwordexpires | smallint(5) unsigned |
  2357. | passwordhistory | smallint(5) unsigned |
  2358. | pmpermissions | int(10) unsigned |
  2359. | pmquota | smallint(5) unsigned |
  2360. | pmsendmax | smallint(5) unsigned |
  2361. | profilepicmaxheight | smallint(5) unsigned |
  2362. | profilepicmaxsize | int(10) unsigned |
  2363. | profilepicmaxwidth | smallint(5) unsigned |
  2364. | sigmaxchars | smallint(5) unsigned |
  2365. | sigmaximages | smallint(5) unsigned |
  2366. | sigmaxlines | smallint(5) unsigned |
  2367. | sigmaxrawchars | smallint(5) unsigned |
  2368. | sigmaxsizebbcode | smallint(5) unsigned |
  2369. | signaturepermissions | int(10) unsigned |
  2370. | sigpicmaxheight | smallint(5) unsigned |
  2371. | sigpicmaxsize | int(10) unsigned |
  2372. | sigpicmaxwidth | smallint(5) unsigned |
  2373. | title | varchar(100) |
  2374. | usergroupid | smallint(5) unsigned |
  2375. | usertitle | varchar(100) |
  2376. | wolpermissions | int(10) unsigned |
  2377. +----------------------+----------------------+
  2378.  
  2379. Database: brazzers
  2380. Table: vbbthreadread
  2381. [3 columns]
  2382. +----------+------------------+
  2383. | Column | Type |
  2384. +----------+------------------+
  2385. | readtime | int(10) unsigned |
  2386. | threadid | int(10) unsigned |
  2387. | userid | int(10) unsigned |
  2388. +----------+------------------+
  2389.  
  2390. Database: brazzers
  2391. Table: favorites_folders
  2392. [5 columns]
  2393. +------------------+--------------+
  2394. | Column | Type |
  2395. +------------------+--------------+
  2396. | folder_id | int(11) |
  2397. | folder_name | varchar(255) |
  2398. | folder_type | varchar(255) |
  2399. | member_id | int(11) |
  2400. | parent_folder_id | int(11) |
  2401. +------------------+--------------+
  2402.  
  2403. Database: brazzers
  2404. Table: vbbpaymentapi
  2405. [7 columns]
  2406. +--------------+------------------+
  2407. | Column | Type |
  2408. +--------------+------------------+
  2409. | active | smallint(6) |
  2410. | classname | varchar(250) |
  2411. | currency | varchar(250) |
  2412. | paymentapiid | int(10) unsigned |
  2413. | recurring | smallint(6) |
  2414. | settings | mediumtext |
  2415. | title | varchar(250) |
  2416. +--------------+------------------+
  2417.  
  2418. Database: brazzers
  2419. Table: vbbuserpromotion
  2420. [8 columns]
  2421. +-----------------+------------------+
  2422. | Column | Type |
  2423. +-----------------+------------------+
  2424. | date | int(10) unsigned |
  2425. | joinusergroupid | int(10) unsigned |
  2426. | posts | int(10) unsigned |
  2427. | reputation | int(11) |
  2428. | strategy | smallint(6) |
  2429. | type | smallint(6) |
  2430. | usergroupid | int(10) unsigned |
  2431. | userpromotionid | int(10) unsigned |
  2432. +-----------------+------------------+
  2433.  
  2434. Database: brazzers
  2435. Table: job_globals
  2436. [2 columns]
  2437. +---------+---------+
  2438. | Column | Type |
  2439. +---------+---------+
  2440. | minute | int(11) |
  2441. | site_id | int(11) |
  2442. +---------+---------+
  2443.  
  2444. Database: brazzers
  2445. Table: vbbinfractionban
  2446. [6 columns]
  2447. +-----------------+------------------------------+
  2448. | Column | Type |
  2449. +-----------------+------------------------------+
  2450. | amount | int(10) unsigned |
  2451. | banusergroupid | int(10) unsigned |
  2452. | infractionbanid | int(10) unsigned |
  2453. | method | enum('points','infractions') |
  2454. | period | char(5) |
  2455. | usergroupid | int(11) |
  2456. +-----------------+------------------------------+
  2457.  
  2458. Database: brazzers
  2459. Table: announcements
  2460. [7 columns]
  2461. +-----------------+--------------+
  2462. | Column | Type |
  2463. +-----------------+--------------+
  2464. | announcement | text |
  2465. | announcement_id | int(11) |
  2466. | date_added | int(11) |
  2467. | employee_id | int(255) |
  2468. | end_date | int(11) |
  2469. | start_date | int(11) |
  2470. | subject | varchar(255) |
  2471. +-----------------+--------------+
  2472.  
  2473. Database: brazzers
  2474. Table: vbbstyle
  2475. [12 columns]
  2476. +--------------+----------------------+
  2477. | Column | Type |
  2478. +--------------+----------------------+
  2479. | css | mediumtext |
  2480. | csscolors | mediumtext |
  2481. | displayorder | smallint(5) unsigned |
  2482. | editorstyles | mediumtext |
  2483. | parentid | smallint(6) |
  2484. | parentlist | varchar(250) |
  2485. | replacements | mediumtext |
  2486. | styleid | smallint(5) unsigned |
  2487. | stylevars | mediumtext |
  2488. | templatelist | mediumtext |
  2489. | title | varchar(250) |
  2490. | userselect | smallint(5) unsigned |
  2491. +--------------+----------------------+
  2492.  
  2493. Database: brazzers
  2494. Table: models
  2495. [10 columns]
  2496. +--------------------------+--------------+
  2497. | Column | Type |
  2498. +--------------------------+--------------+
  2499. | bio | text |
  2500. | date_added | int(11) |
  2501. | dynamic_rating_num_votes | int(11) |
  2502. | dynamic_rating_sum_votes | int(11) |
  2503. | is_active | tinyint(1) |
  2504. | model_id | int(11) |
  2505. | model_name | varchar(255) |
  2506. | pic | varchar(255) |
  2507. | rating_total | double |
  2508. | total_ratings | int(11) |
  2509. +--------------------------+--------------+
  2510.  
  2511. Database: brazzers
  2512. Table: vbbforumpermission
  2513. [4 columns]
  2514. +-------------------+----------------------+
  2515. | Column | Type |
  2516. +-------------------+----------------------+
  2517. | forumid | smallint(5) unsigned |
  2518. | forumpermissionid | smallint(5) unsigned |
  2519. | forumpermissions | int(10) unsigned |
  2520. | usergroupid | smallint(5) unsigned |
  2521. +-------------------+----------------------+
  2522.  
  2523. Database: brazzers
  2524. Table: vbbcalendar
  2525. [14 columns]
  2526. +---------------+----------------------+
  2527. | Column | Type |
  2528. +---------------+----------------------+
  2529. | birthdaycount | smallint(5) unsigned |
  2530. | calendarid | int(10) unsigned |
  2531. | cutoff | smallint(5) unsigned |
  2532. | description | varchar(100) |
  2533. | displayorder | smallint(6) |
  2534. | endyear | smallint(5) unsigned |
  2535. | eventcount | smallint(5) unsigned |
  2536. | holidays | int(10) unsigned |
  2537. | moderatenew | smallint(6) |
  2538. | neweventemail | text |
  2539. | options | int(10) unsigned |
  2540. | startofweek | smallint(6) |
  2541. | startyear | smallint(5) unsigned |
  2542. | title | varchar(255) |
  2543. +---------------+----------------------+
  2544.  
  2545. Database: brazzers
  2546. Table: vbbavatar
  2547. [6 columns]
  2548. +-----------------+----------------------+
  2549. | Column | Type |
  2550. +-----------------+----------------------+
  2551. | avatarid | smallint(5) unsigned |
  2552. | avatarpath | varchar(100) |
  2553. | displayorder | smallint(5) unsigned |
  2554. | imagecategoryid | smallint(5) unsigned |
  2555. | minimumposts | int(10) unsigned |
  2556. | title | varchar(100) |
  2557. +-----------------+----------------------+
  2558.  
  2559. Database: brazzers
  2560. Table: vbbpostparsed
  2561. [6 columns]
  2562. +---------------+----------------------+
  2563. | Column | Type |
  2564. +---------------+----------------------+
  2565. | dateline | int(10) unsigned |
  2566. | hasimages | smallint(6) |
  2567. | languageid | smallint(5) unsigned |
  2568. | pagetext_html | mediumtext |
  2569. | postid | int(10) unsigned |
  2570. | styleid | smallint(5) unsigned |
  2571. +---------------+----------------------+
  2572.  
  2573. Database: brazzers
  2574. Table: vbbsession
  2575. [16 columns]
  2576. +---------------+----------------------+
  2577. | Column | Type |
  2578. +---------------+----------------------+
  2579. | badlocation | smallint(5) unsigned |
  2580. | bypass | tinyint(4) |
  2581. | host | char(15) |
  2582. | idhash | char(32) |
  2583. | incalendar | smallint(5) unsigned |
  2584. | inforum | smallint(5) unsigned |
  2585. | inthread | int(10) unsigned |
  2586. | languageid | smallint(5) unsigned |
  2587. | lastactivity | int(10) unsigned |
  2588. | location | char(255) |
  2589. | loggedin | smallint(5) unsigned |
  2590. | profileupdate | smallint(5) unsigned |
  2591. | sessionhash | char(32) |
  2592. | styleid | smallint(5) unsigned |
  2593. | useragent | char(100) |
  2594. | userid | int(10) unsigned |
  2595. +---------------+----------------------+
  2596.  
  2597. Database: brazzers
  2598. Table: tags_switchboard_test
  2599. [7 columns]
  2600. +--------------------+--------------+
  2601. | Column | Type |
  2602. +--------------------+--------------+
  2603. | date_added | int(11) |
  2604. | is_active | tinyint(4) |
  2605. | item_tagged_id | int(11) |
  2606. | item_tagged_type | varchar(255) |
  2607. | tag_id | int(11) |
  2608. | tag_switchboard_id | int(11) |
  2609. | tag_type | varchar(255) |
  2610. +--------------------+--------------+
  2611.  
  2612. Database: brazzers
  2613. Table: vbbcron
  2614. [12 columns]
  2615. +----------+----------------------+
  2616. | Column | Type |
  2617. +----------+----------------------+
  2618. | active | smallint(6) |
  2619. | cronid | int(10) unsigned |
  2620. | day | smallint(6) |
  2621. | filename | varchar(50) |
  2622. | hour | smallint(6) |
  2623. | loglevel | smallint(6) |
  2624. | minute | varchar(100) |
  2625. | nextrun | int(10) unsigned |
  2626. | product | varchar(25) |
  2627. | varname | varchar(100) |
  2628. | volatile | smallint(5) unsigned |
  2629. | weekday | smallint(6) |
  2630. +----------+----------------------+
  2631.  
  2632. Database: brazzers
  2633. Table: static_uploads
  2634. [3 columns]
  2635. +------------------+--------------+
  2636. | Column | Type |
  2637. +------------------+--------------+
  2638. | folder_name | varchar(255) |
  2639. | last_update_time | int(11) |
  2640. | site_id | int(11) |
  2641. +------------------+--------------+
  2642.  
  2643. Database: brazzers
  2644. Table: vbbbbcode
  2645. [8 columns]
  2646. +-------------------+----------------------+
  2647. | Column | Type |
  2648. +-------------------+----------------------+
  2649. | bbcodeexample | varchar(200) |
  2650. | bbcodeexplanation | mediumtext |
  2651. | bbcodeid | smallint(5) unsigned |
  2652. | bbcodereplacement | mediumtext |
  2653. | bbcodetag | varchar(200) |
  2654. | buttonimage | varchar(250) |
  2655. | title | varchar(100) |
  2656. | twoparams | smallint(6) |
  2657. +-------------------+----------------------+
  2658.  
  2659. Database: brazzers
  2660. Table: vbbthreadviews
  2661. [1 column]
  2662. +----------+------------------+
  2663. | Column | Type |
  2664. +----------+------------------+
  2665. | threadid | int(10) unsigned |
  2666. +----------+------------------+
  2667.  
  2668. Database: brazzers
  2669. Table: vbbstats
  2670. [5 columns]
  2671. +----------+-----------------------+
  2672. | Column | Type |
  2673. +----------+-----------------------+
  2674. | ausers | mediumint(8) unsigned |
  2675. | dateline | int(10) unsigned |
  2676. | npost | mediumint(8) unsigned |
  2677. | nthread | mediumint(8) unsigned |
  2678. | nuser | mediumint(8) unsigned |
  2679. +----------+-----------------------+
  2680.  
  2681. Database: brazzers
  2682. Table: playlists_videos
  2683. [2 columns]
  2684. +-------------+---------+
  2685. | Column | Type |
  2686. +-------------+---------+
  2687. | playlist_id | int(11) |
  2688. | video_id | int(11) |
  2689. +-------------+---------+
  2690.  
  2691. Database: brazzers
  2692. Table: xscore_scene_queue
  2693. [3 columns]
  2694. +----------+---------+
  2695. | Column | Type |
  2696. +----------+---------+
  2697. | rank | int(11) |
  2698. | scene_id | int(11) |
  2699. | site_id | int(11) |
  2700. +----------+---------+
  2701.  
  2702. Database: brazzers
  2703. Table: vbbeditlog
  2704. [5 columns]
  2705. +----------+------------------+
  2706. | Column | Type |
  2707. +----------+------------------+
  2708. | dateline | int(10) unsigned |
  2709. | postid | int(10) unsigned |
  2710. | reason | varchar(200) |
  2711. | userid | int(10) unsigned |
  2712. | username | varchar(100) |
  2713. +----------+------------------+
  2714.  
  2715. Database: brazzers
  2716. Table: vbbimagecategory
  2717. [4 columns]
  2718. +-----------------+----------------------+
  2719. | Column | Type |
  2720. +-----------------+----------------------+
  2721. | displayorder | smallint(5) unsigned |
  2722. | imagecategoryid | smallint(5) unsigned |
  2723. | imagetype | smallint(5) unsigned |
  2724. | title | varchar(255) |
  2725. +-----------------+----------------------+
  2726.  
  2727. Database: brazzers
  2728. Table: jobs_sites
  2729. [2 columns]
  2730. +---------+---------+
  2731. | Column | Type |
  2732. +---------+---------+
  2733. | job_id | int(11) |
  2734. | site_id | int(11) |
  2735. +---------+---------+
  2736.  
  2737. Database: brazzers
  2738. Table: vbbtemplatehistory
  2739. [8 columns]
  2740. +-------------------+----------------------+
  2741. | Column | Type |
  2742. +-------------------+----------------------+
  2743. | comment | varchar(255) |
  2744. | dateline | int(10) unsigned |
  2745. | styleid | smallint(5) unsigned |
  2746. | template | mediumtext |
  2747. | templatehistoryid | int(10) unsigned |
  2748. | title | varchar(100) |
  2749. | username | varchar(100) |
  2750. | version | varchar(30) |
  2751. +-------------------+----------------------+
  2752.  
  2753. Database: brazzers
  2754. Table: ratings_switchboard
  2755. [8 columns]
  2756. +-----------------------+--------------+
  2757. | Column | Type |
  2758. +-----------------------+--------------+
  2759. | date_added | int(11) |
  2760. | item_rated_id | int(11) |
  2761. | item_rated_type | varchar(255) |
  2762. | rating | double |
  2763. | rating_switchboard_id | int(11) |
  2764. | user_id | int(11) |
  2765. | user_ip | varchar(15) |
  2766. | user_type | varchar(255) |
  2767. +-----------------------+--------------+
  2768.  
  2769. Database: brazzers
  2770. Table: employees_groups
  2771. [2 columns]
  2772. +-------------+---------+
  2773. | Column | Type |
  2774. +-------------+---------+
  2775. | employee_id | int(11) |
  2776. | group_id | int(11) |
  2777. +-------------+---------+
  2778.  
  2779. Database: brazzers
  2780. Table: spot_buyer_scenes_potential_sales
  2781. [3 columns]
  2782. +---------------------+-------------+
  2783. | Column | Type |
  2784. +---------------------+-------------+
  2785. | date_added | int(11) |
  2786. | ip | varchar(15) |
  2787. | spot_buyer_scene_id | int(11) |
  2788. +---------------------+-------------+
  2789.  
  2790. Database: brazzers
  2791. Table: dvds_scenes
  2792. [2 columns]
  2793. +----------+---------+
  2794. | Column | Type |
  2795. +----------+---------+
  2796. | dvd_id | int(11) |
  2797. | scene_id | int(11) |
  2798. +----------+---------+
  2799.  
  2800. Database: brazzers
  2801. Table: vbbsigparsed
  2802. [5 columns]
  2803. +-----------------+----------------------+
  2804. | Column | Type |
  2805. +-----------------+----------------------+
  2806. | hasimages | smallint(5) unsigned |
  2807. | languageid | smallint(5) unsigned |
  2808. | signatureparsed | mediumtext |
  2809. | styleid | smallint(5) unsigned |
  2810. | userid | int(10) unsigned |
  2811. +-----------------+----------------------+
  2812.  
  2813. Database: brazzers
  2814. Table: vbbforumread
  2815. [3 columns]
  2816. +----------+----------------------+
  2817. | Column | Type |
  2818. +----------+----------------------+
  2819. | forumid | smallint(5) unsigned |
  2820. | readtime | int(10) unsigned |
  2821. | userid | int(10) unsigned |
  2822. +----------+----------------------+
  2823.  
  2824. More & Shell && Rooted.
  2825.  
  2826. // (c) r00tw0rm team, Xenu
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top