<?php
  include_once '../doc-typo3-funcs.php';
  $doxygen_vars = array(	"title" => "TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/adodb/adodb/datadict/datadict-mysql.inc.php Source File",
				"datetime" => "Sat Dec 2 19:22:25 2006",
				"date" => "2 Dec 2006",
				"doxygenversion" => "1.4.6",
				"projectname" => "TYPO3 4.0.1",
				"projectnumber" => "4.0.1"
			);
  get_header($doxygen_vars);
?>
<!-- Generated by Doxygen 1.4.6 -->
<div class="tabs">
  <ul>
    <li><a href="main.html"><span>Main&nbsp;Page</span></a></li>
    <li><a href="namespaces.html"><span>Namespaces</span></a></li>
    <li><a href="classes.html"><span>Classes</span></a></li>
    <li id="current"><a href="files.html"><span>Files</span></a></li>
    <li><a href="dirs.html"><span>Directories</span></a></li>
    <li><a href="pages.html"><span>Related&nbsp;Pages</span></a></li>
    <li><a href="examples.html"><span>Examples</span></a></li>
    <li>
      <form action="search.php" method="get">
        <table cellspacing="0" cellpadding="0" border="0">
          <tr>
            <td><label>&nbsp;<u>S</u>earch&nbsp;for&nbsp;</label></td>
            <td><input type="text" name="query" value="" size="20" accesskey="s"/></td>
          </tr>
        </table>
      </form>
    </li>
  </ul></div>
<div class="nav">
<a class="el" href="dir_c8daf1ad746050abf985cc546c89e248.html">typo3_src-4.0.1</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_18071ae4545d8b3e0364d30c0659c74a.html">typo3</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_57bf1ed8249c1fd5b014486d01bcb27a.html">sysext</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_e81b1679233d44b74aed493d6fe8e943.html">adodb</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_1f526b87ad011e46f671ba6e798564e1.html">adodb</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_dc23b322957e53f3cb80639e4dbbdbeb.html">datadict</a></div>
<h1>datadict-mysql.inc.php</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00002"></a>00002 
<a name="l00013"></a>00013 <span class="comment">// security - hide paths</span>
<a name="l00014"></a>00014 <span class="keywordflow">if</span> (!defined('ADODB_DIR')) die();
<a name="l00015"></a>00015 
<a name="l00016"></a><a class="code" href="classADODB2__mysql.html">00016</a> <span class="keyword">class </span><a class="code" href="classADODB2__mysql.html">ADODB2_mysql</a> <span class="keyword">extends</span> <a class="code" href="classADODB__DataDict.html">ADODB_DataDict</a> {
<a name="l00017"></a><a class="code" href="classADODB2__mysql.html#f4ad0abc37961f9874347548866fbedf">00017</a>         var <a class="code" href="classADODB2__mysql.html#f4ad0abc37961f9874347548866fbedf">$databaseType</a> = 'mysql';
<a name="l00018"></a><a class="code" href="classADODB2__mysql.html#9a4a9c3595b55ef068760a9097fccaf8">00018</a>         var <a class="code" href="classADODB2__mysql.html#9a4a9c3595b55ef068760a9097fccaf8">$alterCol</a> = ' MODIFY COLUMN';
<a name="l00019"></a><a class="code" href="classADODB2__mysql.html#92e36b680cf07b12a4d51223b24c07ac">00019</a>         var <a class="code" href="classADODB2__mysql.html#92e36b680cf07b12a4d51223b24c07ac">$alterTableAddIndex</a> = <span class="keyword">true</span>;
<a name="l00020"></a><a class="code" href="classADODB2__mysql.html#b635f8eda19f0531a2e6c884e1af037e">00020</a>         var <a class="code" href="classADODB2__mysql.html#b635f8eda19f0531a2e6c884e1af037e">$dropTable</a> = 'DROP TABLE IF EXISTS %s'; <span class="comment">// requires mysql 3.22 or later</span>
<a name="l00021"></a>00021         
<a name="l00022"></a><a class="code" href="classADODB2__mysql.html#00a0c4dc1819e6bc2969a23e4c75b081">00022</a>         var <a class="code" href="classADODB2__mysql.html#00a0c4dc1819e6bc2969a23e4c75b081">$dropIndex</a> = 'DROP INDEX %s ON %s';
<a name="l00023"></a><a class="code" href="classADODB2__mysql.html#198e5cf4213d48e2df4de92f39548efa">00023</a>         var <a class="code" href="classADODB2__mysql.html#198e5cf4213d48e2df4de92f39548efa">$renameColumn</a> = 'ALTER TABLE %s CHANGE COLUMN %s %s %s';    <span class="comment">// needs column-definition!</span>
<a name="l00024"></a>00024         
<a name="l00025"></a><a class="code" href="classADODB2__mysql.html#0540f45f163d21c689993f1f9f75b2df">00025</a>         function <a class="code" href="classADODB2__mysql.html#0540f45f163d21c689993f1f9f75b2df">MetaType</a>($t,$len=-1,$fieldobj=<span class="keyword">false</span>)
<a name="l00026"></a>00026         {
<a name="l00027"></a>00027                 <span class="keywordflow">if</span> (is_object($t)) {
<a name="l00028"></a>00028                         $fieldobj = $t;
<a name="l00029"></a>00029                         $t = $fieldobj-&gt;type;
<a name="l00030"></a>00030                         $len = $fieldobj-&gt;max_length;
<a name="l00031"></a>00031                 }
<a name="l00032"></a>00032                 $is_serial = is_object($fieldobj) &amp;&amp; $fieldobj-&gt;primary_key &amp;&amp; $fieldobj-&gt;auto_increment;
<a name="l00033"></a>00033                 
<a name="l00034"></a>00034                 $len = -1; <span class="comment">// mysql max_length is not accurate</span>
<a name="l00035"></a>00035                 <span class="keywordflow">switch</span> (strtoupper($t)) {
<a name="l00036"></a>00036                 <span class="keywordflow">case</span> 'STRING': 
<a name="l00037"></a>00037                 <span class="keywordflow">case</span> 'CHAR':
<a name="l00038"></a>00038                 <span class="keywordflow">case</span> 'VARCHAR': 
<a name="l00039"></a>00039                 <span class="keywordflow">case</span> 'TINYBLOB': 
<a name="l00040"></a>00040                 <span class="keywordflow">case</span> 'TINYTEXT': 
<a name="l00041"></a>00041                 <span class="keywordflow">case</span> 'ENUM': 
<a name="l00042"></a>00042                 <span class="keywordflow">case</span> 'SET':
<a name="l00043"></a>00043                         <span class="keywordflow">if</span> ($len &lt;= $this-&gt;blobSize) <span class="keywordflow">return</span> <span class="charliteral">'C'</span>;
<a name="l00044"></a>00044                         
<a name="l00045"></a>00045                 <span class="keywordflow">case</span> 'TEXT':
<a name="l00046"></a>00046                 <span class="keywordflow">case</span> 'LONGTEXT': 
<a name="l00047"></a>00047                 <span class="keywordflow">case</span> 'MEDIUMTEXT':
<a name="l00048"></a>00048                         <span class="keywordflow">return</span> <span class="charliteral">'X'</span>;
<a name="l00049"></a>00049                         
<a name="l00050"></a>00050                 <span class="comment">// php_mysql extension always returns 'blob' even if 'text'</span>
<a name="l00051"></a>00051                 <span class="comment">// so we have to check whether binary...</span>
<a name="l00052"></a>00052                 <span class="keywordflow">case</span> 'IMAGE':
<a name="l00053"></a>00053                 <span class="keywordflow">case</span> 'LONGBLOB': 
<a name="l00054"></a>00054                 <span class="keywordflow">case</span> 'BLOB':
<a name="l00055"></a>00055                 <span class="keywordflow">case</span> 'MEDIUMBLOB':
<a name="l00056"></a>00056                         <span class="keywordflow">return</span> !empty($fieldobj-&gt;binary) ? <span class="charliteral">'B'</span> : <span class="charliteral">'X'</span>;
<a name="l00057"></a>00057                         
<a name="l00058"></a>00058                 <span class="keywordflow">case</span> 'YEAR':
<a name="l00059"></a>00059                 <span class="keywordflow">case</span> 'DATE': <span class="keywordflow">return</span> <span class="charliteral">'D'</span>;
<a name="l00060"></a>00060                 
<a name="l00061"></a>00061                 <span class="keywordflow">case</span> 'TIME':
<a name="l00062"></a>00062                 <span class="keywordflow">case</span> 'DATETIME':
<a name="l00063"></a>00063                 <span class="keywordflow">case</span> 'TIMESTAMP': <span class="keywordflow">return</span> <span class="charliteral">'T'</span>;
<a name="l00064"></a>00064                 
<a name="l00065"></a>00065                 <span class="keywordflow">case</span> 'FLOAT':
<a name="l00066"></a>00066                 <span class="keywordflow">case</span> 'DOUBLE':
<a name="l00067"></a>00067                         <span class="keywordflow">return</span> <span class="charliteral">'F'</span>;
<a name="l00068"></a>00068                         
<a name="l00069"></a>00069                 <span class="keywordflow">case</span> 'INT': 
<a name="l00070"></a>00070                 <span class="keywordflow">case</span> 'INTEGER': <span class="keywordflow">return</span> $is_serial ? <span class="charliteral">'R'</span> : <span class="charliteral">'I'</span>;
<a name="l00071"></a>00071                 <span class="keywordflow">case</span> 'TINYINT': <span class="keywordflow">return</span> $is_serial ? <span class="charliteral">'R'</span> : 'I1';
<a name="l00072"></a>00072                 <span class="keywordflow">case</span> 'SMALLINT': <span class="keywordflow">return</span> $is_serial ? <span class="charliteral">'R'</span> : 'I2';
<a name="l00073"></a>00073                 <span class="keywordflow">case</span> 'MEDIUMINT': <span class="keywordflow">return</span> $is_serial ? <span class="charliteral">'R'</span> : 'I4';
<a name="l00074"></a>00074                 <span class="keywordflow">case</span> 'BIGINT':  <span class="keywordflow">return</span> $is_serial ? <span class="charliteral">'R'</span> : 'I8';
<a name="l00075"></a>00075                 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> <span class="charliteral">'N'</span>;
<a name="l00076"></a>00076                 }
<a name="l00077"></a>00077         }
<a name="l00078"></a>00078 
<a name="l00079"></a><a class="code" href="classADODB2__mysql.html#7f4e01b8d6f7a40c798ef1aa4166c3a6">00079</a>         function <a class="code" href="classADODB2__mysql.html#7f4e01b8d6f7a40c798ef1aa4166c3a6">ActualType</a>($meta)
<a name="l00080"></a>00080         {
<a name="l00081"></a>00081                 <span class="keywordflow">switch</span>(strtoupper($meta)) {
<a name="l00082"></a>00082                 <span class="keywordflow">case</span> <span class="charliteral">'C'</span>: <span class="keywordflow">return</span> 'VARCHAR';
<a name="l00083"></a>00083                 <span class="keywordflow">case</span> 'XL':<span class="keywordflow">return</span> 'LONGTEXT';
<a name="l00084"></a>00084                 <span class="keywordflow">case</span> <span class="charliteral">'X'</span>: <span class="keywordflow">return</span> 'TEXT';
<a name="l00085"></a>00085                 
<a name="l00086"></a>00086                 <span class="keywordflow">case</span> 'C2': <span class="keywordflow">return</span> 'VARCHAR';
<a name="l00087"></a>00087                 <span class="keywordflow">case</span> 'X2': <span class="keywordflow">return</span> 'LONGTEXT';
<a name="l00088"></a>00088                 
<a name="l00089"></a>00089                 <span class="keywordflow">case</span> <span class="charliteral">'B'</span>: <span class="keywordflow">return</span> 'LONGBLOB';
<a name="l00090"></a>00090                         
<a name="l00091"></a>00091                 <span class="keywordflow">case</span> <span class="charliteral">'D'</span>: <span class="keywordflow">return</span> 'DATE';
<a name="l00092"></a>00092                 <span class="keywordflow">case</span> <span class="charliteral">'T'</span>: <span class="keywordflow">return</span> 'DATETIME';
<a name="l00093"></a>00093                 <span class="keywordflow">case</span> <span class="charliteral">'L'</span>: <span class="keywordflow">return</span> 'TINYINT';
<a name="l00094"></a>00094                 
<a name="l00095"></a>00095                 <span class="keywordflow">case</span> <span class="charliteral">'R'</span>:
<a name="l00096"></a>00096                 <span class="keywordflow">case</span> 'I4':
<a name="l00097"></a>00097                 <span class="keywordflow">case</span> <span class="charliteral">'I'</span>: <span class="keywordflow">return</span> 'INTEGER';
<a name="l00098"></a>00098                 <span class="keywordflow">case</span> 'I1': <span class="keywordflow">return</span> 'TINYINT';
<a name="l00099"></a>00099                 <span class="keywordflow">case</span> 'I2': <span class="keywordflow">return</span> 'SMALLINT';
<a name="l00100"></a>00100                 <span class="keywordflow">case</span> 'I8': <span class="keywordflow">return</span> 'BIGINT';
<a name="l00101"></a>00101                 
<a name="l00102"></a>00102                 <span class="keywordflow">case</span> <span class="charliteral">'F'</span>: <span class="keywordflow">return</span> 'DOUBLE';
<a name="l00103"></a>00103                 <span class="keywordflow">case</span> <span class="charliteral">'N'</span>: <span class="keywordflow">return</span> 'NUMERIC';
<a name="l00104"></a>00104                 <span class="keywordflow">default</span>:
<a name="l00105"></a>00105                         <span class="keywordflow">return</span> $meta;
<a name="l00106"></a>00106                 }
<a name="l00107"></a>00107         }
<a name="l00108"></a>00108         
<a name="l00109"></a>00109         <span class="comment">// return string must begin with space</span>
<a name="l00110"></a><a class="code" href="classADODB2__mysql.html#986d757ff0c89af7e1a507ca91aed1d2">00110</a>         function <a class="code" href="classADODB2__mysql.html#986d757ff0c89af7e1a507ca91aed1d2">_CreateSuffix</a>($fname,$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint,$funsigned)
<a name="l00111"></a>00111         {       
<a name="l00112"></a>00112                 $suffix = '';
<a name="l00113"></a>00113                 <span class="keywordflow">if</span> ($funsigned) $suffix .= ' UNSIGNED';
<a name="l00114"></a>00114                 <span class="keywordflow">if</span> ($fnotnull) $suffix .= ' NOT NULL';
<a name="l00115"></a>00115                 <span class="keywordflow">if</span> (strlen($fdefault)) $suffix .= <span class="stringliteral">" DEFAULT $fdefault"</span>;
<a name="l00116"></a>00116                 <span class="keywordflow">if</span> ($fautoinc) $suffix .= ' AUTO_INCREMENT';
<a name="l00117"></a>00117                 <span class="keywordflow">if</span> ($fconstraint) $suffix .= <span class="charliteral">' '</span>.$fconstraint;
<a name="l00118"></a>00118                 <span class="keywordflow">return</span> $suffix;
<a name="l00119"></a>00119         }
<a name="l00120"></a>00120         
<a name="l00121"></a>00121         <span class="comment">/*</span>
<a name="l00122"></a>00122 <span class="comment">        CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)]</span>
<a name="l00123"></a>00123 <span class="comment">                [table_options] [select_statement]</span>
<a name="l00124"></a>00124 <span class="comment">                create_definition:</span>
<a name="l00125"></a>00125 <span class="comment">                col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]</span>
<a name="l00126"></a>00126 <span class="comment">                [PRIMARY KEY] [reference_definition]</span>
<a name="l00127"></a>00127 <span class="comment">                or PRIMARY KEY (index_col_name,...)</span>
<a name="l00128"></a>00128 <span class="comment">                or KEY [index_name] (index_col_name,...)</span>
<a name="l00129"></a>00129 <span class="comment">                or INDEX [index_name] (index_col_name,...)</span>
<a name="l00130"></a>00130 <span class="comment">                or UNIQUE [INDEX] [index_name] (index_col_name,...)</span>
<a name="l00131"></a>00131 <span class="comment">                or FULLTEXT [INDEX] [index_name] (index_col_name,...)</span>
<a name="l00132"></a>00132 <span class="comment">                or [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name,...)</span>
<a name="l00133"></a>00133 <span class="comment">                [reference_definition]</span>
<a name="l00134"></a>00134 <span class="comment">                or CHECK (expr)</span>
<a name="l00135"></a>00135 <span class="comment">        */</span>
<a name="l00136"></a>00136         
<a name="l00137"></a>00137         <span class="comment">/*</span>
<a name="l00138"></a>00138 <span class="comment">        CREATE [UNIQUE|FULLTEXT] INDEX index_name</span>
<a name="l00139"></a>00139 <span class="comment">                ON tbl_name (col_name[(length)],... )</span>
<a name="l00140"></a>00140 <span class="comment">        */</span>
<a name="l00141"></a>00141         
<a name="l00142"></a><a class="code" href="classADODB2__mysql.html#c700d84e64a183bad4200693648248ea">00142</a>         function <a class="code" href="classADODB2__mysql.html#c700d84e64a183bad4200693648248ea">_IndexSQL</a>($idxname, $tabname, $flds, $idxoptions)
<a name="l00143"></a>00143         {
<a name="l00144"></a>00144                 $sql = array();
<a name="l00145"></a>00145                 
<a name="l00146"></a>00146                 <span class="keywordflow">if</span> ( isset($idxoptions['REPLACE']) || isset($idxoptions['DROP']) ) {
<a name="l00147"></a>00147                         <span class="keywordflow">if</span> ($this-&gt;alterTableAddIndex) $sql[] = <span class="stringliteral">"ALTER TABLE $tabname DROP INDEX $idxname"</span>;
<a name="l00148"></a>00148                         <span class="keywordflow">else</span> $sql[] = sprintf($this-&gt;dropIndex, $idxname, $tabname);
<a name="l00149"></a>00149 
<a name="l00150"></a>00150                         <span class="keywordflow">if</span> ( isset($idxoptions['DROP']) )
<a name="l00151"></a>00151                                 <span class="keywordflow">return</span> $sql;
<a name="l00152"></a>00152                 }
<a name="l00153"></a>00153                 
<a name="l00154"></a>00154                 <span class="keywordflow">if</span> ( empty ($flds) ) {
<a name="l00155"></a>00155                         <span class="keywordflow">return</span> $sql;
<a name="l00156"></a>00156                 }
<a name="l00157"></a>00157                 
<a name="l00158"></a>00158                 <span class="keywordflow">if</span> (isset($idxoptions['FULLTEXT'])) {
<a name="l00159"></a>00159                         $unique = ' FULLTEXT';
<a name="l00160"></a>00160                 } elseif (isset($idxoptions['UNIQUE'])) {
<a name="l00161"></a>00161                         $unique = ' UNIQUE';
<a name="l00162"></a>00162                 } <span class="keywordflow">else</span> {
<a name="l00163"></a>00163                         $unique = '';
<a name="l00164"></a>00164                 }
<a name="l00165"></a>00165                 
<a name="l00166"></a>00166                 <span class="keywordflow">if</span> ( is_array($flds) ) $flds = implode(', ',$flds);
<a name="l00167"></a>00167                 
<a name="l00168"></a>00168                 <span class="keywordflow">if</span> ($this-&gt;alterTableAddIndex) $s = <span class="stringliteral">"ALTER TABLE $tabname ADD $unique INDEX $idxname "</span>;
<a name="l00169"></a>00169                 <span class="keywordflow">else</span> $s = 'CREATE' . $unique . ' INDEX ' . $idxname . ' ON ' . $tabname;
<a name="l00170"></a>00170                 
<a name="l00171"></a>00171                 $s .= ' (' . $flds . <span class="charliteral">')'</span>;
<a name="l00172"></a>00172                 
<a name="l00173"></a>00173                 <span class="keywordflow">if</span> ( isset($idxoptions[$this-&gt;upperName]) )
<a name="l00174"></a>00174                         $s .= $idxoptions[$this-&gt;upperName];
<a name="l00175"></a>00175                 
<a name="l00176"></a>00176                 $sql[] = $s;
<a name="l00177"></a>00177                 
<a name="l00178"></a>00178                 <span class="keywordflow">return</span> $sql;
<a name="l00179"></a>00179         }
<a name="l00180"></a>00180 }
<a name="l00181"></a>00181 ?&gt;
</pre></div><?php
  include_once '../doc-typo3-funcs.php';
  get_footer();
?>