aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/database_update.php
Commit message (Collapse)AuthorAgeFilesLines
...
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusAndreas Fischer2011-07-071-2/+2
| |\ \ \ | | |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * prep-release-3.0.9: [prep-release-3.0.9] Update Changelog for 3.0.9-RC4 release. [prep-release-3.0.9] Decreasing version for an RC4 release. Conflicts: phpBB/includes/constants.php phpBB/install/database_update.php phpBB/install/schemas/schema_data.sql
| | * | [prep-release-3.0.9] Decreasing version for an RC4 release.Andreas Fischer2011-07-071-3/+3
| | | |
* | | | Merge branch 'develop-olympus' into developNils Adermann2011-07-061-1/+1
|\ \ \ \ | |/ / / | | | | | | | | | | | | | | | | * develop-olympus: [ticket/9859] Changing all phpBB footers to match the new credit line [ticket/9859] New footer copyright line with registered symbol
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusNils Adermann2011-07-061-1/+1
| |\ \ \ | | |/ / | | | | | | | | | | | | | | | | * prep-release-3.0.9: [ticket/9859] Changing all phpBB footers to match the new credit line [ticket/9859] New footer copyright line with registered symbol
| | * | [ticket/9859] Changing all phpBB footers to match the new credit lineYuriy Rusko2011-07-061-1/+1
| | | | | | | | | | | | | | | | PHPBB3-9859
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-07-061-1/+1
|\ \ \ \ | |/ / / | | | | | | | | | | | | * develop-olympus: [ticket/10247] Remove attempt_id as primary key from database_update.php
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusAndreas Fischer2011-07-061-1/+1
| |\ \ \ | | |/ / | | | | | | | | | | | | * prep-release-3.0.9: [ticket/10247] Remove attempt_id as primary key from database_update.php
| | * | [ticket/10247] Remove attempt_id as primary key from database_update.phpJoas Schilling2011-07-051-1/+1
| | | | | | | | | | | | | | | | PHPBB3-10247
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-07-051-1/+26
|\ \ \ \ | |/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * develop-olympus: [prep-release-3.0.9] Update Changelog for 3.0.9 release. [prep-release-3.0.9] Bumping version number for the final 3.0.9 release. [ticket/10247] Removing attempt_id column from the 3.0.8 to 3.0.9-RC1 updater. [ticket/10247] Add a db_tools test for the removal of a primary key column. [ticket/10247] Add empty data section to database update for RC4 [ticket/10247] Remove unecessary attempt_id primary key column Conflicts: phpBB/install/database_update.php
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusAndreas Fischer2011-07-051-1/+26
| |\ \ \ | | |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * prep-release-3.0.9: [prep-release-3.0.9] Update Changelog for 3.0.9 release. [prep-release-3.0.9] Bumping version number for the final 3.0.9 release. [ticket/10247] Removing attempt_id column from the 3.0.8 to 3.0.9-RC1 updater. [ticket/10247] Add a db_tools test for the removal of a primary key column. [ticket/10247] Add empty data section to database update for RC4 [ticket/10247] Remove unecessary attempt_id primary key column Conflicts: phpBB/includes/constants.php phpBB/install/database_update.php phpBB/install/schemas/schema_data.sql
| | * | [prep-release-3.0.9] Bumping version number for the final 3.0.9 release.Andreas Fischer2011-07-051-3/+3
| | | |
| | * | [ticket/10247] Removing attempt_id column from the 3.0.8 to 3.0.9-RC1 updater.Nils Adermann2011-07-041-10/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | To make sure that this column (which was too small and unecessary) does not remain on 3.0.9-RCX installations and boards that were updated to a 3.0.9 RC, the 3.0.10-RC1 release must correctly drop the column after db_tools has been corrected and fully reviewed. The current version is not capable of dropping primary keys correctly on all supported DBMSs. PHPBB3-10247
| | * | [ticket/10247] Add empty data section to database update for RC4Nils Adermann2011-07-031-0/+4
| | | | | | | | | | | | | | | | PHPBB3-10247
| | * | [ticket/10247] Remove unecessary attempt_id primary key columnNils Adermann2011-07-031-1/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The database update drops any key of the same name (potential primary key) and afterwards the column. This does not work on some of the supported DBMS and needs further changes. PHPBB3-10247
| | * | [prep-release-3.0.9] Bump database version to RC3 too.Andreas Fischer2011-06-261-1/+1
| | | |
| | * | [prep-release-3.0.9] Bumping version number for 3.0.9-RC3.Andreas Fischer2011-06-261-0/+6
| | | |
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-201-11/+14
|\ \ \ \ | |/ / / | | | | | | | | | | | | * develop-olympus: [ticket/10223] Make definition of phpbb_require_updated conditional
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusAndreas Fischer2011-06-201-11/+14
| |\ \ \ | | |/ / | | | | | | | | | | | | * prep-release-3.0.9: [ticket/10223] Make definition of phpbb_require_updated conditional
| | * | [ticket/10223] Make definition of phpbb_require_updated conditionalNils Adermann2011-06-201-11/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | The automatic updater defines it too and includes database_update.php for updating which causes an error otherwise. PHPBB3-10223
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-191-13/+13
|\ \ \ \ | |/ / / | | | | | | | | | | | | * develop-olympus: [ticket/10223] Replace spaces with tabs
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusAndreas Fischer2011-06-191-13/+13
| |\ \ \ | | |/ / | | | | | | | | | | | | * prep-release-3.0.9: [ticket/10223] Replace spaces with tabs
| | * | [ticket/10223] Replace spaces with tabsNils Adermann2011-06-191-13/+13
| | | | | | | | | | | | | | | | PHPBB3-10223
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-191-5/+19
|\ \ \ \ | |/ / / | | | | | | | | | | | | | | | | | | | | * develop-olympus: [ticket/10223] The search fid parameter is an array of forums not just an id [ticket/10223] Check optional before file_exists and correct require path [ticket/10223] requiring the new startup.php file conditionally.
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusAndreas Fischer2011-06-191-5/+19
| |\ \ \ | | |/ / | | | | | | | | | | | | | | | | | | | | * prep-release-3.0.9: [ticket/10223] The search fid parameter is an array of forums not just an id [ticket/10223] Check optional before file_exists and correct require path [ticket/10223] requiring the new startup.php file conditionally.
| | * | [ticket/10223] Check optional before file_exists and correct require pathNils Adermann2011-06-181-2/+2
| | | | | | | | | | | | | | | | PHPBB3-10223
| | * | [ticket/10223] requiring the new startup.php file conditionally.Nils Adermann2011-06-181-5/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Added a function for this which we can potentially apply to more of the files in the installer and database updater. PHPBB3-10223
| | * | [prep-release-3.0.9] Bumping version number for 3.0.9-RC2.Andreas Fischer2011-06-151-1/+7
| | | |
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-151-23/+13
|\ \ \ \ | |/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | * develop-olympus: [ticket/10218] Prevent startime from being overwritten by deregister_globals() [ticket/10218] Moving global deregistration, etc. to startup.php Conflicts: phpBB/install/database_update.php
| * | | Merge branch 'prep-release-3.0.9' into develop-olympusAndreas Fischer2011-06-151-23/+13
| |\ \ \ | | |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | * prep-release-3.0.9: [ticket/10218] Prevent startime from being overwritten by deregister_globals() [ticket/10218] Moving global deregistration, etc. to startup.php Conflicts: phpBB/install/database_update.php
| | * | [ticket/10218] Moving global deregistration, etc. to startup.phpYuriy Rusko2011-06-141-23/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Because startup.php deletes all variables, the constants in database_update are used to preserve settings at the top. PHPBB3-10218
| * | | [develop-olympus] Incrementing the version to 3.0.10-dev in develop-olympus.Andreas Fischer2011-06-131-1/+1
| |/ /
* | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-131-2/+2
|\ \ \ | |/ / | | | | | | | | | * develop-olympus: [ticket/10214] Correct Oracle create table query syntax in db_tools
| * | [ticket/10214] Correct Oracle create table query syntax in db_toolsNils Adermann2011-06-131-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | Removes the semicolon at end of oracle CREATE TABLE queries and adds a semicolon to the end of a SELECT query inside of the trigger for a new table's auto increment column before the end keyword PHPBB3-10214
* | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-131-2/+2
|\ \ \ | |/ / | | | | | | | | | * develop-olympus: [ticket/9892] _sql in the updater needs to return the transaction results
| * | Merge remote-tracking branch 'naderman/ticket/9892' into develop-olympusAndreas Fischer2011-06-131-2/+2
| |\ \ | | | | | | | | | | | | | | | | * naderman/ticket/9892: [ticket/9892] _sql in the updater needs to return the transaction results
| | * | [ticket/9892] _sql in the updater needs to return the transaction resultsNils Adermann2011-06-121-2/+2
| | | | | | | | | | | | | | | | PHPBB3-9892
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-121-0/+7
|\ \ \ \ | |/ / / | | | | | | | | | | | | * develop-olympus: [ticket/9992] The table name constant needs to be defined in the updater
| * | | Merge remote-tracking branch 'naderman/ticket/9992' into develop-olympusAndreas Fischer2011-06-121-0/+7
| |\ \ \ | | | | | | | | | | | | | | | | | | | | * naderman/ticket/9992: [ticket/9992] The table name constant needs to be defined in the updater
| | * | | [ticket/9992] The table name constant needs to be defined in the updaterNils Adermann2011-06-121-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | When the database update is run before updating the files the constant is not yet defined. PHPBB3-9992
| * | | | [develop-olympus] Bumping version number for 3.0.9-RC1.Andreas Fischer2011-06-121-1/+1
| | |/ / | |/| |
* | | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-121-9/+71
|\ \ \ \ | |/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * develop-olympus: [ticket/9892] Correct copyright year [ticket/9892] Remove incorrect use of camel case [ticket/9892] Removing closing php tag from create_schema_files [ticket/9892] Transaction support for database update sql execution function [ticket/9892] count is a keyword in firebird, so renaming this alias [ticket/9892] Q&A CAPTCHA did not work on firebird, so no need to change config [ticket/9892] Shorten login_attempt key names to avoid firebird length problems [ticket/9892] Drop Q&A CAPTCHA tables if left in inconsistent state [ticket/9892] Adding a number of tests for db_tools [ticket/9892] Table prefix lengths influence index lengths in db_tools [ticket/9892] Shorten the index names on the q&a captcha [ticket/9892] column & index name limits, firebird auto increment in db_tools Conflicts: phpBB/develop/create_schema_files.php
| * | | [ticket/9892] Transaction support for database update sql execution functionNils Adermann2011-06-121-5/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Updates would fail before because 'begin' as generated by db_tools::sql_create_table would be executed literally. PHPBB3-9892
| * | | [ticket/9892] Q&A CAPTCHA did not work on firebird, so no need to change configNils Adermann2011-06-121-6/+3
| | | | | | | | | | | | | | | | PHPBB3-9892
| * | | [ticket/9892] Shorten login_attempt key names to avoid firebird length problemsNils Adermann2011-06-121-3/+3
| | | | | | | | | | | | | | | | PHPBB3-9892
| * | | [ticket/9892] Drop Q&A CAPTCHA tables if left in inconsistent stateNils Adermann2011-06-121-0/+24
| | | | | | | | | | | | | | | | PHPBB3-9892
| * | | [ticket/9892] Table prefix lengths influence index lengths in db_toolsNils Adermann2011-06-121-5/+9
| | | | | | | | | | | | | | | | PHPBB3-9892
| * | | [ticket/9892] column & index name limits, firebird auto increment in db_toolsNils Adermann2011-06-121-1/+27
| |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Column names are limited to 30 characters - Index names are limited to 31 characters. On some dbms the index name contains both table name and actual index name so the limit applies to the sum of the lenghts of table name and index name. - Auto incremented column names are limited to 26 characters to provide an additional 4 characters for sequence names The code for firebird auto increment support using generators/sequences with triggers was copied from create_schema_files.php PHPBB3-9892
* | | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-111-1/+292
|\ \ \ | |/ / | | | | | | | | | | | | | | | | | | | | | * develop-olympus: [ticket/9992] Clarify explanations of ip and account limits on login [ticket/9992] Add a comma to language for IP_LOGIN_LIMIT_MAX_EXPLAIN [ticket/9992] Use sql_fetchfield for single row and single column result [ticket/9992] Adding a limit on login attempts per IP. [ticket/9992] Make sql_create_table and sql_table_exists available in updater
| * | [ticket/9992] Adding a limit on login attempts per IP.Nils Adermann2011-06-101-1/+38
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | A new table was created to save all failed login attempts with corresponding information on username, ip and useragent. By default the limit is 50 login attempts within 6 hours per IP. The limit is relatively high to avoid big problems on sites behind a reverse proxy that don't receive the forwarded-for value as REMOTE_ADDR but see all users as coming from the same IP address. But if these users run into problems a special forwarded-for option is available to limit logins by forwarded-for value instead of ip. PHPBB3-9992
| * | [ticket/9992] Make sql_create_table and sql_table_exists available in updaterNils Adermann2011-06-101-0/+254
| | | | | | | | | | | | | | | | | | | | | These are defined the same way in db_tools. This duplicated code should be removed together with the rest of the db_tools duplication at some point. PHPBB3-9992