<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16587" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=新細明體 size=2><SPAN class=353040308-02012008>Hi
Oscar:</SPAN></FONT></DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008></SPAN></FONT> </DIV>
<DIV><FONT face=新細明體 size=2><SPAN class=353040308-02012008>Do you remember why
you remove "idxs" when we create table sql???</SPAN></FONT></DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008></SPAN></FONT> </DIV>
<DIV><FONT face=新細明體 size=2><SPAN class=353040308-02012008>It makes our new
lifetype 2.0 wizard does not create any indexes when we do fresh
installation.</SPAN></FONT></DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008></SPAN></FONT> </DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008> Mark</SPAN></FONT></DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008></SPAN></FONT> </DIV>
<DIV><FONT face=新細明體 size=2><SPAN class=353040308-02012008>*** see the codes
below.</SPAN></FONT></DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008></SPAN></FONT> </DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008>==================</SPAN></FONT></DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008></SPAN></FONT> </DIV>
<DIV><FONT face=新細明體 size=2><SPAN
class=353040308-02012008> function
CreateTableSQL($tabname, $flds,
$tableoptions=false)<BR>
{<BR> if
(!$tableoptions) $tableoptions =
array();<BR>
<BR>
list($lines,$pkey) = $this->_GenFields($flds,
true);<BR>
<BR>
$taboptions =
$this->_Options($tableoptions);<BR>
$tabname = $this->TableName
($tabname);<BR>
$sql =
$this->_TableSQL($tabname,$lines,$pkey,$taboptions);<BR> $idxs
=
$this->_IndexesSQL($tabname,$flds);<BR>
<BR> $tsql =
$this->_Triggers($tabname,$taboptions);<BR>
foreach($tsql as $s) $sql[] = $s;<BR> //foreach($idxs as $i)
$sql[] =
$i; <BR> <BR>
return $sql;<BR>
}</SPAN></FONT></DIV></BODY></HTML>