phpBB
Statistics
| Revision:

root / trunk / phpBB / develop / create_schema_files.php

History | View | Annotate | Download (62.4 kB)

  • svn:eol-style: LF
  • svn:keywords: Author Date Id Revision
# Date Author Comment
11015 03/01/2011 10:15 pm Git Gatekeeper

commit 448df1cdf5d06e9457397ae439c04ad44084c2a9
Merge: 6c49f95 4ac8eaf
Author: Oleg Pudeyev <>
Date: Tue Mar 1 16:57:00 2011 -0500

Merge branch 'ticket/9549' into develop
  • ticket/9549:
    [ticket/9549] Display users in their primary group instead of their first group...
10983 02/24/2011 03:15 am Git Gatekeeper

commit ba41e45f84027ebcf8d5118f909cee2bf0b4ddd5
Merge: aae3bd0 df92b7b
Author: Oleg Pudeyev <>
Date: Wed Feb 23 22:03:42 2011 -0500

Merge branch 'develop-olympus' into develop
  • develop-olympus:
    [ticket/7778] Update all the schema files...
10887 12/13/2010 03:45 pm Git Gatekeeper

commit adfa1656fb9d8b5bb601af1d7a6720884954d87a
Merge: bd579c8 af5b9a9
Author: Nils Adermann <>
Date: Mon Dec 13 16:35:55 2010 +0100

Merge branch 'ticket/igorw/9556' into develop
  • ticket/igorw/9556:
    [ticket/9556] Drop php closing tags, add trailing newline...
10558 03/07/2010 03:45 am Git Gatekeeper

commit 693a2dc99bf07aeac1865d4a48ddf2589317ac7a
Merge: b68de23 ac32927
Author: Nils Adermann <>
AuthorDate: Wed Mar 3 23:32:09 2010 +0100
Commit: Nils Adermann <>
CommitDate: Wed Mar 3 23:32:09 2010 +0100

Merge branch 'develop-olympus' into develop...
10211 10/04/2009 07:14 pm Meik Sievertsen

Copy 3.0.x branch to trunk

10107 09/04/2009 06:27 pm Andreas Fischer

Revert r10106 - Index usage is very unlikely because of WHERE IN (). :-|

10106 09/04/2009 04:44 pm Andreas Fischer

Add INDEX on user_regdate because this is the default ORDER BY in memberlist.php - thanks nickvergessen.

9965 08/12/2009 04:00 pm Meik Sievertsen

ok, i am very sorry, but this needs to be fixed.
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....

9931 08/05/2009 04:28 pm Joas Schilling

fix r9713 for #36565

Authorised by: AcydBurn

9916 08/03/2009 04:46 pm Henry Sudhof

#48985

9845 07/24/2009 11:13 am Meik Sievertsen

[Feature] Added new functionality to inactive users module:
- 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.

9814 07/21/2009 08:59 pm Nils Adermann

Users can report PMs to moderators which are then visible in a new MCP module

9697 06/27/2009 09:34 am Ruslan Uzdenov

Addition to r9696 - update develop/ scripts
Authorised by: AcydBurn

9636 06/20/2009 06:45 pm Meik Sievertsen

- [Feature] New "Newly Registered Users" group for assigning 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....

9626 06/19/2009 12:31 pm Henry Sudhof

Make captchas stricter by oly having one entry per session; fix a bug in ucp_register that caused three captcha instances to be generated. Non-MySQL databases and garbage collecting needs extensive testing.

9625 06/19/2009 09:51 am Meik Sievertsen

- Display coloured usernames in ACP groups management screens
- Changed behaviour of group_create() function to support specifying additional group columns
- New groups option to excempt group leaders from group permissions

9564 06/08/2009 12:36 pm Andreas Fischer

Fix bug #44665 - Add index on log_time to the log table to prevent slowdown on boards with many log entries.
Authorised by: acydburn

9400 03/20/2009 01:22 pm Meik Sievertsen

Fix duplicate creation of acl options in acl_add_options() under certain conditions. (Bug #38385, #40225)
Add unique key to ACL options table to prevent duplicate permission options. (Bug #41835)

9129 11/27/2008 02:44 pm Meik Sievertsen

extend the style columns (style_id, template_id, imageset_id, image_id...)
No, not only because of possible style demos. :o

9127 11/26/2008 08:58 pm Meik Sievertsen

Better handling and finer control for custom profile fields visibility options. (Patch by Highway of Life)

8911 09/23/2008 03:03 pm Meik Sievertsen

- Added 'max_recipients' setting for private messages. This setting allows 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.

8730 07/30/2008 01:09 am Henry Sudhof

weird - schemas later

8719 07/29/2008 05:01 pm Henry Sudhof

Schema changes

8666 06/21/2008 06:04 pm Meik Sievertsen

change subject/title column length

8479 03/29/2008 01:22 am Nils Adermann

Hiding everywhere little buggers, eh?

8436 03/17/2008 05:25 pm Henry Sudhof

This should get rid of the filesorts and temp tables on index (with topic read tracking as exception).
Updater still needs testing. Not yet merged to 3.1
#22715 - thanks HoL

8374 02/03/2008 11:55 pm Nils Adermann

merging r8373 into 3.0 branch: adding a new option to hide the entire list of subforums on listforums

8285 12/26/2007 03:53 pm

This commit was manufactured by cvs2svn to create branch 'phpBB-3_0_0'.

8267 12/05/2007 04:18 pm Meik Sievertsen

fix unread/new pm columns

8183 10/14/2007 05:46 pm Meik Sievertsen

more fixes...

8178 10/14/2007 02:12 pm Meik Sievertsen

forum rules, forum descriptions and group description bbcode uid fixes

8151 10/06/2007 01:20 pm Meik Sievertsen

i think david just forgot these. ;)

8130 10/04/2007 01:33 pm Meik Sievertsen

deregister globals to install too

8128 10/04/2007 06:42 am David M

#i71
#i72

8120 10/03/2007 05:05 pm Henry Sudhof

Ok, here comes a big one. Poor updater. Also requires testing.

#i91
#i92
#i93
#i94
#i95
#i96

8015 08/09/2007 03:28 am David M

#13999

7990 07/31/2007 10:27 pm David M

- found a bug, it caused MSSQL not being able to use templates stored in the DB since the first beta. removing pointless auto_increment

7968 07/28/2007 01:47 pm Meik Sievertsen

same right for all. ;) Groups table using same column types as the users table for avatars.

7876 07/12/2007 07:26 pm David M

#13179

7830 07/03/2007 05:36 pm Meik Sievertsen

let's see if i can break something. :o

7826 07/03/2007 07:12 am David M

#12947

7675 05/25/2007 02:22 pm David M

#11637

7669 05/24/2007 01:37 am David M

- Handle ISO-8859-8-i
- Renamed two indicies for Oracle support #11457

7497 05/07/2007 03:19 pm Meik Sievertsen

fixing some bugs
changed the way we are handling bookmarks. No order_id required, really! Order by last post time as suggested by BartVB.

7466 05/05/2007 06:53 am David M

- changed the way we do forum accounting in phpBB, far less intensive and 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....

7455 05/03/2007 04:29 pm Meik Sievertsen

some language-specific adjustements
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)

7428 04/29/2007 10:56 pm Nils Adermann

- * wildcard in a search query should cause \w+ in highlighting, not \w* [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]...

7308 04/09/2007 07:10 am David M

- Firebird is people too! (Firebird works again)
- small style.php bug

7304 04/08/2007 07:40 pm David M

- overhaul of imagesets
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)

7232 03/26/2007 05:42 pm Meik Sievertsen

some tiny bugfixes and changed is_active() a bit...

7206 03/18/2007 01:05 pm David M

better sorting is more important ;)

7202 03/17/2007 03:32 am David M

#4052
- utf8_general_ci picked over utf8_unicode_ci for performance reasons

7182 03/13/2007 11:00 pm Nils Adermann

- improvements to search indexing performance, espacially tidy() by adding a 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...

7146 03/07/2007 10:47 pm David M

oops, forgot a place ;-)

7124 03/05/2007 12:59 am David M

#8502

7119 03/04/2007 05:05 pm Nils Adermann

- added a UNIQUE index on the wordmatch table
- some modifications of search indexing which might improve the speed and hopefully fixes [Bug #8352]
- added logging to search indexing [Bug #8384]

7073 02/25/2007 10:03 pm David M

#7882

7036 02/22/2007 08:58 pm David M

#8244
- cleaned up the TRUNCATE/DELETE FROM in the native search backend
- fixed an imporoper default value on some upgrades

6899 01/18/2007 11:00 am Meik Sievertsen

fixing some bugs i introduced while fixing other bugs. :)

6894 01/17/2007 07:41 pm Meik Sievertsen

ok, handled some bugs... the most important being validate_username (the variable passed to validate_data([...]array('username', [...])) and updating group listings while doing relevant group actions. Oh, and PM icons are working now. :o

6865 01/09/2007 03:10 pm Meik Sievertsen

- some bugfixes
- bugfixes for the convertor (typecasting for example was totally broken)

6814 12/27/2006 01:06 am Nils Adermann

- display search type as page title for premade searches [Bug #6508]
- 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]...

6793 12/23/2006 06:50 pm David M

#6492

6740 12/10/2006 06:44 pm Nils Adermann

- finally correctly calculate current time for birthday calculation [Bug #6030]
- 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]...

6705 12/03/2006 06:36 pm David M

#5734
- replaced array_rand($array) with mt_rand(0, sizeof($array) - 1) as array_rand did not take my seed

6655 11/25/2006 09:00 pm Nils Adermann

message

6650 11/24/2006 03:59 pm Meik Sievertsen

rather large update, most important things done:
- 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. :)...

6584 11/15/2006 04:35 pm Meik Sievertsen

- fixes for the following bugs:
#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)

6561 11/10/2006 02:49 pm Meik Sievertsen

- some fixes
- 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)

6494 10/14/2006 12:10 am Nils Adermann

- introducing clean usernames, needs to be tested more, I'm not sure I didn't miss anything
- homograph list should probably be extended

6480 10/11/2006 09:56 pm David M

#4700

6473 10/10/2006 03:46 am David M

new collation for MySQL >= 4.1.3, should be a tad faster

6436 10/03/2006 08:35 pm Meik Sievertsen

- extend config checking to include check for writeable path
- removed not utilized user_allow_email column from schema
- removed inactive groups (they had no use at all, since inactive users are not able to login)
The only benefit those brought are distinguish users - but this is no longer needed too due to the inactive code present. This also allows us to retain group memberships as well as default settings for users being set inactive due to profile changes....

6430 10/02/2006 05:32 pm David M

#4572

6422 10/01/2006 10:48 am David M

- forgot to make the same change to the ODBC driver
- MySQL 3.x works now
- FirebirdSQL is now on the same level as MySQL and PostgreSQL, zero hacks exist inside the core code now

6411 09/26/2006 09:59 pm Meik Sievertsen

These changes should let olympus scale a little bit better.
i haven't adjusted the schemas but added the details to create_schema_files - david is able to build them then in line with his changes. :)

6400 09/24/2006 02:24 pm grahamje

Forgot this one yesterday

6383 09/23/2006 12:14 am Meik Sievertsen

some tiny fixes here and there

6381 09/19/2006 06:50 am David M

- Oracle now works with large amounts of text
- MSSQL now works :P (sans UTF-8 support)
- The current schema files work well enough to install, etc. but must be tightened. Will get to it when I get some time...

6380 09/18/2006 12:02 am Nils Adermann

- no more encoding mixture, say hello to UTF-8 (I'll add a validation solution for PHP 4.3.3/4 ASAP) [side effect: fixes Bug #3762]
- take local server time into consideration for birthday/age calculation
- faster active topic search
- allow changing active topic time frame [Bug #4150]...

6371 09/16/2006 08:07 am David M

bug fixes
schema changes
i really hope nothing went wrong

6364 09/13/2006 06:08 pm Meik Sievertsen

- fixed some bugs
- changed attachment handling a bit
- tried to remove target tags out of the code
- do not add session ids to urls for bots as well as not creating a new session on each page view for them

I bet i introduced some bugs too. ;)

6360 09/08/2006 08:00 pm grahamje

Next phase of last post changes + a few minor bugs

Note: This template variable is available but will not be used by default

6311 08/22/2006 01:01 pm grahamje

Phase 2 of the changes
This should now be complete

6309 08/21/2006 05:58 pm grahamje

Initial batch of colourization changes. This includes:
- schema changes for first post and last post
- display in viewforum, search and ucp of first post
- update of database on posting
Still outstanding
- display of last post

6305 08/20/2006 02:59 pm grahamje

Minor schema change related to avatars so that they can be > 127px in size
Add additional note about the install directory
Remove some empty tags from the template

6279 08/12/2006 07:06 pm Meik Sievertsen

firebird :P