aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
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
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* Added access groups git-svn-id: https://code.elgg.org/elgg/trunk@207 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* Made URL unique git-svn-id: https://code.elgg.org/elgg/trunk@202 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* Removed site_guid references, since this should be handled by relationships git-svn-id: https://code.elgg.org/elgg/trunk@198 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* Changed a couple of table names git-svn-id: https://code.elgg.org/elgg/trunk@196 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* A little bit of extra info. git-svn-id: https://code.elgg.org/elgg/trunk@193 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* Made subtype a unique key git-svn-id: https://code.elgg.org/elgg/trunk@192 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-13Marcus Povey <marcus@dushka.co.uk>icewing
* New database schema. THIS IS A FLAG DAY! git-svn-id: https://code.elgg.org/elgg/trunk@191 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-12Marcus Povey <marcus@dushka.co.uk>icewing
* object_* changed to entity_* in metadata and annotations git-svn-id: https://code.elgg.org/elgg/trunk@182 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-12Fixing incorrect primary keyben
git-svn-id: https://code.elgg.org/elgg/trunk@181 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-12Fixing incorrect primary keyben
git-svn-id: https://code.elgg.org/elgg/trunk@180 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-12Marcus Povey <marcus@dushka.co.uk>icewing
* object_* changed to entity_* in metadata and annotations git-svn-id: https://code.elgg.org/elgg/trunk@178 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-11Marcus Povey <marcus@dushka.co.uk>icewing
* Added metadata/metastrings tag stuff. Lorks. git-svn-id: https://code.elgg.org/elgg/trunk@151 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-11Marcus Povey <marcus@dushka.co.uk>icewing
* Fixed db problems git-svn-id: https://code.elgg.org/elgg/trunk@150 36083f99-b078-4883-b0ff-0f9b5a30f544