aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
AgeCommit message (Collapse)Author
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
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
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* Access control fields ok git-svn-id: https://code.elgg.org/elgg/trunk@209 36083f99-b078-4883-b0ff-0f9b5a30f544