le Mon, Dec 29, 2003 at 11:37:48AM -0500 par Dennis Heltzel :
> Since I wrote the profile feature, I'll explain how it's designed to work:
> 1) DB created manually
> 2) tiki-install.php runs the DB specific version of tiki.sql to create
> objects and populate the established "defaults". The
> db/profile/default-inserts.sql script is never actually run. but needs to
> reflect the default values in tiki.sql for creating the profiles.
> Essentially, the default inserts are subtracted from a database dump to
> prevent re-running thme as part of the profiles.
> 3) The selected "profile" script is run after the tiki.sql script. It only
> adds/updates the items that are different than the default install. If you
> look at the "_default.prf" file (named that so it will always be at the
> top of the list), it is empty. This is to keep things backwardly
> Doing it this way makes it easy to visually inspect the profiles and see
> exactly what is changed from the Tiki default values. I didn't create the
> BasicEnabled profile, so I can't address the specifics there, but the
> errors that result from duplications are safe to ignore. If the profile
> designer wants to change the value of a record that already has a default,
> the statement should be an update or replace instead of an insert.
- as dennis explains, Profiles are stored values to avoid manual
configuration at install, and they can be used in skeleton.
But that tool is recent, and few already understood the possibilities
it opens. Dennis provided 2 profiles, and I felt we needed another
that's why I made BasicEnabled profile. But I used there arbitrary
personnal choices. I hope to make more of them to provide a
BasicChoice. But anyone can produce sample configurations.
I added in mk_profile.sh some more tables to extract from, and the
ones that have ; are modules, that use a serialized string, ending
with that char. I added an antislash to escape them and comited the
If you need information on who recently changed a files, use :
# cvs log db/profiles/BasicEnabled.prf | more
# cvs annotate db/profiles/BasicEnabled.prf | less
> Hope that helps clarify things.
> > Because I probably won't be awake when the rest of you are online, I
> > need to ask about DB profiles.
> > I found an error in HEAD re db/profiles/BasicEnabled.prf - there are 4
> > SQL statements that have ';' in them, which is confusing the tables
> > creation. Not sure what the fix is, but thought I should let you know.
> > The second problem I need to ask about - are default inserts officially
> > being moved from db/tiki.sql to db/profile/default-inserts.sql??
> > There is an error occurring under HEAD, where tiki_p_add_events is
> > INSERTed twice, causing an error. Not sure whether tiki.sql or
> > default-inserts.sql should be modified to fix.
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
> Free Linux Tutorials. Learn everything from the bash shell to sys admin.
> Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> Tikiwiki-devel mailing list