Merge pull request #2326 from eileenmcnaughton/CRM-14069

[civicrm-core.git] / CRM / Core / BAO / SchemaHandler.php

diff --git a/CRM/Core/BAO/SchemaHandler.php b/CRM/Core/BAO/SchemaHandler.php
index f79f9b7dd6fa3eab6cfa09200c69195c9af9a3fe..1853aa61d1fd42e751b9223c51e47ba5537ab4bc 100644 (file)
--- a/CRM/Core/BAO/SchemaHandler.php
+++ b/CRM/Core/BAO/SchemaHandler.php
@@ -93,6 +93,11 @@ class CRM_Core_BAO_SchemaHandler {
     return TRUE;
   }
 
+  /**
+   * @param $params
+   *
+   * @return string
+   */
   static function buildTableSQL(&$params) {
     $sql = "CREATE TABLE {$params['name']} (";
     if (isset($params['fields']) &&
@@ -123,6 +128,13 @@ class CRM_Core_BAO_SchemaHandler {
     return $sql;
   }
 
+  /**
+   * @param $params
+   * @param $separator
+   * @param $prefix
+   *
+   * @return string
+   */
   static function buildFieldSQL(&$params, $separator, $prefix) {
     $sql = '';
     $sql .= $separator;
@@ -151,6 +163,13 @@ class CRM_Core_BAO_SchemaHandler {
     return $sql;
   }
 
+  /**
+   * @param $params
+   * @param $separator
+   * @param $prefix
+   *
+   * @return null|string
+   */
   static function buildPrimaryKeySQL(&$params, $separator, $prefix) {
     $sql = NULL;
     if (!empty($params['primary'])) {
@@ -162,6 +181,14 @@ class CRM_Core_BAO_SchemaHandler {
     return $sql;
   }
 
+  /**
+   * @param $params
+   * @param $separator
+   * @param $prefix
+   * @param bool $indexExist
+   *
+   * @return null|string
+   */
   static function buildSearchIndexSQL(&$params, $separator, $prefix, $indexExist = FALSE) {
     $sql = NULL;
 
@@ -187,6 +214,13 @@ class CRM_Core_BAO_SchemaHandler {
     return $sql;
   }
 
+  /**
+   * @param $params
+   * @param $separator
+   * @param $prefix
+   *
+   * @return string
+   */
   static function buildIndexSQL(&$params, $separator, $prefix) {
     $sql = '';
     $sql .= $separator;
@@ -213,6 +247,12 @@ class CRM_Core_BAO_SchemaHandler {
     return $sql;
   }
 
+  /**
+   * @param $tableName
+   * @param $fkTableName
+   *
+   * @return bool
+   */
   static function changeFKConstraint($tableName, $fkTableName) {
     $fkName = "{$tableName}_entity_id";
     if (strlen($fkName) >= 48) {
@@ -235,6 +275,14 @@ ALTER TABLE {$tableName}
     return TRUE;
   }
 
+  /**
+   * @param $params
+   * @param $separator
+   * @param $prefix
+   * @param $tableName
+   *
+   * @return null|string
+   */
   static function buildForeignKeySQL(&$params, $separator, $prefix, $tableName) {
     $sql = NULL;
     if (!empty($params['fk_table_name']) && !empty($params['fk_field_name'])) {
@@ -252,6 +300,13 @@ ALTER TABLE {$tableName}
     return $sql;
   }
 
+  /**
+   * @param $params
+   * @param bool $indexExist
+   * @param bool $triggerRebuild
+   *
+   * @return bool
+   */
   static function alterFieldSQL(&$params, $indexExist = FALSE, $triggerRebuild = TRUE) {
     $sql = str_repeat(' ', 8);
     $sql .= "ALTER TABLE {$params['table_name']}";
@@ -324,11 +379,19 @@ ALTER TABLE {$tableName}
     $dao = CRM_Core_DAO::executeQuery($sql);
   }
 
+  /**
+   * @param $tableName
+   * @param $columnName
+   */
   static function dropColumn($tableName, $columnName) {
     $sql = "ALTER TABLE $tableName DROP COLUMN $columnName";
     $dao = CRM_Core_DAO::executeQuery($sql);
   }
 
+  /**
+   * @param $tableName
+   * @param bool $dropUnique
+   */
   static function changeUniqueToIndex($tableName, $dropUnique = TRUE) {
     if ($dropUnique) {
       $sql = "ALTER TABLE $tableName
@@ -343,6 +406,11 @@ ADD UNIQUE INDEX `unique_entity_id` ( `entity_id` )";
     $dao = CRM_Core_DAO::executeQuery($sql);
   }
 
+  /**
+   * @param $tables
+   * @param string $createIndexPrefix
+   * @param array $substrLenghts
+   */
   static function createIndexes(&$tables, $createIndexPrefix = 'index', $substrLenghts = array(
     )) {
     $queries = array();
@@ -404,6 +472,14 @@ ADD UNIQUE INDEX `unique_entity_id` ( `entity_id` )";
     }
   }
 
+  /**
+   * @param $customFieldID
+   * @param $tableName
+   * @param $columnName
+   * @param $length
+   *
+   * @throws Exception
+   */
   static function alterFieldLength($customFieldID, $tableName, $columnName, $length) {
     // first update the custom field tables
     $sql = "