[ Index ]

PHP Cross Reference of phpBB-3.2.11-deutsch

title

Body

[close]

/phpbb/db/tools/ -> mssql.php (summary)

This file is part of the phpBB Forum Software package.

Copyright: (c) phpBB Limited
License: GNU General Public License, version 2 (GPL-2.0)
File Size: 880 lines (24 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

mssql:: (23 methods):
  get_dbms_type_map()
  __construct()
  sql_list_tables()
  sql_create_table()
  sql_list_columns()
  sql_index_exists()
  sql_unique_index_exists()
  sql_prepare_column_data()
  sql_column_add()
  sql_column_remove()
  sql_index_drop()
  sql_table_drop()
  sql_create_primary_key()
  sql_create_unique_index()
  sql_create_index()
  get_max_index_name_length()
  sql_list_index()
  sql_column_change()
  mssql_get_drop_default_constraints_queries()
  mssql_get_drop_default_primary_key_queries()
  mssql_is_column_identity()
  get_existing_indexes()
  mssql_is_sql_server_2000()


Class: mssql  - X-Ref

Database Tools for handling cross-db actions such as altering columns, etc.
Currently not supported is returning SQL for creating tables.

get_dbms_type_map()   X-Ref
Get the column types for mssql based databases

return: array

__construct(\phpbb\db\driver\driver_interface $db, $return_statements = false)   X-Ref
Constructor. Set DB Object and set {@link $return_statements return_statements}.

param: \phpbb\db\driver\driver_interface    $db                    Database connection
param: bool        $return_statements    True if only statements should be returned and no SQL being executed

sql_list_tables()   X-Ref
{@inheritDoc}


sql_create_table($table_name, $table_data)   X-Ref
{@inheritDoc}


sql_list_columns($table_name)   X-Ref
{@inheritDoc}


sql_index_exists($table_name, $index_name)   X-Ref
{@inheritDoc}


sql_unique_index_exists($table_name, $index_name)   X-Ref
{@inheritDoc}


sql_prepare_column_data($table_name, $column_name, $column_data)   X-Ref
{@inheritDoc}


sql_column_add($table_name, $column_name, $column_data, $inline = false)   X-Ref
{@inheritDoc}


sql_column_remove($table_name, $column_name, $inline = false)   X-Ref
{@inheritDoc}


sql_index_drop($table_name, $index_name)   X-Ref
{@inheritDoc}


sql_table_drop($table_name)   X-Ref
{@inheritDoc}


sql_create_primary_key($table_name, $column, $inline = false)   X-Ref
{@inheritDoc}


sql_create_unique_index($table_name, $index_name, $column)   X-Ref
{@inheritDoc}


sql_create_index($table_name, $index_name, $column)   X-Ref
{@inheritDoc}


get_max_index_name_length()   X-Ref
{@inheritdoc}


sql_list_index($table_name)   X-Ref
{@inheritDoc}


sql_column_change($table_name, $column_name, $column_data, $inline = false)   X-Ref
{@inheritDoc}


mssql_get_drop_default_constraints_queries($table_name, $column_name)   X-Ref
Get queries to drop the default constraints of a column

We need to drop the default constraints of a column,
before being able to change their type or deleting them.

param: string $table_name
param: string $column_name
return: array        Array with SQL statements

mssql_get_drop_default_primary_key_queries($table_name, $column_name)   X-Ref
Get queries to drop the primary keys depending on the specified column

We need to drop primary keys depending on this column before being able
to delete them.

param: string $table_name
param: string $column_name
return: array        Array with SQL statements

mssql_is_column_identity($table_name, $column_name)   X-Ref
Checks to see if column is an identity column

Identity columns cannot have defaults set for them.

param: string $table_name
param: string $column_name
return: bool        true if identity, false if not

get_existing_indexes($table_name, $column_name, $unique = false)   X-Ref
Get a list with existing indexes for the column

param: string $table_name
param: string $column_name
param: bool $unique Should we get unique indexes or normal ones
return: array        Array with Index name => columns

mssql_is_sql_server_2000()   X-Ref
Is the used MS SQL Server a SQL Server 2000?

return: bool



Generated: Wed Nov 11 20:33:01 2020 Cross-referenced by PHPXref 0.7.1