<?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-mssql.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-mssql.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">/*</span>
<a name="l00014"></a>00014 <span class="comment">In ADOdb, named quotes for MS SQL Server use ". From the MSSQL Docs:</span>
<a name="l00015"></a>00015 <span class="comment"></span>
<a name="l00016"></a>00016 <span class="comment">        Note Delimiters are for identifiers only. Delimiters cannot be used for keywords, </span>
<a name="l00017"></a>00017 <span class="comment">        whether or not they are marked as reserved in SQL Server.</span>
<a name="l00018"></a>00018 <span class="comment">        </span>
<a name="l00019"></a>00019 <span class="comment">        Quoted identifiers are delimited by double quotation marks ("):</span>
<a name="l00020"></a>00020 <span class="comment">        SELECT * FROM "Blanks in Table Name"</span>
<a name="l00021"></a>00021 <span class="comment">        </span>
<a name="l00022"></a>00022 <span class="comment">        Bracketed identifiers are delimited by brackets ([ ]):</span>
<a name="l00023"></a>00023 <span class="comment">        SELECT * FROM [Blanks In Table Name]</span>
<a name="l00024"></a>00024 <span class="comment">        </span>
<a name="l00025"></a>00025 <span class="comment">        Quoted identifiers are valid only when the QUOTED_IDENTIFIER option is set to ON. By default, </span>
<a name="l00026"></a>00026 <span class="comment">        the Microsoft OLE DB Provider for SQL Server and SQL Server ODBC driver set QUOTED_IDENTIFIER ON </span>
<a name="l00027"></a>00027 <span class="comment">        when they connect. </span>
<a name="l00028"></a>00028 <span class="comment">        </span>
<a name="l00029"></a>00029 <span class="comment">        In Transact-SQL, the option can be set at various levels using SET QUOTED_IDENTIFIER, </span>
<a name="l00030"></a>00030 <span class="comment">        the quoted identifier option of sp_dboption, or the user options option of sp_configure.</span>
<a name="l00031"></a>00031 <span class="comment">        </span>
<a name="l00032"></a>00032 <span class="comment">        When SET ANSI_DEFAULTS is ON, SET QUOTED_IDENTIFIER is enabled.</span>
<a name="l00033"></a>00033 <span class="comment">        </span>
<a name="l00034"></a>00034 <span class="comment">        Syntax</span>
<a name="l00035"></a>00035 <span class="comment">        </span>
<a name="l00036"></a>00036 <span class="comment">                SET QUOTED_IDENTIFIER { ON | OFF }</span>
<a name="l00037"></a>00037 <span class="comment"></span>
<a name="l00038"></a>00038 <span class="comment"></span>
<a name="l00039"></a>00039 <span class="comment">*/</span>
<a name="l00040"></a>00040 
<a name="l00041"></a>00041 <span class="comment">// security - hide paths</span>
<a name="l00042"></a>00042 <span class="keywordflow">if</span> (!defined('ADODB_DIR')) die();
<a name="l00043"></a>00043 
<a name="l00044"></a><a class="code" href="classADODB2__mssql.html">00044</a> <span class="keyword">class </span><a class="code" href="classADODB2__mssql.html">ADODB2_mssql</a> <span class="keyword">extends</span> <a class="code" href="classADODB__DataDict.html">ADODB_DataDict</a> {
<a name="l00045"></a><a class="code" href="classADODB2__mssql.html#eb247f956532aaffcd9e25556ede3df8">00045</a>         var <a class="code" href="classADODB2__mssql.html#eb247f956532aaffcd9e25556ede3df8">$databaseType</a> = 'mssql';
<a name="l00046"></a><a class="code" href="classADODB2__mssql.html#ddf70034af4c5a0fb99a1acdc65f34e6">00046</a>         var <a class="code" href="classADODB2__mssql.html#ddf70034af4c5a0fb99a1acdc65f34e6">$dropIndex</a> = 'DROP INDEX %2$s.%1$s';
<a name="l00047"></a><a class="code" href="classADODB2__mssql.html#db745267ada401fe6da56ff724ef766e">00047</a>         var <a class="code" href="classADODB2__mssql.html#db745267ada401fe6da56ff724ef766e">$renameTable</a> = <span class="stringliteral">"EXEC sp_rename '%s','%s'"</span>;
<a name="l00048"></a><a class="code" href="classADODB2__mssql.html#4cab7921bf2cfa39dd4f52b9ab0ce4a0">00048</a>         var <a class="code" href="classADODB2__mssql.html#4cab7921bf2cfa39dd4f52b9ab0ce4a0">$renameColumn</a> = <span class="stringliteral">"EXEC sp_rename '%s.%s','%s'"</span>;
<a name="l00049"></a>00049 
<a name="l00050"></a><a class="code" href="classADODB2__mssql.html#544fa67df50eef26f936ba98b31d1c67">00050</a>         var <a class="code" href="classADODB2__mssql.html#544fa67df50eef26f936ba98b31d1c67">$typeX</a> = 'TEXT';  ## Alternatively, set it to VARCHAR(4000)
<a name="l00051"></a><a class="code" href="classADODB2__mssql.html#7153da216fee1c7f27364d59a27c24b4">00051</a>         var <a class="code" href="classADODB2__mssql.html#7153da216fee1c7f27364d59a27c24b4">$typeXL</a> = 'TEXT';
<a name="l00052"></a>00052         
<a name="l00053"></a>00053         <span class="comment">//var $alterCol = ' ALTER COLUMN ';</span>
<a name="l00054"></a>00054         
<a name="l00055"></a><a class="code" href="classADODB2__mssql.html#bd8b1702fff965ec46fcbae4f4e28d07">00055</a>         function <a class="code" href="classADODB2__mssql.html#bd8b1702fff965ec46fcbae4f4e28d07">MetaType</a>($t,$len=-1,$fieldobj=false)
<a name="l00056"></a>00056         {
<a name="l00057"></a>00057                 <span class="keywordflow">if</span> (is_object($t)) {
<a name="l00058"></a>00058                         $fieldobj = $t;
<a name="l00059"></a>00059                         $t = $fieldobj-&gt;type;
<a name="l00060"></a>00060                         $len = $fieldobj-&gt;max_length;
<a name="l00061"></a>00061                 }
<a name="l00062"></a>00062                 
<a name="l00063"></a>00063                 $len = -1; <span class="comment">// mysql max_length is not accurate</span>
<a name="l00064"></a>00064                 <span class="keywordflow">switch</span> (strtoupper($t)) {
<a name="l00065"></a>00065                 <span class="keywordflow">case</span> <span class="charliteral">'R'</span>:
<a name="l00066"></a>00066                 <span class="keywordflow">case</span> 'INT': 
<a name="l00067"></a>00067                 <span class="keywordflow">case</span> 'INTEGER': <span class="keywordflow">return</span>  <span class="charliteral">'I'</span>;
<a name="l00068"></a>00068                 <span class="keywordflow">case</span> 'BIT':
<a name="l00069"></a>00069                 <span class="keywordflow">case</span> 'TINYINT': <span class="keywordflow">return</span>  'I1';
<a name="l00070"></a>00070                 <span class="keywordflow">case</span> 'SMALLINT': <span class="keywordflow">return</span> 'I2';
<a name="l00071"></a>00071                 <span class="keywordflow">case</span> 'BIGINT':  <span class="keywordflow">return</span>  'I8';
<a name="l00072"></a>00072                 
<a name="l00073"></a>00073                 <span class="keywordflow">case</span> 'REAL':
<a name="l00074"></a>00074                 <span class="keywordflow">case</span> 'FLOAT': <span class="keywordflow">return</span> <span class="charliteral">'F'</span>;
<a name="l00075"></a>00075                 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> parent::MetaType($t,$len,$fieldobj);
<a name="l00076"></a>00076                 }
<a name="l00077"></a>00077         }
<a name="l00078"></a>00078         
<a name="l00079"></a><a class="code" href="classADODB2__mssql.html#96c66bf5a237cdaad5da955e3cbee251">00079</a>         function <a class="code" href="classADODB2__mssql.html#96c66bf5a237cdaad5da955e3cbee251">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 
<a name="l00083"></a>00083                 <span class="keywordflow">case</span> <span class="charliteral">'C'</span>: <span class="keywordflow">return</span> 'VARCHAR';
<a name="l00084"></a>00084                 <span class="keywordflow">case</span> 'XL': <span class="keywordflow">return</span> (isset($this)) ? $this-&gt;typeXL : 'TEXT';
<a name="l00085"></a>00085                 <span class="keywordflow">case</span> <span class="charliteral">'X'</span>: <span class="keywordflow">return</span> (isset($this)) ? $this-&gt;typeX : 'TEXT'; ## could be varchar(8000), but we want compat with oracle
<a name="l00086"></a>00086                 <span class="keywordflow">case</span> 'C2': <span class="keywordflow">return</span> 'NVARCHAR';
<a name="l00087"></a>00087                 <span class="keywordflow">case</span> 'X2': <span class="keywordflow">return</span> 'NTEXT';
<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> 'IMAGE';
<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> 'DATETIME';
<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> 'BIT';
<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> <span class="charliteral">'I'</span>: <span class="keywordflow">return</span> 'INT'; 
<a name="l00097"></a>00097                 <span class="keywordflow">case</span> 'I1': <span class="keywordflow">return</span> 'TINYINT';
<a name="l00098"></a>00098                 <span class="keywordflow">case</span> 'I2': <span class="keywordflow">return</span> 'SMALLINT';
<a name="l00099"></a>00099                 <span class="keywordflow">case</span> 'I4': <span class="keywordflow">return</span> 'INT';
<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> 'REAL';
<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         
<a name="l00110"></a><a class="code" href="classADODB2__mssql.html#281eb9edd253d0ce8a763112c9116069">00110</a>         function <a class="code" href="classADODB2__mssql.html#281eb9edd253d0ce8a763112c9116069">AddColumnSQL</a>($tabname, $flds)
<a name="l00111"></a>00111         {
<a name="l00112"></a>00112                 $tabname = $this-&gt;<a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a> ($tabname);
<a name="l00113"></a>00113                 $f = array();
<a name="l00114"></a>00114                 list($lines,$pkey) = $this-&gt;<a class="code" href="classADODB__DataDict.html#241128fe02ae191ba3f8df56c6efb492">_GenFields</a>($flds);
<a name="l00115"></a>00115                 $s = <span class="stringliteral">"ALTER TABLE $tabname $this-&gt;addCol"</span>;
<a name="l00116"></a>00116                 foreach($lines as $v) {
<a name="l00117"></a>00117                         $f[] = <span class="stringliteral">"\n $v"</span>;
<a name="l00118"></a>00118                 }
<a name="l00119"></a>00119                 $s .= implode(', ',$f);
<a name="l00120"></a>00120                 $sql[] = $s;
<a name="l00121"></a>00121                 <span class="keywordflow">return</span> $sql;
<a name="l00122"></a>00122         }
<a name="l00123"></a>00123         
<a name="l00124"></a>00124         <span class="comment">/*</span>
<a name="l00125"></a>00125 <span class="comment">        function AlterColumnSQL($tabname, $flds)</span>
<a name="l00126"></a>00126 <span class="comment">        {</span>
<a name="l00127"></a>00127 <span class="comment">                $tabname = $this-&gt;TableName ($tabname);</span>
<a name="l00128"></a>00128 <span class="comment">                $sql = array();</span>
<a name="l00129"></a>00129 <span class="comment">                list($lines,$pkey) = $this-&gt;_GenFields($flds);</span>
<a name="l00130"></a>00130 <span class="comment">                foreach($lines as $v) {</span>
<a name="l00131"></a>00131 <span class="comment">                        $sql[] = "ALTER TABLE $tabname $this-&gt;alterCol $v";</span>
<a name="l00132"></a>00132 <span class="comment">                }</span>
<a name="l00133"></a>00133 <span class="comment"></span>
<a name="l00134"></a>00134 <span class="comment">                return $sql;</span>
<a name="l00135"></a>00135 <span class="comment">        }</span>
<a name="l00136"></a>00136 <span class="comment">        */</span>
<a name="l00137"></a>00137         
<a name="l00138"></a><a class="code" href="classADODB2__mssql.html#358fd50c0cc04be5d56ea1bb37874a6b">00138</a>         function <a class="code" href="classADODB2__mssql.html#358fd50c0cc04be5d56ea1bb37874a6b">DropColumnSQL</a>($tabname, $flds)
<a name="l00139"></a>00139         {
<a name="l00140"></a>00140                 $tabname = $this-&gt;<a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a> ($tabname);
<a name="l00141"></a>00141                 <span class="keywordflow">if</span> (!is_array($flds))
<a name="l00142"></a>00142                         $flds = explode(<span class="charliteral">','</span>,$flds);
<a name="l00143"></a>00143                 $f = array();
<a name="l00144"></a>00144                 $s = 'ALTER TABLE ' . $tabname;
<a name="l00145"></a>00145                 foreach($flds as $v) {
<a name="l00146"></a>00146                         $f[] = <span class="stringliteral">"\n$this-&gt;dropCol "</span>.$this-&gt;NameQuote($v);
<a name="l00147"></a>00147                 }
<a name="l00148"></a>00148                 $s .= implode(', ',$f);
<a name="l00149"></a>00149                 $sql[] = $s;
<a name="l00150"></a>00150                 <span class="keywordflow">return</span> $sql;
<a name="l00151"></a>00151         }
<a name="l00152"></a>00152         
<a name="l00153"></a>00153         <span class="comment">// return string must begin with space</span>
<a name="l00154"></a><a class="code" href="classADODB2__mssql.html#81b9f11813983d091002a51a00ac2d60">00154</a>         function <a class="code" href="classADODB2__mssql.html#81b9f11813983d091002a51a00ac2d60">_CreateSuffix</a>($fname,$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint)
<a name="l00155"></a>00155         {       
<a name="l00156"></a>00156                 $suffix = '';
<a name="l00157"></a>00157                 <span class="keywordflow">if</span> (strlen($fdefault)) $suffix .= <span class="stringliteral">" DEFAULT $fdefault"</span>;
<a name="l00158"></a>00158                 <span class="keywordflow">if</span> ($fautoinc) $suffix .= ' IDENTITY(1,1)';
<a name="l00159"></a>00159                 <span class="keywordflow">if</span> ($fnotnull) $suffix .= ' NOT NULL';
<a name="l00160"></a>00160                 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ($suffix == '') $suffix .= ' NULL';
<a name="l00161"></a>00161                 <span class="keywordflow">if</span> ($fconstraint) $suffix .= <span class="charliteral">' '</span>.$fconstraint;
<a name="l00162"></a>00162                 <span class="keywordflow">return</span> $suffix;
<a name="l00163"></a>00163         }
<a name="l00164"></a>00164         
<a name="l00165"></a>00165         <span class="comment">/*</span>
<a name="l00166"></a>00166 <span class="comment">CREATE TABLE </span>
<a name="l00167"></a>00167 <span class="comment">    [ database_name.[ owner ] . | owner. ] table_name </span>
<a name="l00168"></a>00168 <span class="comment">    ( { &lt; column_definition &gt; </span>
<a name="l00169"></a>00169 <span class="comment">        | column_name AS computed_column_expression </span>
<a name="l00170"></a>00170 <span class="comment">        | &lt; table_constraint &gt; ::= [ CONSTRAINT constraint_name ] }</span>
<a name="l00171"></a>00171 <span class="comment"></span>
<a name="l00172"></a>00172 <span class="comment">            | [ { PRIMARY KEY | UNIQUE } [ ,...n ] </span>
<a name="l00173"></a>00173 <span class="comment">    ) </span>
<a name="l00174"></a>00174 <span class="comment"></span>
<a name="l00175"></a>00175 <span class="comment">[ ON { filegroup | DEFAULT } ] </span>
<a name="l00176"></a>00176 <span class="comment">[ TEXTIMAGE_ON { filegroup | DEFAULT } ] </span>
<a name="l00177"></a>00177 <span class="comment"></span>
<a name="l00178"></a>00178 <span class="comment">&lt; column_definition &gt; ::= { column_name data_type } </span>
<a name="l00179"></a>00179 <span class="comment">    [ COLLATE &lt; collation_name &gt; ] </span>
<a name="l00180"></a>00180 <span class="comment">    [ [ DEFAULT constant_expression ] </span>
<a name="l00181"></a>00181 <span class="comment">        | [ IDENTITY [ ( seed , increment ) [ NOT FOR REPLICATION ] ] ]</span>
<a name="l00182"></a>00182 <span class="comment">    ] </span>
<a name="l00183"></a>00183 <span class="comment">    [ ROWGUIDCOL] </span>
<a name="l00184"></a>00184 <span class="comment">    [ &lt; column_constraint &gt; ] [ ...n ] </span>
<a name="l00185"></a>00185 <span class="comment"></span>
<a name="l00186"></a>00186 <span class="comment">&lt; column_constraint &gt; ::= [ CONSTRAINT constraint_name ] </span>
<a name="l00187"></a>00187 <span class="comment">    { [ NULL | NOT NULL ] </span>
<a name="l00188"></a>00188 <span class="comment">        | [ { PRIMARY KEY | UNIQUE } </span>
<a name="l00189"></a>00189 <span class="comment">            [ CLUSTERED | NONCLUSTERED ] </span>
<a name="l00190"></a>00190 <span class="comment">            [ WITH FILLFACTOR = fillfactor ] </span>
<a name="l00191"></a>00191 <span class="comment">            [ON {filegroup | DEFAULT} ] ] </span>
<a name="l00192"></a>00192 <span class="comment">        ] </span>
<a name="l00193"></a>00193 <span class="comment">        | [ [ FOREIGN KEY ] </span>
<a name="l00194"></a>00194 <span class="comment">            REFERENCES ref_table [ ( ref_column ) ] </span>
<a name="l00195"></a>00195 <span class="comment">            [ ON DELETE { CASCADE | NO ACTION } ] </span>
<a name="l00196"></a>00196 <span class="comment">            [ ON UPDATE { CASCADE | NO ACTION } ] </span>
<a name="l00197"></a>00197 <span class="comment">            [ NOT FOR REPLICATION ] </span>
<a name="l00198"></a>00198 <span class="comment">        ] </span>
<a name="l00199"></a>00199 <span class="comment">        | CHECK [ NOT FOR REPLICATION ] </span>
<a name="l00200"></a>00200 <span class="comment">        ( logical_expression ) </span>
<a name="l00201"></a>00201 <span class="comment">    } </span>
<a name="l00202"></a>00202 <span class="comment"></span>
<a name="l00203"></a>00203 <span class="comment">&lt; table_constraint &gt; ::= [ CONSTRAINT constraint_name ] </span>
<a name="l00204"></a>00204 <span class="comment">    { [ { PRIMARY KEY | UNIQUE } </span>
<a name="l00205"></a>00205 <span class="comment">        [ CLUSTERED | NONCLUSTERED ] </span>
<a name="l00206"></a>00206 <span class="comment">        { ( column [ ASC | DESC ] [ ,...n ] ) } </span>
<a name="l00207"></a>00207 <span class="comment">        [ WITH FILLFACTOR = fillfactor ] </span>
<a name="l00208"></a>00208 <span class="comment">        [ ON { filegroup | DEFAULT } ] </span>
<a name="l00209"></a>00209 <span class="comment">    ] </span>
<a name="l00210"></a>00210 <span class="comment">    | FOREIGN KEY </span>
<a name="l00211"></a>00211 <span class="comment">        [ ( column [ ,...n ] ) ] </span>
<a name="l00212"></a>00212 <span class="comment">        REFERENCES ref_table [ ( ref_column [ ,...n ] ) ] </span>
<a name="l00213"></a>00213 <span class="comment">        [ ON DELETE { CASCADE | NO ACTION } ] </span>
<a name="l00214"></a>00214 <span class="comment">        [ ON UPDATE { CASCADE | NO ACTION } ] </span>
<a name="l00215"></a>00215 <span class="comment">        [ NOT FOR REPLICATION ] </span>
<a name="l00216"></a>00216 <span class="comment">    | CHECK [ NOT FOR REPLICATION ] </span>
<a name="l00217"></a>00217 <span class="comment">        ( search_conditions ) </span>
<a name="l00218"></a>00218 <span class="comment">    } </span>
<a name="l00219"></a>00219 <span class="comment"></span>
<a name="l00220"></a>00220 <span class="comment"></span>
<a name="l00221"></a>00221 <span class="comment">        */</span>
<a name="l00222"></a>00222         
<a name="l00223"></a>00223         <span class="comment">/*</span>
<a name="l00224"></a>00224 <span class="comment">        CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name </span>
<a name="l00225"></a>00225 <span class="comment">    ON { table | view } ( column [ ASC | DESC ] [ ,...n ] ) </span>
<a name="l00226"></a>00226 <span class="comment">                [ WITH &lt; index_option &gt; [ ,...n] ] </span>
<a name="l00227"></a>00227 <span class="comment">                [ ON filegroup ]</span>
<a name="l00228"></a>00228 <span class="comment">                &lt; index_option &gt; :: = </span>
<a name="l00229"></a>00229 <span class="comment">                    { PAD_INDEX | </span>
<a name="l00230"></a>00230 <span class="comment">                        FILLFACTOR = fillfactor | </span>
<a name="l00231"></a>00231 <span class="comment">                        IGNORE_DUP_KEY | </span>
<a name="l00232"></a>00232 <span class="comment">                        DROP_EXISTING | </span>
<a name="l00233"></a>00233 <span class="comment">                    STATISTICS_NORECOMPUTE | </span>
<a name="l00234"></a>00234 <span class="comment">                    SORT_IN_TEMPDB  </span>
<a name="l00235"></a>00235 <span class="comment">                }</span>
<a name="l00236"></a>00236 <span class="comment">*/</span>
<a name="l00237"></a><a class="code" href="classADODB2__mssql.html#604d75e4287e1aa9aef71eeeed3fab96">00237</a>         function <a class="code" href="classADODB2__mssql.html#604d75e4287e1aa9aef71eeeed3fab96">_IndexSQL</a>($idxname, $tabname, $flds, $idxoptions)
<a name="l00238"></a>00238         {
<a name="l00239"></a>00239                 $sql = array();
<a name="l00240"></a>00240                 
<a name="l00241"></a>00241                 <span class="keywordflow">if</span> ( isset($idxoptions['REPLACE']) || isset($idxoptions['DROP']) ) {
<a name="l00242"></a>00242                         $sql[] = sprintf ($this-&gt;dropIndex, $idxname, $tabname);
<a name="l00243"></a>00243                         <span class="keywordflow">if</span> ( isset($idxoptions['DROP']) )
<a name="l00244"></a>00244                                 <span class="keywordflow">return</span> $sql;
<a name="l00245"></a>00245                 }
<a name="l00246"></a>00246                 
<a name="l00247"></a>00247                 <span class="keywordflow">if</span> ( empty ($flds) ) {
<a name="l00248"></a>00248                         <span class="keywordflow">return</span> $sql;
<a name="l00249"></a>00249                 }
<a name="l00250"></a>00250                 
<a name="l00251"></a>00251                 $unique = isset($idxoptions['UNIQUE']) ? ' UNIQUE' : '';
<a name="l00252"></a>00252                 $clustered = isset($idxoptions['CLUSTERED']) ? ' CLUSTERED' : '';
<a name="l00253"></a>00253                 
<a name="l00254"></a>00254                 <span class="keywordflow">if</span> ( is_array($flds) )
<a name="l00255"></a>00255                         $flds = implode(', ',$flds);
<a name="l00256"></a>00256                 $s = 'CREATE' . $unique . $clustered . ' INDEX ' . $idxname . ' ON ' . $tabname . ' (' . $flds . <span class="charliteral">')'</span>;
<a name="l00257"></a>00257                 
<a name="l00258"></a>00258                 <span class="keywordflow">if</span> ( isset($idxoptions[$this-&gt;upperName]) )
<a name="l00259"></a>00259                         $s .= $idxoptions[$this-&gt;upperName];
<a name="l00260"></a>00260                 
<a name="l00261"></a>00261 
<a name="l00262"></a>00262                 $sql[] = $s;
<a name="l00263"></a>00263                 
<a name="l00264"></a>00264                 <span class="keywordflow">return</span> $sql;
<a name="l00265"></a>00265         }
<a name="l00266"></a>00266         
<a name="l00267"></a>00267         
<a name="l00268"></a><a class="code" href="classADODB2__mssql.html#f3f4ac2f5512cca9e9bcbe107248c48c">00268</a>         function <a class="code" href="classADODB2__mssql.html#f3f4ac2f5512cca9e9bcbe107248c48c">_GetSize</a>($ftype, $ty, $fsize, $fprec)
<a name="l00269"></a>00269         {
<a name="l00270"></a>00270                 <span class="keywordflow">switch</span> ($ftype) {
<a name="l00271"></a>00271                 <span class="keywordflow">case</span> 'INT':
<a name="l00272"></a>00272                 <span class="keywordflow">case</span> 'SMALLINT':
<a name="l00273"></a>00273                 <span class="keywordflow">case</span> 'TINYINT':
<a name="l00274"></a>00274                 <span class="keywordflow">case</span> 'BIGINT':
<a name="l00275"></a>00275                         <span class="keywordflow">return</span> $ftype;
<a name="l00276"></a>00276                 }
<a name="l00277"></a>00277         <span class="keywordflow">if</span> ($ty == <span class="charliteral">'T'</span>) <span class="keywordflow">return</span> $ftype;
<a name="l00278"></a>00278         <span class="keywordflow">return</span> parent::_GetSize($ftype, $ty, $fsize, $fprec);    
<a name="l00279"></a>00279 
<a name="l00280"></a>00280         }
<a name="l00281"></a>00281 }
<a name="l00282"></a>00282 ?&gt;
</pre></div><?php
  include_once '../doc-typo3-funcs.php';
  get_footer();
?>