PageRenderTime 31ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/forum/includes/db/db_tools.php

https://bitbucket.org/itoxable/chiron-gaming
PHP | 2420 lines | 1852 code | 323 blank | 245 comment | 278 complexity | 9f51d57c4320c77eaf3575b5a0b0aad3 MD5 | raw file
Possible License(s): AGPL-1.0, GPL-2.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /**

    3. 

  3. *

    4. 

  4. * @package dbal

    5. 

  5. * @version $Id$

    6. 

  6. * @copyright (c) 2007 phpBB Group

    7. 

  7. * @license http://opensource.org/licenses/gpl-license.php GNU Public License

    8. 

  8. *

    9. 

  9. */

    10. 

  10. 

    11. 

  11. /**

    12. 

  12. * @ignore

    13. 

  13. */

    14. 

  14. if (!defined('IN_PHPBB'))

    15. 

  15. {

    16. 

  16. 	exit;

    17. 

  17. }

    18. 

  18. 

    19. 

  19. /**

    20. 

  20. * Database Tools for handling cross-db actions such as altering columns, etc.

    21. 

  21. * Currently not supported is returning SQL for creating tables.

    22. 

  22. *

    23. 

  23. * @package dbal

    24. 

  24. * @note currently not used within phpBB3, but may be utilized later.

    25. 

  25. */

    26. 

  26. class phpbb_db_tools

    27. 

  27. {

    28. 

  28. 	/**

    29. 

  29. 	* Current sql layer

    30. 

  30. 	*/

    31. 

  31. 	var $sql_layer = '';

    32. 

  32. 

    33. 

  33. 	/**

    34. 

  34. 	* @var object DB object

    35. 

  35. 	*/

    36. 

  36. 	var $db = NULL;

    37. 

  37. 

    38. 

  38. 	/**

    39. 

  39. 	* The Column types for every database we support

    40. 

  40. 	* @var array

    41. 

  41. 	*/

    42. 

  42. 	var $dbms_type_map = array(

    43. 

  43. 		'mysql_41'	=> array(

    44. 

  44. 			'INT:'		=> 'int(%d)',

    45. 

  45. 			'BINT'		=> 'bigint(20)',

    46. 

  46. 			'UINT'		=> 'mediumint(8) UNSIGNED',

    47. 

  47. 			'UINT:'		=> 'int(%d) UNSIGNED',

    48. 

  48. 			'TINT:'		=> 'tinyint(%d)',

    49. 

  49. 			'USINT'		=> 'smallint(4) UNSIGNED',

    50. 

  50. 			'BOOL'		=> 'tinyint(1) UNSIGNED',

    51. 

  51. 			'VCHAR'		=> 'varchar(255)',

    52. 

  52. 			'VCHAR:'	=> 'varchar(%d)',

    53. 

  53. 			'CHAR:'		=> 'char(%d)',

    54. 

  54. 			'XSTEXT'	=> 'text',

    55. 

  55. 			'XSTEXT_UNI'=> 'varchar(100)',

    56. 

  56. 			'STEXT'		=> 'text',

    57. 

  57. 			'STEXT_UNI'	=> 'varchar(255)',

    58. 

  58. 			'TEXT'		=> 'text',

    59. 

  59. 			'TEXT_UNI'	=> 'text',

    60. 

  60. 			'MTEXT'		=> 'mediumtext',

    61. 

  61. 			'MTEXT_UNI'	=> 'mediumtext',

    62. 

  62. 			'TIMESTAMP'	=> 'int(11) UNSIGNED',

    63. 

  63. 			'DECIMAL'	=> 'decimal(5,2)',

    64. 

  64. 			'DECIMAL:'	=> 'decimal(%d,2)',

    65. 

  65. 			'PDECIMAL'	=> 'decimal(6,3)',

    66. 

  66. 			'PDECIMAL:'	=> 'decimal(%d,3)',

    67. 

  67. 			'VCHAR_UNI'	=> 'varchar(255)',

    68. 

  68. 			'VCHAR_UNI:'=> 'varchar(%d)',

    69. 

  69. 			'VCHAR_CI'	=> 'varchar(255)',

    70. 

  70. 			'VARBINARY'	=> 'varbinary(255)',

    71. 

  71. 		),

    72. 

  72. 

    73. 

  73. 		'mysql_40'	=> array(

    74. 

  74. 			'INT:'		=> 'int(%d)',

    75. 

  75. 			'BINT'		=> 'bigint(20)',

    76. 

  76. 			'UINT'		=> 'mediumint(8) UNSIGNED',

    77. 

  77. 			'UINT:'		=> 'int(%d) UNSIGNED',

    78. 

  78. 			'TINT:'		=> 'tinyint(%d)',

    79. 

  79. 			'USINT'		=> 'smallint(4) UNSIGNED',

    80. 

  80. 			'BOOL'		=> 'tinyint(1) UNSIGNED',

    81. 

  81. 			'VCHAR'		=> 'varbinary(255)',

    82. 

  82. 			'VCHAR:'	=> 'varbinary(%d)',

    83. 

  83. 			'CHAR:'		=> 'binary(%d)',

    84. 

  84. 			'XSTEXT'	=> 'blob',

    85. 

  85. 			'XSTEXT_UNI'=> 'blob',

    86. 

  86. 			'STEXT'		=> 'blob',

    87. 

  87. 			'STEXT_UNI'	=> 'blob',

    88. 

  88. 			'TEXT'		=> 'blob',

    89. 

  89. 			'TEXT_UNI'	=> 'blob',

    90. 

  90. 			'MTEXT'		=> 'mediumblob',

    91. 

  91. 			'MTEXT_UNI'	=> 'mediumblob',

    92. 

  92. 			'TIMESTAMP'	=> 'int(11) UNSIGNED',

    93. 

  93. 			'DECIMAL'	=> 'decimal(5,2)',

    94. 

  94. 			'DECIMAL:'	=> 'decimal(%d,2)',

    95. 

  95. 			'PDECIMAL'	=> 'decimal(6,3)',

    96. 

  96. 			'PDECIMAL:'	=> 'decimal(%d,3)',

    97. 

  97. 			'VCHAR_UNI'	=> 'blob',

    98. 

  98. 			'VCHAR_UNI:'=> array('varbinary(%d)', 'limit' => array('mult', 3, 255, 'blob')),

    99. 

  99. 			'VCHAR_CI'	=> 'blob',

    100. 

  100. 			'VARBINARY'	=> 'varbinary(255)',

    101. 

  101. 		),

    102. 

  102. 

    103. 

  103. 		'firebird'	=> array(

    104. 

  104. 			'INT:'		=> 'INTEGER',

    105. 

  105. 			'BINT'		=> 'DOUBLE PRECISION',

    106. 

  106. 			'UINT'		=> 'INTEGER',

    107. 

  107. 			'UINT:'		=> 'INTEGER',

    108. 

  108. 			'TINT:'		=> 'INTEGER',

    109. 

  109. 			'USINT'		=> 'INTEGER',

    110. 

  110. 			'BOOL'		=> 'INTEGER',

    111. 

  111. 			'VCHAR'		=> 'VARCHAR(255) CHARACTER SET NONE',

    112. 

  112. 			'VCHAR:'	=> 'VARCHAR(%d) CHARACTER SET NONE',

    113. 

  113. 			'CHAR:'		=> 'CHAR(%d) CHARACTER SET NONE',

    114. 

  114. 			'XSTEXT'	=> 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

    115. 

  115. 			'STEXT'		=> 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

    116. 

  116. 			'TEXT'		=> 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

    117. 

  117. 			'MTEXT'		=> 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

    118. 

  118. 			'XSTEXT_UNI'=> 'VARCHAR(100) CHARACTER SET UTF8',

    119. 

  119. 			'STEXT_UNI'	=> 'VARCHAR(255) CHARACTER SET UTF8',

    120. 

  120. 			'TEXT_UNI'	=> 'BLOB SUB_TYPE TEXT CHARACTER SET UTF8',

    121. 

  121. 			'MTEXT_UNI'	=> 'BLOB SUB_TYPE TEXT CHARACTER SET UTF8',

    122. 

  122. 			'TIMESTAMP'	=> 'INTEGER',

    123. 

  123. 			'DECIMAL'	=> 'DOUBLE PRECISION',

    124. 

  124. 			'DECIMAL:'	=> 'DOUBLE PRECISION',

    125. 

  125. 			'PDECIMAL'	=> 'DOUBLE PRECISION',

    126. 

  126. 			'PDECIMAL:'	=> 'DOUBLE PRECISION',

    127. 

  127. 			'VCHAR_UNI'	=> 'VARCHAR(255) CHARACTER SET UTF8',

    128. 

  128. 			'VCHAR_UNI:'=> 'VARCHAR(%d) CHARACTER SET UTF8',

    129. 

  129. 			'VCHAR_CI'	=> 'VARCHAR(255) CHARACTER SET UTF8',

    130. 

  130. 			'VARBINARY'	=> 'CHAR(255) CHARACTER SET NONE',

    131. 

  131. 		),

    132. 

  132. 

    133. 

  133. 		'mssql'		=> array(

    134. 

  134. 			'INT:'		=> '[int]',

    135. 

  135. 			'BINT'		=> '[float]',

    136. 

  136. 			'UINT'		=> '[int]',

    137. 

  137. 			'UINT:'		=> '[int]',

    138. 

  138. 			'TINT:'		=> '[int]',

    139. 

  139. 			'USINT'		=> '[int]',

    140. 

  140. 			'BOOL'		=> '[int]',

    141. 

  141. 			'VCHAR'		=> '[varchar] (255)',

    142. 

  142. 			'VCHAR:'	=> '[varchar] (%d)',

    143. 

  143. 			'CHAR:'		=> '[char] (%d)',

    144. 

  144. 			'XSTEXT'	=> '[varchar] (1000)',

    145. 

  145. 			'STEXT'		=> '[varchar] (3000)',

    146. 

  146. 			'TEXT'		=> '[varchar] (8000)',

    147. 

  147. 			'MTEXT'		=> '[text]',

    148. 

  148. 			'XSTEXT_UNI'=> '[varchar] (100)',

    149. 

  149. 			'STEXT_UNI'	=> '[varchar] (255)',

    150. 

  150. 			'TEXT_UNI'	=> '[varchar] (4000)',

    151. 

  151. 			'MTEXT_UNI'	=> '[text]',

    152. 

  152. 			'TIMESTAMP'	=> '[int]',

    153. 

  153. 			'DECIMAL'	=> '[float]',

    154. 

  154. 			'DECIMAL:'	=> '[float]',

    155. 

  155. 			'PDECIMAL'	=> '[float]',

    156. 

  156. 			'PDECIMAL:'	=> '[float]',

    157. 

  157. 			'VCHAR_UNI'	=> '[varchar] (255)',

    158. 

  158. 			'VCHAR_UNI:'=> '[varchar] (%d)',

    159. 

  159. 			'VCHAR_CI'	=> '[varchar] (255)',

    160. 

  160. 			'VARBINARY'	=> '[varchar] (255)',

    161. 

  161. 		),

    162. 

  162. 

    163. 

  163. 		'mssqlnative'	=> array(

    164. 

  164. 			'INT:'		=> '[int]',

    165. 

  165. 			'BINT'		=> '[float]',

    166. 

  166. 			'UINT'		=> '[int]',

    167. 

  167. 			'UINT:'		=> '[int]',

    168. 

  168. 			'TINT:'		=> '[int]',

    169. 

  169. 			'USINT'		=> '[int]',

    170. 

  170. 			'BOOL'		=> '[int]',

    171. 

  171. 			'VCHAR'		=> '[varchar] (255)',

    172. 

  172. 			'VCHAR:'	=> '[varchar] (%d)',

    173. 

  173. 			'CHAR:'		=> '[char] (%d)',

    174. 

  174. 			'XSTEXT'	=> '[varchar] (1000)',

    175. 

  175. 			'STEXT'		=> '[varchar] (3000)',

    176. 

  176. 			'TEXT'		=> '[varchar] (8000)',

    177. 

  177. 			'MTEXT'		=> '[text]',

    178. 

  178. 			'XSTEXT_UNI'=> '[varchar] (100)',

    179. 

  179. 			'STEXT_UNI'	=> '[varchar] (255)',

    180. 

  180. 			'TEXT_UNI'	=> '[varchar] (4000)',

    181. 

  181. 			'MTEXT_UNI'	=> '[text]',

    182. 

  182. 			'TIMESTAMP'	=> '[int]',

    183. 

  183. 			'DECIMAL'	=> '[float]',

    184. 

  184. 			'DECIMAL:'	=> '[float]',

    185. 

  185. 			'PDECIMAL'	=> '[float]',

    186. 

  186. 			'PDECIMAL:'	=> '[float]',

    187. 

  187. 			'VCHAR_UNI'	=> '[varchar] (255)',

    188. 

  188. 			'VCHAR_UNI:'=> '[varchar] (%d)',

    189. 

  189. 			'VCHAR_CI'	=> '[varchar] (255)',

    190. 

  190. 			'VARBINARY'	=> '[varchar] (255)',

    191. 

  191. 		),

    192. 

  192. 

    193. 

  193. 		'oracle'	=> array(

    194. 

  194. 			'INT:'		=> 'number(%d)',

    195. 

  195. 			'BINT'		=> 'number(20)',

    196. 

  196. 			'UINT'		=> 'number(8)',

    197. 

  197. 			'UINT:'		=> 'number(%d)',

    198. 

  198. 			'TINT:'		=> 'number(%d)',

    199. 

  199. 			'USINT'		=> 'number(4)',

    200. 

  200. 			'BOOL'		=> 'number(1)',

    201. 

  201. 			'VCHAR'		=> 'varchar2(255)',

    202. 

  202. 			'VCHAR:'	=> 'varchar2(%d)',

    203. 

  203. 			'CHAR:'		=> 'char(%d)',

    204. 

  204. 			'XSTEXT'	=> 'varchar2(1000)',

    205. 

  205. 			'STEXT'		=> 'varchar2(3000)',

    206. 

  206. 			'TEXT'		=> 'clob',

    207. 

  207. 			'MTEXT'		=> 'clob',

    208. 

  208. 			'XSTEXT_UNI'=> 'varchar2(300)',

    209. 

  209. 			'STEXT_UNI'	=> 'varchar2(765)',

    210. 

  210. 			'TEXT_UNI'	=> 'clob',

    211. 

  211. 			'MTEXT_UNI'	=> 'clob',

    212. 

  212. 			'TIMESTAMP'	=> 'number(11)',

    213. 

  213. 			'DECIMAL'	=> 'number(5, 2)',

    214. 

  214. 			'DECIMAL:'	=> 'number(%d, 2)',

    215. 

  215. 			'PDECIMAL'	=> 'number(6, 3)',

    216. 

  216. 			'PDECIMAL:'	=> 'number(%d, 3)',

    217. 

  217. 			'VCHAR_UNI'	=> 'varchar2(765)',

    218. 

  218. 			'VCHAR_UNI:'=> array('varchar2(%d)', 'limit' => array('mult', 3, 765, 'clob')),

    219. 

  219. 			'VCHAR_CI'	=> 'varchar2(255)',

    220. 

  220. 			'VARBINARY'	=> 'raw(255)',

    221. 

  221. 		),

    222. 

  222. 

    223. 

  223. 		'sqlite'	=> array(

    224. 

  224. 			'INT:'		=> 'int(%d)',

    225. 

  225. 			'BINT'		=> 'bigint(20)',

    226. 

  226. 			'UINT'		=> 'INTEGER UNSIGNED', //'mediumint(8) UNSIGNED',

    227. 

  227. 			'UINT:'		=> 'INTEGER UNSIGNED', // 'int(%d) UNSIGNED',

    228. 

  228. 			'TINT:'		=> 'tinyint(%d)',

    229. 

  229. 			'USINT'		=> 'INTEGER UNSIGNED', //'mediumint(4) UNSIGNED',

    230. 

  230. 			'BOOL'		=> 'INTEGER UNSIGNED', //'tinyint(1) UNSIGNED',

    231. 

  231. 			'VCHAR'		=> 'varchar(255)',

    232. 

  232. 			'VCHAR:'	=> 'varchar(%d)',

    233. 

  233. 			'CHAR:'		=> 'char(%d)',

    234. 

  234. 			'XSTEXT'	=> 'text(65535)',

    235. 

  235. 			'STEXT'		=> 'text(65535)',

    236. 

  236. 			'TEXT'		=> 'text(65535)',

    237. 

  237. 			'MTEXT'		=> 'mediumtext(16777215)',

    238. 

  238. 			'XSTEXT_UNI'=> 'text(65535)',

    239. 

  239. 			'STEXT_UNI'	=> 'text(65535)',

    240. 

  240. 			'TEXT_UNI'	=> 'text(65535)',

    241. 

  241. 			'MTEXT_UNI'	=> 'mediumtext(16777215)',

    242. 

  242. 			'TIMESTAMP'	=> 'INTEGER UNSIGNED', //'int(11) UNSIGNED',

    243. 

  243. 			'DECIMAL'	=> 'decimal(5,2)',

    244. 

  244. 			'DECIMAL:'	=> 'decimal(%d,2)',

    245. 

  245. 			'PDECIMAL'	=> 'decimal(6,3)',

    246. 

  246. 			'PDECIMAL:'	=> 'decimal(%d,3)',

    247. 

  247. 			'VCHAR_UNI'	=> 'varchar(255)',

    248. 

  248. 			'VCHAR_UNI:'=> 'varchar(%d)',

    249. 

  249. 			'VCHAR_CI'	=> 'varchar(255)',

    250. 

  250. 			'VARBINARY'	=> 'blob',

    251. 

  251. 		),

    252. 

  252. 

    253. 

  253. 		'postgres'	=> array(

    254. 

  254. 			'INT:'		=> 'INT4',

    255. 

  255. 			'BINT'		=> 'INT8',

    256. 

  256. 			'UINT'		=> 'INT4', // unsigned

    257. 

  257. 			'UINT:'		=> 'INT4', // unsigned

    258. 

  258. 			'USINT'		=> 'INT2', // unsigned

    259. 

  259. 			'BOOL'		=> 'INT2', // unsigned

    260. 

  260. 			'TINT:'		=> 'INT2',

    261. 

  261. 			'VCHAR'		=> 'varchar(255)',

    262. 

  262. 			'VCHAR:'	=> 'varchar(%d)',

    263. 

  263. 			'CHAR:'		=> 'char(%d)',

    264. 

  264. 			'XSTEXT'	=> 'varchar(1000)',

    265. 

  265. 			'STEXT'		=> 'varchar(3000)',

    266. 

  266. 			'TEXT'		=> 'varchar(8000)',

    267. 

  267. 			'MTEXT'		=> 'TEXT',

    268. 

  268. 			'XSTEXT_UNI'=> 'varchar(100)',

    269. 

  269. 			'STEXT_UNI'	=> 'varchar(255)',

    270. 

  270. 			'TEXT_UNI'	=> 'varchar(4000)',

    271. 

  271. 			'MTEXT_UNI'	=> 'TEXT',

    272. 

  272. 			'TIMESTAMP'	=> 'INT4', // unsigned

    273. 

  273. 			'DECIMAL'	=> 'decimal(5,2)',

    274. 

  274. 			'DECIMAL:'	=> 'decimal(%d,2)',

    275. 

  275. 			'PDECIMAL'	=> 'decimal(6,3)',

    276. 

  276. 			'PDECIMAL:'	=> 'decimal(%d,3)',

    277. 

  277. 			'VCHAR_UNI'	=> 'varchar(255)',

    278. 

  278. 			'VCHAR_UNI:'=> 'varchar(%d)',

    279. 

  279. 			'VCHAR_CI'	=> 'varchar_ci',

    280. 

  280. 			'VARBINARY'	=> 'bytea',

    281. 

  281. 		),

    282. 

  282. 	);

    283. 

  283. 

    284. 

  284. 	/**

    285. 

  285. 	* A list of types being unsigned for better reference in some db's

    286. 

  286. 	* @var array

    287. 

  287. 	*/

    288. 

  288. 	var $unsigned_types = array('UINT', 'UINT:', 'USINT', 'BOOL', 'TIMESTAMP');

    289. 

  289. 

    290. 

  290. 	/**

    291. 

  291. 	* A list of supported DBMS. We change this class to support more DBMS, the DBMS itself only need to follow some rules.

    292. 

  292. 	* @var array

    293. 

  293. 	*/

    294. 

  294. 	var $supported_dbms = array('firebird', 'mssql', 'mssqlnative', 'mysql_40', 'mysql_41', 'oracle', 'postgres', 'sqlite');

    295. 

  295. 

    296. 

  296. 	/**

    297. 

  297. 	* This is set to true if user only wants to return the 'to-be-executed' SQL statement(s) (as an array).

    298. 

  298. 	* This mode has no effect on some methods (inserting of data for example). This is expressed within the methods command.

    299. 

  299. 	*/

    300. 

  300. 	var $return_statements = false;

    301. 

  301. 

    302. 

  302. 	/**

    303. 

  303. 	* Constructor. Set DB Object and set {@link $return_statements return_statements}.

    304. 

  304. 	*

    305. 

  305. 	* @param phpbb_dbal	$db					DBAL object

    306. 

  306. 	* @param bool		$return_statements	True if only statements should be returned and no SQL being executed

    307. 

  307. 	*/

    308. 

  308. 	function phpbb_db_tools(&$db, $return_statements = false)

    309. 

  309. 	{

    310. 

  310. 		$this->db = $db;

    311. 

  311. 		$this->return_statements = $return_statements;

    312. 

  312. 

    313. 

  313. 		// Determine mapping database type

    314. 

  314. 		switch ($this->db->sql_layer)

    315. 

  315. 		{

    316. 

  316. 			case 'mysql':

    317. 

  317. 				$this->sql_layer = 'mysql_40';

    318. 

  318. 			break;

    319. 

  319. 

    320. 

  320. 			case 'mysql4':

    321. 

  321. 				if (version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

    322. 

  322. 				{

    323. 

  323. 					$this->sql_layer = 'mysql_41';

    324. 

  324. 				}

    325. 

  325. 				else

    326. 

  326. 				{

    327. 

  327. 					$this->sql_layer = 'mysql_40';

    328. 

  328. 				}

    329. 

  329. 			break;

    330. 

  330. 

    331. 

  331. 			case 'mysqli':

    332. 

  332. 				$this->sql_layer = 'mysql_41';

    333. 

  333. 			break;

    334. 

  334. 

    335. 

  335. 			case 'mssql':

    336. 

  336. 			case 'mssql_odbc':

    337. 

  337. 				$this->sql_layer = 'mssql';

    338. 

  338. 			break;

    339. 

  339. 

    340. 

  340. 			case 'mssqlnative':

    341. 

  341. 				$this->sql_layer = 'mssqlnative';

    342. 

  342. 			break;

    343. 

  343. 

    344. 

  344. 			default:

    345. 

  345. 				$this->sql_layer = $this->db->sql_layer;

    346. 

  346. 			break;

    347. 

  347. 		}

    348. 

  348. 	}

    349. 

  349. 

    350. 

  350. 	/**

    351. 

  351. 	* Check if table exists

    352. 

  352. 	*

    353. 

  353. 	*

    354. 

  354. 	* @param string	$table_name	The table name to check for

    355. 

  355. 	* @return bool true if table exists, else false

    356. 

  356. 	*/

    357. 

  357. 	function sql_table_exists($table_name)

    358. 

  358. 	{

    359. 

  359. 		$this->db->sql_return_on_error(true);

    360. 

  360. 		$result = $this->db->sql_query_limit('SELECT * FROM ' . $table_name, 1);

    361. 

  361. 		$this->db->sql_return_on_error(false);

    362. 

  362. 

    363. 

  363. 		if ($result)

    364. 

  364. 		{

    365. 

  365. 			$this->db->sql_freeresult($result);

    366. 

  366. 			return true;

    367. 

  367. 		}

    368. 

  368. 

    369. 

  369. 		return false;

    370. 

  370. 	}

    371. 

  371. 

    372. 

  372. 	/**

    373. 

  373. 	* Create SQL Table

    374. 

  374. 	*

    375. 

  375. 	* @param string	$table_name	The table name to create

    376. 

  376. 	* @param array	$table_data	Array containing table data.

    377. 

  377. 	* @return array	Statements if $return_statements is true.

    378. 

  378. 	*/

    379. 

  379. 	function sql_create_table($table_name, $table_data)

    380. 

  380. 	{

    381. 

  381. 		// holds the DDL for a column

    382. 

  382. 		$columns = $statements = array();

    383. 

  383. 

    384. 

  384. 		if ($this->sql_table_exists($table_name))

    385. 

  385. 		{

    386. 

  386. 			return $this->_sql_run_sql($statements);

    387. 

  387. 		}

    388. 

  388. 

    389. 

  389. 		// Begin transaction

    390. 

  390. 		$statements[] = 'begin';

    391. 

  391. 

    392. 

  392. 		// Determine if we have created a PRIMARY KEY in the earliest

    393. 

  393. 		$primary_key_gen = false;

    394. 

  394. 

    395. 

  395. 		// Determine if the table must be created with TEXTIMAGE

    396. 

  396. 		$create_textimage = false;

    397. 

  397. 

    398. 

  398. 		// Determine if the table requires a sequence

    399. 

  399. 		$create_sequence = false;

    400. 

  400. 

    401. 

  401. 		// Begin table sql statement

    402. 

  402. 		switch ($this->sql_layer)

    403. 

  403. 		{

    404. 

  404. 			case 'mssql':

    405. 

  405. 			case 'mssqlnative':

    406. 

  406. 				$table_sql = 'CREATE TABLE [' . $table_name . '] (' . "\n";

    407. 

  407. 			break;

    408. 

  408. 

    409. 

  409. 			default:

    410. 

  410. 				$table_sql = 'CREATE TABLE ' . $table_name . ' (' . "\n";

    411. 

  411. 			break;

    412. 

  412. 		}

    413. 

  413. 

    414. 

  414. 		// Iterate through the columns to create a table

    415. 

  415. 		foreach ($table_data['COLUMNS'] as $column_name => $column_data)

    416. 

  416. 		{

    417. 

  417. 			// here lies an array, filled with information compiled on the column's data

    418. 

  418. 			$prepared_column = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

    419. 

  419. 

    420. 

  420. 			if (isset($prepared_column['auto_increment']) && strlen($column_name) > 26) // "${column_name}_gen"

    421. 

  421. 			{

    422. 

  422. 				trigger_error("Index name '${column_name}_gen' on table '$table_name' is too long. The maximum auto increment column length is 26 characters.", E_USER_ERROR);

    423. 

  423. 			}

    424. 

  424. 

    425. 

  425. 			// here we add the definition of the new column to the list of columns

    426. 

  426. 			switch ($this->sql_layer)

    427. 

  427. 			{

    428. 

  428. 				case 'mssql':

    429. 

  429. 				case 'mssqlnative':

    430. 

  430. 					$columns[] = "\t [{$column_name}] " . $prepared_column['column_type_sql_default'];

    431. 

  431. 				break;

    432. 

  432. 

    433. 

  433. 				default:

    434. 

  434. 					$columns[] = "\t {$column_name} " . $prepared_column['column_type_sql'];

    435. 

  435. 				break;

    436. 

  436. 			}

    437. 

  437. 

    438. 

  438. 			// see if we have found a primary key set due to a column definition if we have found it, we can stop looking

    439. 

  439. 			if (!$primary_key_gen)

    440. 

  440. 			{

    441. 

  441. 				$primary_key_gen = isset($prepared_column['primary_key_set']) && $prepared_column['primary_key_set'];

    442. 

  442. 			}

    443. 

  443. 

    444. 

  444. 			// create textimage DDL based off of the existance of certain column types

    445. 

  445. 			if (!$create_textimage)

    446. 

  446. 			{

    447. 

  447. 				$create_textimage = isset($prepared_column['textimage']) && $prepared_column['textimage'];

    448. 

  448. 			}

    449. 

  449. 

    450. 

  450. 			// create sequence DDL based off of the existance of auto incrementing columns

    451. 

  451. 			if (!$create_sequence && isset($prepared_column['auto_increment']) && $prepared_column['auto_increment'])

    452. 

  452. 			{

    453. 

  453. 				$create_sequence = $column_name;

    454. 

  454. 			}

    455. 

  455. 		}

    456. 

  456. 

    457. 

  457. 		// this makes up all the columns in the create table statement

    458. 

  458. 		$table_sql .= implode(",\n", $columns);

    459. 

  459. 

    460. 

  460. 		// Close the table for two DBMS and add to the statements

    461. 

  461. 		switch ($this->sql_layer)

    462. 

  462. 		{

    463. 

  463. 			case 'firebird':

    464. 

  464. 				$table_sql .= "\n);";

    465. 

  465. 				$statements[] = $table_sql;

    466. 

  466. 			break;

    467. 

  467. 

    468. 

  468. 			case 'mssql':

    469. 

  469. 			case 'mssqlnative':

    470. 

  470. 				$table_sql .= "\n) ON [PRIMARY]" . (($create_textimage) ? ' TEXTIMAGE_ON [PRIMARY]' : '');

    471. 

  471. 				$statements[] = $table_sql;

    472. 

  472. 			break;

    473. 

  473. 		}

    474. 

  474. 

    475. 

  475. 		// we have yet to create a primary key for this table,

    476. 

  476. 		// this means that we can add the one we really wanted instead

    477. 

  477. 		if (!$primary_key_gen)

    478. 

  478. 		{

    479. 

  479. 			// Write primary key

    480. 

  480. 			if (isset($table_data['PRIMARY_KEY']))

    481. 

  481. 			{

    482. 

  482. 				if (!is_array($table_data['PRIMARY_KEY']))

    483. 

  483. 				{

    484. 

  484. 					$table_data['PRIMARY_KEY'] = array($table_data['PRIMARY_KEY']);

    485. 

  485. 				}

    486. 

  486. 

    487. 

  487. 				switch ($this->sql_layer)

    488. 

  488. 				{

    489. 

  489. 					case 'mysql_40':

    490. 

  490. 					case 'mysql_41':

    491. 

  491. 					case 'postgres':

    492. 

  492. 					case 'sqlite':

    493. 

  493. 						$table_sql .= ",\n\t PRIMARY KEY (" . implode(', ', $table_data['PRIMARY_KEY']) . ')';

    494. 

  494. 					break;

    495. 

  495. 

    496. 

  496. 					case 'firebird':

    497. 

  497. 					case 'mssql':

    498. 

  498. 					case 'mssqlnative':

    499. 

  499. 						// We need the data here

    500. 

  500. 						$old_return_statements = $this->return_statements;

    501. 

  501. 						$this->return_statements = true;

    502. 

  502. 

    503. 

  503. 						$primary_key_stmts = $this->sql_create_primary_key($table_name, $table_data['PRIMARY_KEY']);

    504. 

  504. 						foreach ($primary_key_stmts as $pk_stmt)

    505. 

  505. 						{

    506. 

  506. 							$statements[] = $pk_stmt;

    507. 

  507. 						}

    508. 

  508. 

    509. 

  509. 						$this->return_statements = $old_return_statements;

    510. 

  510. 					break;

    511. 

  511. 

    512. 

  512. 					case 'oracle':

    513. 

  513. 						$table_sql .= ",\n\t CONSTRAINT pk_{$table_name} PRIMARY KEY (" . implode(', ', $table_data['PRIMARY_KEY']) . ')';

    514. 

  514. 					break;

    515. 

  515. 				}

    516. 

  516. 			}

    517. 

  517. 		}

    518. 

  518. 

    519. 

  519. 		// close the table

    520. 

  520. 		switch ($this->sql_layer)

    521. 

  521. 		{

    522. 

  522. 			case 'mysql_41':

    523. 

  523. 				// make sure the table is in UTF-8 mode

    524. 

  524. 				$table_sql .= "\n) CHARACTER SET `utf8` COLLATE `utf8_bin`;";

    525. 

  525. 				$statements[] = $table_sql;

    526. 

  526. 			break;

    527. 

  527. 

    528. 

  528. 			case 'mysql_40':

    529. 

  529. 			case 'sqlite':

    530. 

  530. 				$table_sql .= "\n);";

    531. 

  531. 				$statements[] = $table_sql;

    532. 

  532. 			break;

    533. 

  533. 

    534. 

  534. 			case 'postgres':

    535. 

  535. 				// do we need to add a sequence for auto incrementing columns?

    536. 

  536. 				if ($create_sequence)

    537. 

  537. 				{

    538. 

  538. 					$statements[] = "CREATE SEQUENCE {$table_name}_seq;";

    539. 

  539. 				}

    540. 

  540. 

    541. 

  541. 				$table_sql .= "\n);";

    542. 

  542. 				$statements[] = $table_sql;

    543. 

  543. 			break;

    544. 

  544. 

    545. 

  545. 			case 'oracle':

    546. 

  546. 				$table_sql .= "\n)";

    547. 

  547. 				$statements[] = $table_sql;

    548. 

  548. 

    549. 

  549. 				// do we need to add a sequence and a tigger for auto incrementing columns?

    550. 

  550. 				if ($create_sequence)

    551. 

  551. 				{

    552. 

  552. 					// create the actual sequence

    553. 

  553. 					$statements[] = "CREATE SEQUENCE {$table_name}_seq";

    554. 

  554. 

    555. 

  555. 					// the trigger is the mechanism by which we increment the counter

    556. 

  556. 					$trigger = "CREATE OR REPLACE TRIGGER t_{$table_name}\n";

    557. 

  557. 					$trigger .= "BEFORE INSERT ON {$table_name}\n";

    558. 

  558. 					$trigger .= "FOR EACH ROW WHEN (\n";

    559. 

  559. 					$trigger .= "\tnew.{$create_sequence} IS NULL OR new.{$create_sequence} = 0\n";

    560. 

  560. 					$trigger .= ")\n";

    561. 

  561. 					$trigger .= "BEGIN\n";

    562. 

  562. 					$trigger .= "\tSELECT {$table_name}_seq.nextval\n";

    563. 

  563. 					$trigger .= "\tINTO :new.{$create_sequence}\n";

    564. 

  564. 					$trigger .= "\tFROM dual;\n";

    565. 

  565. 					$trigger .= "END;";

    566. 

  566. 

    567. 

  567. 					$statements[] = $trigger;

    568. 

  568. 				}

    569. 

  569. 			break;

    570. 

  570. 

    571. 

  571. 			case 'firebird':

    572. 

  572. 				if ($create_sequence)

    573. 

  573. 				{

    574. 

  574. 					$statements[] = "CREATE GENERATOR {$table_name}_gen;";

    575. 

  575. 					$statements[] = "SET GENERATOR {$table_name}_gen TO 0;";

    576. 

  576. 

    577. 

  577. 					$trigger = "CREATE TRIGGER t_$table_name FOR $table_name\n";

    578. 

  578. 					$trigger .= "BEFORE INSERT\nAS\nBEGIN\n";

    579. 

  579. 					$trigger .= "\tNEW.{$create_sequence} = GEN_ID({$table_name}_gen, 1);\nEND;";

    580. 

  580. 					$statements[] = $trigger;

    581. 

  581. 				}

    582. 

  582. 			break;

    583. 

  583. 		}

    584. 

  584. 

    585. 

  585. 		// Write Keys

    586. 

  586. 		if (isset($table_data['KEYS']))

    587. 

  587. 		{

    588. 

  588. 			foreach ($table_data['KEYS'] as $key_name => $key_data)

    589. 

  589. 			{

    590. 

  590. 				if (!is_array($key_data[1]))

    591. 

  591. 				{

    592. 

  592. 					$key_data[1] = array($key_data[1]);

    593. 

  593. 				}

    594. 

  594. 

    595. 

  595. 				$old_return_statements = $this->return_statements;

    596. 

  596. 				$this->return_statements = true;

    597. 

  597. 

    598. 

  598. 				$key_stmts = ($key_data[0] == 'UNIQUE') ? $this->sql_create_unique_index($table_name, $key_name, $key_data[1]) : $this->sql_create_index($table_name, $key_name, $key_data[1]);

    599. 

  599. 

    600. 

  600. 				foreach ($key_stmts as $key_stmt)

    601. 

  601. 				{

    602. 

  602. 					$statements[] = $key_stmt;

    603. 

  603. 				}

    604. 

  604. 

    605. 

  605. 				$this->return_statements = $old_return_statements;

    606. 

  606. 			}

    607. 

  607. 		}

    608. 

  608. 

    609. 

  609. 		// Commit Transaction

    610. 

  610. 		$statements[] = 'commit';

    611. 

  611. 

    612. 

  612. 		return $this->_sql_run_sql($statements);

    613. 

  613. 	}

    614. 

  614. 

    615. 

  615. 	/**

    616. 

  616. 	* Handle passed database update array.

    617. 

  617. 	* Expected structure...

    618. 

  618. 	* Key being one of the following

    619. 

  619. 	*	change_columns: Column changes (only type, not name)

    620. 

  620. 	*	add_columns: Add columns to a table

    621. 

  621. 	*	drop_keys: Dropping keys

    622. 

  622. 	*	drop_columns: Removing/Dropping columns

    623. 

  623. 	*	add_primary_keys: adding primary keys

    624. 

  624. 	*	add_unique_index: adding an unique index

    625. 

  625. 	*	add_index: adding an index (can be column:index_size if you need to provide size)

    626. 

  626. 	*

    627. 

  627. 	* The values are in this format:

    628. 

  628. 	*		{TABLE NAME}		=> array(

    629. 

  629. 	*			{COLUMN NAME}		=> array({COLUMN TYPE}, {DEFAULT VALUE}, {OPTIONAL VARIABLES}),

    630. 

  630. 	*			{KEY/INDEX NAME}	=> array({COLUMN NAMES}),

    631. 

  631. 	*		)

    632. 

  632. 	*

    633. 

  633. 	* For more information have a look at /develop/create_schema_files.php (only available through SVN)

    634. 

  634. 	*/

    635. 

  635. 	function perform_schema_changes($schema_changes)

    636. 

  636. 	{

    637. 

  637. 		if (empty($schema_changes))

    638. 

  638. 		{

    639. 

  639. 			return;

    640. 

  640. 		}

    641. 

  641. 

    642. 

  642. 		$statements = array();

    643. 

  643. 		$sqlite = false;

    644. 

  644. 

    645. 

  645. 		// For SQLite we need to perform the schema changes in a much more different way

    646. 

  646. 		if ($this->db->sql_layer == 'sqlite' && $this->return_statements)

    647. 

  647. 		{

    648. 

  648. 			$sqlite_data = array();

    649. 

  649. 			$sqlite = true;

    650. 

  650. 		}

    651. 

  651. 

    652. 

  652. 		// Add tables?

    653. 

  653. 		if (!empty($schema_changes['add_tables']))

    654. 

  654. 		{

    655. 

  655. 			foreach ($schema_changes['add_tables'] as $table => $table_data)

    656. 

  656. 			{

    657. 

  657. 				$result = $this->sql_create_table($table, $table_data);

    658. 

  658. 				if ($this->return_statements)

    659. 

  659. 				{

    660. 

  660. 					$statements = array_merge($statements, $result);

    661. 

  661. 				}

    662. 

  662. 			}

    663. 

  663. 		}

    664. 

  664. 

    665. 

  665. 		// Change columns?

    666. 

  666. 		if (!empty($schema_changes['change_columns']))

    667. 

  667. 		{

    668. 

  668. 			foreach ($schema_changes['change_columns'] as $table => $columns)

    669. 

  669. 			{

    670. 

  670. 				foreach ($columns as $column_name => $column_data)

    671. 

  671. 				{

    672. 

  672. 					// If the column exists we change it, else we add it ;)

    673. 

  673. 					if ($column_exists = $this->sql_column_exists($table, $column_name))

    674. 

  674. 					{

    675. 

  675. 						$result = $this->sql_column_change($table, $column_name, $column_data, true);

    676. 

  676. 					}

    677. 

  677. 					else

    678. 

  678. 					{

    679. 

  679. 						$result = $this->sql_column_add($table, $column_name, $column_data, true);

    680. 

  680. 					}

    681. 

  681. 

    682. 

  682. 					if ($sqlite)

    683. 

  683. 					{

    684. 

  684. 						if ($column_exists)

    685. 

  685. 						{

    686. 

  686. 							$sqlite_data[$table]['change_columns'][] = $result;

    687. 

  687. 						}

    688. 

  688. 						else

    689. 

  689. 						{

    690. 

  690. 							$sqlite_data[$table]['add_columns'][] = $result;

    691. 

  691. 						}

    692. 

  692. 					}

    693. 

  693. 					else if ($this->return_statements)

    694. 

  694. 					{

    695. 

  695. 						$statements = array_merge($statements, $result);

    696. 

  696. 					}

    697. 

  697. 				}

    698. 

  698. 			}

    699. 

  699. 		}

    700. 

  700. 

    701. 

  701. 		// Add columns?

    702. 

  702. 		if (!empty($schema_changes['add_columns']))

    703. 

  703. 		{

    704. 

  704. 			foreach ($schema_changes['add_columns'] as $table => $columns)

    705. 

  705. 			{

    706. 

  706. 				foreach ($columns as $column_name => $column_data)

    707. 

  707. 				{

    708. 

  708. 					// Only add the column if it does not exist yet

    709. 

  709. 					if ($column_exists = $this->sql_column_exists($table, $column_name))

    710. 

  710. 					{

    711. 

  711. 						continue;

    712. 

  712. 						// This is commented out here because it can take tremendous time on updates

    713. 

  713. //						$result = $this->sql_column_change($table, $column_name, $column_data, true);

    714. 

  714. 					}

    715. 

  715. 					else

    716. 

  716. 					{

    717. 

  717. 						$result = $this->sql_column_add($table, $column_name, $column_data, true);

    718. 

  718. 					}

    719. 

  719. 

    720. 

  720. 					if ($sqlite)

    721. 

  721. 					{

    722. 

  722. 						if ($column_exists)

    723. 

  723. 						{

    724. 

  724. 							continue;

    725. 

  725. //							$sqlite_data[$table]['change_columns'][] = $result;

    726. 

  726. 						}

    727. 

  727. 						else

    728. 

  728. 						{

    729. 

  729. 							$sqlite_data[$table]['add_columns'][] = $result;

    730. 

  730. 						}

    731. 

  731. 					}

    732. 

  732. 					else if ($this->return_statements)

    733. 

  733. 					{

    734. 

  734. 						$statements = array_merge($statements, $result);

    735. 

  735. 					}

    736. 

  736. 				}

    737. 

  737. 			}

    738. 

  738. 		}

    739. 

  739. 

    740. 

  740. 		// Remove keys?

    741. 

  741. 		if (!empty($schema_changes['drop_keys']))

    742. 

  742. 		{

    743. 

  743. 			foreach ($schema_changes['drop_keys'] as $table => $indexes)

    744. 

  744. 			{

    745. 

  745. 				foreach ($indexes as $index_name)

    746. 

  746. 				{

    747. 

  747. 					if (!$this->sql_index_exists($table, $index_name))

    748. 

  748. 					{

    749. 

  749. 						continue;

    750. 

  750. 					}

    751. 

  751. 

    752. 

  752. 					$result = $this->sql_index_drop($table, $index_name);

    753. 

  753. 

    754. 

  754. 					if ($this->return_statements)

    755. 

  755. 					{

    756. 

  756. 						$statements = array_merge($statements, $result);

    757. 

  757. 					}

    758. 

  758. 				}

    759. 

  759. 			}

    760. 

  760. 		}

    761. 

  761. 

    762. 

  762. 		// Drop columns?

    763. 

  763. 		if (!empty($schema_changes['drop_columns']))

    764. 

  764. 		{

    765. 

  765. 			foreach ($schema_changes['drop_columns'] as $table => $columns)

    766. 

  766. 			{

    767. 

  767. 				foreach ($columns as $column)

    768. 

  768. 				{

    769. 

  769. 					// Only remove the column if it exists...

    770. 

  770. 					if ($this->sql_column_exists($table, $column))

    771. 

  771. 					{

    772. 

  772. 						$result = $this->sql_column_remove($table, $column, true);

    773. 

  773. 

    774. 

  774. 						if ($sqlite)

    775. 

  775. 						{

    776. 

  776. 							$sqlite_data[$table]['drop_columns'][] = $result;

    777. 

  777. 						}

    778. 

  778. 						else if ($this->return_statements)

    779. 

  779. 						{

    780. 

  780. 							$statements = array_merge($statements, $result);

    781. 

  781. 						}

    782. 

  782. 					}

    783. 

  783. 				}

    784. 

  784. 			}

    785. 

  785. 		}

    786. 

  786. 

    787. 

  787. 		// Add primary keys?

    788. 

  788. 		if (!empty($schema_changes['add_primary_keys']))

    789. 

  789. 		{

    790. 

  790. 			foreach ($schema_changes['add_primary_keys'] as $table => $columns)

    791. 

  791. 			{

    792. 

  792. 				$result = $this->sql_create_primary_key($table, $columns, true);

    793. 

  793. 

    794. 

  794. 				if ($sqlite)

    795. 

  795. 				{

    796. 

  796. 					$sqlite_data[$table]['primary_key'] = $result;

    797. 

  797. 				}

    798. 

  798. 				else if ($this->return_statements)

    799. 

  799. 				{

    800. 

  800. 					$statements = array_merge($statements, $result);

    801. 

  801. 				}

    802. 

  802. 			}

    803. 

  803. 		}

    804. 

  804. 

    805. 

  805. 		// Add unqiue indexes?

    806. 

  806. 		if (!empty($schema_changes['add_unique_index']))

    807. 

  807. 		{

    808. 

  808. 			foreach ($schema_changes['add_unique_index'] as $table => $index_array)

    809. 

  809. 			{

    810. 

  810. 				foreach ($index_array as $index_name => $column)

    811. 

  811. 				{

    812. 

  812. 					if ($this->sql_unique_index_exists($table, $index_name))

    813. 

  813. 					{

    814. 

  814. 						continue;

    815. 

  815. 					}

    816. 

  816. 

    817. 

  817. 					$result = $this->sql_create_unique_index($table, $index_name, $column);

    818. 

  818. 

    819. 

  819. 					if ($this->return_statements)

    820. 

  820. 					{

    821. 

  821. 						$statements = array_merge($statements, $result);

    822. 

  822. 					}

    823. 

  823. 				}

    824. 

  824. 			}

    825. 

  825. 		}

    826. 

  826. 

    827. 

  827. 		// Add indexes?

    828. 

  828. 		if (!empty($schema_changes['add_index']))

    829. 

  829. 		{

    830. 

  830. 			foreach ($schema_changes['add_index'] as $table => $index_array)

    831. 

  831. 			{

    832. 

  832. 				foreach ($index_array as $index_name => $column)

    833. 

  833. 				{

    834. 

  834. 					if ($this->sql_index_exists($table, $index_name))

    835. 

  835. 					{

    836. 

  836. 						continue;

    837. 

  837. 					}

    838. 

  838. 

    839. 

  839. 					$result = $this->sql_create_index($table, $index_name, $column);

    840. 

  840. 

    841. 

  841. 					if ($this->return_statements)

    842. 

  842. 					{

    843. 

  843. 						$statements = array_merge($statements, $result);

    844. 

  844. 					}

    845. 

  845. 				}

    846. 

  846. 			}

    847. 

  847. 		}

    848. 

  848. 

    849. 

  849. 		if ($sqlite)

    850. 

  850. 		{

    851. 

  851. 			foreach ($sqlite_data as $table_name => $sql_schema_changes)

    852. 

  852. 			{

    853. 

  853. 				// Create temporary table with original data

    854. 

  854. 				$statements[] = 'begin';

    855. 

  855. 

    856. 

  856. 				$sql = "SELECT sql

    857. 

  857. 					FROM sqlite_master

    858. 

  858. 					WHERE type = 'table'

    859. 

  859. 						AND name = '{$table_name}'

    860. 

  860. 					ORDER BY type DESC, name;";

    861. 

  861. 				$result = $this->db->sql_query($sql);

    862. 

  862. 

    863. 

  863. 				if (!$result)

    864. 

  864. 				{

    865. 

  865. 					continue;

    866. 

  866. 				}

    867. 

  867. 

    868. 

  868. 				$row = $this->db->sql_fetchrow($result);

    869. 

  869. 				$this->db->sql_freeresult($result);

    870. 

  870. 

    871. 

  871. 				// Create a backup table and populate it, destroy the existing one

    872. 

  872. 				$statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $row['sql']);

    873. 

  873. 				$statements[] = 'INSERT INTO ' . $table_name . '_temp SELECT * FROM ' . $table_name;

    874. 

  874. 				$statements[] = 'DROP TABLE ' . $table_name;

    875. 

  875. 

    876. 

  876. 				// Get the columns...

    877. 

  877. 				preg_match('#\((.*)\)#s', $row['sql'], $matches);

    878. 

  878. 

    879. 

  879. 				$plain_table_cols = trim($matches[1]);

    880. 

  880. 				$new_table_cols = preg_split('/,(?![\s\w]+\))/m', $plain_table_cols);

    881. 

  881. 				$column_list = array();

    882. 

  882. 

    883. 

  883. 				foreach ($new_table_cols as $declaration)

    884. 

  884. 				{

    885. 

  885. 					$entities = preg_split('#\s+#', trim($declaration));

    886. 

  886. 					if ($entities[0] == 'PRIMARY')

    887. 

  887. 					{

    888. 

  888. 						continue;

    889. 

  889. 					}

    890. 

  890. 					$column_list[] = $entities[0];

    891. 

  891. 				}

    892. 

  892. 

    893. 

  893. 				// note down the primary key notation because sqlite only supports adding it to the end for the new table

    894. 

  894. 				$primary_key = false;

    895. 

  895. 				$_new_cols = array();

    896. 

  896. 

    897. 

  897. 				foreach ($new_table_cols as $key => $declaration)

    898. 

  898. 				{

    899. 

  899. 					$entities = preg_split('#\s+#', trim($declaration));

    900. 

  900. 					if ($entities[0] == 'PRIMARY')

    901. 

  901. 					{

    902. 

  902. 						$primary_key = $declaration;

    903. 

  903. 						continue;

    904. 

  904. 					}

    905. 

  905. 					$_new_cols[] = $declaration;

    906. 

  906. 				}

    907. 

  907. 

    908. 

  908. 				$new_table_cols = $_new_cols;

    909. 

  909. 

    910. 

  910. 				// First of all... change columns

    911. 

  911. 				if (!empty($sql_schema_changes['change_columns']))

    912. 

  912. 				{

    913. 

  913. 					foreach ($sql_schema_changes['change_columns'] as $column_sql)

    914. 

  914. 					{

    915. 

  915. 						foreach ($new_table_cols as $key => $declaration)

    916. 

  916. 						{

    917. 

  917. 							$entities = preg_split('#\s+#', trim($declaration));

    918. 

  918. 							if (strpos($column_sql, $entities[0] . ' ') === 0)

    919. 

  919. 							{

    920. 

  920. 								$new_table_cols[$key] = $column_sql;

    921. 

  921. 							}

    922. 

  922. 						}

    923. 

  923. 					}

    924. 

  924. 				}

    925. 

  925. 

    926. 

  926. 				if (!empty($sql_schema_changes['add_columns']))

    927. 

  927. 				{

    928. 

  928. 					foreach ($sql_schema_changes['add_columns'] as $column_sql)

    929. 

  929. 					{

    930. 

  930. 						$new_table_cols[] = $column_sql;

    931. 

  931. 					}

    932. 

  932. 				}

    933. 

  933. 

    934. 

  934. 				// Now drop them...

    935. 

  935. 				if (!empty($sql_schema_changes['drop_columns']))

    936. 

  936. 				{

    937. 

  937. 					foreach ($sql_schema_changes['drop_columns'] as $column_name)

    938. 

  938. 					{

    939. 

  939. 						// Remove from column list...

    940. 

  940. 						$new_column_list = array();

    941. 

  941. 						foreach ($column_list as $key => $value)

    942. 

  942. 						{

    943. 

  943. 							if ($value === $column_name)

    944. 

  944. 							{

    945. 

  945. 								continue;

    946. 

  946. 							}

    947. 

  947. 

    948. 

  948. 							$new_column_list[] = $value;

    949. 

  949. 						}

    950. 

  950. 

    951. 

  951. 						$column_list = $new_column_list;

    952. 

  952. 

    953. 

  953. 						// Remove from table...

    954. 

  954. 						$_new_cols = array();

    955. 

  955. 						foreach ($new_table_cols as $key => $declaration)

    956. 

  956. 						{

    957. 

  957. 							$entities = preg_split('#\s+#', trim($declaration));

    958. 

  958. 							if (strpos($column_name . ' ', $entities[0] . ' ') === 0)

    959. 

  959. 							{

    960. 

  960. 								continue;

    961. 

  961. 							}

    962. 

  962. 							$_new_cols[] = $declaration;

    963. 

  963. 						}

    964. 

  964. 						$new_table_cols = $_new_cols;

    965. 

  965. 					}

    966. 

  966. 				}

    967. 

  967. 

    968. 

  968. 				// Primary key...

    969. 

  969. 				if (!empty($sql_schema_changes['primary_key']))

    970. 

  970. 				{

    971. 

  971. 					$new_table_cols[] = 'PRIMARY KEY (' . implode(', ', $sql_schema_changes['primary_key']) . ')';

    972. 

  972. 				}

    973. 

  973. 				// Add a new one or the old primary key

    974. 

  974. 				else if ($primary_key !== false)

    975. 

  975. 				{

    976. 

  976. 					$new_table_cols[] = $primary_key;

    977. 

  977. 				}

    978. 

  978. 

    979. 

  979. 				$columns = implode(',', $column_list);

    980. 

  980. 

    981. 

  981. 				// create a new table and fill it up. destroy the temp one

    982. 

  982. 				$statements[] = 'CREATE TABLE ' . $table_name . ' (' . implode(',', $new_table_cols) . ');';

    983. 

  983. 				$statements[] = 'INSERT INTO ' . $table_name . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . $table_name . '_temp;';

    984. 

  984. 				$statements[] = 'DROP TABLE ' . $table_name . '_temp';

    985. 

  985. 

    986. 

  986. 				$statements[] = 'commit';

    987. 

  987. 			}

    988. 

  988. 		}

    989. 

  989. 

    990. 

  990. 		if ($this->return_statements)

    991. 

  991. 		{

    992. 

  992. 			return $statements;

    993. 

  993. 		}

    994. 

  994. 	}

    995. 

  995. 

    996. 

  996. 	/**

    997. 

  997. 	* Check if a specified column exist

    998. 

  998. 	*

    999. 

  999. 	* @param string	$table			Table to check the column at

    1000. 

  1000. 	* @param string	$column_name	The column to check

    1001. 

  1001. 	*

    1002. 

  1002. 	* @return bool True if column exists, else false

    1003. 

  1003. 	*/

    1004. 

  1004. 	function sql_column_exists($table, $column_name)

    1005. 

  1005. 	{

    1006. 

  1006. 		switch ($this->sql_layer)

    1007. 

  1007. 		{

    1008. 

  1008. 			case 'mysql_40':

    1009. 

  1009. 			case 'mysql_41':

    1010. 

  1010. 

    1011. 

  1011. 				$sql = "SHOW COLUMNS FROM $table";

    1012. 

  1012. 				$result = $this->db->sql_query($sql);

    1013. 

  1013. 

    1014. 

  1014. 				while ($row = $this->db->sql_fetchrow($result))

    1015. 

  1015. 				{

    1016. 

  1016. 					// lower case just in case

    1017. 

  1017. 					if (strtolower($row['Field']) == $column_name)

    1018. 

  1018. 					{

    1019. 

  1019. 						$this->db->sql_freeresult($result);

    1020. 

  1020. 						return true;

    1021. 

  1021. 					}

    1022. 

  1022. 				}

    1023. 

  1023. 				$this->db->sql_freeresult($result);

    1024. 

  1024. 				return false;

    1025. 

  1025. 			break;

    1026. 

  1026. 

    1027. 

  1027. 			// PostgreSQL has a way of doing this in a much simpler way but would

    1028. 

  1028. 			// not allow us to support all versions of PostgreSQL

    1029. 

  1029. 			case 'postgres':

    1030. 

  1030. 				$sql = "SELECT a.attname

    1031. 

  1031. 					FROM pg_class c, pg_attribute a

    1032. 

  1032. 					WHERE c.relname = '{$table}'

    1033. 

  1033. 						AND a.attnum > 0

    1034. 

  1034. 						AND a.attrelid = c.oid";

    1035. 

  1035. 				$result = $this->db->sql_query($sql);

    1036. 

  1036. 				while ($row = $this->db->sql_fetchrow($result))

    1037. 

  1037. 				{

    1038. 

  1038. 					// lower case just in case

    1039. 

  1039. 					if (strtolower($row['attname']) == $column_name)

    1040. 

  1040. 					{

    1041. 

  1041. 						$this->db->sql_freeresult($result);

    1042. 

  1042. 						return true;

    1043. 

  1043. 					}

    1044. 

  1044. 				}

    1045. 

  1045. 				$this->db->sql_freeresult($result);

    1046. 

  1046. 

    1047. 

  1047. 				return false;

    1048. 

  1048. 			break;

    1049. 

  1049. 

    1050. 

  1050. 			// same deal with PostgreSQL, we must perform more complex operations than

    1051. 

  1051. 			// we technically could

    1052. 

  1052. 			case 'mssql':

    1053. 

  1053. 			case 'mssqlnative':

    1054. 

  1054. 				$sql = "SELECT c.name

    1055. 

  1055. 					FROM syscolumns c

    1056. 

  1056. 					LEFT JOIN sysobjects o ON c.id = o.id

    1057. 

  1057. 					WHERE o.name = '{$table}'";

    1058. 

  1058. 				$result = $this->db->sql_query($sql);

    1059. 

  1059. 				while ($row = $this->db->sql_fetchrow($result))

    1060. 

  1060. 				{

    1061. 

  1061. 					// lower case just in case

    1062. 

  1062. 					if (strtolower($row['name']) == $column_name)

    1063. 

  1063. 					{

    1064. 

  1064. 						$this->db->sql_freeresult($result);

    1065. 

  1065. 						return true;

    1066. 

  1066. 					}

    1067. 

  1067. 				}

    1068. 

  1068. 				$this->db->sql_freeresult($result);

    1069. 

  1069. 				return false;

    1070. 

  1070. 			break;

    1071. 

  1071. 

    1072. 

  1072. 			case 'oracle':

    1073. 

  1073. 				$sql = "SELECT column_name

    1074. 

  1074. 					FROM user_tab_columns

    1075. 

  1075. 					WHERE LOWER(table_name) = '" . strtolower($table) . "'";

    1076. 

  1076. 				$result = $this->db->sql_query($sql);

    1077. 

  1077. 				while ($row = $this->db->sql_fetchrow($result))

    1078. 

  1078. 				{

    1079. 

  1079. 					// lower case just in case

    1080. 

  1080. 					if (strtolower($row['column_name']) == $column_name)

    1081. 

  1081. 					{

    1082. 

  1082. 						$this->db->sql_freeresult($result);

    1083. 

  1083. 						return true;

    1084. 

  1084. 					}

    1085. 

  1085. 				}

    1086. 

  1086. 				$this->db->sql_freeresult($result);

    1087. 

  1087. 				return false;

    1088. 

  1088. 			break;

    1089. 

  1089. 

    1090. 

  1090. 			case 'firebird':

    1091. 

  1091. 				$sql = "SELECT RDB\$FIELD_NAME as FNAME

    1092. 

  1092. 					FROM RDB\$RELATION_FIELDS

    1093. 

  1093. 					WHERE RDB\$RELATION_NAME = '" . strtoupper($table) . "'";

    1094. 

  1094. 				$result = $this->db->sql_query($sql);

    1095. 

  1095. 				while ($row = $this->db->sql_fetchrow($result))

    1096. 

  1096. 				{

    1097. 

  1097. 					// lower case just in case

    1098. 

  1098. 					if (strtolower($row['fname']) == $column_name)

    1099. 

  1099. 					{

    1100. 

  1100. 						$this->db->sql_freeresult($result);

    1101. 

  1101. 						return true;

    1102. 

  1102. 					}

    1103. 

  1103. 				}

    1104. 

  1104. 				$this->db->sql_freeresult($result);

    1105. 

  1105. 				return false;

    1106. 

  1106. 			break;

    1107. 

  1107. 

    1108. 

  1108. 			// ugh, SQLite

    1109. 

  1109. 			case 'sqlite':

    1110. 

  1110. 				$sql = "SELECT sql

    1111. 

  1111. 					FROM sqlite_master

    1112. 

  1112. 					WHERE type = 'table'

    1113. 

  1113. 						AND name = '{$table}'";

    1114. 

  1114. 				$result = $this->db->sql_query($sql);

    1115. 

  1115. 

    1116. 

  1116. 				if (!$result)

    1117. 

  1117. 				{

    1118. 

  1118. 					return false;

    1119. 

  1119. 				}

    1120. 

  1120. 

    1121. 

  1121. 				$row = $this->db->sql_fetchrow($result);

    1122. 

  1122. 				$this->db->sql_freeresult($result);

    1123. 

  1123. 

    1124. 

  1124. 				preg_match('#\((.*)\)#s', $row['sql'], $matches);

    1125. 

  1125. 

    1126. 

  1126. 				$cols = trim($matches[1]);

    1127. 

  1127. 				$col_array = preg_split('/,(?![\s\w]+\))/m', $cols);

    1128. 

  1128. 

    1129. 

  1129. 				foreach ($col_array as $declaration)

    1130. 

  1130. 				{

    1131. 

  1131. 					$entities = preg_split('#\s+#', trim($declaration));

    1132. 

  1132. 					if ($entities[0] == 'PRIMARY')

    1133. 

  1133. 					{

    1134. 

  1134. 						continue;

    1135. 

  1135. 					}

    1136. 

  1136. 

    1137. 

  1137. 					if (strtolower($entities[0]) == $column_name)

    1138. 

  1138. 					{

    1139. 

  1139. 						return true;

    1140. 

  1140. 					}

    1141. 

  1141. 				}

    1142. 

  1142. 				return false;

    1143. 

  1143. 			break;

    1144. 

  1144. 		}

    1145. 

  1145. 	}

    1146. 

  1146. 

    1147. 

  1147. 	/**

    1148. 

  1148. 	* Check if a specified index exists in table. Does not return PRIMARY KEY and UNIQUE indexes.

    1149. 

  1149. 	*

    1150. 

  1150. 	* @param string	$table_name		Table to check the index at

    1151. 

  1151. 	* @param string	$index_name		The index name to check

    1152. 

  1152. 	*

    1153. 

  1153. 	* @return bool True if index exists, else false

    1154. 

  1154. 	*/

    1155. 

  1155. 	function sql_index_exists($table_name, $index_name)

    1156. 

  1156. 	{

    1157. 

  1157. 		if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

    1158. 

  1158. 		{

    1159. 

  1159. 			$sql = "EXEC sp_statistics '$table_name'";

    1160. 

  1160. 			$result = $this->db->sql_query($sql);

    1161. 

  1161. 

    1162. 

  1162. 			while ($row = $this->db->sql_fetchrow($result))

    1163. 

  1163. 			{

    1164. 

  1164. 				if ($row['TYPE'] == 3)

    1165. 

  1165. 				{

    1166. 

  1166. 					if (strtolower($row['INDEX_NAME']) == strtolower($index_name))

    1167. 

  1167. 					{

    1168. 

  1168. 						$this->db->sql_freeresult($result);

    1169. 

  1169. 						return true;

    1170. 

  1170. 					}

    1171. 

  1171. 				}

    1172. 

  1172. 			}

    1173. 

  1173. 			$this->db->sql_freeresult($result);

    1174. 

  1174. 

    1175. 

  1175. 			return false;

    1176. 

  1176. 		}

    1177. 

  1177. 

    1178. 

  1178. 		switch ($this->sql_layer)

    1179. 

  1179. 		{

    1180. 

  1180. 			case 'firebird':

    1181. 

  1181. 				$sql = "SELECT LOWER(RDB\$INDEX_NAME) as index_name

    1182. 

  1182. 					FROM RDB\$INDICES

    1183. 

  1183. 					WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

    1184. 

  1184. 						AND RDB\$UNIQUE_FLAG IS NULL

    1185. 

  1185. 						AND RDB\$FOREIGN_KEY IS NULL";

    1186. 

  1186. 				$col = 'index_name';

    1187. 

  1187. 			break;

    1188. 

  1188. 

    1189. 

  1189. 			case 'postgres':

    1190. 

  1190. 				$sql = "SELECT ic.relname as index_name

    1191. 

  1191. 					FROM pg_class bc, pg_class ic, pg_index i

    1192. 

  1192. 					WHERE (bc.oid = i.indrelid)

    1193. 

  1193. 						AND (ic.oid = i.indexrelid)

    1194. 

  1194. 						AND (bc.relname = '" . $table_name . "')

    1195. 

  1195. 						AND (i.indisunique != 't')

    1196. 

  1196. 						AND (i.indisprimary != 't')";

    1197. 

  1197. 				$col = 'index_name';

    1198. 

  1198. 			break;

    1199. 

  1199. 

    1200. 

  1200. 			case 'mysql_40':

    1201. 

  1201. 			case 'mysql_41':

    1202. 

  1202. 				$sql = 'SHOW KEYS

    1203. 

  1203. 					FROM ' . $table_name;

    1204. 

  1204. 				$col = 'Key_name';

    1205. 

  1205. 			break;

    1206. 

  1206. 

    1207. 

  1207. 			case 'oracle':

    1208. 

  1208. 				$sql = "SELECT index_name

    1209. 

  1209. 					FROM user_indexes

    1210. 

  1210. 					WHERE table_name = '" . strtoupper($table_name) . "'

    1211. 

  1211. 						AND generated = 'N'

    1212. 

  1212. 						AND uniqueness = 'NONUNIQUE'";

    1213. 

  1213. 				$col = 'index_name';

    1214. 

  1214. 			break;

    1215. 

  1215. 

    1216. 

  1216. 			case 'sqlite':

    1217. 

  1217. 				$sql = "PRAGMA index_list('" . $table_name . "');";

    1218. 

  1218. 				$col = 'name';

    1219. 

  1219. 			break;

    1220. 

  1220. 		}

    1221. 

  1221. 

    1222. 

  1222. 		$result = $this->db->sql_query($sql);

    1223. 

  1223. 		while ($row = $this->db->sql_fetchrow($result))

    1224. 

  1224. 		{

    1225. 

  1225. 			if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && !$row['Non_unique'])

    1226. 

  1226. 			{

    1227. 

  1227. 				continue;

    1228. 

  1228. 			}

    1229. 

  1229. 

    1230. 

  1230. 			// These DBMS prefix index name with the table name

    1231. 

  1231. 			switch ($this->sql_layer)

    1232. 

  1232. 			{

    1233. 

  1233. 				case 'firebird':

    1234. 

  1234. 				case 'oracle':

    1235. 

  1235. 				case 'postgres':

    1236. 

  1236. 				case 'sqlite':

    1237. 

  1237. 					$row[$col] = substr($row[$col], strlen($table_name) + 1);

    1238. 

  1238. 				break;

    1239. 

  1239. 			}

    1240. 

  1240. 

    1241. 

  1241. 			if (strtolower($row[$col]) == strtolower($index_name))

    1242. 

  1242. 			{

    1243. 

  1243. 				$this->db->sql_freeresult($result);

    1244. 

  1244. 				return true;

    1245. 

  1245. 			}

    1246. 

  1246. 		}

    1247. 

  1247. 		$this->db->sql_freeresult($result);

    1248. 

  1248. 

    1249. 

  1249. 		return false;

    1250. 

  1250. 	}

    1251. 

  1251. 

    1252. 

  1252. 	/**

    1253. 

  1253. 	* Check if a specified index exists in table. Does not return PRIMARY KEY and UNIQUE indexes.

    1254. 

  1254. 	*

    1255. 

  1255. 	* @param string	$table_name		Table to check the index at

    1256. 

  1256. 	* @param string	$index_name		The index name to check

    1257. 

  1257. 	*

    1258. 

  1258. 	* @return bool True if index exists, else false

    1259. 

  1259. 	*/

    1260. 

  1260. 	function sql_unique_index_exists($table_name, $index_name)

    1261. 

  1261. 	{

    1262. 

  1262. 		if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

    1263. 

  1263. 		{

    1264. 

  1264. 			$sql = "EXEC sp_statistics '$table_name'";

    1265. 

  1265. 			$result = $this->db->sql_query($sql);

    1266. 

  1266. 

    1267. 

  1267. 			while ($row = $this->db->sql_fetchrow($result))

    1268. 

  1268. 			{

    1269. 

  1269. 				// Usually NON_UNIQUE is the column we want to check, but we allow for both

    1270. 

  1270. 				if ($row['TYPE'] == 3)

    1271. 

  1271. 				{

    1272. 

  1272. 					if (strtolower($row['INDEX_NAME']) == strtolower($index_name))

    1273. 

  1273. 					{

    1274. 

  1274. 						$this->db->sql_freeresult($result);

    1275. 

  1275. 						return true;

    1276. 

  1276. 					}

    1277. 

  1277. 				}

    1278. 

  1278. 			}

    1279. 

  1279. 			$this->db->sql_freeresult($result);

    1280. 

  1280. 			return false;

    1281. 

  1281. 		}

    1282. 

  1282. 

    1283. 

  1283. 		switch ($this->sql_layer)

    1284. 

  1284. 		{

    1285. 

  1285. 			case 'firebird':

    1286. 

  1286. 				$sql = "SELECT LOWER(RDB\$INDEX_NAME) as index_name

    1287. 

  1287. 					FROM RDB\$INDICES

    1288. 

  1288. 					WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

    1289. 

  1289. 						AND RDB\$UNIQUE_FLAG IS NOT NULL

    1290. 

  1290. 						AND RDB\$FOREIGN_KEY IS NULL";

    1291. 

  1291. 				$col = 'index_name';

    1292. 

  1292. 			break;

    1293. 

  1293. 

    1294. 

  1294. 			case 'postgres':

    1295. 

  1295. 				$sql = "SELECT ic.relname as index_name, i.indisunique

    1296. 

  1296. 					FROM pg_class bc, pg_class ic, pg_index i

    1297. 

  1297. 					WHERE (bc.oid = i.indrelid)

    1298. 

  1298. 						AND (ic.oid = i.indexrelid)

    1299. 

  1299. 						AND (bc.relname = '" . $table_name . "')

    1300. 

  1300. 						AND (i.indisprimary != 't')";

    1301. 

  1301. 				$col = 'index_name';

    1302. 

  1302. 			break;

    1303. 

  1303. 

    1304. 

  1304. 			case 'mysql_40':

    1305. 

  1305. 			case 'mysql_41':

    1306. 

  1306. 				$sql = 'SHOW KEYS

    1307. 

  1307. 					FROM ' . $table_name;

    1308. 

  1308. 				$col = 'Key_name';

    1309. 

  1309. 			break;

    1310. 

  1310. 

    1311. 

  1311. 			case 'oracle':

    1312. 

  1312. 				$sql = "SELECT index_name, table_owner

    1313. 

  1313. 					FROM user_indexes

    1314. 

  1314. 					WHERE table_name = '" . strtoupper($table_name) . "'

    1315. 

  1315. 						AND generated = 'N'

    1316. 

  1316. 						AND uniqueness = 'UNIQUE'";

    1317. 

  1317. 				$col = 'index_name';

    1318. 

  1318. 			break;

    1319. 

  1319. 

    1320. 

  1320. 			case 'sqlite':

    1321. 

  1321. 				$sql = "PRAGMA index_list('" . $table_name . "');";

    1322. 

  1322. 				$col = 'name';

    1323. 

  1323. 			break;

    1324. 

  1324. 		}

    1325. 

  1325. 

    1326. 

  1326. 		$result = $this->db->sql_query($sql);

    1327. 

  1327. 		while ($row = $this->db->sql_fetchrow($result))

    1328. 

  1328. 		{

    1329. 

  1329. 			if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && ($row['Non_unique'] || $row[$col] == 'PRIMARY'))

    1330. 

  1330. 			{

    1331. 

  1331. 				continue;

    1332. 

  1332. 			}

    1333. 

  1333. 

    1334. 

  1334. 			if ($this->sql_layer == 'sqlite' && !$row['unique'])

    1335. 

  1335. 			{

    1336. 

  1336. 				continue;

    1337. 

  1337. 			}

    1338. 

  1338. 

    1339. 

  1339. 			if ($this->sql_layer == 'postgres' && $row['indisunique'] != 't')

    1340. 

  1340. 			{

    1341. 

  1341. 				continue;

    1342. 

  1342. 			}

    1343. 

  1343. 

    1344. 

  1344. 			// These DBMS prefix index name with the table name

    1345. 

  1345. 			switch ($this->sql_layer)

    1346. 

  1346. 			{

    1347. 

  1347. 				case 'oracle':

    1348. 

  1348. 					// Two cases here... prefixed with U_[table_owner] and not prefixed with table_name

    1349. 

  1349. 					if (strpos($row[$col], 'U_') === 0)

    1350. 

  1350. 					{

    1351. 

  1351. 						$row[$col] = substr($row[$col], strlen('U_' . $row['table_owner']) + 1);

    1352. 

  1352. 					}

    1353. 

  1353. 					else if (strpos($row[$col], strtoupper($table_name)) === 0)

    1354. 

  1354. 					{

    1355. 

  1355. 						$row[$col] = substr($row[$col], strlen($table_name) + 1);

    1356. 

  1356. 					}

    1357. 

  1357. 				break;

    1358. 

  1358. 

    1359. 

  1359. 				case 'firebird':

    1360. 

  1360. 				case 'postgres':

    1361. 

  1361. 				case 'sqlite':

    1362. 

  1362. 					$row[$col] = substr($row[$col], strlen($table_name) + 1);

    1363. 

  1363. 				break;

    1364. 

  1364. 			}

    1365. 

  1365. 

    1366. 

  1366. 			if (strtolower($row[$col]) == strtolower($index_name))

    1367. 

  1367. 			{

    1368. 

  1368. 				$this->db->sql_freeresult($result);

    1369. 

  1369. 				return true;

    1370. 

  1370. 			}

    1371. 

  1371. 		}

    1372. 

  1372. 		$this->db->sql_freeresult($result);

    1373. 

  1373. 

    1374. 

  1374. 		return false;

    1375. 

  1375. 	}

    1376. 

  1376. 

    1377. 

  1377. 	/**

    1378. 

  1378. 	* Private method for performing sql statements (either execute them or return them)

    1379. 

  1379. 	* @access private

    1380. 

  1380. 	*/

    1381. 

  1381. 	function _sql_run_sql($statements)

    1382. 

  1382. 	{

    1383. 

  1383. 		if ($this->return_statements)

    1384. 

  1384. 		{

    1385. 

  1385. 			return $statements;

    1386. 

  1386. 		}

    1387. 

  1387. 

    1388. 

  1388. 		// We could add error handling here...

    1389. 

  1389. 		foreach ($statements as $sql)

    1390. 

  1390. 		{

    1391. 

  1391. 			if ($sql === 'begin')

    1392. 

  1392. 			{

    1393. 

  1393. 				$this->db->sql_transaction('begin');

    1394. 

  1394. 			}

    1395. 

  1395. 			else if ($sql === 'commit')

    1396. 

  1396. 			{

    1397. 

  1397. 				$this->db->sql_transaction('commit');

    1398. 

  1398. 			}

    1399. 

  1399. 			else

    1400. 

  1400. 			{

    1401. 

  1401. 				$this->db->sql_query($sql);

    1402. 

  1402. 			}

    1403. 

  1403. 		}

    1404. 

  1404. 

    1405. 

  1405. 		return true;

    1406. 

  1406. 	}

    1407. 

  1407. 

    1408. 

  1408. 	/**

    1409. 

  1409. 	* Function to prepare some column information for better usage

    1410. 

  1410. 	* @access private

    1411. 

  1411. 	*/

    1412. 

  1412. 	function sql_prepare_column_data($table_name, $column_name, $column_data)

    1413. 

  1413. 	{

    1414. 

  1414. 		if (strlen($column_name) > 30)

    1415. 

  1415. 		{

    1416. 

  1416. 			trigger_error("Column name '$column_name' on table '$table_name' is too long. The maximum is 30 characters.", E_USER_ERROR);

    1417. 

  1417. 		}

    1418. 

  1418. 

    1419. 

  1419. 		// Get type

    1420. 

  1420. 		if (strpos($column_data[0], ':') !== false)

    1421. 

  1421. 		{

    1422. 

  1422. 			list($orig_column_type, $column_length) = explode(':', $column_data[0]);

    1423. 

  1423. 			if (!is_array($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']))

    1424. 

  1424. 			{

    1425. 

  1425. 				$column_type = sprintf($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':'], $column_length);

    1426. 

  1426. 			}

    1427. 

  1427. 			else

    1428. 

  1428. 			{

    1429. 

  1429. 				if (isset($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['rule']))

    1430. 

  1430. 				{

    1431. 

  1431. 					switch ($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['rule'][0])

    1432. 

  1432. 					{

    1433. 

  1433. 						case 'div':

    1434. 

  1434. 							$column_length /= $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['rule'][1];

    1435. 

  1435. 							$column_length = ceil($column_length);

    1436. 

  1436. 							$column_type = sprintf($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':'][0], $column_length);

    1437. 

  1437. 						break;

    1438. 

  1438. 					}

    1439. 

  1439. 				}

    1440. 

  1440. 

    1441. 

  1441. 				if (isset($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit']))

    1442. 

  1442. 				{

    1443. 

  1443. 					switch ($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][0])

    1444. 

  1444. 					{

    1445. 

  1445. 						case 'mult':

    1446. 

  1446. 							$column_length *= $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][1];

    1447. 

  1447. 							if ($column_length > $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][2])

    1448. 

  1448. 							{

    1449. 

  1449. 								$column_type = $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][3];

    1450. 

  1450. 							}

    1451. 

  1451. 							else

    1452. 

  1452. 							{

    1453. 

  1453. 								$column_type = sprintf($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':'][0], $column_length);

    1454. 

  1454. 							}

    1455. 

  1455. 						break;

    1456. 

  1456. 					}

    1457. 

  1457. 				}

    1458. 

  1458. 			}

    1459. 

  1459. 			$orig_column_type .= ':';

    1460. 

  1460. 		}

    1461. 

  1461. 		else

    1462. 

  1462. 		{

    1463. 

  1463. 			$orig_column_type = $column_data[0];

    1464. 

  1464. 			$column_type = $this->dbms_type_map[$this->sql_layer][$column_data[0]];

    1465. 

  1465. 		}

    1466. 

  1466. 

    1467. 

  1467. 		// Adjust default value if db-dependant specified

    1468. 

  1468. 		if (is_array($column_data[1]))

    1469. 

  1469. 		{

    1470. 

  1470. 			$column_data[1] = (isset($column_data[1][$this->sql_layer])) ? $column_data[1][$this->sql_layer] : $column_data[1]['default'];

    1471. 

  1471. 		}

    1472. 

  1472. 

    1473. 

  1473. 		$sql = '';

    1474. 

  1474. 

    1475. 

  1475. 		$return_array = array();

    1476. 

  1476. 

    1477. 

  1477. 		switch ($this->sql_layer)

    1478. 

  1478. 		{

    1479. 

  1479. 			case 'firebird':

    1480. 

  1480. 				$sql .= " {$column_type} ";

    1481. 

  1481. 				$return_array['column_type_sql_type'] = " {$column_type} ";

    1482. 

  1482. 

    1483. 

  1483. 				if (!is_null($column_data[1]))

    1484. 

  1484. 				{

    1485. 

  1485. 					$sql .= 'DEFAULT ' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ' ';

    1486. 

  1486. 					$return_array['column_type_sql_default'] = ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ' ';

    1487. 

  1487. 				}

    1488. 

  1488. 

    1489. 

  1489. 				$sql .= 'NOT NULL';

    1490. 

  1490. 

    1491. 

  1491. 				// This is a UNICODE column and thus should be given it's fair share

    1492. 

  1492. 				if (preg_match('/^X?STEXT_UNI|VCHAR_(CI|UNI:?)/', $column_data[0]))

    1493. 

  1493. 				{

    1494. 

  1494. 					$sql .= ' COLLATE UNICODE';

    1495. 

  1495. 				}

    1496. 

  1496. 

    1497. 

  1497. 				$return_array['auto_increment'] = false;

    1498. 

  1498. 				if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

    1499. 

  1499. 				{

    1500. 

  1500. 					$return_array['auto_increment'] = true;

    1501. 

  1501. 				}

    1502. 

  1502. 

    1503. 

  1503. 			break;

    1504. 

  1504. 

    1505. 

  1505. 			case 'mssql':

    1506. 

  1506. 			case 'mssqlnative':

    1507. 

  1507. 				$sql .= " {$column_type} ";

    1508. 

  1508. 				$sql_default = " {$column_type} ";

    1509. 

  1509. 

    1510. 

  1510. 				// For adding columns we need the default definition

    1511. 

  1511. 				if (!is_null($column_data[1]))

    1512. 

  1512. 				{

    1513. 

  1513. 					// For hexadecimal values do not use single quotes

    1514. 

  1514. 					if (strpos($column_data[1], '0x') === 0)

    1515. 

  1515. 					{

    1516. 

  1516. 						$return_array['default'] = 'DEFAULT (' . $column_data[1] . ') ';

    1517. 

  1517. 						$sql_default .= $return_array['default'];

    1518. 

  1518. 					}

    1519. 

  1519. 					else

    1520. 

  1520. 					{

    1521. 

  1521. 						$return_array['default'] = 'DEFAULT (' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ') ';

    1522. 

  1522. 						$sql_default .= $return_array['default'];

    1523. 

  1523. 					}

    1524. 

  1524. 				}

    1525. 

  1525. 

    1526. 

  1526. 				if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

    1527. 

  1527. 				{

    1528. 

  1528. //					$sql .= 'IDENTITY (1, 1) ';

    1529. 

  1529. 					$sql_default .= 'IDENTITY (1, 1) ';

    1530. 

  1530. 				}

    1531. 

  1531. 

    1532. 

  1532. 				$return_array['textimage'] = $column_type === '[text]';

    1533. 

  1533. 

    1534. 

  1534. 				$sql .= 'NOT NULL';

    1535. 

  1535. 				$sql_default .= 'NOT NULL';

    1536. 

  1536. 

    1537. 

  1537. 				$return_array['column_type_sql_default'] = $sql_default;

    1538. 

  1538. 

    1539. 

  1539. 			break;

    1540. 

  1540. 

    1541. 

  1541. 			case 'mysql_40':

    1542. 

  1542. 			case 'mysql_41':

    1543. 

  1543. 				$sql .= " {$column_type} ";

    1544. 

  1544. 

    1545. 

  1545. 				// For hexadecimal values do not use single quotes

    1546. 

  1546. 				if (!is_null($column_data[1]) && substr($column_type, -4) !== 'text' && substr($column_type, -4) !== 'blob')

    1547. 

  1547. 				{

    1548. 

  1548. 					$sql .= (strpos($column_data[1], '0x') === 0) ? "DEFAULT {$column_data[1]} " : "DEFAULT '{$column_data[1]}' ";

    1549. 

  1549. 				}

    1550. 

  1550. 				$sql .= 'NOT NULL';

    1551. 

  1551. 

    1552. 

  1552. 				if (isset($column_data[2]))

    1553. 

  1553. 				{

    1554. 

  1554. 					if ($column_data[2] == 'auto_increment')

    1555. 

  1555. 					{

    1556. 

  1556. 						$sql .= ' auto_increment';

    1557. 

  1557. 					}

    1558. 

  1558. 					else if ($this->sql_layer === 'mysql_41' && $column_data[2] == 'true_sort')

    1559. 

  1559. 					{

    1560. 

  1560. 						$sql .= ' COLLATE utf8_unicode_ci';

    1561. 

  1561. 					}

    1562. 

  1562. 				}

    1563. 

  1563. 

    1564. 

  1564. 			break;

    1565. 

  1565. 

    1566. 

  1566. 			case 'oracle':

    1567. 

  1567. 				$sql .= " {$column_type} ";

    1568. 

  1568. 				$sql .= (!is_null($column_data[1])) ? "DEFAULT '{$column_data[1]}' " : '';

    1569. 

  1569. 

    1570. 

  1570. 				// In Oracle empty strings ('') are treated as NULL.

    1571. 

  1571. 				// Therefore in oracle we allow NULL's for all DEFAULT '' entries

    1572. 

  1572. 				// Oracle does not like setting NOT NULL on a column that is already NOT NULL (this happens only on number fields)

    1573. 

  1573. 				if (!preg_match('/number/i', $column_type))

    1574. 

  1574. 				{

    1575. 

  1575. 					$sql .= ($column_data[1] === '') ? '' : 'NOT NULL';

    1576. 

  1576. 				}

    1577. 

  1577. 

    1578. 

  1578. 				$return_array['auto_increment'] = false;

    1579. 

  1579. 				if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

    1580. 

  1580. 				{

    1581. 

  1581. 					$return_array['auto_increment'] = true;

    1582. 

  1582. 				}

    1583. 

  1583. 

    1584. 

  1584. 			break;

    1585. 

  1585. 

    1586. 

  1586. 			case 'postgres':

    1587. 

  1587. 				$return_array['column_type'] = $column_type;

    1588. 

  1588. 

    1589. 

  1589. 				$sql .= " {$column_type} ";

    1590. 

  1590. 

    1591. 

  1591. 				$return_array['auto_increment'] = false;

    1592. 

  1592. 				if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

    1593. 

  1593. 				{

    1594. 

  1594. 					$default_val = "nextval('{$table_name}_seq')";

    1595. 

  1595. 					$return_array['auto_increment'] = true;

    1596. 

  1596. 				}

    1597. 

  1597. 				else if (!is_null($column_data[1]))

    1598. 

  1598. 				{

    1599. 

  1599. 					$default_val = "'" . $column_data[1] . "'";

    1600. 

  1600. 					$return_array['null'] = 'NOT NULL';

    1601. 

  1601. 					$sql .= 'NOT NULL ';

    1602. 

  1602. 				}

    1603. 

  1603. 

    1604. 

  1604. 				$return_array['default'] = $default_val;

    1605. 

  1605. 

    1606. 

  1606. 				$sql .= "DEFAULT {$default_val}";

    1607. 

  1607. 

    1608. 

  1608. 				// Unsigned? Then add a CHECK contraint

    1609. 

  1609. 				if (in_array($orig_column_type, $this->unsigned_types))

    1610. 

  1610. 				{

    1611. 

  1611. 					$return_array['constraint'] = "CHECK ({$column_name} >= 0)";

    1612. 

  1612. 					$sql .= " CHECK ({$column_name} >= 0)";

    1613. 

  1613. 				}

    1614. 

  1614. 

    1615. 

  1615. 			break;

    1616. 

  1616. 

    1617. 

  1617. 			case 'sqlite':

    1618. 

  1618. 				$return_array['primary_key_set'] = false;

    1619. 

  1619. 				if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

    1620. 

  1620. 				{

    1621. 

  1621. 					$sql .= ' INTEGER PRIMARY KEY';

    1622. 

  1622. 					$return_array['primary_key_set'] = true;

    1623. 

  1623. 				}

    1624. 

  1624. 				else

    1625. 

  1625. 				{

    1626. 

  1626. 					$sql .= ' ' . $column_type;

    1627. 

  1627. 				}

    1628. 

  1628. 

    1629. 

  1629. 				$sql .= ' NOT NULL ';

    1630. 

  1630. 				$sql .= (!is_null($column_data[1])) ? "DEFAULT '{$column_data[1]}'" : '';

    1631. 

  1631. 

    1632. 

  1632. 			break;

    1633. 

  1633. 		}

    1634. 

  1634. 

    1635. 

  1635. 		$return_array['column_type_sql'] = $sql;

    1636. 

  1636. 

    1637. 

  1637. 		return $return_array;

    1638. 

  1638. 	}

    1639. 

  1639. 

    1640. 

  1640. 	/**

    1641. 

  1641. 	* Add new column

    1642. 

  1642. 	*/

    1643. 

  1643. 	function sql_column_add($table_name, $column_name, $column_data, $inline = false)

    1644. 

  1644. 	{

    1645. 

  1645. 		$column_data = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

    1646. 

  1646. 		$statements = array();

    1647. 

  1647. 

    1648. 

  1648. 		switch ($this->sql_layer)

    1649. 

  1649. 		{

    1650. 

  1650. 			case 'firebird':

    1651. 

  1651. 				// Does not support AFTER statement, only POSITION (and there you need the column position)

    1652. 

  1652. 				$statements[] = 'ALTER TABLE ' . $table_name . ' ADD "' . strtoupper($column_name) . '" ' . $column_data['column_type_sql'];

    1653. 

  1653. 			break;

    1654. 

  1654. 

    1655. 

  1655. 			case 'mssql':

    1656. 

  1656. 			case 'mssqlnative':

    1657. 

  1657. 				// Does not support AFTER, only through temporary table

    1658. 

  1658. 				$statements[] = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

    1659. 

  1659. 			break;

    1660. 

  1660. 

    1661. 

  1661. 			case 'mysql_40':

    1662. 

  1662. 			case 'mysql_41':

    1663. 

  1663. 				$after = (!empty($column_data['after'])) ? ' AFTER ' . $column_data['after'] : '';

    1664. 

  1664. 				$statements[] = 'ALTER TABLE `' . $table_name . '` ADD COLUMN `' . $column_name . '` ' . $column_data['column_type_sql'] . $after;

    1665. 

  1665. 			break;

    1666. 

  1666. 

    1667. 

  1667. 			case 'oracle':

    1668. 

  1668. 				// Does not support AFTER, only through temporary table

    1669. 

  1669. 				$statements[] = 'ALTER TABLE ' . $table_name . ' ADD ' . $column_name . ' ' . $column_data['column_type_sql'];

    1670. 

  1670. 			break;

    1671. 

  1671. 

    1672. 

  1672. 			case 'postgres':

    1673. 

  1673. 				// Does not support AFTER, only through temporary table

    1674. 

  1674. 				if (version_compare($this->db->sql_server_info(true), '8.0', '>='))

    1675. 

  1675. 				{

    1676. 

  1676. 					$statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type_sql'];

    1677. 

  1677. 				}

    1678. 

  1678. 				else

    1679. 

  1679. 				{

    1680. 

  1680. 					// old versions cannot add columns with default and null information

    1681. 

  1681. 					$statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type'] . ' ' . $column_data['constraint'];

    1682. 

  1682. 

    1683. 

  1683. 					if (isset($column_data['null']))

    1684. 

  1684. 					{

    1685. 

  1685. 						if ($column_data['null'] == 'NOT NULL')

    1686. 

  1686. 						{

    1687. 

  1687. 							$statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' SET NOT NULL';

    1688. 

  1688. 						}

    1689. 

  1689. 					}

    1690. 

  1690. 

    1691. 

  1691. 					if (isset($column_data['default']))

    1692. 

  1692. 					{

    1693. 

  1693. 						$statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' SET DEFAULT ' . $column_data['default'];

    1694. 

  1694. 					}

    1695. 

  1695. 				}

    1696. 

  1696. 

    1697. 

  1697. 			break;

    1698. 

  1698. 

    1699. 

  1699. 			case 'sqlite':

    1700. 

  1700. 

    1701. 

  1701. 				if ($inline && $this->return_statements)

    1702. 

  1702. 				{

    1703. 

  1703. 					return $column_name . ' ' . $column_data['column_type_sql'];

    1704. 

  1704. 				}

    1705. 

  1705. 

    1706. 

  1706. 				if (version_compare(sqlite_libversion(), '3.0') == -1)

    1707. 

  1707. 				{

    1708. 

  1708. 					$sql = "SELECT sql

    1709. 

  1709. 						FROM sqlite_master

    1710. 

  1710. 						WHERE type = 'table'

    1711. 

  1711. 							AND name = '{$table_name}'

    1712. 

  1712. 						ORDER BY type DESC, name;";

    1713. 

  1713. 					$result = $this->db->sql_query($sql);

    1714. 

  1714. 

    1715. 

  1715. 					if (!$result)

    1716. 

  1716. 					{

    1717. 

  1717. 						break;

    1718. 

  1718. 					}

    1719. 

  1719. 

    1720. 

  1720. 					$row = $this->db->sql_fetchrow($result);

    1721. 

  1721. 					$this->db->sql_freeresult($result);

    1722. 

  1722. 

    1723. 

  1723. 					$statements[] = 'begin';

    1724. 

  1724. 

    1725. 

  1725. 					// Create a backup table and populate it, destroy the existing one

    1726. 

  1726. 					$statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $row['sql']);

    1727. 

  1727. 					$statements[] = 'INSERT INTO ' . $table_name . '_temp SELECT * FROM ' . $table_name;

    1728. 

  1728. 					$statements[] = 'DROP TABLE ' . $table_name;

    1729. 

  1729. 

    1730. 

  1730. 					preg_match('#\((.*)\)#s', $row['sql'], $matches);

    1731. 

  1731. 

    1732. 

  1732. 					$new_table_cols = trim($matches[1]);

    1733. 

  1733. 					$old_table_cols = preg_split('/,(?![\s\w]+\))/m', $new_table_cols);

    1734. 

  1734. 					$column_list = array();

    1735. 

  1735. 

    1736. 

  1736. 					foreach ($old_table_cols as $declaration)

    1737. 

  1737. 					{

    1738. 

  1738. 						$entities = preg_split('#\s+#', trim($declaration));

    1739. 

  1739. 						if ($entities[0] == 'PRIMARY')

    1740. 

  1740. 						{

    1741. 

  1741. 							continue;

    1742. 

  1742. 						}

    1743. 

  1743. 						$column_list[] = $entities[0];

    1744. 

  1744. 					}

    1745. 

  1745. 

    1746. 

  1746. 					$columns = implode(',', $column_list);

    1747. 

  1747. 

    1748. 

  1748. 					$new_table_cols = $column_name . ' ' . $column_data['column_type_sql'] . ',' . $new_table_cols;

    1749. 

  1749. 

    1750. 

  1750. 					// create a new table and fill it up. destroy the temp one

    1751. 

  1751. 					$statements[] = 'CREATE TABLE ' . $table_name . ' (' . $new_table_cols . ');';

    1752. 

  1752. 					$statements[] = 'INSERT INTO ' . $table_name . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . $table_name . '_temp;';

    1753. 

  1753. 					$statements[] = 'DROP TABLE ' . $table_name . '_temp';

    1754. 

  1754. 

    1755. 

  1755. 					$statements[] = 'commit';

    1756. 

  1756. 				}

    1757. 

  1757. 				else

    1758. 

  1758. 				{

    1759. 

  1759. 					$statements[] = 'ALTER TABLE ' . $table_name . ' ADD ' . $column_name . ' [' . $column_data['column_type_sql'] . ']';

    1760. 

  1760. 				}

    1761. 

  1761. 			break;

    1762. 

  1762. 		}

    1763. 

  1763. 

    1764. 

  1764. 		return $this->_sql_run_sql($statements);

    1765. 

  1765. 	}

    1766. 

  1766. 

    1767. 

  1767. 	/**

    1768. 

  1768. 	* Drop column

    1769. 

  1769. 	*/

    1770. 

  1770. 	function sql_column_remove($table_name, $column_name, $inline = false)

    1771. 

  1771. 	{

    1772. 

  1772. 		$statements = array();

    1773. 

  1773. 

    1774. 

  1774. 		switch ($this->sql_layer)

    1775. 

  1775. 		{

    1776. 

  1776. 			case 'firebird':

    1777. 

  1777. 				$statements[] = 'ALTER TABLE ' . $t…
    1778.

Large files files are truncated, but you can click here to view the full file