Database schema - Moving from 1.12 to 2.x and looking forward to 3.0
Hi,
I know that Elgg 3.0 is set to include a "database schema overhaul". I'm looking for documentation on the new schema.
Also, are there any changes to the database when upgrading from 1.12 to the latest stable version (2.x)?
We have over 100 million rows in our Entities table and need to ensure a smooth upgrade
Thanks for your help!
Feedback and Planning
Discussions about the past, present, and future of Elgg and this community site.
- Jeroen Dalsem@jdalsem
Jeroen Dalsem - 2 likes
- denormalizing metadata/annotations (the table metastring will dissapear)
- site_guid column will dissapear for entities
- config and datalist tables will be merged
- removal of entity type specific tables (not yet finished)
- Steve Clay@steve_clay
Steve Clay - 2 likes
You must log in to post replies.Elgg 3.0 will indeed include some schema changes. They are related to
Elgg will provide migration scripts to move all the data around. If you have no multisite installation, no customizations on the tables and are using the Elgg API for accessing the data, it should cause not that many problems. Nonetheless going from Elgg 2.x to 3.0 will be an update that requires attention.
Schema diff 2.3 to master.