aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/develop/create_schema_files.php
Commit message (Collapse)AuthorAgeFilesLines
* [ticket/9916] Changing header in non-distributed filesUnknown2012-01-021-2/+1
| | | | PHPBB3-9916
* Merge remote-tracking branch 'igorw/ticket/10413' into develop-olympusAndreas Fischer2011-10-161-6/+2
|\ | | | | | | | | | | * igorw/ticket/10413: [ticket/10413] Fix CS [ticket/10413] Make create_schema_files usable
| * [ticket/10413] Fix CSIgor Wiedler2011-10-161-2/+2
| | | | | | | | PHPBB3-10413
| * [ticket/10413] Make create_schema_files usableIgor Wiedler2011-10-141-6/+2
| | | | | | | | PHPBB3-10413
* | [ticket/10189] Get rid of $id$ from schema filesIgor Wiedler2011-10-141-16/+1
| | | | | | | | PHPBB3-10189
* | [ticket/10189] Add "automatically generated" comment into schema-filesIgor Wiedler2011-10-141-0/+26
|/ | | | PHPBB3-10189
* [ticket/10247] Remove unecessary attempt_id primary key columnNils Adermann2011-07-031-2/+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
* [ticket/10213] Update install schema with shorter index names.Nils Adermann2011-06-131-4/+4
| | | | PHPBB3-10213
* [ticket/9892] Removing closing php tag from create_schema_filesNils Adermann2011-06-121-1/+0
| | | | PHPBB3-9892
* [ticket/9892] column & index name limits, firebird auto increment in db_toolsNils Adermann2011-06-121-1/+15
| | | | | | | | | | | | | | - 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
* [ticket/9992] Adding a limit on login attempts per IP.Nils Adermann2011-06-101-0/+20
| | | | | | | | | | | | | 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/7778] BBCode single limitErik Frèrejean2011-02-231-1/+1
| | | | | | | | | | | | | There are currently two hard limits for the number of BBCodes allowed. One is enforced by the type of the `bbcode_id` column, the other by an hard limit in `acp/acp_bbcode.php`. However this limit can never be reached due to the size of the database column. Suggested fix involves adding a new constant to define the max. number of BBCodes (as with smilies) and chaning the database column from a tinyint to a smallint to actually allow 1511 BBCodes PHPBB3-7778
* Updating the create_schema_files.php file to reflect the minor mssql schema ↵Nils Adermann2010-02-271-2/+4
| | | | | | change introduced in r10489 (implementing mssql native driver support - Bug #57055) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10548 89ea8834-ac86-4346-8a33-228a782c2dd0
* 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/+1
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9916 89ea8834-ac86-4346-8a33-228a782c2dd0
* [Feature] Added new functionality to inactive users module:Meik Sievertsen2009-07-241-0/+2
| | | | | | | | | | | - Ability to set users per page. - Ability to sort by posts/number of reminders/last reminded date. - Show number of posts and ability to search posts. - Show number of reminders sent to user. - Show date of last reminder sent to user. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9845 89ea8834-ac86-4346-8a33-228a782c2dd0
* Users can report PMs to moderators which are then visible in a new MCP moduleNils Adermann2009-07-211-0/+6
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9814 89ea8834-ac86-4346-8a33-228a782c2dd0
* Addition to r9696 - update develop/ scriptsRuslan Uzdenov2009-06-271-1/+1
| | | | | | Authorised by: AcydBurn git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9697 89ea8834-ac86-4346-8a33-228a782c2dd0
* - [Feature] New "Newly Registered Users" group for assigning ↵Meik Sievertsen2009-06-201-1/+1
| | | | | | | | | | | | permissions to newly registered users. They will be removed from this group once they reach a defineable amount of posts. - [Feature] Ability to define if the "Newly Registered Users" group will be assigned as the default group to newly registered users. As a coincidence also Bug #46535 got fixed. Additionally the error message displayed with trigger_error() if accessing the private message tab in the ucp is now displayed inline in addition to a slightly different message for newly registered users to let them know that access permissions may be lifted over time. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9636 89ea8834-ac86-4346-8a33-228a782c2dd0
* Make captchas stricter by oly having one entry per session; fix a bug in ↵Henry Sudhof2009-06-191-0/+1
| | | | | | ucp_register that caused three captcha instances to be generated. Non-MySQL databases and garbage collecting needs extensive testing. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9626 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-12/+12
| | | | | | 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-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
* weird - schemas laterHenry Sudhof2008-07-291-1/+1
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8730 89ea8834-ac86-4346-8a33-228a782c2dd0
* Schema changesHenry Sudhof2008-07-291-0/+2
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8719 89ea8834-ac86-4346-8a33-228a782c2dd0
* change subject/title column lengthMeik Sievertsen2008-06-211-8/+8
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8666 89ea8834-ac86-4346-8a33-228a782c2dd0
* This should get rid of the filesorts and temp tables on index (with topic ↵Henry Sudhof2008-03-171-1/+3
| | | | | | | | | | read tracking as exception). Updater still needs testing. Not yet merged to 3.1 #22715 - thanks HoL git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8436 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
* 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
* deregister globals to install tooMeik Sievertsen2007-10-041-11/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@8130 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/+4
| | | | | | | | | | | | #i91 #i92 #i93 #i94 #i95 #i96 git-svn-id: file:///svn/phpbb/trunk@8120 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13999David M2007-08-091-0/+24
| | | | git-svn-id: file:///svn/phpbb/trunk@8015 89ea8834-ac86-4346-8a33-228a782c2dd0
* - found a bug, it caused MSSQL not being able to use templates stored in the ↵David M2007-07-311-1/+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-4/+4
| | | | | | table for avatars. git-svn-id: file:///svn/phpbb/trunk@7968 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13179David M2007-07-121-11/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@7876 89ea8834-ac86-4346-8a33-228a782c2dd0
* let's see if i can break something. :oMeik Sievertsen2007-07-031-4/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@7830 89ea8834-ac86-4346-8a33-228a782c2dd0
* #12947David M2007-07-031-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@7826 89ea8834-ac86-4346-8a33-228a782c2dd0
* #11637David M2007-05-251-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7675 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2025-08-06 09:41:53 +0000