summaryrefslogtreecommitdiff
path: root/database/database.pgsql
Commit message (Collapse)AuthorAge
* - Patch #17747 by Adrian: more PostgreSQL fixes. Committed part of the patch:Dries Buytaert2005-02-27
| | | | | | 1. Removed a duplicate line from the changes to update.inc. 2. Excluded the session.inc changes: they did not make sense to me. 3. Excluded the search related changes in the node and search module. According to Steven these are not correct.
* - Patch #17687 by Gerhard: removed some cruft.Dries Buytaert2005-02-21
|
* - Patch #11366 by Junyor: fixed twin comment problem in HEAD.Dries Buytaert2005-02-11
|
* - Patch #16074 by Andre Molnar: add configuration option to show blocks only ↵Dries Buytaert2005-01-27
| | | | on pages of certain node type.
* - Patch #6847 by Gerhard: replaced vocabulary->nodes by a separate table and ↵Dries Buytaert2005-01-19
| | | | tidied up the taxonomy API a bit. This fixes a number of issues.
* Remove left-overs from admin.module.Steven Wittens2005-01-14
|
* - Patch #13260 by UnConeD: watchdog module improvements.Dries Buytaert2005-01-09
| | | | | | | | | | We added a 'severity' column to watchdog(): watchdog($type, $message, $link) --> watchdog($type, $message, $severity, $link); * Specify a severity in case you are reporting a warning or error. * The $link-parameter is now the fourth parameter instead of the third. TODO: document this in the upgrade guide.
* - Patch #14241 by fungy: fixed brokeness in the PostgreSQL database scheme.Dries Buytaert2004-12-12
|
* - Refactored the queue module: removed the queue module's field from the ↵Dries Buytaert2004-12-07
| | | | | | | | | | node table. With help from Gerhard. - Slight addition to INSTALL.txt with regard to PHP versions. - Updated/reworded some node type descriptions as per Boris' suggestions. - Adding missing {} around a table name in update.php.
* - Refactored the statistics and watchdog module (views). The most importantDries Buytaert2004-11-28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | changes are: 1. Simplified the statistics pages: there are less pages and on the remaining pages there is a lot less visual clutter (less columns and better presentation). 2. Reorganized the 'administer - logs' menu: flattened the menu structure and removed a number of links. 3. Improved performance. Most statistics pages used about 160 slow SQL queries which made the statistics pages fairly unusable on my system. The new pages use at least 10 times less SQL queries and render much faster. They are actually usable. 4. There is now a 'track'-tab on node pages, and a second subtrab on the user accounts 'track'-tab for people with the 'access statistics' permission. They can be used to resp. track the node and the user. This makes the statistics more accessible. 5. Changed the way watchdog messages are filtered. This makes it easier to introduce new watchdog types. 6. Reworked the statistics module's permissions. 7. Less code: 223 insertions(+), 343 deletions(-). 8. Fixed several glitches: for example, the statistics pages sorted the 'Name' column by user ID instead of by name. Unfortunately, it is too difficult to backport these to DRUPAL-4-5. TODO: 1. Review the statistics modules help pages. 2. Help fine-tune the interfaces/views. NOTES: 1. You'll want to run update.php.
* - Patch #5942 by jhriggs and Adrian:Dries Buytaert2004-11-24
| | | | | + added support for multi-site configurations. + tidied up some old cruft and added code comments.
* - Adding the missing flood tables. Sorry.Dries Buytaert2004-11-16
|
* - Modified patch #11689 by Adrian: made the locale module work with PostgreSQL.Dries Buytaert2004-10-18
|
* - Patch #11505 by Steven: 'my account' information is not saved.Dries Buytaert2004-10-16
| | | | | | + Drupal 4.4 stored profile data in the serialized user->data column. Drupal 4.5 stores profile data in tables (but user->data is still available and used for other stuff, like locale or themes). The update from 4.4 to 4.5 didn't remove the old data from the user->data column properly, because there is no mechanism in user_save to do so (it did try to unset the fields, but this has no effect). + On registration, hook_user('insert') is invoked after saving the data column. This means that any module-specific data is put into the data field. We cannot move hook_user('insert') higher up, because before that point, we do not have a complete $user object yet.
* Bug: the default filter setup had the wrong filter delta for the linebreak ↵Steven Wittens2004-10-13
| | | | filter. Now it matches updates.inc.
* Changing the value of variable "update_start" to match updates.inc.Steven Wittens2004-10-08
|
* - Patch #11094 by Allen Chandler and Adrian: fixed PostgreSQL related SQL ↵Dries Buytaert2004-09-27
| | | | problem in aggregator module.
* Fixing stray comma in database.*sqlSteven Wittens2004-09-23
|
* - Bugfix: the access rule mask does not have to be unique. It should be ↵Dries Buytaert2004-09-22
| | | | possible to use a particular mask for both e-mail and username rules. This also avoids an SQL query error. Fixes bug report #10551.
* - Patch #10945 by Adrian: more PostgreSQL fixes/updates.Dries Buytaert2004-09-20
|
* - Patch #6500 by Mathias with help from Steven: made it possible to add ↵Dries Buytaert2004-09-19
| | | | fields to the registration form. This feature used to exist.
* #10862: Smarter filter cache wiping.Steven Wittens2004-09-15
|
* - Patch #10622 by Adrian: fixes various PostgreSQL related problems.Dries Buytaert2004-09-08
| | | | | | | | | | | | | 1) Menu problems with Postgres (this is a highly critical 1 line fix) 2) Archive module fails with Postgres 3) Postgres setup problems - changes to database.pgsql (although i made these changes myself before finding this patch) 4) Book module fails with Postgres 5) Postgres problems following creation of a new type of user - which is actually about a taxonomy.module bug. 6) Creating accregator_item_table in PostgreSQL 7) Postgres - Polls not displayed on Poll Page 8) Blog module has sql errors with postgres This should not affect MySQL users (hopefully).
* #9861: Updates.inc/database.pgsql: incorrect menu sequence when $db_prefix ↵Steven Wittens2004-09-05
| | | | was used.
* - Theme system changes. Please consult http://drupal.org/node/view/9576 for ↵Dries Buytaert2004-08-20
| | | | details.
* - The upload (filehandler) module has landed!Dries Buytaert2004-08-17
|
* - New locale module thanks to Gerhard, Goba, Marco, Kristjan and others.Dries Buytaert2004-08-11
| | | | | | The new locale module provides every functionality on the web interface, so you don't need to edit the configuration files or add columns, when you add a new language. This module is an integration of the old locale and localegettext modules, plus a bunch of logic to parse Gettext Portable Object files (opposed to Machine Object files, as supported by localegettext). Note: I made some minor changes to the context-sensitive help texts and to some of the status messages.
* The Input formats - filter patch has landed. I still need to make update ↵Steven Wittens2004-08-10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | instructions for modules and update the hook docs. Here's an overview of the changes: 1) Multiple Input formats: they are complete filter configurations (what filters to use, in what order and with which settings). Input formats are admin-definable, and usage of them is role-dependant. For example, you can set it up so that regular users can only use limited HTML, while admins can free HTML without any tag limitations. The input format can be chosen per content item (nodes, comments, blocks, ...) when you add/edit them. If only a single format is available, there is no choice, and nothing changes with before. The default install (and the upgrade) contains a basic set of formats which should satisfy the average user's needs. 2) Filters have toggles Because now you might want to enable a filter only on some input formats, an explicit toggle is provided by the filter system. Modules do not need to worry about it and filters that still have their own on/off switch should get rid of it. 3) Multiple filters per module This was necessary to accomodate the next change, and it's also a logical extension of the filter system. 4) Embedded PHP is now a filter Thanks to the multiple input formats, I was able to move the 'embedded PHP' feature from block.module, page.module and book.module into a simple filter which executes PHP code. This filter is part of filter.module, and by default there is an input format 'PHP', restricted to the administrator only, which contains this filter. This change means that block.module now passes custom block contents through the filter system. As well as from reducing code duplication and avoiding two type selectors for page/book nodes, you can now combine PHP code with other filters. 5) User-supplied PHP code now requires <?php ?> tags. This is required for teasers to work with PHP code. Because PHP evaluation is now just another step in the filter process, we can't do this. Also, because teasers are generated before filtering, this would result in errors when the teaser generation would cut off a piece of PHP code. Also, regular PHP syntax explicitly includes the <?php ?> tags for PHP files, so it makes sense to use the same convention for embedded PHP in Drupal. 6) Filter caching was added. Benchmarking shows that even for a simple setup (basic html filtering + legacy URL rewriting), filtercache can offer speedups. Unlike the old filtercache, this uses the normal cache table. 7) Filtertips were moved from help into a hook_filter_tips(). This was required to accomodate the fact that there are multiple filters per module, and that filter settings are format dependant. Shoehorning filter tips into _help was ugly and silly. The display of the filter tips is done through the input format selector, so filter_tips_short() no longer exists. 8) A more intelligent linebreak convertor was added, which doesn't stop working if you use block-level tags and which adds <p> tags.
* - Patch #9330: ucfirst() gives problem when used with multibyte charset.Dries Buytaert2004-08-06
| | | | Replaced the use of ucfirst() with a CSS-based solution.
* #9810: PostgreSQL updates by Adrian.Steven Wittens2004-08-06
|
* - Patch #7336 by TDobes: in various parts of Drupal, we use the title ↵Dries Buytaert2004-08-03
| | | | attribute for links to provide a slightly more detailed explanation as to the purpose of a link or where it goes.
* - Patch by Jeremy: statistics module improvements.Dries Buytaert2004-08-03
|
* - #7295: Fixing issue with latest comments being incorrectly displayed on ↵Steven Wittens2004-07-22
| | | | PostgreSQL
* - Patch by Matt: made it possible to alias an URL multiple times.Dries Buytaert2004-07-11
|
* - Added missing homepage column to the comments table in the PostgreSQL scheme.Dries Buytaert2004-07-07
|
* - Patch #8585 by Junyor: sort blog items by creation date. Added some ↵Dries Buytaert2004-06-30
| | | | database indices.
* I refactored quite a bit of the user.module:Dries Buytaert2004-06-27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | $ diffstat user.patch database/database.mysql | 4 database/database.pgsql | 2 database/updates.inc | 10 - modules/block.module | 20 +- modules/locale.module | 9 modules/profile.module | 108 +++++++---- modules/system.module | 8 modules/user.module | 456 +++++++++++++++++++----------------------------- 8 files changed, 289 insertions(+), 328 deletions(-) More functionality, less code. Here is a list of the changes: - Some user API changes: + When $type is 'form', you have to return an associative array of groups. In turn, each group is an array with a 'title', 'data' and 'weight'. + A new $type has been added, namely 'categories'. User settings can be organized in categories. Categories can be sorted, as can the groups within a category. (Ordering 'categories' is somewhat broken due to a bug in the menu system.) - The 'my account > edit' page will use subtabs for each 'category'. Read: you can break down the account settings into multiple subpages. - Profile module improvements: + Added support for private fields to the profile module! + Improved workflow of profile administration pages. + Improved the form descriptions. - Code improvements: + Unified user_edit() and user_admin_edit(). + Unified and cleaned up the validation code. Fixed some validation glitches too.
* - Patch #7696 by TDobes: renamed 'static' to 'sticky' which is a moreDries Buytaert2004-06-19
| | | | logical name. Requires a database upgrade.
* Tabs patch!Dries Buytaert2004-06-18
| | | | | | | | | | | | | | | | | | CHANGES ------- + Introduced tabs. First, we extended the menu system to support tabs. Next, a tab was added for every link that was (1) an administrative action other than the implicit 'view' (2) relevant to that particular page only. This is illustrated by the fact that all tabs are verbs and that clicking a page's tab leads you to a subpage of that page. + Flattened the administration menu. The tabs helped simplify the navigation menu as I could separate 'actions' from 'navigation'. In addition, I removed the 'administer > configuration'-menu, renamed 'blocks' to 'sidebars' which I hope is a bit more descriptive, and made a couple more changes. Earlier, we already renamed 'taxonomy' to 'categorization' and we move 'statistics' under 'logs'. + Grouped settings. All settings have been grouped under 'administer > settings'. TODO ---- + Update core themes: only Xtemplate default supports tabs and even those look ugly. Need help. + Update contributed modules. The menu() hook changed drastically. Updating your code adhere the new menu() function should be 90% of the work. Moreover, ensure that your modue's admin links are still valid and that URLs to node get updated to the new scheme ('node/view/x' -> 'node/x').
* - Patch #7614 by jhriggs: fixed some role related problems.Dries Buytaert2004-05-19
|
* - Made it possible for anonymous users to leave their name, e-mail addressDries Buytaert2004-05-18
| | | | and the URL of their homepage. Patch by Pablo.
* - Added support for multiple user roles. Patch by Jim Hriggs.Dries Buytaert2004-05-10
|
* - Patch #7498 by nereocystis: PostgreSQL updates for HEADDries Buytaert2004-05-03
|
* - Patch #6009 by Matthias: reworked the help texts of the taxonomy module ↵Dries Buytaert2004-04-24
| | | | generated forms. The help text can now be customized.
* - Patch #7286 by LiDave: improved filter table indices. I updated ↵Dries Buytaert2004-04-24
| | | | database/updates.inc as well.
* - Fix #6393 by TDobes: fixed users table after. It was not updated properly ↵Dries Buytaert2004-03-12
| | | | after the recent profile module changes.
* - Rewrote the profile module:Dries Buytaert2004-03-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | + Added a 'created' field to the users table and renamed the 'timestamp' fied to 'changed' (cfr. node table). Update.php will try to determine a 'created' timestamp for existing users. + The profile module no longer uses serialized data but has its own set of tables. Known existing profile data is migrated by these new tables. TODO: migrate the birthday field. + The profile fields can be grouped, and within each group, profile fields can be sorted using weights. + The profile pages can be themed. + The profiles can be browsed based on certain properties/settings. + Change the _user hook: (i) 'private_view' and 'public_view' are merged into 'view' as there are no private fields and (ii) 'edit_form' has been renamed to 'edit'. + Avatar handling has been refactored and is now part of the user module. The users table has a dedicted 'picture' field. + Simplified the way themes should use display/visualize pictures or avatars. + Made it possible for administrators to replace or delete avatars. + ... I hope this make for a good base to build on collectively.
* - Patch 6012 by Adrian: syncs the PostgreSQL port with the current state of ↵Dries Buytaert2004-02-23
| | | | | | | | HEAD, and adds a user notice to add the throttle and bootstrap columns to the system table manually, else update.php will not run. The message includes the SQL statements required for both MySQL and PostgreSQL.
* - Updating update_start value.Kjartan Mannes2004-02-21
|
* - Cleaning up database definition.Kjartan Mannes2004-02-21
|