I've got a database where I want to store user information and user_meta information.

The reason behind setting it up in this way was because the user_meta side may change over time and I would like to do this without disrupting the master user table.

If possible, I would like some advice on how to best set up this meta data table.

I can either set it as below:

+----+---------+----------+--------------------+
| id | user_id | key      | value              |
+----+---------+----------+--------------------+
| 1  | 1       | email    | [email protected] |
| 2  | 1       | name     | user name          |
| 3  | 1       | address  | test address       |
...

Or, I can set it as below:

+----+---------+--------------------+--------------------+--------------+
| id | user_id | email              | name               | address      |
+----+---------+--------------------+--------------------+--------------+
| 1  | 1       | [email protected] | user name          | test address |

Obviously, the top verison is more flexible, but the bottom version is space saving and perhaps more efficient, returning all the data as a single record.

Which is the best way to go about this?
Or, am I going about this completely wrong and there's another way I've not thought of?