aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
AgeCommit message (Collapse)Author
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