summaryrefslogtreecommitdiff
path: root/database/database.pgsql
Commit message (Collapse)AuthorAge
* - 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
|
* - Patch by Killes: drop the 'attributes' field from the 'users' table. ItDries Buytaert2004-02-21
| | | | is no longer used.
* - Removed the 'Page not found' message after the initial install and removedDries Buytaert2004-01-24
| | | | some old user module logic to install the initial role IDs.
* - Added default permissiona to the MySQL and PosgreSQL database scheme toDries Buytaert2004-01-15
| | | | prevent 404s. The MS SQL database scheme still needs to be updated ...
* Patch 5114 by Kjartan:Dries Buytaert2004-01-14
| | | | | | | - Adds drupal_set_header() and drupal_get_headers(). - Cache now stores custom headers. - Replace theme_head() with drupal_get_html_head(), added drupal_set_html_head(). - Added RSS autodiscover links to node, blog and taxonomy pages.
* Round 3 of aggregator improvements:Dries Buytaert2004-01-11
| | | | | | | | | | | | | | | - Added support for new tags: + Optinal feed image: <image> tag. + Dublin core dates: <dc:date> <dcterms:created>, <dcterms:issued>, <dcterms:modified>. - Usability improvements: + On the administration page, made the feed/bundle titles link to the feeds/bundles' pages. On the feed/bundle's page, made the 'Last updated' field link to the administration page. + Moved the 'syndication' menu one level down. - Updated some content sensitive help. - Further improved themeability. - Fixed some invalid HTML.
* - Many excellent news aggregator improvements by Kjartan:Dries Buytaert2004-01-07
| | | | | | | + Added drupal_http_request(). + Replaced rssfeeds with OPML feed subscription list. + Added support for pubDate. + Added support for conditional gets using ETag and Last-Modified.
* - Updated the database schemes: the default rows that are inserted intoDries Buytaert2003-12-08
| | | | | the database did not have the throttle column. Patches by Matt and Goba.
* - Patch 0185 by Jeremy: made it possible to automatically disable modules whenDries Buytaert2003-12-07
| | | | under heave load.
* - Made it possible to auto-throttle blocks. That is, blocks can beDries Buytaert2003-11-28
| | | | configured to be disabled when under excessive load. Patch by Jeremy.
* - Updated the INSERT statements at the bottom of the database schemes toDries Buytaert2003-11-19
| | | | reflect the bootstrap changes. Patch #152 by Tom Dobes.
* - Improved module loading when serving cached pages. Moshe's bootstrap patch.Dries Buytaert2003-11-18
| | | | - Used legend and fieldset tags for the configuration page.
* - Moving the cloud module to the contributions repository.Dries Buytaert2003-11-15
|
* - Set the update_start variable for the Drupal 4.4.0 release.Dries Buytaert2003-10-31
|
* - Bugfix: increased the size of variable's tables the 'name' field. PatchDries Buytaert2003-10-26
| | | | by Gerhard.
* - Bugfix: don't set a name and e-mail address for the anonymous user. FixesDries Buytaert2003-10-23
| | | | bug #3740.
* - Bugfix: renamed the 'statistics' table to 'node_counter' as 'statistics' isDries Buytaert2003-10-22
| | | | | | | | a reserved SQL keyword. Required for both PostgreSQL and MSSQL. Patch by Adrian. - Bugfix: renamed the 'path' table to 'url_alias' as 'path' is a reserved SQL keyword. Required for both PostgreSQL and MSSQL. Patch by Adrian.
* - Fixed translation bugs with statistics module. Patch by Gabor.Dries Buytaert2003-10-12
| | | | | | - Removed 'homepage' field from user table. Patch by Gabor. - Added 'real name' field to the profile module. Patch by Gabor.
* - Modifies path.module to get rid of pgsql reserved word. Patch by Adrian.Dries Buytaert2003-10-01
| | | | | | | | | | - Updates database.pgsql and database.mysql to work with current cvs. Patch by Adrian. - Updates update.php to be able to update postgres from 4.2 to current. Patch by Adrian. - Small fixes by me.
* - Added PostgreSQL support to the update script. Patch by Adrian.Dries Buytaert2003-09-30
| | | | - Making Adrian the new PostgreSQL maintainer.
* - Patch by Bart Jansen:Dries Buytaert2003-09-10
| | | | | | | | | | | | | | | | | | | <quote> This adds session support for anonymous users and fixes a bug/typo. 1. changed rid for user #0 from 0 to 1 (rid 1 == anonymous user) to make inner join work. 2. replaced "if ($user .." by "if ($user->uid .." because now $user is always set (my previous change probably caused this). 3. db_next_id("user_uid") -> db_next_id("users_uid"); </quote> I repeat: "This adds session support for anonymous users and fixes a bug/typo."
* - Gerhard's uid 0 patches. These patches bring various performanceDries Buytaert2003-09-09
| | | | improvements. Requires a database update.
* - Tested and committed Kjartan's performance patches. (Fixed the access checkDries Buytaert2003-08-27
| | | | in update.php though.)
* - Removed left-overs from the rating module. Patch by Gerhard. Updated theDries Buytaert2003-08-22
| | | | | | | | | | | | | | | | PostgreSQL and MSSQL database scheme as well. - Made sure the update script updates the correct tables when database prefixing is enabled. Patch by Bart Jansens. - Improved the breadcrumb navigation of the book and the forum module as per Keith Instone's suggestions. - Updated page titles (or block titles) and links to match. Suggested by Keith Instone. - Added missing 'thread' field to the comment table of the MySQL database scheme. Fixes bug #2590.
* - Fixed typo in database.pgsql. Patch by Michael.Dries Buytaert2003-08-21
|
* - Fixed braino in PostgreSQL database scheme.Dries Buytaert2003-08-21
|
* - Committed Jeremy's session patch: this brings us one step closer to havingDries Buytaert2003-08-20
| | | | session for anonymous users.
* - Fixed typo: 'vharchar' -> 'varchar'. Patch by Michael Frankowski.Dries Buytaert2003-08-13
|
* - Committed Marco's comment module patch:Dries Buytaert2003-08-12
| | | | | | | | | | | + Dramatically improves performance of large discussions/threads: only very few SQL queries are required. + Replaces custom pager with standard pager. Modifications by me: + Reworded some code comments. + Removed dependencies on pager internals.
* - Commited the URL aliasing patch. Thanks Matt.Dries Buytaert2003-07-16
| | | | This update requires you to run update.php!
* - Bugfix: renamed the SQL field 'types' to 'nodes' because 'types' is a ↵Dries Buytaert2003-06-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | reserved keyword in MySQL 4. This fixes critical bug #1618. Patch by Marco. ==> This fix requires to run update.php! - Bugfix: made sessions work without warnings when register_globals is turned off. The solution is to use $_SESSION instead of session_register(). This fixes critical bug #1797. Patch by Marco. - Bugfix: sometimes error messages where being discarded when previewing a node. Patch by Craig Courtney. - Bugfix: fixed charset problems. This fixes critical bug #1549. Patch '0023.charset.patch' by Al. - Code improvements: removed some dead code from the comment module. Patch by Marco. - Documentation improvements: polished the node module help texts and form descriptions. Patch '0019.node.module.help.patch' by Al. - CSS improvements all over the map! Patch '0021.more.css.patch' by Al. - GUI improvements: improved the position of Druplicon in the admin menu. Patch '0020.admin.logo.patch' by Al. - GUI improvements: new logos for theme Marvin and theme UnConeD. Logos by Kristjan Jansen. - GUI improvements: small changes to the output emitted by the profile module. Suggestions by Steven Wittens. - GUI improvements: small fixes to Xtemplate. Patch '0022.xtemplate.css.patch' by Al. TODO: - Some modules such as the buddy list module and the annotation module in the contributions repository are also using session_register(). They should be updated. We should setup a task on Drupal. - There is code emitting '<div align="right">' which doesn't validate. - Does our XML feeds validate with the charset changes? - The forum module's SQL doesn't work properly on PostgreSQL.