| # |
Feb 19th 2009, 15:35 |
alkemann |
yes they could put it in free text, but many wouldnt think to do so. and being international community, it can be useful to know where ppl are.. time zone wise |
| # |
Feb 19th 2009, 15:34 |
alkemann |
location might be useful thought. |
| # |
Feb 19th 2009, 15:32 |
AD7six |
and my db is way old, so I'm sure there are more users and the same profiles :) |
| # |
Feb 19th 2009, 15:31 |
ADmad |
so i says just id, user_id, published and some_free_field where they can put whatever they want to share if anything at all |
| # |
Feb 19th 2009, 15:31 |
AD7six |
so practically nobody |
| # |
Feb 19th 2009, 15:31 |
AD7six |
<5% of users have a profile (323 profiles, 6k users), ~40 of each im |
| # |
Feb 19th 2009, 15:29 |
ADmad |
interests, occupations .... dont need all these social networkng kinda crap |
| # |
Feb 19th 2009, 15:29 |
alkemann |
there is a freefield ppl can write contact info if they want |
| # |
Feb 19th 2009, 15:29 |
AD7six |
I have an old dump, let's see what's in there |
| # |
Feb 19th 2009, 15:29 |
ADmad |
AD7six: i say scrap all the extra crap |
| # |
Feb 19th 2009, 15:29 |
alkemann |
i say we drop em.. unless there are lots of ppl using them |
| # |
Feb 19th 2009, 15:29 |
AD7six |
alkemann: it's currently md5 with no salt |
| # |
Feb 19th 2009, 15:28 |
AD7six |
ADmad: I don't think anyone uses them, but they currently exist |
| # |
Feb 19th 2009, 15:28 |
alkemann |
md5. |
| # |
Feb 19th 2009, 15:28 |
AD7six |
why change what? |
| # |
Feb 19th 2009, 15:27 |
ADmad |
do we need all those messenger fields ? |
| # |
Feb 19th 2009, 15:27 |
alkemann |
why change? |
| # |
Feb 19th 2009, 15:25 |
AD7six |
seem ok? |
| # |
Feb 19th 2009, 15:25 |
AD7six |
users plugin schema: http://bin.cakephp.org/view/1054466554 old_passwords to allow us to transparently change from current md5 -> sha1 without affecting users |
| # |
Feb 19th 2009, 15:16 |
alkemann |
ok |
| # |
Feb 19th 2009, 15:16 |
AD7six |
design for no joins across <big fence> and we're golden :) |
| # |
Feb 19th 2009, 15:15 |
AD7six |
so user + profile < big fence > (role|user_profile|aname) + rest of app data |
| # |
Feb 19th 2009, 15:15 |
AD7six |
it's in the current bakery's schema because the bakery was the first app but it's entirely generic. |
| # |
Feb 19th 2009, 15:14 |
AD7six |
alkemann: look at the current bakery profiles table |
| # |
Feb 19th 2009, 15:14 |
alkemann |
AD7six: think the plugin is a bit greedy if it also claims UserProfile |
| # |
Feb 19th 2009, 15:14 |
AD7six |
ADmad: so I could during this conversation (effectively) refer to both with a different name |
| # |
Feb 19th 2009, 15:14 |
ADmad |
nvm.. its user_profiles in the AD7six's schema |
| # |
Feb 19th 2009, 15:13 |
AD7six |
but each app needs something to point at a user and hold the app's settings etc. |
| # |
Feb 19th 2009, 15:13 |
ADmad |
why is it not user_profiles :) |
| # |
Feb 19th 2009, 15:13 |
AD7six |
user_profile is maybe the wrong name. in the users _plugin_ would be users and profiles. |
| # |
Feb 19th 2009, 15:12 |
AD7six |
any (other) suggestions |
| # |
Feb 19th 2009, 15:12 |
AD7six |
alkemann: that's what I'm currently thinking |
| # |
Feb 19th 2009, 15:11 |
alkemann |
and each of these apps have a separate users_profile model instead? |
| # |
Feb 19th 2009, 15:11 |
AD7six |
yes, or designed to be so. |
| # |
Feb 19th 2009, 15:11 |
alkemann |
a plugin that is installed in all cakephp.org apps? |
| # |
Feb 19th 2009, 15:11 |
AD7six |
thats a lot slimmer than the current bakery's users table |
| # |
Feb 19th 2009, 15:10 |
AD7six |
alkemann: there must be a users table, it's just not on the app side of things. |
| # |
Feb 19th 2009, 15:10 |
alkemann |
we* |
| # |
Feb 19th 2009, 15:10 |
alkemann |
have have a users table then? |
| # |
Feb 19th 2009, 15:09 |
AD7six |
afais |
| # |
Feb 19th 2009, 15:09 |
AD7six |
and.. that's all that would be needed in the users table: http://bin.cakephp.org/view/50458369 |