summaryrefslogtreecommitdiff
path: root/database/database.mysql
Commit message (Collapse)AuthorAge
* - 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.
* - Changed the type of the string fields in the locale table to BLOB.Dries Buytaert2003-05-24
| | | | | This fixes bug #987. For PostgreSQL this is not required because its string comparisons are case-senitive. Not idea about MSSQL.
* - 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.
* - 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.
* - Added missing tid-column to the forum table. Patch by Anarcat.Dries Buytaert2003-04-13
|
* - Added missing 'created' field to 'cache' table.Dries Buytaert2003-03-19
|
* - The link field got accidentically removed. Thanks Stephane.Dries Buytaert2003-03-18
|
* - All LIMIT queries must go through the pager or through db_query_range().Dries Buytaert2003-03-16
| | | | | | | | | | | | | | | The syntax for db_query_range() was enhanced so it matches db_query(). So you may pass extra arguments of the SQL statement which are checked via check_query() and then substituted into the SQL statement. After these optional arguments, you always pass $from and $count parameters which define your range. Most often, the $from is 0 and the count is the max number of records you want returned. Patch by Moshe. - The pager_query() function for PEAR was enhanced so that it adds proper GROUP BY statement counting the number of records to be paged. Patch by James Arthur. - MSSQL database scheme by Moshe.
* - Removing the menu table: it is no longer used.Dries Buytaert2003-02-24
| | | | [TODO: update 'update.php'.]
* - database.mysql cannot be run from within phpMyAdmin because of lineDries Buytaert2003-02-24
| | | | consisting of hyphens only. Patch by Zbynek.
* - Fixed typo: forum2 -> forum.Dries Buytaert2003-02-07
|
* - 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
|
* 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.
* - Added Stefan's page module improvements.Dries Buytaert2002-11-20
| | | | [NOTE: the PostgreSQL database scheme needs updating.]
* - Updated the PostgreSQL database scheme (thanks James) and the MySQLDries Buytaert2002-11-09
| | | | database scheme.
* - Wrapped some hardcoded colors in "theme_invoke()"s; we can still createDries Buytaert2002-10-22
| | | | | | | | a drupal_error() later on but I think we better get used to theme_invoke(). - Fixed translation bug. Patch by Moshe. - Fixed PHP warning. Patch by ax.
* - removed function module_rehash().Kjartan Mannes2002-10-17
| | | | | - updated database dump. - removed tables modules, layout and referrer (don't forget to backup!).
* - serializing update_start variable.Kjartan Mannes2002-09-25
|
* - Changed "$watchdog->message" from type "varchar(255)" to type "text".Dries Buytaert2002-08-26
| | | | | Patch by James. For sake of consistency, I updated the MySQL scheme and added a new update entry to "update.php".
* - Fixed typo. Patch by Marco.Dries Buytaert2002-08-21
|
* - Applied a (modified) version of Marco's SQL sequence patch.Dries Buytaert2002-08-20
|
* - Made the rating module and its SQL table ASNI compliant. Patch by jaa.Dries Buytaert2002-08-16
|
* - removing cvs table definition.Kjartan Mannes2002-07-31
|
* - feed table should have not null defined for refresh and timestamp.Kjartan Mannes2002-07-31
|
* - Patch my Marco: "session in my users table is actually varchar(32), which ↵Dries Buytaert2002-07-13
| | | | is small. locale data was greater and so was not correctly recorded. strangely, update_11() in update.php reads: update_sql("ALTER TABLE users ADD session TEXT;"); but in database.mysql.inc, line 496 session varchar(32) NOT NULL default '', so the update fails."
* - fixed the markup of the collapsed comment view settings.Kjartan Mannes2002-06-15
| | | | | - updated update.php and database.mysql disable a few more modules by default. Without the config options in place to disable things this might confuse users.
* - Removed non-existing theme from both update.php and database.mysql. PatchDries Buytaert2002-06-08
| | | | by Marco.
* - Changed some "default NULL"s to "default NOT NULL"s as this only works onDries Buytaert2002-06-06
| | | | | | | | | | | | | | | | | | recent MySQL versions. I included the diffs for review. update.php: - update_sql("CREATE TABLE search_index (word varchar(50) default NULL, lno in + update_sql("CREATE TABLE search_index (word varchar(50) default NOT NULL, ln database.mysql: - word varchar(50) default NULL, - lno int(10) unsigned default NULL, - type varchar(16) default NULL, - count int(10) unsigned default NULL, + word varchar(50) NOT NULL, + lno int(10) unsigned NOT NULL, + type varchar(16) default NULL, + count int(10) unsigned default NULL,
* - adding descriptions to modules (thanks Joe + Scott).Kjartan Mannes2002-06-01
| | | | | | | | | | - fixed comment flat list view missing 1 comment. - changed update.php around a bit. * security check isn't in effect if the db hasn't been updated. * instructions re-organized. * fixed some minor updates. - updated database.mysql done by UnConeD. - changelog update.
* - Ran the code through 'scripts/code-clean.sh': removed trailing whitespaceDries Buytaert2002-05-20
| | | | (and possibly tabs).
* - fixing a typoKjartan Mannes2002-05-16
|
* - Haven't re-implemented custom in the main tree. Oops.Kjartan Mannes2002-04-29
|
* - updating database.mysql definition.Kjartan Mannes2002-04-29
|
* Poll.module:Steven Wittens2002-04-21
| | | | Forgot to change a 'lid' into a 'nid'
* Updated poll.module:Steven Wittens2002-04-20
| | | | | - Removed obsolete lid column (changed update.php and database.mysql) - Added short help
* - Added Marco's long-awaited taxonmy module and patches - a replacementDries Buytaert2002-04-14
| | | | | | | | | | | | | | | | | | | for the meta system. The patches add some extra functionality to the comment system (for example, comments can be set read-only) and fix a couple of small problems. + I integrated the required SQL updates from the varius *.mysql files into the "update.php" script. Upgrading should be easy ... + I did not apply/commit the "user.diff" as requested by Marco ... + I didn't know what to do with "forum.module" and "forum2.module": what do you want me to do with it Marco? Which one should go in? + Can we remove "node_index()" now; both from "node.module" and the themes? + Thanks Marco!
* - added default value to enable user block to update.phpKjartan Mannes2002-01-27
| | | | | - did a new dump of the database from a clean upgrade as my local devel is a little infected with additional tables.
* - updating database/database.mysql again. Forgot to remove some contribKjartan Mannes2002-01-21
| | | | module tables.
* - moved user block from theme.inc to user.module.Kjartan Mannes2002-01-21
| | | | | | | | | | * only problem is that the admin.php link is not available until the admin enables the block. * $theme->user is obsolete, will patch the themes properly in a later patch. - moved moderation block from theme.inc to queue.module. * removed theme_moderation_results(). - updated database/database.mysql.
* - Changed the authentication and login scheme as discussed on the mailingDries Buytaert2001-08-11
| | | | | | list. - Fixed the export function in book.module (patch my Julian). - Fixed the comment alignment (comments got truncated).
* database.mysqlKjartan Mannes2001-07-24
| | | | - Added link to the SQL definition.
* - Added blog.module to replace diary.module (contrubeted by Julian):Dries Buytaert2001-07-11
| | | | | | | | | | | | + feedback wanted - Added updated import.module (contributed by Julian): + user page do browse the headlines by feed and bundle, to display the item descriptions, etc. - Fixed small bug in common.inc. - Updated database.mysql
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-27 14:06:55 +0000