Symphony.

Something doesn't seem right about the tables created with the default workspace:

sym_authors
sym_cache
sym_entries
sym_entries_data_26
sym_entries_data_27
sym_entries_data_29
sym_entries_data_30
sym_entries_data_31
sym_entries_data_34
sym_entries_data_35
sym_entries_data_36
sym_entries_data_37
sym_entries_data_38
sym_entries_data_39
sym_entries_data_40
sym_entries_data_41
sym_entries_data_43
sym_entries_data_44
sym_entries_data_45
sym_entries_data_46
sym_entries_data_47
sym_entries_data_48
sym_entries_data_49
sym_entries_data_50
sym_entries_data_51
sym_entries_data_54
sym_extensions
sym_extensions_delegates
sym_fields
sym_fields_author
sym_fields_checkbox
sym_fields_date
sym_fields_input
sym_fields_sectionlink
sym_fields_select
sym_fields_taglist
sym_fields_textarea
sym_fields_upload
sym_forgotpass
sym_pages
sym_pages_types
sym_sections
sym_sections_association

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.