aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
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
2008-06-05Marcus Povey <marcus@dushka.co.uk>icewing
* System log performs the id of the user who performed a given action (or 0 if no user was logged in). Update your DB schema. git-svn-id: https://code.elgg.org/elgg/trunk@814 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-06-02Marcus Povey <marcus@dushka.co.uk>icewing
* Privileged path check to privileged function execution. ... i really don't like this exception stuff. I think it would be better to say that you can't access stuff you can't access. git-svn-id: https://code.elgg.org/elgg/trunk@767 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-27Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed DB code git-svn-id: https://code.elgg.org/elgg/trunk@725 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-23Marcus Povey <marcus@dushka.co.uk>icewing
* Support for river entries git-svn-id: https://code.elgg.org/elgg/trunk@701 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-23Marcus Povey <marcus@dushka.co.uk>icewing
* Added access_id git-svn-id: https://code.elgg.org/elgg/trunk@697 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-22Marcus Povey <marcus@dushka.co.uk>icewing
* Added system_log table git-svn-id: https://code.elgg.org/elgg/trunk@684 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-01Major site config changesben
git-svn-id: https://code.elgg.org/elgg/trunk@615 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-05-01Schema update for configurationben
git-svn-id: https://code.elgg.org/elgg/trunk@612 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-04-24The beginnings of a db upgrade system. See lib/version.php, /version.php and ↵ben
the datalist functions in elgglib.php. git-svn-id: https://code.elgg.org/elgg/trunk@519 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-04-21Removing extraneous character from schemaben
git-svn-id: https://code.elgg.org/elgg/trunk@497 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-04-21Added site_guid to the entities tableben
git-svn-id: https://code.elgg.org/elgg/trunk@496 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-04-14Marcus Povey <marcus@dushka.co.uk>icewing
* Relationships table brought in line with code... oops git-svn-id: https://code.elgg.org/elgg/trunk@440 36083f99-b078-4883-b0ff-0f9b5a30f544