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_posts | |||||
| Field | Type | Null | Key | Default | Extra |
| post_id | mediumint(8) unsigned | NO | PRI | auto_increment | |
| topic_id | mediumint(8) unsigned | NO | MUL | ||
| forum_id | mediumint(8) unsigned | NO | MUL | ||
| poster_id | mediumint(8) unsigned | NO | MUL | ||
| icon_id | mediumint(8) unsigned | NO | |||
| poster_ip | varchar(40) | NO | MUL | ||
| post_time | int(11) unsigned | NO | |||
| post_approved | tinyint(1) unsigned | NO | MUL | 1 | |
| post_reported | tinyint(1) unsigned | NO | |||
| enable_bbcode | tinyint(1) unsigned | NO | 1 | ||
| enable_smilies | tinyint(1) unsigned | NO | 1 | ||
| enable_magic_url | tinyint(1) unsigned | NO | 1 | ||
| enable_sig | tinyint(1) unsigned | NO | 1 | ||
| post_username | varchar(255) | NO | |||
| post_subject | varchar(255) | NO | |||
| post_text | mediumtext | NO | |||
| post_checksum | varchar(32) | NO | |||
| post_attachment | tinyint(1) unsigned | NO | |||
| bbcode_bitfield | varchar(255) | NO | |||
| bbcode_uid | varchar(8) | NO | |||
| post_postcount | tinyint(1) unsigned | NO | 1 | ||
| post_edit_time | int(11) unsigned | NO | |||
| post_edit_reason | varchar(255) | NO | |||
| post_edit_user | mediumint(8) unsigned | NO | |||
| post_edit_count | smallint(4) unsigned | NO | |||
| post_edit_locked | 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
|
|
