summaryrefslogtreecommitdiff
path: root/installer/install.sql
AgeCommit message (Collapse)Author
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