RE: database design conundrum
That would have been my suggested approach as well. I would suggest adding a sharewithall flag to tbl_shared_things so that the user has the option. I can be tedious to individually share information that you would gladly provide to anyone who asked for it, like office email, phone and fax. It also allows that the information could be easily displayed on an open profile if desired. Dave -Original Message- From: Michael van Leest [mailto:mvanle...@gmail.com] Sent: Thursday, March 20, 2014 10:30 PM To: cf-talk Subject: Re: database design conundrum That's basically it. Depending how your would query the data is entirely up on the specific use, so that is something fun to play with. This way you have all the flexibility you need, good luck! Michael 2014-03-21 2:38 GMT+01:00 PT cft...@gmail.com: so ... tbl_users (containing things that don't need to be shared) - userid displayName archived lastLoginDate lastLoginLocation joinDate ... tbl_things_that_can_be_shared - thingid thing (emailAddress, phoneNumber, birthday) tbl_shared_things (standard join table) - (pk) userid (fk to users.userid) (pk) thingid (fk to things.thingid) (pk) toShareWithUserID (fk to users.userid) (if they are in this table, then they are shared, so no boolean is needed) tbl_user_things - (pk) userid (fk to users.userid) (pk) thingid (fk to things.thingid) thingContents (the actual contents of the things for the user in question, like 'b...@example.com', '8885551212', '01/01/1980') Then make a view of the tbl_users-tbl_things_that_can_be_shared-tbl_user_things relationships to approximate a more traditional users table for easier querying. ? On 3/20/2014 8:56 PM, Michael van Leest wrote: I would build it like this: - tbl_users (userID etc) - tbl_user_things (thing id so you can add extra things without changing the DB) - tbl_user_join_thing (userID, thingID, setting (boolean 1/0) and a optional toShareWithUserID) Hope this helps ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: database design conundrum
Aye. Thought of that. There will be predefined groups, kind of like Facebook's Only Me, Friends, Friends of Friends, Everyone groups, but I wanted users to be able to exclude specific people from an entire group share in addition to adding individuals, should they desire. Hence the slightly overcomplicated design. Who knows? the feature might not ever get used or might end up being too resource intensive to keep, but better to build it into place now than try to cram it in later ... as long as it doesn't break anything. On 3/21/2014 10:02 AM, David Phelan wrote: That would have been my suggested approach as well. I would suggest adding a sharewithall flag to tbl_shared_things so that the user has the option. I can be tedious to individually share information that you would gladly provide to anyone who asked for it, like office email, phone and fax. It also allows that the information could be easily displayed on an open profile if desired. Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Patch/update 9.0 help
The recent issues with security have led me to abandon my previous psychology of if it ain't broke, don't fix it. I'm running CF 9.0, is there a single patch/installer that I can run to bring my installation up to date, or do I need to update from 9.0 to 9.01 and then from 9.01 to 9.02? I'm just trying to determine whether the hotfixes are cumulative withing minor version, or inclusive of all versions, and I don't want to risk borking my install. Thanks, Pete Ruckelshaus ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Patch/update 9.0 help
You need to update to 9.0.1 and then inststall the 901 patches. 9.0.2 is not and update it is a separate version without verity which is no longer supported. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 21 Mar 2014 22:42, Pete Ruckelshaus pruckelsh...@gmail.com wrote: The recent issues with security have led me to abandon my previous psychology of if it ain't broke, don't fix it. I'm running CF 9.0, is there a single patch/installer that I can run to bring my installation up to date, or do I need to update from 9.0 to 9.01 and then from 9.01 to 9.02? I'm just trying to determine whether the hotfixes are cumulative withing minor version, or inclusive of all versions, and I don't want to risk borking my install. Thanks, Pete Ruckelshaus ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Patch/update 9.0 help
Awesome. Ran the 9.01 updater and the CF service won't restart now. This is why I don't update unless I have to. On Fri, Mar 21, 2014 at 6:56 PM, Russ Michaels r...@michaels.me.uk wrote: You need to update to 9.0.1 and then inststall the 901 patches. 9.0.2 is not and update it is a separate version without verity which is no longer supported. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 21 Mar 2014 22:42, Pete Ruckelshaus pruckelsh...@gmail.com wrote: The recent issues with security have led me to abandon my previous psychology of if it ain't broke, don't fix it. I'm running CF 9.0, is there a single patch/installer that I can run to bring my installation up to date, or do I need to update from 9.0 to 9.01 and then from 9.01 to 9.02? I'm just trying to determine whether the hotfixes are cumulative withing minor version, or inclusive of all versions, and I don't want to risk borking my install. Thanks, Pete Ruckelshaus ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Patch/update 9.0 help
9.0.2 is not and update it is a separate version without verity which is no longer supported. Exact, and since I've never been able to get Solr to work under 9.0.1, no chance I ugrade to 9.0.2 ! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm