Primary keys needed for bat_event

please share here the DESC from mysql client for a few of those tables.
IE desc bat_event_availability_hourly_day_event ;

desc bat_event_availability_hourly_day_event ;
+---------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| unit_id | int(10) unsigned | NO | PRI | NULL | |
| year | int(11) | NO | PRI | 0 | |
| month | int(11) | NO | PRI | 0 | |
| d1 | int(11) | NO | | 0 | |
| d2 | int(11) | NO | | 0 | |
| d3 | int(11) | NO | | 0 | |
| d4 | int(11) | NO | | 0 | |
| d5 | int(11) | NO | | 0 | |
| d6 | int(11) | NO | | 0 | |
| d7 | int(11) | NO | | 0 | |
| d8 | int(11) | NO | | 0 | |
| d9 | int(11) | NO | | 0 | |
| d10 | int(11) | NO | | 0 | |
| d11 | int(11) | NO | | 0 | |
| d12 | int(11) | NO | | 0 | |
| d13 | int(11) | NO | | 0 | |
| d14 | int(11) | NO | | 0 | |
| d15 | int(11) | NO | | 0 | |
| d16 | int(11) | NO | | 0 | |
| d17 | int(11) | NO | | 0 | |
| d18 | int(11) | NO | | 0 | |
| d19 | int(11) | NO | | 0 | |
| d20 | int(11) | NO | | 0 | |
| d21 | int(11) | NO | | 0 | |
| d22 | int(11) | NO | | 0 | |
| d23 | int(11) | NO | | 0 | |
| d24 | int(11) | NO | | 0 | |
| d25 | int(11) | NO | | 0 | |
| d26 | int(11) | NO | | 0 | |
| d27 | int(11) | NO | | 0 | |
| d28 | int(11) | NO | | 0 | |
| d29 | int(11) | NO | | 0 | |
| d30 | int(11) | NO | | 0 | |
| d31 | int(11) | NO | | 0 | |
+---------+------------------+------+-----+---------+-------+
34 rows in set (0.002 sec)

desc bat_event_availability_hourly_minute_state;
+---------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| unit_id | int(10) unsigned | NO | PRI | NULL | |
| year | int(11) | NO | PRI | 0 | |
| month | int(11) | NO | PRI | 0 | |
| day | int(11) | NO | PRI | 0 | |
| hour | int(11) | NO | PRI | 0 | |
| m00 | int(11) | NO | | 0 | |
| m01 | int(11) | NO | | 0 | |
| m02 | int(11) | NO | | 0 | |
| m03 | int(11) | NO | | 0 | |
| m04 | int(11) | NO | | 0 | |
| m05 | int(11) | NO | | 0 | |
| m06 | int(11) | NO | | 0 | |
| m07 | int(11) | NO | | 0 | |
| m08 | int(11) | NO | | 0 | |
| m09 | int(11) | NO | | 0 | |
| m10 | int(11) | NO | | 0 | |
| m11 | int(11) | NO | | 0 | |
| m12 | int(11) | NO | | 0 | |
| m13 | int(11) | NO | | 0 | |
| m14 | int(11) | NO | | 0 | |
| m15 | int(11) | NO | | 0 | |
| m16 | int(11) | NO | | 0 | |
| m17 | int(11) | NO | | 0 | |
| m18 | int(11) | NO | | 0 | |
| m19 | int(11) | NO | | 0 | |
| m20 | int(11) | NO | | 0 | |
| m21 | int(11) | NO | | 0 | |
| m22 | int(11) | NO | | 0 | |
| m23 | int(11) | NO | | 0 | |
| m24 | int(11) | NO | | 0 | |
| m25 | int(11) | NO | | 0 | |
| m26 | int(11) | NO | | 0 | |
| m27 | int(11) | NO | | 0 | |
| m28 | int(11) | NO | | 0 | |
| m29 | int(11) | NO | | 0 | |
| m30 | int(11) | NO | | 0 | |
| m31 | int(11) | NO | | 0 | |
| m32 | int(11) | NO | | 0 | |
| m33 | int(11) | NO | | 0 | |
| m34 | int(11) | NO | | 0 | |
| m35 | int(11) | NO | | 0 | |
| m36 | int(11) | NO | | 0 | |
| m37 | int(11) | NO | | 0 | |
| m38 | int(11) | NO | | 0 | |
| m39 | int(11) | NO | | 0 | |
| m40 | int(11) | NO | | 0 | |
| m41 | int(11) | NO | | 0 | |
| m42 | int(11) | NO | | 0 | |
| m43 | int(11) | NO | | 0 | |
| m44 | int(11) | NO | | 0 | |
| m45 | int(11) | NO | | 0 | |
| m46 | int(11) | NO | | 0 | |
| m47 | int(11) | NO | | 0 | |
| m48 | int(11) | NO | | 0 | |
| m49 | int(11) | NO | | 0 | |
| m50 | int(11) | NO | | 0 | |
| m51 | int(11) | NO | | 0 | |
| m52 | int(11) | NO | | 0 | |
| m53 | int(11) | NO | | 0 | |
| m54 | int(11) | NO | | 0 | |
| m55 | int(11) | NO | | 0 | |
| m56 | int(11) | NO | | 0 | |
| m57 | int(11) | NO | | 0 | |
| m58 | int(11) | NO | | 0 | |
| m59 | int(11) | NO | | 0 | |
+---------+------------------+------+-----+---------+-------+
65 rows in set (0.001 sec)

On BAT existing instances, you can

ALTER TABLE TABLE_NAME ADD PRIMARY KEY(unit_id, year, month);

or produce the proper hook_update_????()