summaryrefslogtreecommitdiff
path: root/installer/install.sql
AgeCommit message (Collapse)Author
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.
2009-06-28Set the gallery module version to 6 in install() (missed this in my last ↵Bharat Mediratta
change). Refresh the install.sql.
2009-06-27Updated for module upgrades:Bharat Mediratta
gallery 2 -> 3 comment 1 -> 2
2009-06-23Refactor the install/upgrade code to be more flexible.Bharat Mediratta
Add xxx_installer::upgrade($version) method so that upgrade stanzas are separate from install stanzas. In the old code, to do an upgrade meant that you had to re-evolve everything from the initial install because we'd step through each version's changes. But what we really want is for the initial install to start off in the perfect initial state, and the upgrades to do the work behind the scenes. So now the install() function gets things set up properly the first time, and the upgrade() function does any work to catch you up to the latest code. See gallery_installer.php for a good example.
2009-06-20Fix a bug in gallery_installer where on an initial install we wereBharat Mediratta
only implementing schema version 1. This caused install.sql to be populated from version 1 which meant that after install you'd have to run the upgrader. No harm done, and the pattern is fixed for the future. Alphabetize the tables so it's easier to find stuff.
2009-06-05Update version to beta 1Bharat Mediratta
2009-06-01Normalize the random values used in the blocks_dashboard_xxx vars soBharat Mediratta
that install.sql is more stable.
2009-05-29Move the code that was in the scaffolding to package the initial mySql ↵tim almdal
database and var directory to a seperate standalone file in the installer. This will save the current database environment and restore it when the packaging is complete
2009-05-29Move credits message into a variable, which can be changed in Admin >Bharat Mediratta
Settings > Advanced. It's stored in the variable as an internationalized string and localized at output time.
2009-05-27Normalize root update time in the installerBharat Mediratta
Rebuild install.sql
2009-05-27Manually updated to change 'core' to 'gallery'Bharat Mediratta
2009-05-26Restructure the module lifecycle.Bharat Mediratta
Install: <module>_installer::install() is called, any necessary tables are created. Activate: <module>_installer::activate() is called. Module controllers are routable, helpers are accessible, etc. The module is in use. Deactivate: <module>_installer::deactivate() is called. Module code is not accessible or routable. Module is *not* in use, but its tables are still around. Uninstall: <module>_installer::uninstall() is called. Module is completely removed from the database. Admin > Modules will install and activate modules, but will only deactivate (will NOT uninstall modules).
2009-05-20Add a default image quality level. There's no UI for it, except AdminBharat Mediratta
> Settings > Advanced. The default is 75.
2009-05-17Add var/tmpBharat Mediratta
2009-05-14Cache variables in core._cache so that we can retrieve them all in aBharat Mediratta
single query. In most cases, we were fetching 4-5 variables per page load, so this is 2-3x faster.