aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
2009-05-14Fixed geocode stuff + version bumpmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@3289 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-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: 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-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-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
2008-08-04Closes #193: Added salt field to database and new users will be generated ↵marcus
with salted passwords. Existing users remain unchanged and should still be able to log in. Requires a schema change and the following code run against the database: alter table elggusers_entity add column salt varchar(8) NOT NULL default '' after password; git-svn-id: https://code.elgg.org/elgg/trunk@1676 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-25Fixing access collections tablemarcus
git-svn-id: https://code.elgg.org/elgg/trunk@1541 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-24Introducing the (still issue-packed) friend picker.ben
git-svn-id: https://code.elgg.org/elgg/trunk@1511 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-18Moved container_guid to entities, modified a bunch of functions.ben
git-svn-id: https://code.elgg.org/elgg/trunk@1473 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-18Fixed a bug with the revamped access collectionsben
git-svn-id: https://code.elgg.org/elgg/trunk@1467 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-18Added auto increment initial val. Fixes #171ben
git-svn-id: https://code.elgg.org/elgg/trunk@1463 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-17access_collections now auto_incrementben
git-svn-id: https://code.elgg.org/elgg/trunk@1461 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-17access_groups -> access_collectionsben
git-svn-id: https://code.elgg.org/elgg/trunk@1459 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-04Fixed regressionmarcus
git-svn-id: https://code.elgg.org/elgg/trunk@1296 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-02Typo on database tablemarcus
git-svn-id: https://code.elgg.org/elgg/trunk@1267 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-01Added groups, refs #106marcus
git-svn-id: https://code.elgg.org/elgg/trunk@1230 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-01Fix for the schemaben
git-svn-id: https://code.elgg.org/elgg/trunk@1229 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-07-01Refs #106: Added schemamarcus
git-svn-id: https://code.elgg.org/elgg/trunk@1213 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-19Fixes #54 - 'Enabled' functionality needs to be added to metadata, refs #53marcus
git-svn-id: https://code.elgg.org/elgg/trunk@986 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-19Added 'enabled' field to annotations. Refs #51ben
git-svn-id: https://code.elgg.org/elgg/trunk@984 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-18Fixes #12: Active variable on entities table. Update db schema.marcus
git-svn-id: https://code.elgg.org/elgg/trunk@980 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-18Fixes #41: User full text search. See caveats in function search_for_user()marcus
git-svn-id: https://code.elgg.org/elgg/trunk@967 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-16CLOSED - #26: Lengthing metadata fields marcus
http://trac.elgg.org/elgg/ticket/26 git-svn-id: https://code.elgg.org/elgg/trunk@934 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-10Added an explicit conversion to MyISAM in the db tables when a FULLTEXT key ↵ben
is used. git-svn-id: https://code.elgg.org/elgg/trunk@857 36083f99-b078-4883-b0ff-0f9b5a30f544