aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/develop/create_schema_files.php
Commit message (Collapse)AuthorAgeFilesLines
* 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
* - 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-5/+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
* some language-specific adjustementsMeik Sievertsen2007-05-031-2/+2
| | | | | | | | fix prune users (adding the list of users to the confirmation page) tried to fix the show/hide trigger in ACP by not using width: auto; (which gets somehow inherited to each other element) git-svn-id: file:///svn/phpbb/trunk@7455 89ea8834-ac86-4346-8a33-228a782c2dd0
* - * wildcard in a search query should cause \w+ in highlighting, not \w* ↵Nils Adermann2007-04-291-6/+6
| | | | | | | | | | | | | | | | [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-109/+16
| | | | | | | | 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
* some tiny bugfixes and changed is_active() a bit...Meik Sievertsen2007-03-261-0/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7232 89ea8834-ac86-4346-8a33-228a782c2dd0
* better sorting is more important ;)David M2007-03-181-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7206 89ea8834-ac86-4346-8a33-228a782c2dd0
* #4052David M2007-03-171-3/+10
| | | | | | | - utf8_general_ci picked over utf8_unicode_ci for performance reasons git-svn-id: file:///svn/phpbb/trunk@7202 89ea8834-ac86-4346-8a33-228a782c2dd0
* - improvements to search indexing performance, espacially tidy() by adding a ↵Nils Adermann2007-03-131-0/+7
| | | | | | | | | | word_count column, the database update from b5 to next version will take quite a while on bigger databases, I also lowered the default common word threshold from 20 to 5 percent, big boards might want to use 3 or 2 percent, 20 was way too high - added some keys to ACL tables, great improvement of auth query performance - we will only add new language strings to install.php language file and won't modify any, if a language file is updated before phpBB is updated, the updater will not overwrite the user's language with english if install.php was modified git-svn-id: file:///svn/phpbb/trunk@7182 89ea8834-ac86-4346-8a33-228a782c2dd0
* oops, forgot a place ;-)David M2007-03-071-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7146 89ea8834-ac86-4346-8a33-228a782c2dd0
* #8502David M2007-03-041-1/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@7124 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added a UNIQUE index on the wordmatch tableNils Adermann2007-03-041-0/+1
| | | | | | | | - some modifications of search indexing which might improve the speed and hopefully fixes [Bug #8352] - added logging to search indexing [Bug #8384] git-svn-id: file:///svn/phpbb/trunk@7119 89ea8834-ac86-4346-8a33-228a782c2dd0
* #7882David M2007-02-251-15/+15
| | | | git-svn-id: file:///svn/phpbb/trunk@7073 89ea8834-ac86-4346-8a33-228a782c2dd0
* #8244David M2007-02-221-1/+1
| | | | | | | | - cleaned up the TRUNCATE/DELETE FROM in the native search backend - fixed an imporoper default value on some upgrades git-svn-id: file:///svn/phpbb/trunk@7036 89ea8834-ac86-4346-8a33-228a782c2dd0
* fixing some bugs i introduced while fixing other bugs. :)Meik Sievertsen2007-01-181-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@6899 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, handled some bugs... the most important being validate_username (the ↵Meik Sievertsen2007-01-171-2/+2
| | | | | | variable passed to validate_data([...]array('username', [...])) and updating group listings while doing relevant group actions. Oh, and PM icons are working now. :o git-svn-id: file:///svn/phpbb/trunk@6894 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some bugfixesMeik Sievertsen2007-01-091-3/+3
| | | | | | | - bugfixes for the convertor (typecasting for example was totally broken) git-svn-id: file:///svn/phpbb/trunk@6865 89ea8834-ac86-4346-8a33-228a782c2dd0
* - display search type as page title for premade searches [Bug #6508]Nils Adermann2006-12-271-1/+1
| | | | | | | | | | | | | | | - flash enabled on user side by default, so that admins can actually change anything by activating it (still disabled by default) - properly implemented password complexity check [Bug #6584] - do not ldap_escape paramaters for the bind function [Bug #6208] - deleted words in edited post subjects weren't getting there search cache refreshed [Bug #6288] - made common word threshold configurable [Bug #6168] - recreated word match table entries after installation, side effect of bug #6060 - option to only allow ASCII usernames - adjusted search page pagination [Bug #6424] - correctly calculate unformatted search result extract length git-svn-id: file:///svn/phpbb/trunk@6814 89ea8834-ac86-4346-8a33-228a782c2dd0
* #6492David M2006-12-231-4/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6793 89ea8834-ac86-4346-8a33-228a782c2dd0
* - finally correctly calculate current time for birthday calculation [Bug #6030]Nils Adermann2006-12-101-0/+1
| | | | | | | | | | | | | | | | - allow searching forums with unsearchable subforums [Bug #6056] - addition of an optional HTTP_X_FORWARDED_FOR check in sessions, including bans - do not index forums which have indexing disabled on index recreation [Bug #6060] - properly handle html entities in the theme editor [Bug #6048] - anonymous access is no longer required for the LDAP auth plugin [Bug #6046] - corrected mcp_front queue link to point to approve_details [Bug #6134] - added direct (dis)approval to mcp_front queue items [Bug #6134] - proper mysql version test for fulltext-compatibility [Bug #6054] - added note to style/language "used by" column so it's clear that bots are included - correctly update bot last visit time [Bug #6108] git-svn-id: file:///svn/phpbb/trunk@6740 89ea8834-ac86-4346-8a33-228a782c2dd0
* #5734David M2006-12-031-0/+1
| | | | | | | - replaced array_rand($array) with mt_rand(0, sizeof($array) - 1) as array_rand did not take my seed git-svn-id: file:///svn/phpbb/trunk@6705 89ea8834-ac86-4346-8a33-228a782c2dd0
* messageNils Adermann2006-11-251-0/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6655 89ea8834-ac86-4346-8a33-228a782c2dd0
* rather large update, most important things done:Meik Sievertsen2006-11-241-3/+4
| | | | | | | | | | | - implemented provided patch/diff file for bug #5350 (Highway of Life) with some tiny changes and alterations - more username/colour changes/fixes - added a note about PM rule-dependant message removals so the user is not wondering too much if he can't remember his rules. :) - some column changes to fix unicode issues - bugfixes git-svn-id: file:///svn/phpbb/trunk@6650 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixes for the following bugs:Meik Sievertsen2006-11-151-1/+1
| | | | | | | | | | | | | | | | | | #5326 #5318 #5304 #5290 #5288 #5278 #5276 #5272 #5266 - also fixed the "Call-time pass-by-reference" bug #5252 - within this step changed the normalize calls to require references. - added captcha size variables to the class scope (suggestion was posted at area51) git-svn-id: file:///svn/phpbb/trunk@6584 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some fixesMeik Sievertsen2006-11-101-2/+2
| | | | | | | - added script for easy adjustement of username_clean column within the users table (please see the note i added to the utf8_clean_string() function) git-svn-id: file:///svn/phpbb/trunk@6561 89ea8834-ac86-4346-8a33-228a782c2dd0