MySQL -> nekonzistentni DB -> pad na hubu

[Ondřej Surý]

On Wed, 27 Oct 1999, you wrote:

> Co byste mi poradili delat?

Zkusil bych zmenit auto_incrementovaci radek na int unsigned

> Dekuji Vam
> 
> --- START PRIKLADU ---
> mysql> describe bruimstat;
> +--------+---------------+------+-----+---------+----------------+
> | Field  | Type          | Null | Key | Default | Extra          |
> +--------+---------------+------+-----+---------+----------------+
> | id     | int(15)       |      | PRI | 0       | auto_increment |
> | ref    | char(255)     |      |     |         |                |
> | ip     | char(15)      |      |     |         |                |
> | fileid | smallint(6)   |      |     | 0       |                |
> | cas    | timestamp(14) | YES  | MUL | NULL    |                |
> +--------+---------------+------+-----+---------+----------------+
> 5 rows in set (0.00 sec)
> 
> mysql> select id, fileid from bruimstat order by id limit 1;
> +-------------+--------+
> | id          | fileid |
> +-------------+--------+
> | -2056388608 | -27392 |
> +-------------+--------+
> 1 row in set (0.01 sec)