I'm fairly new to the SharePoint 2010 development world (I'm more of an infrastructure guy) so please bear with me.
We have a number of time zones we support and we would like to make these available to a large number of site collections.
In the past we have stored the time zones in a custom database, but I am hoping to change this and use the SP2010 out of the box functionality to centralise storage of the time zones.
My thought was to create a site column, add it to a content type then publish the content type from a CT hub.
However, I have encountered two issues with this:
If I try to create a list definition based on a content type, Visual Studio appears to require that the content type be defined within the same solution - is that correct?
Based on this article I don't seem to be able to create the content types declaratively and publish them from a CT hub. Could I instead create a farm-scoped feature with code to create the content types with a GUID? My concern is moving these developments between development and production environments.
A key requirement is being able to update the column centrally and push the changes to all site collections - something that was very easy when we stored the values in a custom database.
Any suggestions or thoughts welcome. Thanks in advance.