<div id="content">
<h1 align="center">Source for file Informix.php</h1>
<p>Documentation is available at <a href="../Doctrine/_Doctrine---Import---Informix.php.html">Informix.php</a></p>
<div class="src-code"><span class="php">
<ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li>
<li><div class="src-line"><a name="a2"></a><span class="src-comm">/*</span></div></li>
<li><div class="src-line"><a name="a3"></a><span class="src-comm"> * $Id: Informix.php 1080 2007-02-10 18:17:08Z romanb $</span></div></li>
<li><div class="src-line"><a name="a4"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a5"></a><span class="src-comm"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS</span></div></li>
<li><div class="src-line"><a name="a6"></a><span class="src-comm"> * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a7"></a><span class="src-comm"> * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR</span></div></li>
<li><div class="src-line"><a name="a8"></a><span class="src-comm"> * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT</span></div></li>
<li><div class="src-line"><a name="a9"></a><span class="src-comm"> * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,</span></div></li>
<li><div class="src-line"><a name="a10"></a><span class="src-comm"> * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a11"></a><span class="src-comm"> * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,</span></div></li>
<li><div class="src-line"><a name="a12"></a><span class="src-comm"> * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY</span></div></li>
<li><div class="src-line"><a name="a13"></a><span class="src-comm"> * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT</span></div></li>
<li><div class="src-line"><a name="a14"></a><span class="src-comm"> * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE</span></div></li>
<li><div class="src-line"><a name="a15"></a><span class="src-comm"> * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.</span></div></li>
<li><div class="src-line"><a name="a16"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a17"></a><span class="src-comm"> * This software consists of voluntary contributions made by many individuals</span></div></li>
<li><div class="src-line"><a name="a18"></a><span class="src-comm"> * and is licensed under the LGPL. For more information, see</span></div></li>
<li><div class="src-line"><a name="a19"></a><span class="src-comm"> * <http://www.phpdoctrine.com>.</span></div></li>
<li><div class="src-line"><a name="a20"></a><span class="src-comm"> */</span></div></li>
<li><div class="src-line"><a name="a21"></a><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><a href="../Doctrine/Doctrine.html#methodautoload">autoload</a><span class="src-sym">(</span><span class="src-str">'Doctrine_Import'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a22"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a23"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Doctrine</span></div></li>
<li><div class="src-line"><a name="a24"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.opensource.org/licenses/lgpl-license.php LGPL</span></div></li>
<li><div class="src-line"><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Konsta Vesterinen <kvesteri@cc.hut.fi></span></div></li>
<li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Lukas Smith <smith@pooteeweet.org> (PEAR MDB2 library)</span></div></li>
<li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 1080 $</span></div></li>
<li><div class="src-line"><a name="a28"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> Object Relational Mapping</span></div></li>
<li><div class="src-line"><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> www.phpdoctrine.com</span></div></li>
<li><div class="src-line"><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@since</span><span class="src-doc"> 1.0</span></div></li>
<li><div class="src-line"><a name="a31"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a32"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_Import_Informix.html">Doctrine_Import_Informix</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_Import.html">Doctrine_Import</a></div></li>
<li><div class="src-line"><a name="a33"></a><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a34"></a> <span class="src-key">protected </span><a href="../Doctrine/Doctrine_Import_Informix.html#var$sql">$sql</a> = <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a35"></a> <span class="src-str">'listTables' </span>=> <span class="src-str">"SELECT tabname,tabtype FROM systables WHERE tabtype IN ('T','V') AND owner != 'informix'"</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a36"></a> <span class="src-str">'listColumns' </span>=> <span class="src-str">"SELECT c.colname, c.coltype, c.collength, d.default, c.colno</span></div></li>
<li><div class="src-line"><a name="a37"></a><span class="src-str"> FROM syscolumns c, systables t,outer sysdefaults d</span></div></li>
<li><div class="src-line"><a name="a38"></a><span class="src-str"> WHERE c.tabid = t.tabid AND d.tabid = t.tabid AND d.colno = c.colno</span></div></li>
<li><div class="src-line"><a name="a39"></a><span class="src-str"> AND tabname='%s' ORDER BY c.colno"</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a40"></a> <span class="src-str">'listPk' </span>=> <span class="src-str">"SELECT part1, part2, part3, part4, part5, part6, part7, part8 FROM</span></div></li>
<li><div class="src-line"><a name="a41"></a><span class="src-str"> systables t, sysconstraints s, sysindexes i WHERE t.tabname='%s'</span></div></li>
<li><div class="src-line"><a name="a42"></a><span class="src-str"> AND s.tabid=t.tabid AND s.constrtype='P'</span></div></li>
<li><div class="src-line"><a name="a43"></a><span class="src-str"> AND i.idxname=s.idxname"</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a44"></a> <span class="src-str">'listForeignKeys' </span>=> <span class="src-str">"SELECT tr.tabname,updrule,delrule,</span></div></li>
<li><div class="src-line"><a name="a45"></a><span class="src-str"> i.part1 o1,i2.part1 d1,i.part2 o2,i2.part2 d2,i.part3 o3,i2.part3 d3,i.part4 o4,i2.part4 d4,</span></div></li>
<li><div class="src-line"><a name="a46"></a><span class="src-str"> i.part5 o5,i2.part5 d5,i.part6 o6,i2.part6 d6,i.part7 o7,i2.part7 d7,i.part8 o8,i2.part8 d8</span></div></li>
<li><div class="src-line"><a name="a47"></a><span class="src-str"> from systables t,sysconstraints s,sysindexes i,</span></div></li>
<li><div class="src-line"><a name="a48"></a><span class="src-str"> sysreferences r,systables tr,sysconstraints s2,sysindexes i2</span></div></li>
<li><div class="src-line"><a name="a49"></a><span class="src-str"> where t.tabname='%s'</span></div></li>
<li><div class="src-line"><a name="a50"></a><span class="src-str"> and s.tabid=t.tabid and s.constrtype='R' and r.constrid=s.constrid</span></div></li>
<li><div class="src-line"><a name="a51"></a><span class="src-str"> and i.idxname=s.idxname and tr.tabid=r.ptabid</span></div></li>
<li><div class="src-line"><a name="a52"></a><span class="src-str"> and s2.constrid=r.primary and i2.idxname=s2.idxname"</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a53"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a54"></a> </div></li>
<li><div class="src-line"><a name="a55"></a><span class="src-sym">}</span></div></li>
</ol>
</span></div>
</div>