aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
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
2008-04-08Marcus Povey <marcus@dushka.co.uk>icewing
* Simplified extender types, now only supports integer and text - types deamed not to be necessary (yet), also simplifies import and export. * Types better detected. git-svn-id: https://code.elgg.org/elgg/trunk@424 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-04-02Marcus Povey <marcus@dushka.co.uk>icewing
* BUGFIX: User creation * User import functionality working git-svn-id: https://code.elgg.org/elgg/trunk@358 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-27Marcus Povey <marcus@dushka.co.uk>icewing
* Removed sql restriction to allow multiple tag entries git-svn-id: https://code.elgg.org/elgg/trunk@271 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-25Marcus Povey <marcus@dushka.co.uk>icewing
* Subtype subclass instantiation git-svn-id: https://code.elgg.org/elgg/trunk@269 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-20Marcus Povey <marcus@dushka.co.uk>icewing
* Annotations now using metastrings table for name_ids * Stupid amounts of whitespace removed git-svn-id: https://code.elgg.org/elgg/trunk@261 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-20Marcus Povey <marcus@dushka.co.uk>icewing
* Metadata now using metastrings * Entities will now throw an exception when creation is attempted with no owner git-svn-id: https://code.elgg.org/elgg/trunk@260 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-18Marcus Povey <marcus@dushka.co.uk>icewing
* Value to value_id git-svn-id: https://code.elgg.org/elgg/trunk@242 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-17Marcus Povey <marcus@dushka.co.uk>icewing
* guid not needed in subtype since this is just a label. git-svn-id: https://code.elgg.org/elgg/trunk@237 36083f99-b078-4883-b0ff-0f9b5a30f544
generated by cgit v1.2.3 (git 2.39.1) at 2024-07-04 07:13:01 +0000