Hello,
 
I have the fullowing sql db sheme and like to del an email. What do I need to del from each db?
 
Thanks,
 
Alex
 

mysql> describe bayes_expire;
+---------+---------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| id      | int(11) |      | MUL | 0       |       |
| runtime | int(11) |      |     | 0       |       |
+---------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
 
mysql> describe bayes_global_vars;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| variable | varchar(30)  |      | PRI |         |       |
| value    | varchar(200) |      |     |         |       |
+----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
 
mysql> describe bayes_seen;
+-------+---------------------+------+-----+---------+-------+
| Field | Type                | Null | Key | Default | Extra |
+-------+---------------------+------+-----+---------+-------+
| id    | int(11)             |      | PRI | 0       |       |
| msgid | varchar(200) binary |      | PRI |         |       |
| flag  | char(1)             |      |     |         |       |
+-------+---------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
 
mysql> describe bayes_token;
+------------+---------+------+-----+---------+-------+
| Field      | Type    | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+-------+
| id         | int(11) |      | PRI | 0       |       |
| token      | char(5) |      | PRI |         |       |
| spam_count | int(11) |      |     | 0       |       |
| ham_count  | int(11) |      |     | 0       |       |
| atime      | int(11) |      |     | 0       |       |
+------------+---------+------+-----+---------+-------+
5 rows in set (0.00 sec)
 
mysql> describe bayes_vars;
+--------------------+--------------+------+-----+------------+----------------+
| Field              | Type         | Null | Key | Default    | Extra          |
+--------------------+--------------+------+-----+------------+----------------+
| id                 | int(11)      |      | PRI | NULL       | auto_increment |
| username           | varchar(200) |      | UNI |            |                |
| spam_count         | int(11)      |      |     | 0          |                |
| ham_count          | int(11)      |      |     | 0          |                |
| token_count        | int(11)      |      |     | 0          |                |
| last_expire        | int(11)      |      |     | 0          |                |
| last_atime_delta   | int(11)      |      |     | 0          |                |
| last_expire_reduce | int(11)      |      |     | 0          |                |
| oldest_token_age   | int(11)      |      |     | 2147483647 |                |
| newest_token_age   | int(11)      |      |     | 0          |                |
+--------------------+--------------+------+-----+------------+----------------+
10 rows in set (0.00 sec)

Reply via email to