-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hello,
Uung HR Bhuwono wrote:
| Dear Midgardeers, | | Season's greetings to you all! We have a query: | | Regarding the table entitled "article" in midgard's standard aegir | database: is this the only place to store text-type content? Are the | fields in this database generally flexible for the sort of content most | midgard users want to put in their websites?:
Most of the Midgard tables have fields of type "longtext" which can take _a lot_ of data. The fields are preset and acknowledged by Midgard API and applications. Personally I wouldn't go on altering the Midgard tables.
There is record_extension table for extending fields. The problem with this table is the size of "value" field (which is 255 characters if I remember correctly).
| If we add several fields to this database (in addition to the | "extra1,extra2,extra3", for example fields for several secondary topic | areas which an article relates to; after we have done this, can we still | use the standard Aegir wysiwyg interface to create and manage articles, | or will we need to code our own changes;
For this purpose I would use record_extension table which stores parameters. For example:
$article = mgd_get_article($artid);
$article->parameter('relation','secondarytopic','ID_or_GUID_of_target_here');However, you can't have two parameters with same domain and name
in a single object. So you might want to use serialize() function
to store several relations into one parameter or use several names
(i.e. parameter('relation','tertiarytopic')).Somebody has already produced something like this (dig the user-list archives). Was it the Australian or New Zealand team? :)
Usage of parameters won't break Aegir. Aegir as it is does not understand the relations though...
Changing the DB tables, I don't know...(any developers around?)
Cheers!
~ //Henri
| And if we code our own changes will we then be branching off from the | main code stream and not be able to apply future updates to Midgard? | | Thanks, and apologies if this is a bit of an obvious question. |
- -- Henri Kaukola [EMAIL PROTECTED] Consultant Tel: +358-20-198 6037 Nemein Oy http://www.nemein.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/6DND3xWc2AolrKgRAqtaAJ4ibTYk4lnSY999u7YPeJuLbVwpfgCghn5E PSJqUWlDGs1fMzRsVrFwck4= =Pf/1 -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
