aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
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
2008-03-11Marcus Povey <marcus@dushka.co.uk>icewing
* Removed count based on this conversation: [10:05:38] … basically, if you add an item, you need to create a tag entry in the metastrings table (as discussed yesterday) [10:05:56] … if you then delete the item, that leaves a tag [10:06:07] … if you want to delete the tag when nothing references it [10:06:11] … it needs a counter [10:06:29] … which means for every add and delete query you need to check for and sometimes update this counter [10:06:36] … making three queries for every one [10:06:47] … but if you don't do that the meta strings table grows over time [10:06:54] … making it space inefficient [10:07:03] … so, which do you do? [10:10:31] … ? [10:10:43] … i'd be tempted to not delete [10:10:58] … because the multiple queries will be a pain for everyone all the time [10:11:05] … and storage costs are cheap [10:11:32] Ben Werdmuller: I would be very tempted to do the same [10:11:35] … so let's do that :) [10:11:36] Marcus Povey: maybe we could write an admin script to clean up or something [10:11:45] Ben Werdmuller: exactly, we could clean up on a cron if people really want [10:11:59] … but for now, let's just go with the growing tag cloud git-svn-id: https://code.elgg.org/elgg/trunk@149 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-10Marcus Povey <marcus@dushka.co.uk>icewing
* Added count git-svn-id: https://code.elgg.org/elgg/trunk@146 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-10Marcus Povey <marcus@dushka.co.uk>icewing
* Changed metadata database to use metastrings as described (all values in metadata are now storing data only once) git-svn-id: https://code.elgg.org/elgg/trunk@145 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-10Marcus Povey <marcus@dushka.co.uk>icewing
* Tokens and execute code added to api git-svn-id: https://code.elgg.org/elgg/trunk@140 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-09git-svn-id: https://code.elgg.org/elgg/trunk@122 ↵icewing
36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-09Marcus Povey <marcus@dushka.co.uk>icewing
* Corrected database fault git-svn-id: https://code.elgg.org/elgg/trunk@121 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-07Users and friendsben
git-svn-id: https://code.elgg.org/elgg/trunk@108 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-07Marcus Povey <marcus@dushka.co.uk>icewing
* Initial work on API git-svn-id: https://code.elgg.org/elgg/trunk@106 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-06git-svn-id: https://code.elgg.org/elgg/trunk@85 ↵icewing
36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-06Marcus Povey <marcus@dushka.co.uk>icewing
* Removed write access id on sites since it seemed superfluous git-svn-id: https://code.elgg.org/elgg/trunk@84 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-05Added owner id to metadataicewing
git-svn-id: https://code.elgg.org/elgg/trunk@75 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-04Added metadata and annotations, removed superfluous tables.icewing
git-svn-id: https://code.elgg.org/elgg/trunk@70 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-03-03new site dbicewing
git-svn-id: https://code.elgg.org/elgg/trunk@64 36083f99-b078-4883-b0ff-0f9b5a30f544