| # |
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 |
| # |
Feb 19th 2009, 15:07 |
AD7six |
since it's currently seemingly fluid I left as is |
| # |
Feb 19th 2009, 15:07 |
AD7six |
role would be the equivalent of group_id in the spec doc |