aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
AgeCommit message (Collapse)Author
2009-12-31Removed lock tables from db utf8 migration because it fails on some (all?) ↵brettp
servers. git-svn-id: http://code.elgg.org/elgg/trunk@3781 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-11-12fixes #1329 - schema for river is fixed - was incomplete beforecash
git-svn-id: http://code.elgg.org/elgg/trunk@3667 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-11-06removed space which would break the schema parsing routine for the next poor ↵cash
sucker who tried to add a table - not the most robust code git-svn-id: http://code.elgg.org/elgg/trunk@3629 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-10-28Got rid of the silly conditional comments in the db upgrade now that I know ↵brettp
what they are. git-svn-id: http://code.elgg.org/elgg/trunk@3595 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-10-28Added table locking and disabling keys for the UTF8 database upgrade.brettp
git-svn-id: http://code.elgg.org/elgg/trunk@3594 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-10-09Reverted back to previous copy removing Justin's search because of views ↵brettp
problems in plugins. git-svn-id: http://code.elgg.org/elgg/trunk@3521 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-10-09Pulled in Justin's search changes from github.brettp
git-svn-id: http://code.elgg.org/elgg/trunk@3520 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-10-07Fixes #1181: UTF8 now correctly stored in database.brettp
git-svn-id: http://code.elgg.org/elgg/trunk@3514 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-09-21New river code added to allow user comment to be pulled out and displayeddave
git-svn-id: http://code.elgg.org/elgg/trunk@3490 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-08-20Whoa nelly this is a big one: Removed license and copyright for files.brettp
git-svn-id: https://code.elgg.org/elgg/trunk@3427 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-05-22Closes #1030: Group title and description search added, refs #965marcus
git-svn-id: https://code.elgg.org/elgg/trunk@3300 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-05-14Fixed geocode stuff + version bumpmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@3289 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-02-13Closes #761, #718: Group permissions now made much much simpler.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2744 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-02-12Schema fixben
git-svn-id: https://code.elgg.org/elgg/trunk@2728 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-02-12Alternative river system trial. This is a test.ben
git-svn-id: https://code.elgg.org/elgg/trunk@2723 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-01-23Refs #706marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2611 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-01-09Closes #668: Banning now works through a flag in the users_entity table. ↵marcus
Database upgrade required. * Added ElggUser::isBanned(); * Added 'banned' column to users_entity * Modified ban() and unban() * Modified pam functions to check $user->isBanned() * Modified login() to check $user->isBanned() * Modified sessions_init() to check isBanned() and destroy session accordingly * Modified profile views to highlight banned users and prevent menus for non-admin users. git-svn-id: https://code.elgg.org/elgg/trunk@2554 36083f99-b078-4883-b0ff-0f9b5a30f544
2009-01-08Closes #666: Added some extra indexesmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2543 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-12-08Fixes #615marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2513 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-12-05Closes #611: Made name field longermarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2506 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-12-04Fixed update scriptmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2502 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-26Closes #571: Widgets now use private store for settingsmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2491 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-25Hook for future geocoding library added.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2488 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-25git-svn-id: https://code.elgg.org/elgg/trunk@2487 ↵marcus
36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-20Refs #569, #570, #571: Update script for both users and plugins plugin settingsmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2477 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-20Migrate plugin settings from plugin to new settigns store.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2476 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-20Refs #569, #570, #571: Minor database schema errors correctedmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2474 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-20Refs #569, #570, #571: Minor database schema errors correctedmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2472 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-19Introducing the new private settings table.ben
git-svn-id: https://code.elgg.org/elgg/trunk@2464 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-06datalists now has primary key, datalist set function optimisedmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2417 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-11-03Some missing keys added.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2380 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-22Removed unnecessary columnmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2293 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-22Semi-working session code. Still won't permit logging in, commented out ↵marcus
until there is time to fix. Problem seems to be based around the action_gatekeeper() and the values set for the __elgg_session. Removing this component from the key causes the token to be valid. My feeling is that the session is not being saved or loaded correctly. git-svn-id: https://code.elgg.org/elgg/trunk@2291 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-21Database session code.marcus
IMPORTANT NOTE: The trigger for this is commented out, so old session code is used. There are serious problems with using the new code since it causes a chicken and egg problem with the upgrade script. git-svn-id: https://code.elgg.org/elgg/trunk@2289 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-17Changes to access any system log code. Introducing owner guid on items which ↵marcus
is necessary for access control. Requires upgrade.php to be run git-svn-id: https://code.elgg.org/elgg/trunk@2278 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-16Closes #442: Requires schema upgrade. Side effect - friends activity rivers ↵marcus
will be blanked. git-svn-id: https://code.elgg.org/elgg/trunk@2267 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-07Bugfixes to river scriptmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2212 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-07Added river key to main schemamarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2211 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-06Closes #402 and #407 : Right! Finally nailed this fscking issue to the wall ↵marcus
(hopefully). Modified system log to hold extra information about the class being stored, this lets us pull only the required rows from the event log. This drastically simplifies and speeds up the query. Requires: Database upgrade. Outstanding issues: Query is using filesort despite using correct index. Still much faster than the last method! git-svn-id: https://code.elgg.org/elgg/trunk@2194 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-10-06Refs #402 and #407: Extra fields added to system_logmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@2188 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-23The database schema will now automatically update itself on upgrade.ben
git-svn-id: https://code.elgg.org/elgg/trunk@2107 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-23Database upgrade script from 1.0 to latest schema.ben
git-svn-id: https://code.elgg.org/elgg/trunk@2104 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-17Added hmac cache of hmacs we have seen before (MEMORY TABLE)marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2090 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-17Added hmac cache of hmacs we have seen before (MEMORY TABLE)marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2089 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-17Changed users_apisessions to use memory, since there is no reason to store ↵marcus
this forever. git-svn-id: https://code.elgg.org/elgg/trunk@2087 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-15Marcus Povey:marcus
* Some missing indexes added to database. * Removed privileged path table since this is no longer used. git-svn-id: https://code.elgg.org/elgg/trunk@2084 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-09-02Set default db to UTF 8... for what it's worth.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2052 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-08-19Fixes #260: Done. Nice spot.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@2014 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-08-11Usernames now uniquemarcus
git-svn-id: https://code.elgg.org/elgg/trunk@1833 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-08-10Closes #223marcus
git-svn-id: https://code.elgg.org/elgg/trunk@1816 36083f99-b078-4883-b0ff-0f9b5a30f544