Mousing over any column name shown in link font will provide more information on the data it contains
There is a window at the bottom of the page where you can entery SQL queries and view the results in a number of formats
| viper_topics | |||||
| Field | Type | Null | Key | Default | Extra |
| topic_id | mediumint(8) unsigned | NO | PRI | auto_increment | |
| forum_id | mediumint(8) unsigned | NO | MUL | ||
| icon_id | mediumint(8) unsigned | NO | |||
| topic_attachment | tinyint(1) unsigned | NO | |||
| topic_approved | tinyint(1) unsigned | NO | MUL | 1 | |
| topic_reported | tinyint(1) unsigned | NO | |||
| topic_title | varchar(255) | NO | |||
| topic_poster | mediumint(8) unsigned | NO | |||
| topic_time | int(11) unsigned | NO | |||
| topic_time_limit | int(11) unsigned | NO | |||
| topic_views | mediumint(8) unsigned | NO | |||
| topic_replies | mediumint(8) unsigned | NO | |||
| topic_replies_real | mediumint(8) unsigned | NO | |||
| topic_status | tinyint(3) | NO | |||
| topic_type | tinyint(3) | NO | |||
| topic_first_post_id | mediumint(8) unsigned | NO | |||
| topic_first_poster_name | varchar(255) | NO | |||
| topic_first_poster_colour | varchar(6) | NO | |||
| topic_last_post_id | mediumint(8) unsigned | NO | |||
| topic_last_poster_id | mediumint(8) unsigned | NO | |||
| topic_last_poster_name | varchar(255) | NO | |||
| topic_last_poster_colour | varchar(6) | NO | |||
| topic_last_post_subject | varchar(255) | NO | |||
| topic_last_post_time | int(11) unsigned | NO | MUL | ||
| topic_last_view_time | int(11) unsigned | NO | |||
| topic_moved_id | mediumint(8) unsigned | NO | |||
| topic_bumped | tinyint(1) unsigned | NO | |||
| topic_bumper | mediumint(8) unsigned | NO | |||
| poll_title | varchar(255) | NO | |||
| poll_start | int(11) unsigned | NO | |||
| poll_length | int(11) unsigned | NO | |||
| poll_max_options | tinyint(4) | NO | 1 | ||
| poll_last_vote | int(11) unsigned | NO | |||
| poll_vote_change | tinyint(1) unsigned | NO | |||
Note: Only SELECT, SHOW or DESCRIBE queries can be performed, any other command will generate an error
 |
 |
|
|
Main |
Data & Analysis |
Utilities |
Search |
Contact Us |
Help |
Links |
Mailing List |
Cite VIPERdb |
Disclaimer
|
|
