Function Database_Static_postgresql->create_index__sql

Definitions

sources/database/postgresql.php

  • Get SQL for creating a table index.
  • Visibility: public
  • Is abstract?: No
  • Is static?: No
  • Is final?: No
  • Return: array

Parameters

Name Type Default Set Range Description
$table_name ID_TEXT required parameter N/A N/A The name of the table to create the index on
$index_name ID_TEXT required parameter N/A N/A The index name (not really important at all)
$_fields string required parameter N/A N/A Part of the SQL query: a comma-separated list of fields to use on the index
$connection_read mixed required parameter N/A N/A The DB connection, may be used for running checks
$raw_table_name ID_TEXT required parameter N/A N/A The table name with no table prefix
$unique_key_fields string required parameter N/A N/A The name of the unique key field for the table
$table_prefix string required parameter N/A N/A The table prefix

Return

  • List of SQL queries to run
  • Type: array
  • Set: N/A
  • Range: N/A