<?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 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 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> <u>S</u>earch for </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> » <a class="el" href="dir_18071ae4545d8b3e0364d30c0659c74a.html">typo3</a> » <a class="el" href="dir_57bf1ed8249c1fd5b014486d01bcb27a.html">sysext</a> » <a class="el" href="dir_e81b1679233d44b74aed493d6fe8e943.html">adodb</a> » <a class="el" href="dir_1f526b87ad011e46f671ba6e798564e1.html">adodb</a> » <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 <?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->type;
<a name="l00060"></a>00060 $len = $fieldobj->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->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->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-><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-><a class="code" href="classADODB__DataDict.html#241128fe02ae191ba3f8df56c6efb492">_GenFields</a>($flds);
<a name="l00115"></a>00115 $s = <span class="stringliteral">"ALTER TABLE $tabname $this->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->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->_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->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-><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->dropCol "</span>.$this->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"> ( { < column_definition > </span>
<a name="l00169"></a>00169 <span class="comment"> | column_name AS computed_column_expression </span>
<a name="l00170"></a>00170 <span class="comment"> | < table_constraint > ::= [ 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">< column_definition > ::= { column_name data_type } </span>
<a name="l00179"></a>00179 <span class="comment"> [ COLLATE < collation_name > ] </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"> [ < column_constraint > ] [ ...n ] </span>
<a name="l00185"></a>00185 <span class="comment"></span>
<a name="l00186"></a>00186 <span class="comment">< column_constraint > ::= [ 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">< table_constraint > ::= [ 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 < index_option > [ ,...n] ] </span>
<a name="l00227"></a>00227 <span class="comment"> [ ON filegroup ]</span>
<a name="l00228"></a>00228 <span class="comment"> < index_option > :: = </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->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->upperName]) )
<a name="l00259"></a>00259 $s .= $idxoptions[$this->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 ?>
</pre></div><?php
include_once '../doc-typo3-funcs.php';
get_footer();
?>