My Semantic MediaWiki installation version 1.8.0.4 that uses mySQL store (the default one, I suppose) has the following tables:
- smw_attributes
- smw_atts2
- smw_conc2
- smw_conccache
- smw_concept_cache
- smw_di_blob
- smw_di_bool
- smw_di_coords
- smw_di_number
- smw_di_time
- smw_di_uri
- smw_di_wikipage
- smw_fpt_ask
- smw_fpt_askde
- smw_fpt_askfo
- smw_fpt_asksi
- smw_fpt_askst
- smw_fpt_cdat
- smw_fpt_conc
- smw_fpt_conv
- smw_fpt_impo
- smw_fpt_inst
- smw_fpt_ledt
- smw_fpt_list
- smw_fpt_mdat
- smw_fpt_newp
- smw_fpt_pval
- smw_fpt_redi
- smw_fpt_serv
- smw_fpt_sf_af
- smw_fpt_sf_df
- smw_fpt_sobj
- smw_fpt_subc
- smw_fpt_subp
- smw_fpt_type
- smw_fpt_unit
- smw_fpt_uri
- smw_ids
- smw_inst2
- smw_longstrings
- smw_nary
- smw_nary_attributes
- smw_nary_longstrings
- smw_nary_relations
- smw_object_ids
- smw_prop_stats
- smw_redi2
- smw_relations
- smw_rels2
- smw_spec2
- smw_specialprops
- smw_subp2
- smw_subprops
- smw_subs2
- smw_text2
Which of them can I safely drop?
Either you do it with the script (see here 4.) or manually (see there - paragraph below 13.) Cheers
Thank you. I removed "smw_ids", "smw_conccache", "smw_rels2", "smw_atts2", "smw_text2", "smw_spec2", "smw_subs2", "smw_subp2", "smw_inst2", "smw_redi2", "smw_conc2" and "sm_coords". However, there are still many. Are they all used by SQLStore3?
Yes, and if you set up fixed properties you can have even more. :)