Database Tables in default workspace
This is an open discussion with 5 replies, filed under General.
Search
I've made a bug report regarding this. This should be related.
Or.. perhaps not. I noticed that sym_authors was included. My problem was that a missing default value prevented all the other tables to be included. Is the weirdness from the _data_* tables?
I have posted a bug report about the "crippled database". I am rather sure that certain obscurities in the system are related to this.
Actually, that table structure is normal. The data_*
tables represent the data associated with each field added in the system. The DB scales better by having each field's data in a separate table. If you create a new field, it will create a new table. This is a common method of scaling, and prevents trying to LEFT JOIN
tables with lots of irrelevant data, which just slows things down.
Thank you, Alistair.
Don't mind those "obscurities" I mentioned. Images and section linking did not to work, but since I did another fresh install (without .svn files and with permissions carefully set) everything's fine.
I am deeply impressed by Symphony 2.
Create an account or sign in to comment.
Something doesn't seem right about the tables created with the default workspace: