summaryrefslogtreecommitdiff
path: root/installer/install.sql
AgeCommit message (Collapse)Author
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.
2009-05-14Introduce a relative_path_cache column in the items table. This letsBharat Mediratta
us avoid doing lots of MPTT lookups to find the parent path when we're trying to generate thumbnails, etc. Invalidate the cache at all the right times. This greatly reduces our query count on album page views. This fixes ticket #40.
2009-05-13Create a new "add" permission and require it at the controller levelBharat Mediratta
when adding photos/movies/albums
2009-05-13updated to reflect tinyint(2) -> smallint(6) changeBharat Mediratta
2009-05-07Grab photo capture date and captions from EXIF/IPTC data.Bharat Mediratta
- Add a "captured" column to the items table. - Pull the DateTime EXIF field and put it into the captured column - Pull the Caption EXIF & IPTC fields and put them into the description field if there was not already a value there
2009-04-28Root album weight is now 1; Organize module is auto-activated; search_record ↵Bharat Mediratta
has a key on item_id
2009-04-05Don't do graphics detection in core_installer::install() because thatBharat Mediratta
gets run at scaffolding::package() time, not on the target machine. Instead, create a core module variable to trigger running graphics::choose_default_toolkit() on the first admin login after install. Fixes ticket #206.
2009-04-05Add a weight column to the items model. Change the album ordering toTim Almdal
use this as the default instead of id. This prepares the way for manual reordering in the organize functionality.
2009-03-20Oops, we need UNIX_TIMESTAMP() instead of NOW()Bharat Mediratta
2009-03-20Do some data normalization so that the install files will have stableBharat Mediratta
ordering and known values. This way subsequent packaging runs won't have any differences unless there's a real data change.
2009-03-16Revive the install() and uninstall() functions in Scaffold_ControllerBharat Mediratta
because we need those to make a package. Fix the packaging code to ignore whatever prefix is being used by the developer who is doing the packaging. Update the install.sql file (there were a variety of small inconsistencies, probably from hand-editing. Don't hand-edit this file!)
2009-03-09Restructure the sort order to maintain the sort column and sort orderTim Almdal
as two separate columns in the item table.
2009-03-09On second thought, make the description column varchar(2048) instead.Bharat Mediratta
If I understand correctly, this is better for performance. I could be wrong here, though.
2009-03-09Make the description a text column so that we can handle much largerBharat Mediratta
descriptions.
2009-03-08Log the user in as admin after running the web installer, and giveBharat Mediratta
them a nice "Welcome to Gallery 3" dialog. The text in there needs a little work but it's a start. In the process, re-build the install.sql using the scaffolding code.
2009-03-08Implement Sortable albums. Current sort fields include (CreationTim Almdal
Date, Update Date, Random Key, Title, Mime Type, Item Type & Number of views)
2009-03-02Forgot to update the install.sql when i changed the [] to {} toTim Almdal
identify table names that need substitution.
2009-02-27Both the command line and web installer installer now supportsTim Almdal
creating tables with a table prefix. There are still some queries that haven't been converted, so don't start using prefixes yet. However, if you do, you can login and modify the user profile.
2009-02-27* Refactor task management methods from admin_maintenance.php toTim Almdal
task.php * Added a owner_id field to the task database * Modified the admin maintenace to show the owner of the task <<**** Requires a reinstallation of core ****>>
2009-02-26Update to image_block based on bharat's feedbackTim Almdal
1) move the rand_key column into core 2) don't do a max rand, just try to a get a random number less than the current random number if that doesn't successd look the other way
2009-02-23A couple of references to media_rss that were overlookedTim Almdal
2009-02-23Changing from binary(16) to char(32) as translation message key.Andy Staudacher
Although less efficient as a storage / transmission / comparison format, it's friendlier on the eyes and universally supported.
2009-02-10Move site default_locale into DB (vars) and add a per user locale preference.Andy Staudacher
There's no UI to select the locale yet.
2009-02-09Add local localization functionality. Local = no means to upload / download ↵Andy Staudacher
translations to a translation server yet. - Added an outgoing_translations table to store translations from the local translation UI. - I18n class is checking incoming_ and outgoing_translations for translations, giving the latter priority. - Not handling plural strings in the translations UI yet.
2009-01-20Web based installer. It's still got some rough edges, but you can nowBharat Mediratta
do a complete CLI or web based install.
2009-01-19Fix up various little things to get File_Structure_Test to pass.Bharat Mediratta
2009-01-19Flush the access_intent cache after ALTER TABLE queries, fixes aBharat Mediratta
problem where the install.sql had the wrong view permissions.
2009-01-19Packager now does a clean reinstall of just the packages we want, thenBharat Mediratta
rebuilds the install.sql and init_var.php files accordingly.
2009-01-19Simplification pass over the installer:Bharat Mediratta
- Flattened the directory structure - Greatly simplified structure in installer; it now only reports environmental checks that fail. Simplified code that prints exceptions. Use only mysql calls for the installer, but select mysqli automatically if it's available. Drop the response file; that's easily replicated with flag support - Create a random password for the admin user - Delete unused controllers - Invert the form of the database config template to be mostly non-PHP with just a few PHP calls