aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
2011-03-17Fixes #3123. Datalists and config names can now be up to 255 chars long. ↵brettp
Debug mode is disabled when caching views to avoid saving bad stuff. git-svn-id: http://code.elgg.org/elgg/trunk@8746 36083f99-b078-4883-b0ff-0f9b5a30f544
2010-08-21Merged r6534-6559 from 1.7 branch to trunkcash
git-svn-id: http://code.elgg.org/elgg/trunk@6840 36083f99-b078-4883-b0ff-0f9b5a30f544
2010-04-05Merged 5605:5622 from 1.7 to trunk.brettp
git-svn-id: http://code.elgg.org/elgg/trunk@5623 36083f99-b078-4883-b0ff-0f9b5a30f544
2010-03-02Fixes #1562: Added a default value for entities.last_action in the schema ↵brettp
and as an upgraded. Bumped version number to 1.7 final. git-svn-id: http://code.elgg.org/elgg/trunk@3984 36083f99-b078-4883-b0ff-0f9b5a30f544
2010-02-06Fixes #1493: Updated schema to set auto_increment IDs for access_collections ↵brettp
to 3 to avoid overwriting default values with group / shared access ACLs. git-svn-id: http://code.elgg.org/elgg/trunk@3912 36083f99-b078-4883-b0ff-0f9b5a30f544
2010-01-29Added db migration 2010012901 that adds last_action column to entities table.brettp
Bumped version number to 1.7b (2010012901). git-svn-id: http://code.elgg.org/elgg/trunk@3857 36083f99-b078-4883-b0ff-0f9b5a30f544
2010-01-10Fixes #1432: Version number is set during installation.brettp
Refs #1424: The upgrade functions now detect if no version number is saved to the db and silences all upgrade warnings and errors. This is required for all installations < this commit to upgrade correctly because of #1432. More strict regex for finding upgrade files. Upgrade mysql.sql schema with latest. git-svn-id: http://code.elgg.org/elgg/trunk@3791 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-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-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