phpbb/Tabellen hier beschreiben...

[b]ZENSUR[/b]

mysql> select post_id,post_subject from phpbb_posts_text where post_subject like '%video%' ;
+---------+-----------------------------------------+
| post_id | post_subject                            |
+---------+-----------------------------------------+
| 677     | Free porno pictures, free porn videos ! |
| 678     | Free porno pictures, free porn videos ! |
| 679     | Free porno pictures, free porn videos ! |
| 681     | Free porno pictures, free porn videos ! |
| 682     | Free porno pictures, free porn videos ! |
| 683     | Free porno pictures, free porn videos ! |
| 687     | Free porno pictures, free porn videos ! |
| 688     | Free porno pictures, free porn videos ! |
| 690     | Free porno pictures, free porn videos ! |
| 691     | Free porno pictures, free porn videos ! |
| 692     | Free porno pictures, free porn videos ! |
| 693     | Free porno pictures, free porn videos ! |
| 694     | Free porno pictures, free porn videos ! |
| 695     | Free porno pictures, free porn videos ! |
| 696     | Free porno pictures, free porn videos ! |
| 697     | Free porno pictures, free porn videos ! |
| 698     | Free porno pictures, free porn videos ! |
| 700     | Free porno pictures, free porn videos ! |
| 699     | Free porno pictures, free porn videos ! |
| 701     | Free porno pictures, free porn videos ! |
| 703     | Free porno pictures, free porn videos ! |
| 704     | Free porno pictures, free porn videos ! |
| 705     | Free porno pictures, free porn videos ! |
| 706     | Free porno pictures, free porn videos ! |
| 707     | Free porno pictures, free porn videos ! |
| 708     | Free porno pictures, free porn videos ! |
| 709     | Free porno pictures, free porn videos ! |
| 710     | Free porno pictures, free porn videos ! |
| 711     | Free porno pictures, free porn videos ! |
| 712     | Free porno pictures, free porn videos ! |
| 713     | Free porno pictures, free porn videos ! |
| 714     | Free porno pictures, free porn videos ! |
| 715     | Free porno pictures, free porn videos ! |
| 716     | Free porno pictures, free porn videos ! |




ysql> describe phpbb_posts ;
+-----------------+-----------------------+------+-----+---------+----------------+
| Field           | Type                  | Null | Key | Default | Extra          |
+-----------------+-----------------------+------+-----+---------+----------------+
| post_id         | mediumint(8) unsigned | NO   | PRI |         | auto_increment |
| topic_id        | mediumint(8) unsigned | NO   | MUL | 0       |                |
| forum_id        | smallint(5) unsigned  | NO   | MUL | 0       |                |
| poster_id       | mediumint(8)          | NO   | MUL | 0       |                |
| post_time       | int(11)               | NO   | MUL | 0       |                |
| poster_ip       | varchar(8)            | NO   |     |         |                |
| post_username   | varchar(25)           | YES  |     |         |                |
| enable_bbcode   | tinyint(1)            | NO   |     | 1       |                |
| enable_html     | tinyint(1)            | NO   |     | 0       |                |
| enable_smilies  | tinyint(1)            | NO   |     | 1       |                |
| enable_sig      | tinyint(1)            | NO   |     | 1       |                |
| post_edit_time  | int(11)               | YES  |     |         |                |
| post_edit_count | smallint(5) unsigned  | NO   |     | 0       |                |
+-----------------+-----------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
mysql> describe phpbb_posts_text ;
+--------------+-----------------------+------+-----+---------+-------+
| Field        | Type                  | Null | Key | Default | Extra |
+--------------+-----------------------+------+-----+---------+-------+
| post_id      | mediumint(8) unsigned | NO   | PRI | 0       |       |
| bbcode_uid   | varchar(10)           | NO   |     |         |       |
| post_subject | varchar(60)           | YES  |     |         |       |
| post_text    | text                  | YES  |     |         |       |
+--------------+-----------------------+------+-----+---------+-------+
4 rows in set (0.12 sec)

mysql> describe phpbb_forums;
+--------------------+-----------------------+------+-----+---------+-------+
| Field              | Type                  | Null | Key | Default | Extra |
+--------------------+-----------------------+------+-----+---------+-------+
| forum_id           | smallint(5) unsigned  | NO   | PRI | 0       |       |
| cat_id             | mediumint(8) unsigned | NO   | MUL | 0       |       |
| forum_name         | varchar(150)          | YES  |     |         |       |
| forum_desc         | text                  | YES  |     |         |       |
| forum_status       | tinyint(4)            | NO   |     | 0       |       |
| forum_order        | mediumint(8) unsigned | NO   | MUL | 1       |       |
| forum_posts        | mediumint(8) unsigned | NO   |     | 0       |       |
| forum_topics       | mediumint(8) unsigned | NO   |     | 0       |       |
| forum_last_post_id | mediumint(8) unsigned | NO   | MUL | 0       |       |
| prune_next         | int(11)               | YES  |     |         |       |
| prune_enable       | tinyint(1)            | NO   |     | 0       |       |
| auth_view          | tinyint(2)            | NO   |     | 0       |       |
| auth_read          | tinyint(2)            | NO   |     | 0       |       |
| auth_post          | tinyint(2)            | NO   |     | 0       |       |
| auth_reply         | tinyint(2)            | NO   |     | 0       |       |
| auth_edit          | tinyint(2)            | NO   |     | 0       |       |
| auth_delete        | tinyint(2)            | NO   |     | 0       |       |
| auth_sticky        | tinyint(2)            | NO   |     | 0       |       |
| auth_announce      | tinyint(2)            | NO   |     | 0       |       |
| auth_vote          | tinyint(2)            | NO   |     | 0       |       |
| auth_pollcreate    | tinyint(2)            | NO   |     | 0       |       |
| auth_attachments   | tinyint(2)            | NO   |     | 0       |       |
+--------------------+-----------------------+------+-----+---------+-------+
22 rows in set (0.00 sec)

Forum/Tabellen (last modified 2008-11-04 07:00:07)