summaryrefslogtreecommitdiff
path: root/database/database.pgsql
Commit message (Collapse)AuthorAge
* - 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.
* - Fixed critical bug #1788: cloud module pings too much. Modified patch byDries Buytaert2003-06-01
| | | | | | Kjartan. This update requires some database changes so make sure to run update.php.
* - Fixed bug in book_prev(). Patch by Andy Colson.Dries Buytaert2003-05-18
| | | | | | | - Book optimizations: updated to use inner joins. Patch by Andy Colson. This should address bug #1373. TODO: add index to MSSQL database scheme.
* - Fixed a typo in the PostgreSQL database scheme. Patch by Michael Frankowski.Dries Buytaert2003-05-13
| | | | | | | | | | | | | - Fixed a typo in the MSSQL database scheme. Patch by Michael Frankowski. - Removed dependency on "register_globals = on"! Patches by Michael Frankowski. Notes: + Updated the patches to use $foo["bar"] instead of $foo['bar']. + Updated the INSTALL and CHANGELOG files as well. - Tiny improvement to the "./scripts/code-clean.sh" script.
* - Applied modified version of Al's "block delta" patch. I left out theDries Buytaert2003-04-19
| | | | | | | | blogroll feature as I think it would get very confusing. I don't mind to add it but it need some thought and documentation as it somewhat conflicts with the existing cloud module. These changes require you to run update.php.
* - Made sure the admin menu is enabled after a fresh install. This isDries Buytaert2003-04-18
| | | | | | required to make the menu show up. This partly fixes bug #1508.
* - Removing the menu table: it is no longer used.Dries Buytaert2003-02-24
| | | | [TODO: update 'update.php'.]
* - Updated the database scheme.Dries Buytaert2003-02-06
|
* - Small improvement to the admin menu based on feedback from Michael.Dries Buytaert2003-01-14
|
* - Added an extra parameter to watchdog() which lets you specifiy an "action"Dries Buytaert2003-01-04
| | | | | | | | | or "operation" link. - Made the main page of the administration section show an overview of all watchdog entries with such action link. - Fixed typo in PostgreSQL database scheme.
* - Refactored the administration pages.Dries Buytaert2002-12-24
|
* - Fixed typo in the database scheme. Reported by Ettiene.Dries Buytaert2002-12-15
|
* Applied patch by Natrak:Dries Buytaert2002-12-11
| | | | | | | | | | | | | - page_header() now adds Last-Modified and ETag http headers. - When running PHP as an Apache module page_header() will check the HTTP headers for conditional gets, and will only push the content when it fails. (Works for html and xml pages as they are all cached). Note: this is a PHP limitation, so until PHP makes it work for other web servers this won't work for them. - Added created field to cache database to hold the timestamp when the cache was created. - Changed cache_get() to return an object with ->data and ->created. - Update forum and locale modules.
* - Removed rating module; it is not being used much and it has a known bug.Dries Buytaert2002-12-08
| | | | Will add it to the contributions repository.
* - Removed two a dead table from both the MySQL and the PostgreSQL databaseDries Buytaert2002-12-07
| | | | | | | scheme. - Fixed the default settings for both the MySQL and the PostgreSQL database scheme.
* - Fixed small glitch in the database schemes; the block table has changed butDries Buytaert2002-11-30
| | | | the queries that insert some default block values were not updated.