[wp-hackers] Fw: Creating / Inserting into Table named afterWPUsername

[Guus (IFS)]

User id not the index of course, but a field (indexed would be nicest).

----- Original Message ----- 
From: "Guus (IFS)" <guus at inspiration-for-success.com>
To: <wp-hackers at lists.automattic.com>
Sent: Monday, August 26, 2013 12:49 PM
Subject: Re: [wp-hackers] Creating / Inserting into Table named
afterWPUsername


>I did not folllow the whole conversation, but I understand you want to
>create a table per user? I don't think that's a good idea, but you could
>make an additional table and make the user id the index and store then
>something like user id, meta key, meta value, start date, end date.
>
> ----- Original Message ----- 
> From: "J.D. Grimes" <jdg at codesymphony.co>
> To: <wp-hackers at lists.automattic.com>
> Sent: Sunday, August 25, 2013 11:49 PM
> Subject: Re: [wp-hackers] Creating / Inserting into Table named after
> WPUsername
>
>
>>> The only reason I am doing it this way is because I want to have a
>>> historical record - Meaning show the whole table, including all rows,
>>> which
>>> will be dated and include several rows.  wp_usermeta only allows for one
>>> value per key and updating it results in the loss of the previous entry.
>>> That wont work for me.
>>
>> I just wanted to add another comment on this. You *can* have multiple
>> values for the same key in the usermeta table. There can be multiple rows
>> with the same meta_key, and different meta_values. I just wanted to
>> clarify that. So if you wanted to you could store all of your values in
>> the usermeta table with duplicate keys, and add a date as part of the
>> value for each record (as part of an array, for example). But it still
>> sounds to me that in your case, a separate table with a date column would
>> be better.
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers