aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/phpbb/db/tools.php
Commit message (Collapse)AuthorAgeFilesLines
* [ticket/13282] Use strpos() instead of preg_match()Marc Alexander2015-01-221-1/+1
| | | | PHPBB3-13282
* [ticket/13282] Use 0 as default for integer type columns in postgresqlMarc Alexander2015-01-221-1/+9
| | | | PHPBB3-13282
* [ticket/13406] Add a space between the index name and columns listrxu2014-11-301-1/+1
| | | | | | | | Currently there's no space between the index name and columns list when generating ADD INDEX sql query for MySQL DBMSes. This may cause errors on earlier MySQL versions like 3.23. PHPBB3-13406
* [ticket/13268] Properly append ternary result in get_existing_indexes()Patrick Webster2014-11-011-2/+2
| | | | PHPBB3-13268
* [ticket/13117] Correctly define auto increment columns as "NOT NULL" on mysqlJoas Schilling2014-09-291-1/+1
| | | | | | Unintended change from 95ab4b3e931521ce3c56068478311f0c04f713cc PHPBB3-13117
* [ticket/12710] Fix missing closing bracketJoas Schilling2014-08-091-1/+1
| | | | PHPBB3-12710
* [ticket/12710] Prefix column so it does not start with a numberJoas Schilling2014-08-091-1/+1
| | | | PHPBB3-12710
* [ticket/12710] Pass the original column data to the create functionJoas Schilling2014-08-091-2/+3
| | | | PHPBB3-12710
* [ticket/12710] Fix foreach generationJoas Schilling2014-08-091-1/+1
| | | | PHPBB3-12710
* [ticket/12710] Compare to uppercase versionJoas Schilling2014-08-091-1/+1
| | | | PHPBB3-12710
* [ticket/12710] Do not try to match the uniqueness in the queryJoas Schilling2014-08-091-4/+6
| | | | PHPBB3-12710
* [ticket/12710] Remove table_name from index_name before deleting and ↵Joas Schilling2014-08-091-3/+15
| | | | | | recreating them PHPBB3-12710
* [ticket/12710] Can not use upper in oracles where clausJoas Schilling2014-08-091-3/+3
| | | | PHPBB3-12710
* [ticket/12710] Correctly select index name and compare to column nameJoas Schilling2014-08-091-2/+2
| | | | PHPBB3-12710
* [ticket/12710] Fix problems with creating unique indexes on oracleJoas Schilling2014-08-091-1/+1
| | | | PHPBB3-12710
* [ticket/12710] Correctly fetch unique and normal indexes only in MSSQLJoas Schilling2014-08-091-9/+6
| | | | PHPBB3-12710
* [ticket/12710] Fix changing the column type on oracleJoas Schilling2014-08-071-47/+129
| | | | PHPBB3-12710
* [ticket/12710] Prepare get_existing_indexes() for other DBMSJoas Schilling2014-08-071-73/+112
| | | | PHPBB3-12710
* Merge pull request #2761 from Nicofuma/ticket/12873Joas Schilling2014-08-071-1/+1
|\ | | | | | | | | | | | | | | | | [ticket/12873] Test the correct identifier in \phpbb\db\tools * Nicofuma/ticket/12873: [ticket/12873] Add migration to rename the index [ticket/12873] Don not touch the existing migrations [ticket/12873] Test the good identifier in \phpbb\db\tools
| * [ticket/12873] Test the good identifier in \phpbb\db\toolsTristan Darricau2014-07-201-1/+1
| | | | | | | | | | | | | | | | | | We need to rename the index key because with the default prefix (phpbb_) this key has a length of 31. And because we don't accept the keys longer than 30 characters we should ensure that by default no key is longer than 30 characters. PHPBB3-12873
* | Merge pull request #2651 from nickvergessen/ticket/12448Dhruv Goel2014-07-221-6/+31
|\ \ | |/ |/| [ticket/12448] Allow null as default value for columns
| * [ticket/12448] Fix null columns for MS SQLJoas Schilling2014-06-251-1/+1
| | | | | | | | PHPBB3-12448
| * [ticket/12448] Fix null columns for postgresJoas Schilling2014-06-251-0/+6
| | | | | | | | PHPBB3-12448
| * [ticket/12448] Allow null as default value for columnsJoas Schilling2014-06-251-6/+25
| | | | | | | | PHPBB3-12448
* | [ticket/12446] Unnecessary db connect inphpbb_bootstrap_enabled_extsTristan Darricau2014-06-261-4/+4
|/ | | | PHPBB3-12446
* [ticket/12747] Drop support for FirebirdJoas Schilling2014-06-201-157/+1
| | | | PHPBB3-12747
* [ticket/12643] Properly handle changing columns on tables with constraintsPatrick Webster2014-06-151-1/+12
| | | | PHPBB3-12643
* [ticket/12643] Ensure that similarly named columns are not removedBorisBerdichevski2014-06-151-1/+1
| | | | PHPBB3-12643
* [ticket/12594] Remove @package tags and update file headersYuriy Rusko2014-05-271-5/+7
| | | | PHPBB3-12594
* [feature/sqlite3] Remove unneeded ORDER BY type from sqlite_master queriesJoas Schilling2014-05-021-4/+2
| | | | PHPBB3-9728
* [feature/sqlite3] Correctly recreate indexes when recreating a tableJoas Schilling2014-05-021-82/+135
| | | | PHPBB3-9728
* [feature/sqlite3] Fix sql_index_drop() for sqlite3Joas Schilling2014-05-021-1/+1
| | | | PHPBB3-9728
* [feature/sqlite3] Remove trailing comma from column listJoas Schilling2014-05-021-1/+6
| | | | PHPBB3-9728
* [feature/sqlite3] Add support for SQLite 3Patrick Webster2014-05-021-47/+99
| | | | | | | Minimum version requirement is 3.6.15 as that's what ships with PHP 5.3.0 when support for SQLite 3 was added. PHPBB3-9728
* [ticket/12012] Move property to the topJoas Schilling2014-04-241-2/+6
| | | | PHPBB3-12012
* [ticket/12012] Move MS SQL server comparison into a methodJoas Schilling2014-04-241-18/+28
| | | | PHPBB3-12012
* [ticket/12012] Remove duplicated code (only the $sql are different)Joas Schilling2014-04-201-59/+42
| | | | PHPBB3-12012
* [ticket/12012] Drop and recreate indexes when removing columnsJoas Schilling2014-04-171-2/+33
| | | | PHPBB3-12012
* [ticket/12012] Return SQL statements for index drop/createJoas Schilling2014-04-171-3/+17
| | | | | | Otherwise we recreate the index before changing the column PHPBB3-12012
* [ticket/12012] Fix tools::mssql_get_existing_indexes() for SQL Server 2000Joas Schilling2014-04-171-14/+36
| | | | PHPBB3-12012
* [ticket/12012] Drop and recreate indexes when changing a column on MSSQLJoas Schilling2014-04-171-0/+111
| | | | PHPBB3-12012
* [ticket/12012] Fix query layoutJoas Schilling2014-04-171-1/+2
| | | | PHPBB3-12012
* [ticket/12012] Correctly drop default value constraints on MSSQLJoas Schilling2014-04-171-85/+59
| | | | | | | We need to drop the default constraints of a column, before being able to change their type or deleting them. PHPBB3-12012
* Merge branch 'develop-olympus' into develop-ascraeusAndreas Fischer2014-04-151-2/+2
| | | | | * develop-olympus: [ticket/12397] Fix sql_unique_index_exists doc block
* [ticket/12282] Use interface for type hintingJoas Schilling2014-04-011-2/+2
| | | | PHPBB3-12282
* [ticket/12330] Fix create index in db tools on mssqlOliver Schramm2014-03-301-2/+2
| | | | PHPBB3-12330
* Merge branch 'develop-olympus' into develop-ascraeusJoas Schilling2014-03-291-49/+97
| | | | | | | | | | | | | | | | * develop-olympus: [ticket/9725] Code sniffer fixes [ticket/9725] Do not use deprecated views to remove default constraints [ticket/9725] Move primary key creation to the correct location [ticket/9725] Remove trailing spaces from MSSQL schema [ticket/9725] Create MSSQL primary keys if none exist [ticket/9725] Remove explicit filegroup designations [ticket/9725] Fetch Azure db stats from proper table [ticket/9725] Add dummy indexes for Azure [ticket/9725] Create an Azure SQL compatible Schema Conflicts: phpBB/install/schemas/mssql_schema.sql
* Merge branch 'develop-olympus' into developNils Adermann2014-02-181-1/+1
| | | | | * develop-olympus: [ticket/12210] dbtools::sql_create_table incorrectly throws error related to auto-increment length on non auto-increment fields
* [ticket/11201] Move "get type" code into a new functionJoas Schilling2014-01-151-46/+60
| | | | PHPBB3-11201
* [task/code-sniffer] Remove the IN_PHPBB check side-effect from class files.Andreas Fischer2013-10-301-8/+0
| | | | PHPBB3-11980
generated by cgit v1.2.1 (git 2.21.0) at 2025-12-27 23:08:30 +0000