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_forums | |||||
| Field | Type | Null | Key | Default | Extra |
| forum_id | mediumint(8) unsigned | NO | PRI | auto_increment | |
| parent_id | mediumint(8) unsigned | NO | |||
| left_id | mediumint(8) unsigned | NO | MUL | ||
| right_id | mediumint(8) unsigned | NO | |||
| forum_parents | mediumtext | NO | |||
| forum_name | varchar(255) | NO | |||
| forum_desc | text | NO | |||
| forum_desc_bitfield | varchar(255) | NO | |||
| forum_desc_options | int(11) unsigned | NO | 7 | ||
| forum_desc_uid | varchar(8) | NO | |||
| forum_link | varchar(255) | NO | |||
| forum_password | varchar(40) | NO | |||
| forum_style | smallint(4) unsigned | NO | |||
| forum_image | varchar(255) | NO | |||
| forum_rules | text | NO | |||
| forum_rules_link | varchar(255) | NO | |||
| forum_rules_bitfield | varchar(255) | NO | |||
| forum_rules_options | int(11) unsigned | NO | 7 | ||
| forum_rules_uid | varchar(8) | NO | |||
| forum_topics_per_page | tinyint(4) | NO | |||
| forum_type | tinyint(4) | NO | |||
| forum_status | tinyint(4) | NO | |||
| forum_posts | mediumint(8) unsigned | NO | |||
| forum_topics | mediumint(8) unsigned | NO | |||
| forum_topics_real | mediumint(8) unsigned | NO | |||
| forum_last_post_id | mediumint(8) unsigned | NO | MUL | ||
| forum_last_poster_id | mediumint(8) unsigned | NO | |||
| forum_last_post_subject | varchar(255) | NO | |||
| forum_last_post_time | int(11) unsigned | NO | |||
| forum_last_poster_name | varchar(255) | NO | |||
| forum_last_poster_colour | varchar(6) | NO | |||
| forum_flags | tinyint(4) | NO | 32 | ||
| display_subforum_list | tinyint(1) unsigned | NO | 1 | ||
| display_on_index | tinyint(1) unsigned | NO | 1 | ||
| enable_indexing | tinyint(1) unsigned | NO | 1 | ||
| enable_icons | tinyint(1) unsigned | NO | 1 | ||
| enable_prune | tinyint(1) unsigned | NO | |||
| prune_next | int(11) unsigned | NO | |||
| prune_days | mediumint(8) unsigned | NO | |||
| prune_viewed | mediumint(8) unsigned | NO | |||
| prune_freq | mediumint(8) 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
|
|
