sql structure improvement
In the sql data structure, you should replace INT (11) with INT (10) UNISIGNED
there are in 2 tables, 2 identical indexes.
This takes up unnecessary space
ust_movements and ust_clients
PRIMARY KEY (id),
UNIQUE KEY id (id),
3
votes
nico78180
shared this idea
The INT was changed to INT unsigned. Note that all INTs take up 4 bytes, the value in brackets only shows how many digits to display. Unsigned was added to double maximum value.
I have removed the unique index on the IDs. Probably they were ignored anyway as you can’t have both primary and unique.
Thanks for the report!