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

[Mike Crowe]

Folks,

I refer you to my post: 
http://forums.vtiger.com/viewtopic.php?t=4535&highlight=

To install from command line:
	php install.php
where install.php is:
<?
require_once('config.php');
require_once('connection.php');
require_once('adodb/adodb.inc.php');
require_once('adodb/adodb-xmlschema.inc.php');

$conn = ADONewConnection($dbconfig['db_type']);
$conn->Connect($dbconfig['db_host_name'],$dbconfig['db_user_name'],
$dbconfig['db_password'],$dbconfig['db_name']);
$schema = new adoSchema( $conn );
$schema->SetUpgradeMethod('ALTER');
$schema->ExecuteInline(true);
$sql = $schema->ParseSchema( "adodb/DatabaseSchema.xml" );
?>

To create the XML file, all it takes is:
$schema = new adoSchema( $conn );
$t = $schema->ExtractSchema(true);
(now write $t to the xml file)

Mike


On Tuesday 21 February 2006 6:34 pm, Fathi BOUDRA wrote:
> > I don't understand half of what you just said but using the adodb xml
> > file for database creation is one of the only thing this project does
> > right, please continue to use it.
> >
> > The adodb xml file it designed to be cross database compatible, the
> > only thing it depends on is adodb which is already a requirement,
> > using it will save you tons of "copy and paste" code "reuse" which
> > just leads to bugs.
>
> more simple that you can understand :
> can you give me a simple command line that i can use to install database on
> windows and linux ?
>
> something that can replace something like :
> mysql < file.sql
> _______________________________________________
> 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

-- 
_____________________________________________________
Cheers!

Mike Crowe
Sr. Field Sales Engineer
ELCOM 

3030 Naomi Dr.
Clover, SC 29710
Phone: (803) 831-9050
Fax: (704) 973-7910 

mike.crowe at elcomsales.com
http://www.elcomsales.com/