[Vtigercrm-developers] Why include a SQL file when we don't use it?

Allan Bush allan.bush+vtiger_dev at gmail.com
Tue Feb 21 16:00:18 PST 2006


The difference is with a sql file you'll have one file for each
database type where 90%+ of the code is the same in all the files
verses one xml file for all database types.  It's a lot easier and
cleaner to modify one file.

On 2/21/06, Fathi BOUDRA <fboudra at free.fr> wrote:
> > Just add the queries to populate the database into the xml file like this:
> >
> > <sql>
> >   <descr>Insert some data into the users table.</descr>
> >   <query>insert into users (userName) values ( 'admin' )</query>
> >
> >   <query>insert into users (userName) values ( 'Joe' )</query>
> > </sql>
> >
> > To install the database, create a simple php file (like the one in the
> > current installer or see here for another example
> > http://phplens.com/lens/adodb/docs-datadict.htm) and run it on
> > install: php install.php.
>
> what is the difference between embedding sql query in an xml file, add an
> install.php to call this xml file rather call an sql file.
>
> from my point of view the same. This isn't a technical problem but a
> philosophy question.
>
> introducing this sql seems to not be pleased. Maybe a poll on it can be asked.
> anyway i use and will use the sql file for debian and ubuntu packaging.
> just need to know if you (developers) wants it in source code or not.
> _______________________________________________
> This vtiger.com email is sponsored by: Zoho Writer. Are you still using your desktop word processor for typing documents? Try the AJAX enabled, collaboration-friendly online word processor, Zoho Writer for FREE instead!
> http://zohowriter.com/?vt
>




More information about the vtigercrm-developers mailing list