Help:Special:SemanticMediaWiki/Database installation and upgrade/Example output

This page shows an example output after using the database installation and upgrade function of special page "SemanticMediaWiki". The printout is actually identical to what a wiki's system administrator will get prompted on the shell when using maintenance script "setupStore.php" directly (recommended).

Selected storage engine is "SMWSQLStore3" (or an extension thereof)

Setting up standard database configuration for SMW ...

Checking table smw_object_ids ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_namespace is fine.
   ... field smw_title is fine.
   ... field smw_iw is fine.
   ... field smw_subobject is fine.
   ... field smw_sortkey is fine.
   ... field smw_proptable_hash is fine.
   ... done.
Checking index structures for table smw_object_ids ...
   ... index smw_id is fine.
   ... index smw_id,smw_sortkey is fine.
   ... index smw_iw is fine.
   ... index smw_title,smw_namespace,smw_iw,smw_subobject is fine.
   ... index smw_sortkey is fine.
   ... done.
Checking table smw_concept_cache ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_concept_cache ...
   ... index o_id is fine.
   ... done.
Checking table smw_query_links ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_query_links ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... index s_id,o_id is fine.
   ... done.
Checking table smw_ft_search ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_text is fine.
   ... field o_sort is fine.
   ... done.
Checking index structures for table smw_ft_search ...
   ... index s_id is fine.
   ... index p_id is fine.
   ... index o_sort is fine.
   ... index o_text is fine.
   ... done.
Checking table smw_prop_stats ...
   Table already exists, checking structure ...
   ... field p_id is fine.
   ... field usage_count is fine.
   ... done.
Checking index structures for table smw_prop_stats ...
   ... index p_id is fine.
   ... index usage_count is fine.
   ... done.
Checking table smw_di_number ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_di_number ...
   ... index s_id,p_id is fine.
   ... index p_id,o_sortkey is fine.
   ... done.
Checking table smw_di_blob ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_di_blob ...
   ... index s_id,p_id is fine.
   ... index p_id,o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_di_bool ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_value is fine.
   ... done.
Checking index structures for table smw_di_bool ...
   ... index s_id,p_id is fine.
   ... index p_id,o_value is fine.
   ... done.
Checking table smw_di_uri ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_blob is fine.
   ... field o_serialized is fine.
   ... done.
Checking index structures for table smw_di_uri ...
   ... index s_id,p_id is fine.
   ... index p_id,o_serialized is fine.
   ... done.
Checking table smw_di_time ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_di_time ...
   ... index s_id,p_id is fine.
   ... index p_id,o_sortkey is fine.
   ... done.
Checking table smw_di_coords ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_serialized is fine.
   ... field o_lat is fine.
   ... field o_lon is fine.
   ... done.
Checking index structures for table smw_di_coords ...
   ... index s_id,p_id is fine.
   ... index p_id,o_serialized is fine.
   ... index o_lat,o_lon is fine.
   ... done.
Checking table smw_di_wikipage ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field p_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_di_wikipage ...
   ... index s_id,p_id is fine.
   ... index p_id,o_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_type ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_serialized is fine.
   ... done.
Checking index structures for table smw_fpt_type ...
   ... index s_id is fine.
   ... index o_serialized is fine.
   ... done.
Checking table smw_fpt_unit ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_unit ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_conv ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_conv ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_pval ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_pval ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_list ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_list ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_serv ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_serv ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_prec ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_fpt_prec ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_fpt_pplb ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_pplb ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_ask ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_ask ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_askde ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_fpt_askde ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_fpt_asksi ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_fpt_asksi ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_fpt_askfo ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_askfo ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_askst ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_askst ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_askdu ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_fpt_askdu ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_fpt_subp ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_subp ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_subc ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_subc ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_inst ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_inst ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_redi ...
   Table already exists, checking structure ...
   ... field s_title is fine.
   ... field s_namespace is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_redi ...
   ... index s_title,s_namespace is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_sobj ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_sobj ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_impo ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_impo ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_uri ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_serialized is fine.
   ... done.
Checking index structures for table smw_fpt_uri ...
   ... index s_id is fine.
   ... index o_serialized is fine.
   ... done.
Checking table smw_fpt_conc ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field concept_txt is fine.
   ... field concept_docu is fine.
   ... field concept_features is fine.
   ... field concept_size is fine.
   ... field concept_depth is fine.
   ... field cache_date is fine.
   ... field cache_count is fine.
   ... done.
Checking index structures for table smw_fpt_conc ...
   ... index s_id is fine.
   ... done.
Checking table smw_fpt_lcode ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_lcode ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_text ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_text ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_dtitle ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_dtitle ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_mdat ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_fpt_mdat ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_fpt_cdat ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_fpt_cdat ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_fpt_newp ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_value is fine.
   ... done.
Checking index structures for table smw_fpt_newp ...
   ... index s_id is fine.
   ... index o_value is fine.
   ... done.
Checking table smw_fpt_ledt ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_ledt ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_media ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_media ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_mime ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_mime ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_cite_key ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_cite_key ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_cite_reference ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_cite_reference ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_cite_text ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_cite_text ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_cite ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_sci_cite ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_fpt_sci_doi ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_doi ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_pmcid ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_pmcid ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_pmid ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_pmid ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_oclc ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_oclc ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_viaf ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_viaf ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_sci_olid ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_sci_olid ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_2irek341litg ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... field o_hash is fine.
   ... done.
Checking index structures for table smw_fpt_2irek341litg ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_46esbjipj510 ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_46esbjipj510 ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_ftp_sesp_revid ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_revid ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_ftp_sesp_pageid ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_pageid ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_ftp_sesp_euser ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_euser ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_ftp_sesp_cuser ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_cuser ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_ftp_sesp_subp ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_subp ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking table smw_ftp_sesp_nrev ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_nrev ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_ftp_sesp_ntrev ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_ntrev ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_ftp_sesp_userreg ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_userreg ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_ftp_sesp_usereditcnt ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_serialized is fine.
   ... field o_sortkey is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_usereditcnt ...
   ... index s_id is fine.
   ... index o_sortkey is fine.
   ... done.
Checking table smw_ftp_sesp_exifdata ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_ftp_sesp_exifdata ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... done.
Checking predefined properties ...
   ... space for internal properties already allocated.
   ... writing properties ...
   ... done.

Database initialized completed.