summaryrefslogtreecommitdiff
path: root/database
Commit message (Collapse)AuthorAge
* - Patch #20615 by Robert: added missing table prefixesDries Buytaert2005-04-16
|
* - Re-added update_sql() and moved it to the bottom.Dries Buytaert2005-04-14
|
* - Patch by Adrian: postgresql fixesDries Buytaert2005-04-14
|
* - Patch #19965 by Robin Monks: fixed problem with duplicate block titles.Dries Buytaert2005-04-12
|
* - Patch #19298 by Jeremy: loose caching!Dries Buytaert2005-04-11
| | | | | | Drupal's existing caching mechanism doesn't perform well on highly dynamic websites in which the cache is flushed frequently. One example is a site that is under attack by a spambot that is posting spam comments every few seconds, causing all cached pages to be flushed every few seconds. Loose caching immediately flushes the cache only for specific users who have modified cached data (whether or not they are logged in), delaying the flushing of data for other users by several minutes. (I rewrote the help text a bit and made minor changes to the code comments.)
* - Patch #19697 by Morbus: FOLKSONOMY.Dries Buytaert2005-04-08
| | | | | | | | | | | This patch adds folksonomy support to Drupal (named internally as "Free tagging"). In a nutshell, the core difference is the input method: unlike normal taxonomies which are administratively controlled, a "free tagging" vocabulary allows tag creation when the node is submitted. It does this through an text input box, as opposed to a dropdown or selectbox. This patch: * Removes the useless "Preview form" of a vocabulary. * Alters the vocabulary table to include a new "tags" column. * Adds a new "Free tagging" preference on vocabulary creation/editing. * Modifies the vocabulary overview to support pagers for free tagging vocabs. The new code integrates tightly with the existing taxonomy code. The only additional processing occurs on node save and edit, where we parse through the tags associated with a node. All other display (and thus, code) remains the same.
* - Added missing }Dries Buytaert2005-04-08
|
* - Fixed bug #19432, modified patch from Junyor: database update fails when a ↵Dries Buytaert2005-04-08
| | | | name contains a quote.
* - Patch #19768 by danielc: line 593 in version 1.109 of database.pgsql is ↵Dries Buytaert2005-04-03
| | | | problematic. The line creates a unique index for sid. But, sid is already a primary key so doesn't need a unique index on it. Let alone, the syntax is wrong due to wrapping the table name in {}'s. This patch removes the line.
* - Updated the start date of the updates.Dries Buytaert2005-03-23
|
* - Patch by Matt and chx: improved performance of taxonomy queries. When manyDries Buytaert2005-03-23
| | | | terms are matched, the query would become very slow.
* - Bug #18597: updated the database scheme. Renamed poll.voters to poll.polled.Dries Buytaert2005-03-20
|
* - #18597: Resolve conflict in column name between queue.module and poll.module.Steven Wittens2005-03-18
|
* - Patch #12497 by Morbus: Just working on a profile reporting idea and ↵Dries Buytaert2005-03-16
| | | | | | | | | spotted that the following fields appear to have incorrect type definitions: profile_values.fid = int(11) profile_values.uid = int(11) These both appear inconsistant with the rest of the database (that I have seen i.e. user tables) where they are defined as int(10). The profile_fields.fid is defined as int(10) also.
* - Fixed parse error.Dries Buytaert2005-03-03
|
* - Better upgrade path. Suggested by Neil.Dries Buytaert2005-03-03
|
* - Modified patch #18328 by Neil: currently the two forum topic blocks share ↵Dries Buytaert2005-03-03
| | | | a number of topics in block setting. This is a bit confusing since configuring one blockshould not affect another block. Fixed some indentation as well.
* #17747: PGSQL improvementsSteven Wittens2005-02-28
|
* - 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.
* - The update for the twin comments was 'borken' and had several bugs.Dries Buytaert2005-02-27
|
* - Patch #17747 by Adrian: first round of PostgreSQL updates!Dries Buytaert2005-02-23
|
* - 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 #10425 by ccourtne and walkah: added admin screens to maintain ↵Dries Buytaert2005-01-28
| | | | forums instead of forcing the user to add a taxonomy.
* - Patch by andre: fixed typo: type -> types.Dries Buytaert2005-01-27
|
* - Patch #16074 by Andre Molnar: add configuration option to show blocks only ↵Dries Buytaert2005-01-27
| | | | on pages of certain node type.
* - Patch #16237 by Neil: removed dead code from page.module.Dries Buytaert2005-01-26
|
* - Wrong update slipped in.Dries Buytaert2005-01-25
|
* - Patch #16021 by tangent: changed the format "/blog/feed/52" to ↵Dries Buytaert2005-01-25
| | | | "/blog/52/feed".
* - Modified patch #14170 by Neil: improved default workflow (default node ↵Dries Buytaert2005-01-24
| | | | | | type) configuration page. Modified the patch to remove some redundant code, to translate strings, and to better use the menu system.
* - Patch #15962 by Goba: fixed the association between the accesslog data and ↵Dries Buytaert2005-01-23
| | | | the nodes.
* - Patch #15962 by Goba: no need to drop the accesslog table to add a new ↵Dries Buytaert2005-01-22
| | | | primary key.
* - 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 #15337 by Gerhard: fixed a broken date query in the database scheme.Dries Buytaert2005-01-09
|
* - 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.
* - Changed aid from tinyint to int.Dries Buytaert2004-11-28
|
* - 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
|
* oopsDries Buytaert2004-11-08
|
* - Remove old variables from variable-table.Dries Buytaert2004-11-08
|
* - Performance improvement: made 'sid' the primary key of the sessions table.Dries Buytaert2004-11-07
| | | | | | | | | That should improve performance of session handling as well improve performance of the "Who's online"-block. Drupal.org's sessions table contains appr. 40.000 sessions on a slow day and rendering the "Who's online"-block became a performance bottleneck. This change has yet to be tested on a busy site so things might go wrong.
* - Patch #12232 by Steven: more search improvements:Dries Buytaert2004-11-04
| | | | | | | | + When a comment is posted, a node needs to be re-indexed. Luckily, we can use node_comment_statistics for this easily. + When a node is deleted, it should be deleted from the search index as well. + The search wipe didn't properly remove links to nodes from the index. + Section url was faulty in _help. + Minor code rearrangement.
* - Patch by Steven:Dries Buytaert2004-11-03
| | | | | | | | | | | + Display 'friendly' name rather than module name in search watchdog messages. + Remove left-over from search_total table. + Add index wipe button to the admin + Moved the admin to admin/settings/search + Prevented menu bug when node modules update the breadcrumb in view (thanks JonBob). + Changed search_total table's word key to PRIMARY.
* - Patch #11875 by Neil Drumm: block module configuration improvements.Dries Buytaert2004-10-31
| | | | | | | | | | The primary goal of this patch is to take the 'custom' and 'path' columns of the block overview page and make them into something understandable. As of Drupal 4.5 'custom' lacked an explanation which wasn't buried in help text and path required dealing with regular expressions. Every block now has a configuration page to control these options. This gives more space to make form controls which do not require a lengthy explanation. This page also gives modules a chance to put their block configuration options in a place that makes sense using new operations in the block hook. The only required changes to modules implementing hook_block() is to be careful about what is returned. Do not return anything if $op is not 'list' or 'view'. Once this change is made, modules will still be compatible with Drupal 4.5. Required changes to core modules are included in this path. An additional optional change to modules is to implement the additional $op options added. 'configure' should return a string containing the configuration form for the block with the appropriate $delta. 'configure save' will come with an additional $edit argument, which will contain the submitted form data for saving. These changes to core modules are also included in this patch.
* - Patch #12232 by Steven/UnConed: search module improvements.Dries Buytaert2004-10-31
| | | | | | | | | | | | | | | | | | | | | | 1) Clean up the text analyser: make it handle UTF-8 and all sorts of characters. The word splitter now does intelligent splitting into words and supports all Unicode characters. It has smart handling of acronyms, URLs, dates, ... 2) It now indexes the filtered output, which means it can take advantage of HTML tags. Meaningful tags (headers, strong, em, ...) are analysed and used to boost certain words scores. This has the side-effect of allowing the indexing of PHP nodes. 3) Link analyser for node links. The HTML analyser also checks for links. If they point to a node on the current site (handles path aliases) then the link's words are counted as part of the target node. This helps bring out commonly linked FAQs and answers to the top of the results. 4) Index comments along with the node. This means that the search can make a difference between a single node/comment about 'X' and a whole thread about 'X'. It also makes the search results much shorter and more relevant (before this patch, comments were even shown first). 5) We now keep track of total counts as well as a per item count for a word. This allows us to divide the word score by the total before adding up the scores for different words, and automatically makes noisewords have less influence than rare words. This dramatically improves the relevancy of multiword searches. This also makes the disadvantage of now using OR searching instead of AND searching less problematic. 6) Includes support for text preprocessors through a hook. This is required to index Chinese and Japanese, because these languages do not use spaces between words. An external utility can be used to split these into words through a simple wrapper module. Other uses could be spell checking (although it would have no UI). 7) Indexing is now regulated: only a certain amount of items will be indexed per cron run. This prevents PHP from running out of memory or timing out. This also makes the reindexing required for this patch automatic. I also added an index coverage estimate to the search admin screen. 8) Code cleanup! Moved all the search stuff from common.inc into search.module, rewired some hooks and simplified the functions used. The search form and results now also use valid XHTML and form_ functions. The search admin was moved from search/configure to admin/search for consistency. 9) Improved search output: we also show much more info per item: date, author, node type, amount of comments and a cool dynamic excerpt à la Google. The search form is now much more simpler and the help is only displayed as tips when no search results are found. 10) By moving all search logic to SQL, I was able to add a pager to the search results. This improves usability and performance dramatically.
* - Patch #11728 by Uwe Hermann: fixed some typos in the code comments, ↵Dries Buytaert2004-10-19
| | | | | | Doxygen documentation and screen output. Uwe: I dropped the 'iff' chunks as 'iff' stands for 'if and only if'.