aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/postgres_schema.sql
Commit message (Collapse)AuthorAgeFilesLines
...
* | 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/+23
|\ \ | |/ | | | | | | | | | | | | | | * 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/+23
| | | | | | | | | | | | | | | | | | | | | | | | | | 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
* | Merge branch 'ticket/9549' into developOleg Pudeyev2011-03-011-1/+2
|\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * ticket/9549: [ticket/9549] Display users in their primary group instead of their first group [ticket/9549] Change default value of "sort legend by group name" to false. [ticket/9549] Fix displaying empty groups [ticket/9549] Fix language strings. [ticket/9549] Only add group to legend/teampage when the checkbox is checked. [ticket/9549] New method move() to move a group more than 1 up/down. [ticket/9549] Fix some minor issues with descriptions and coding-guidelines. [ticket/9549] Throw an error when the given field-name is invalid. [ticket/9549] Make the class non static and extend delete_group function. [ticket/9549] Add template changes for subsilver2. [ticket/9549] Enhance teampage and legend functionality [ticket/9549] Add the module and files for the ACP. [ticket/9549] Update database with the new config values and columns [ticket/9549] Enhance teampage functionality with a new class, group_positions. Conflicts: phpBB/install/database_update.php
| * | [ticket/9549] Update database with the new config values and columnsJoas Schilling2011-02-161-1/+2
| | | | | | | | | | | | PHPBB3-9549
* | | Merge branch 'develop-olympus' into developOleg Pudeyev2011-02-231-1/+1
|\ \ \ | |/ / |/| / | |/ | | | | | | | | | | | | * develop-olympus: [ticket/7778] Update all the schema files [ticket/7778] Add the column change to `mysql_upgrader.php` [ticket/7778] BBCode single limit Conflicts: phpBB/install/database_update.php
| * [ticket/7778] Update all the schema filesErik Frèrejean2011-02-231-1/+1
| | | | | | | | | | | | Correct all the schema files to contain the new field type PHPBB3-7778
* | 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-0/+3
| | | | | | | | 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-0/+4
| | | | | | | | 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-0/+2
| | | | | | | | 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
| * extend the style columns (style_id, template_id, imageset_id, image_id...)Meik Sievertsen2008-11-271-13/+13
| | | | | | | | | | | | No, not only because of possible style demos. :o git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9129 89ea8834-ac86-4346-8a33-228a782c2dd0
| * Better handling and finer control for custom profile fields visibility ↵Meik Sievertsen2008-11-261-1/+2
| | | | | | | | | | | | 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-0/+2
| | | | | | | | 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/+1291
| | | | | | | | git-svn-id: file:///svn/phpbb/trunk@10211 89ea8834-ac86-4346-8a33-228a782c2dd0
* | we enter a brave new world...David M2008-01-101-1200/+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-161/+90
|/ | | | | | | | | - 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
* fix unread/new pm columnsMeik Sievertsen2007-12-051-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@8267 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
* #i71David M2007-10-041-1/+1
| | | | | | | #i72 git-svn-id: file:///svn/phpbb/trunk@8128 89ea8834-ac86-4346-8a33-228a782c2dd0
* Ok, here comes a big one. Poor updater. Also requires testing.Henry Sudhof2007-10-031-0/+1
| | | | | | | | | | | | #i91 #i92 #i93 #i94 #i95 #i96 git-svn-id: file:///svn/phpbb/trunk@8120 89ea8834-ac86-4346-8a33-228a782c2dd0
* - found a bug, it caused MSSQL not being able to use templates stored in the ↵David M2007-07-311-3/+1
| | | | | | DB since the first beta. removing pointless auto_increment git-svn-id: file:///svn/phpbb/trunk@7990 89ea8834-ac86-4346-8a33-228a782c2dd0
* same right for all. ;) Groups table using same column types as the users ↵Meik Sievertsen2007-07-281-2/+2
| | | | | | table for avatars. git-svn-id: file:///svn/phpbb/trunk@7968 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13179David M2007-07-121-6/+6
| | | | git-svn-id: file:///svn/phpbb/trunk@7876 89ea8834-ac86-4346-8a33-228a782c2dd0
* #12947David M2007-07-031-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@7826 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Handle ISO-8859-8-iDavid M2007-05-231-2/+2
| | | | | | | - Renamed two indicies for Oracle support #11457 git-svn-id: file:///svn/phpbb/trunk@7669 89ea8834-ac86-4346-8a33-228a782c2dd0
* fixing some bugsMeik Sievertsen2007-05-071-3/+1
| | | | | | | changed the way we are handling bookmarks. No order_id required, really! Order by last post time as suggested by BartVB. git-svn-id: file:///svn/phpbb/trunk@7497 89ea8834-ac86-4346-8a33-228a782c2dd0
* - changed the way we do forum accounting in phpBB, far less intensive and ↵David M2007-05-051-0/+1
| | | | | | | | | | | much faster. sync() recalculates the number of topics and posts using just the topics table instead of having to join topics and posts together. However, even this can be avoided if we know what operation is happening and an auto sync is not in action. Since MCP operations are "known", we can provide very fast MCP operations. - changed the way we decide if a DB gets multi value support. Old method uses switch/case, new method assumes a DB can't unless the DB says it can via a property I hope nothing is broken :P git-svn-id: file:///svn/phpbb/trunk@7466 89ea8834-ac86-4346-8a33-228a782c2dd0
* - * wildcard in a search query should cause \w+ in highlighting, not \w* ↵Nils Adermann2007-04-291-1/+0
| | | | | | | | | | | | | | | | [Bug #10031] - display a warning that the search index is not converted from phpBB2 to phpBB3 [Bug #9761] - forgot to add : to reg_name when deleting userinfo from the url regex constructor [Bug #9868] - magic urls should work after ">" - fixed sorting in mcp_reports/mcp_queue [Bug #9882] - display a "Report has already been closed" message, if a post is accessed in mcp_reports which has a closed report (might occur if two moderators want to process it at the same time) - convertor: old forum path should have the trailing slash removed - subsilver2 will come bundled with phpBB3, but it will not be installed by default (if admins want to use it they can, but it's not a default option for users) - prosilver was missing the topic-only mode in mcp_reports/mcp_queue git-svn-id: file:///svn/phpbb/trunk@7428 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Firebird is people too! (Firebird works again)David M2007-04-091-3/+3
| | | | | | | - small style.php bug git-svn-id: file:///svn/phpbb/trunk@7308 89ea8834-ac86-4346-8a33-228a782c2dd0
* - overhaul of imagesetsDavid M2007-04-081-94/+18
| | | | | | | | imagesets are now "intelligently" multilingual, one may use imagesets inside of CSS files now (as well as properties like the width and height of an imageset's image) all previous styles should change their imageset.cfg to be like prosilver and subsilver2 (notice how there is now an imageset.cfg in the /en folder, there should be one for each language) git-svn-id: file:///svn/phpbb/trunk@7304 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2026-01-02 09:14:41 +0000