aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/firebird_schema.sql
Commit message (Collapse)AuthorAgeFilesLines
* [ticket/10650] Revert merge of 'rahulr92/ticket/10650' into developOleg Pudeyev2012-04-041-1/+0
| | | | | | | | | | | The pull request (#654) was merged a little too quickly. In particular, display_last_subject per-forum option needs consensus. This reverts commit b1fb34a4d7e446768b9f66ba6dd359173cd2a5fb, reversing changes made to 7d6b289671c51694f17dd5f9849abf2534b55e59. PHPBB3-10650
* [ticket/10650] Added static sql filesRahul2012-04-051-0/+1
| | | | | | | Ran create_schema_files.php and added the generated static sql files to the commit. PHPBB3-10650
* Merge remote-tracking branch 'upstream/develop' into ↵Vjacheslav Trushkin2012-03-291-1/+2
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | feature/merging-style-components * upstream/develop: (65 commits) [ticket/10730] Added label tag around "select" text in post splitting UI [ticket/10732] Add config_dev.php and config_test.php to .gitignore [ticket/10586] Added space in if statement [ticket/10586] Tidy up comments [task/php5.3] Updated range of tested PHP versions [task/php5.3] Looks like I missed a few places that needed PHP 5.2 changed to PHP 5.3.2 [task/php5.3] Changed minimum PHP requirement for Ascraeus to 5.3.2 [ticket/10723] Stop Travis running all tests on sqlite [ticket/10703] Added a condition to check if ext directory exists [task/travis] Refactor php version check for dbunit install [task/travis] Exclude functional and slow tests [ticket/10719] Revert "Skip functional tests on PHP 5.2" [task/travis-develop2] Update version from 5.3 to 5.3.2 [task/travis] Dropping support for 5.2 in develop branch [task/travis] Some more small travis fixes [task/travis] Rename travis phpunit config files [task/travis] Fixing some travis issues [ticket/10684] Adjust function and parameter name, minor changes. [task/travis] Add automated testing to readme [task/travis] Removing development information ... Conflicts: phpBB/install/database_update.php
| * [feature/save-post-on-report] Changed the name of the columnBruno Ais2012-03-191-1/+1
| | | | | | | | | | | | | | | | The name of the column was changed from reported_post AND reported_text to reported_post_text. This change was made by request PHPBB3-10600
| * [feature/save-post-on-report] Saves the post reported when a report is creatBruno Ais2012-03-191-1/+2
| | | | | | | | | | | | | | | | | | | | A problem when creating a report is that the report may be made and then the post changed. After the changes, if the report is seen the message it shows may not be correct to be reported. With these changes, when a report is created the system copies the post that was reported and shows it in the report details in the MCP PHPBB3-10600
* | [feature/merging-style-components] Updating database and acp modulesVjacheslav Trushkin2012-03-141-53/+4
|/ | | | | | Removing theme and template tables, adding new columns to styles table, deleting acp modules, deleting code that updates theme in updater PHPBB3-10632
* Merge branch 'develop' into feature/extension-managerNils Adermann2011-11-181-3/+4
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * develop: (93 commits) [ticket/10157] Add notification to update cpfs when installing a language. [ticket/10185] Always set board startdate on conversion [ticket/10419] Reword the language strings [ticket/9361] View correct error messages when editing account information [ticket/10457] Undefined variable $request, when print-viewing PMs [ticket/10452] Fix xHTML errors when print-viewing PMs [ticket/9066] Move regex into get_preg_expression function and add tests [ticket/10254] Add "phpBB Group" to "Modified by" in prosilver stylesheet.css [ticket/10254] Removing the subsilver2 NOTE, incompatible with phpBB.com. [ticket/10254] Removing the NOTE as it is incompatible with phpBB.com. [ticket/10254] Remove subsilver2 as default style on theme. [ticket/10254] Remove style names from themes and fix some informations on it. [ticket/7138] Allow simple header and footer for trigger_error() messages [ticket/9066] Disallow some database prefix to prevent same errors and problems [ticket/10365] Fix up S_POST_UNAPPROVED check, make it easier to read [ticket/10437] Do not display announcements that are waiting for approval [ticket/10087] Organize bans in acp_baninto optgroups [ticket/8616] Include old U_INBOX var for BC [ticket/10435] Remove global announcement from forums total topic count [ticket/10435] Readd local announcements to total topic count in viewforum ... Conflicts: phpBB/install/database_update.php
| * Merge branch 'develop-olympus' into developJoas Schilling2011-10-141-3/+4
| |\
| | * [ticket/10189] Get rid of $id$ from schema filesIgor Wiedler2011-10-141-4/+0
| | | | | | | | | | | | PHPBB3-10189
| | * [ticket/10189] Add "automatically generated" comment into schema-filesIgor Wiedler2011-10-141-0/+5
| | | | | | | | | | | | PHPBB3-10189
* | | [feature/extension-manager] Use an incremental process for enable and purgeNils Adermann2011-09-291-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The enable or purge operation of an extension could take a long time if an expensive operation needs to be executed on a large set of data. To allow this to succeed from a web interface with max_execution_time set in the webserver's php configuration, subsequent requests must continue the operation started earlier. So individual enable and purge implementations must be able to spread their work across multiple steps. PHPBB3-10323
* | | [feature/extension-manager] Remove the ext_active index for lack of specificityNils Adermann2011-09-291-1/+0
| | | | | | | | | | | | PHPBB3-10323
* | | [feature/extension-manager] Extension Manager & FinderNils Adermann2011-09-291-0/+9
|/ / | | | | | | | | | | | | Extensions RFC: http://area51.phpbb.com/phpBB/viewtopic.php?f=84&t=41499 Ticket: http://tracker.phpbb.com/browse/PHPBB3-10323 PHPBB3-10323
* | [feature/remove-db-styles] Update database schemas.Chris Smith2011-09-201-17/+1
| | | | | | | | | | | | | | | | | | | | | | | | Removes: * styles_template_data table * template_storedb on styles_template table * On styles_theme table: - theme_storedb - theme_mtime - theme_data PHPBB3-9741
* | [feature/remove-imagesets] Changing database structureVjacheslav Trushkin2011-09-031-52/+1
| | | | | | | | | | | | Removing imagesets. Changing database structure PHPBB3-10336
* | Merge branch 'develop-olympus' into developAndreas Fischer2011-07-051-14/+0
|\ \ | |/ | | | | | | | | | | | | | | | | | | | | | | * 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
| * [ticket/10247] Remove unecessary attempt_id primary key columnNils Adermann2011-07-031-14/+0
| | | | | | | | | | | | | | | | 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
* | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-131-3/+3
|\ \ | |/ | | | | | | * develop-olympus: [ticket/10213] Update install schema with shorter index names.
| * [ticket/10213] Update install schema with shorter index names.Nils Adermann2011-06-131-3/+3
| | | | | | | | PHPBB3-10213
* | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-111-1/+31
|\ \ | |/ | | | | | | | | | | | | | | * 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/+31
| | | | | | | | | | | | | | | | | | | | | | | | | | 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/8542] Display custom profile fields in private messagesJoas Schilling2011-05-201-0/+1
| | | | | | | | | | | | Introduce an option to display the cpf in the PM view. PHPBB3-8542
* | [ticket/9549] Update database with the new config values and columnsJoas Schilling2011-02-161-1/+2
| | | | | | | | PHPBB3-9549
* | Merge branch 'develop-olympus' into developNils Adermann2010-03-031-0/+1
|\ \ | |/ | | | | | | I simply used the develop-olympus version of all files that conflicted. Afterall there should not have been anything new in develop yet.
| * Bug #56545 - Speed up topic move operation by adding an index for topic_id ↵Andreas Fischer2010-01-281-0/+1
| | | | | | | | | | | | on the topics track table. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10462 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Revert r9564, Fix #54445, Related to #44665.Andreas Fischer2010-01-251-1/+0
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10445 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Revert r10106 - Index usage is very unlikely because of WHERE IN (). :-|Andreas Fischer2009-09-041-1/+0
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10107 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Add INDEX on user_regdate because this is the default ORDER BY in ↵Andreas Fischer2009-09-041-0/+1
| | | | | | | | | | | | memberlist.php - thanks nickvergessen. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10106 89ea8834-ac86-4346-8a33-228a782c2dd0
| * ok, i am very sorry, but this needs to be fixed.Meik Sievertsen2009-08-121-0/+1
| | | | | | | | | | | | | | | | | | Generally, our config table is not really suited for holding large datasets. Because feed settings for the forums to enable news feeds and excluded forums rely on the forums itself we have decided to introduce a forum_options table where custom options can be stored. Additionally, for this to work across all DBMS we support, we added a new method to the DBAL for the bitwise AND operator. Also moved the forum/topic feed template variable to the location where they belong to (forum and topic view) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9965 89ea8834-ac86-4346-8a33-228a782c2dd0
| * fix r9713 for #36565Joas Schilling2009-08-051-0/+1
| | | | | | | | | | | | Authorised by: AcydBurn git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9931 89ea8834-ac86-4346-8a33-228a782c2dd0
| * #48985Henry Sudhof2009-08-031-1/+4
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9916 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Users can report PMs to moderators which are then visible in a new MCP moduleNils Adermann2009-07-211-1/+5
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9814 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Fixed Bug #45115 - Signature parsing flags are not stored in DBRuslan Uzdenov2009-06-271-1/+1
| | | | | | | | | | | | Authorised by: AcydBurn git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9696 89ea8834-ac86-4346-8a33-228a782c2dd0
| * add missing user_new field to schema (just forgot to create it)Meik Sievertsen2009-06-231-2/+4
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9655 89ea8834-ac86-4346-8a33-228a782c2dd0
| * - Display coloured usernames in ACP groups management screensMeik Sievertsen2009-06-191-0/+1
| | | | | | | | | | | | | | | | - Changed behaviour of group_create() function to support specifying additional group columns - New groups option to excempt group leaders from group permissions git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9625 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Fix bug #44665 - Add index on log_time to the log table to prevent slowdown ↵Andreas Fischer2009-06-081-0/+1
| | | | | | | | | | | | | | | | on boards with many log entries. Authorised by: acydburn git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9564 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Fix duplicate creation of acl options in acl_add_options() under certain ↵Meik Sievertsen2009-03-201-1/+1
| | | | | | | | | | | | | | | | | | conditions. (Bug #38385, #40225) Add unique key to ACL options table to prevent duplicate permission options. (Bug #41835) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9400 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Better handling and finer control for custom profile fields visibility ↵Meik Sievertsen2008-11-261-0/+1
| | | | | | | | | | | | options. (Patch by Highway of Life) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9127 89ea8834-ac86-4346-8a33-228a782c2dd0
| * - Added 'max_recipients' setting for private messages. This setting allows ↵Meik Sievertsen2008-09-231-0/+1
| | | | | | | | | | | | | | | | | | admins to define the maximum number of recipients per private message with a board-wide setting and a group-specific setting. - Added new permission setting for sending private messages to groups. Now there are two permissions to define sending private messages to multiple recipients and private messages to groups. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8911 89ea8834-ac86-4346-8a33-228a782c2dd0
| * schemasHenry Sudhof2008-07-301-1/+1
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8734 89ea8834-ac86-4346-8a33-228a782c2dd0
| * forgot a few thingsHenry Sudhof2008-07-291-1/+3
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8708 89ea8834-ac86-4346-8a33-228a782c2dd0
| * change subject/title column lengthMeik Sievertsen2008-06-211-7/+7
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8666 89ea8834-ac86-4346-8a33-228a782c2dd0
| * people are so imaptientHenry Sudhof2008-03-221-1/+3
| | | | | | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8456 89ea8834-ac86-4346-8a33-228a782c2dd0
| * merging r8373 into 3.0 branch: adding a new option to hide the entire list ↵Nils Adermann2008-02-031-0/+1
| | | | | | | | | | | | of subforums on listforums git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8374 89ea8834-ac86-4346-8a33-228a782c2dd0
* | Copy 3.0.x branch to trunkMeik Sievertsen2009-10-041-0/+1453
| | | | | | | | git-svn-id: file:///svn/phpbb/trunk@10211 89ea8834-ac86-4346-8a33-228a782c2dd0
* | we enter a brave new world...David M2008-01-101-1436/+0
| | | | | | | | | | | | | | | | | | - fix schema data so that it can now be used - replace the current system of packaging schemas with phpBB with a new system that dynamically generates the schemas on the fly - give the db tools package the power to create databases git-svn-id: file:///svn/phpbb/trunk@8318 89ea8834-ac86-4346-8a33-228a782c2dd0
* | - make viewforum work againDavid M2008-01-081-0/+3
|/ | | | | | | | | - remove the lower case functions, they were stupid anyway - added some indexes - added a group_name_clean column git-svn-id: file:///svn/phpbb/trunk@8315 89ea8834-ac86-4346-8a33-228a782c2dd0
* more fixes...Meik Sievertsen2007-10-141-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8183 89ea8834-ac86-4346-8a33-228a782c2dd0
* forum rules, forum descriptions and group description bbcode uid fixesMeik Sievertsen2007-10-141-3/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@8178 89ea8834-ac86-4346-8a33-228a782c2dd0
* i think david just forgot these. ;)Meik Sievertsen2007-10-061-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@8151 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2026-02-06 13:16:42 +0000