summaryrefslogtreecommitdiff
path: root/installer/install.sql
AgeCommit message (Collapse)Author
2010-09-01One more adjustment for ticket #1216. The packaging process forcesBharat Mediratta
the default email address for admin to be unknown@unknown.com and when that happens the gallery_event::user_updated() event listener fires and sets the default values. This is hard to work around, so let's just roll with it and use unknown@unknown.com as our default placeholder. So now, if an admin sets their email address and the current values are unknown@unknown.com we adopt the admin's email address for the site's mail_from/reply_to fields.
2010-08-31Don't use HTTP_HOST to get the hostname. We force that toBharat Mediratta
"example.com" when we are using the CLI so we'll get inconsistent behavior between CLI and the web interface. For now hardcode it to be example.com so that it's clear. But to do it right we need an after_install step which actually fixes it up. And probably an after_upgrade step as well.
2010-08-31Update the install sql to correspond to the change to fix ticket #1216Tim Almdal
2010-08-29Bump gallery module to v36 and add a favicon_url variable, which weBharat Mediratta
expose in Admin > Appearance > Theme Options and defaults to lib/images/favicon.ico. Thix fixes ticket #1312.
2010-08-28Add a "visible_title_length" variable that defaults to 15 and use thatBharat Mediratta
as the max title length when we do title truncation in the wind theme. Bump the gallery module to 35.
2010-08-28Oops, forgot to create an install() function and set the version ofBharat Mediratta
the organize module to 2 in 8fb56abf034dd1f5c561e7af12bf6e097a3de6f6
2010-08-14Add a key on access_caches.item_id. Without this, the Fix task queryBharat Mediratta
to find missing access_caches is very slow. Bump Gallery module to v34.
2010-08-14Update install.sql for gallery module version 3. This was left out ofBharat Mediratta
779d91cca01567a09b894e9fff4dfa32cb82d3d9 but it doesn't cause any real damage, it just means that anybody who got the code in the intervening window and did an initial install required an upgrade as well.
2010-08-06Add a "weight" column to the module table. This allows us to specifyBharat Mediratta
module ordering, which is currently being done in the moduleorder contrib module. By default, the weight will be the same as the id of the row which means that new modules will get added at the end of the list. This is covered in the upgrade case as well. The one gotcha is that we need to make sure that we don't try to sort by the weight column if the gallery module version is < 32, which is something we haven't done before.
2010-08-01Updated for gallery module v31.Bharat Mediratta
2010-06-18Update the installer/install.sql properly.Tim Almdal
2010-06-18Fix ticket #1155. For compatibility with gallery2 increase the size of the ↵Tim Almdal
tag name field from 64 bytes to 128 bytes.
2010-06-15Install the rest module by default.Bharat Mediratta
2010-06-15New dump generated by new mysqladmin has a slightly different format:Bharat Mediratta
mysqladmin Ver 8.42 Distrib 5.1.47, for debian-linux-gnu on i486 Also, updated for comment module v2.
2010-02-22Fix for ticket #1027: Add index on cache key column.Andy Staudacher
(and fix the packager to truncate the cache table before packaging)
2010-02-14Fix for ticket 901: Wrap Gallery version string into bdo tag to override the ↵Andy Staudacher
BiDi algorithm. Also, properly marking the "Powere by" string for translation. See: http://www.w3.org/International/tutorials/bidi-xhtml/#Slide0420
2010-02-09Refresh installer codeAndy Staudacher
2010-02-07Fix installer code for version 27, and introduce new module variable in ↵Andy Staudacher
version 28 as a preparation for admin area compartmentalization.
2010-01-30Update install.sql -- gallery version jumps from 23 to 25 due to a mistakeBharat Mediratta
in the version 24 upgrade code. Update packager to serialize files so that we can serialize the new .htaccess files Update init_var.php to include the newly serialized .htaccess files. Fixes ticket #587.
2010-01-30Gallery module version 23, with the failed_logins table.Bharat Mediratta
2010-01-29Oops, somebody (me?) forgot to update the gallery module versionBharat Mediratta
number in gallery_installer::install() so the install.sql was out of sync.
2010-01-28Updated for model based validation. We must now provide a placeholderBharat Mediratta
email address for the admin user, since one is required for all users.
2010-01-11Fixes ticket #671.Tim Almdal
In the graphics_rules table height and width set the maximum height and width values and should be equal. Initially, the height on the resize target rule was less than the height, which artificially constrained images in portrait mode. **Note"" this fix requires an upgrade to version 22. All the resizes will be flagged dirty.
2010-01-01Don't enable the rest module by default yet; we should make sure thatBharat Mediratta
we do a more thorough security audit on it first.
2010-01-01Change the installer so that the rest module is automatically installed in ↵Tim Almdal
new installations.
2009-12-05Use NULL instead of actual values in the vars table, so that varBharat Mediratta
tweaks result in smaller diffs.
2009-12-05Update the gallery module to version 21 in the installer.Bharat Mediratta
2009-11-19Revert "Update the installer to reflect the new location of the theme ↵Tim Almdal
related options." This reverts commit 678e22996d73b96833c48d94751344a6bd8f2899.
2009-11-18Update the installer to reflect the new location of the theme related options.Tim Almdal
2009-11-13Standardize the name of the blocks.Tim Almdal
2009-11-13Undo using the md5 hash of the module name and block_id, so duplicate blocks ↵Tim Almdal
are no allowed again
2009-11-12Re-generate the install.sql so that the keys of the block lists are an md5 ↵Tim Almdal
hash of the module_name:block_id. Also change the packager so we delete the _cache variable for the module gallery not core.
2009-11-12Change the keys of the block arrays in block manager to be a md5 hash of ↵Tim Almdal
module_name:block_id. This allows easier lookup of blocks to remove when modules are being deactivated. Change the module activation/deactivation to call (activate|deactivate)_blocks instead of just the sidebar blocks. This insures that when a module is deactivated any admin dashboard blocks are removed as well the site sideboard blocks. Fix for ticket #876.
2009-10-26Update the install.sql to reflect the current version number(16) and the ↵Tim Almdal
refactoring of the user module into an idnetity provider
2009-10-23Poor man's merge. Note to self, git pull before working. Next pound the ↵Chad Kieffer
steps to merge into your head.
2009-10-21Change the default install.sql such that the owner id of root album is the ↵Tim Almdal
defined admin (id = 2)
2009-09-27Change gallery installer to do a direct update to the database, preppending ↵Tim Almdal
gallery_graphics:: to each of the defined rules operations
2009-09-27This path requires the upgrader to be run and applies the following changes:Tim Almdal
* moves the composite method back into core * requires that the operation be fully qualified i.e. gallery_graphics::resize * caches the graphics rules on each request
2009-09-27Fix one more place in the installer where we referring to the old defaultBharat Mediratta
theme names. Update installer.sql
2009-09-16Changed the search module installer to explicitly specify MyISAM as the ↵Tim Almdal
database type. Changed the packager to not remove the engine specification if the table is search_records. Fixes Ticket #774
2009-09-08Update to gallery module v12.Bharat Mediratta
2009-09-01Updated for modules/gallery version 11.Bharat Mediratta
2009-08-27Remove 'ENGINE=InnoDB' specification from tables that we create. UseBharat Mediratta
the system's default table specification. Fixes ticket #597.
2009-07-29Updated for gallery v10Bharat Mediratta
2009-07-26Updating install.sql with the packaging script, basically re-adding the ↵Andy Staudacher
charset (utf8) expressions that were removed by merging in rledisez's left/right -> left_ptr/right_ptr changes.
2009-07-25Rename columns that use reserved SQL words : items.left and items.rightRomain LE DISEZ
2009-07-23Updated version of installer sql:Bharat Mediratta
- gallery_version is gone - access related columns are now binary (Postgres) - for some reason we've reverted back to the /*!40101*/ style settings in mysqldump.
2009-07-23Use BOOLEAN instead of integer to describe the permissions :Romain LE DISEZ
- DENY = false - ALLOW = true - UNKNOW = null (for intent only) - INHERIT = null (for cache) Upgrade is not included for now. (cherry picked from commit 719c59e0402464a0e2b14915f6d10218ff5d4729)
2009-07-11Turn off extended inserts when creating install.sql so that it'sBharat Mediratta
easier to see what's changed.
2009-07-11MySQL 5 generates backwards compatible code-containing comments so:Bharat Mediratta
SET character_set_client = @saved_cs_client; becomes: /*!40101 SET character_set_client = @saved_cs_client */; for MySQL 4.0.1-01 and newer.