aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
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
2008-03-03Installation issues: fixedben
git-svn-id: https://code.elgg.org/elgg/trunk@57 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-02-15All kinds of object and database stuffben
git-svn-id: https://code.elgg.org/elgg/trunk@44 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-02-15Added the concept of a site_id to msot of the database tables. Also some ↵ben
extra installation stuff. git-svn-id: https://code.elgg.org/elgg/trunk@43 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-02-15Adding more plugin-related funben
git-svn-id: https://code.elgg.org/elgg/trunk@41 36083f99-b078-4883-b0ff-0f9b5a30f544
2008-02-14Actions, .htaccess, and the database schemaben
git-svn-id: https://code.elgg.org/elgg/trunk@31 36083f99-b078-4883-b0ff-0f9b5a30f544