|
|
Something dropping all the table options (auto_increment, default values etc.). It is not just on an upgrade.
I fixed my tables last night by dropping the network table and re-adding using the schema. This morning, the options are gone again. Weird:
MariaDB [reports]> explain network;
+------------+---------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------------------+-------+
| id | bigint(20) unsigned | NO | | 0 | |
| iface | varchar(16) | NO | | NULL | |
| rx_bytes | bigint(20) | YES | | NULL | |
| rx_packets | bigint(20) | YES | | NULL | |
| rx_errors | bigint(20) | YES | | NULL | |
| rx_drop | bigint(20) | YES | | NULL | |
| rx_rate | bigint(20) | YES | | NULL | |
| tx_bytes | bigint(20) | YES | | NULL | |
| tx_packets | bigint(20) | YES | | NULL | |
| tx_errors | bigint(20) | YES | | NULL | |
| tx_drop | bigint(20) | YES | | NULL | |
| tx_rate | bigint(20) | YES | | NULL | |
| timestamp | timestamp | NO | | 0000-00-00 00:00:00 | |
+------------+---------------------+------+-----+---------------------+-------+ |
|