Maintenance script "setupStore.php" example (no parameter)

From semantic-mediawiki.org
< Maintenance script "setup­Store.php"
Maintenance script "setup­Store.php"Maintenance script "setupStore.php" example (no parameter)

The following command either updates an existing Storage Engine for use with Semantic MediaWiki or sets it up:

Shell command
php path/to/extensions/SemanticMediaWiki/maintenance/setupStore.php
Prompt shown

The prompt shown gives an example of the output by Semantic MediaWiki 3.2.0Released on 7 September 2020 and compatible with MW 1.31.0 - 1.35.x. and later1:

Semantic MediaWiki:                                             3.2.0-alpha
MediaWiki:                                                           1.34.0

--- Indices setup ---------------------------------------------------------

Query engine:                                               SMWElasticStore

Checking indices ...
   ... smw-data-db9907120150926-02100_ ...                                ✓
   ... smw-lookup-db9907120150926-02100_ ...                              ✓
   ... done.

--- Database setup --------------------------------------------------------

Storage engine:                                                SMWSQLStore3
Database:                          mysql (10.1.44-MariaDB-0ubuntu0.18.04.1)

Checking database version requirement ...
   ... done.

------------------------------------------------------ Core table(s) ------

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.
   ... changing to a CHARSET utf8 field type ... done.
   ... field smw_sort is fine.
   ... field smw_proptable_hash is fine.
   ... field smw_hash is fine.
   ... field smw_rev is fine.
   ... field smw_touched 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.
   ... index smw_iw,smw_id is fine.
   ... index smw_hash,smw_id is fine.
   ... index smw_sort,smw_id is fine.
   ... index smw_namespace,smw_sortkey is fine.
   ... index smw_rev,smw_id is fine.
   ... index smw_touched,smw_id is fine.
   ... done.
Checking table smw_object_aux ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_seqmap is fine.
   ... done.
Checking index structures for table smw_object_aux ...
   ... index smw_id 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.
   ... field null_count is fine.
   ... done.
Checking index structures for table smw_prop_stats ...
   ... index p_id is fine.
   ... index usage_count is fine.
   ... index null_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.
   ... index s_id,p_id,o_sortkey is fine.
   ... index p_id,o_serialized is fine.
   ... index 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_di_blob ...
   ... index s_id,p_id is fine.
   ... index s_id,o_hash is fine.
   ... index o_hash is fine.
   ... index p_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 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_di_uri ...
   ... index s_id,p_id is fine.
   ... index p_id,o_serialized is fine.
   ... index 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.
   ... index s_id,p_id,o_sortkey,o_serialized is fine.
   ... index p_id,o_serialized is fine.
   ... index 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.
   ... index o_serialized 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 o_id is fine.
   ... index s_id,o_id is fine.
   ... index s_id,p_id,o_id is fine.
   ... index o_id,s_id is fine.
   ... index o_id,p_id is fine.
   ... index p_id,s_id is fine.
   ... done.
Checking table smw_fpt_type ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_fpt_type ...
   ... index s_id is fine.
   ... index o_serialized is fine.
   ... done.
Checking table smw_fpt_uri ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_fpt_uri ...
   ... index s_id is fine.
   ... index o_serialized 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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id is fine.
   ... done.
Checking table smw_fpt_unit ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_impo ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id 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_conv ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_serv ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_pval ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_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_dtitle ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_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.
   ... index s_id,o_id is fine.
   ... index o_id,s_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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id 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_list ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id is fine.
   ... done.
Checking table smw_fpt_askst ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_askfo ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_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_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_askpa ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_fpt_askpa ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_fpt_lcode ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id 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_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_attch_link ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_id is fine.
   ... done.
Checking index structures for table smw_fpt_attch_link ...
   ... index s_id is fine.
   ... index o_id is fine.
   ... index s_id,o_id is fine.
   ... index o_id,s_id 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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id is fine.
   ... done.
Checking table smw_fpt_media ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.

---------------------------------------------------- Custom table(s) ------

Checking table smw_fpt_sci_cite_key ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... index s_id,o_id is fine.
   ... index o_id,s_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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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_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_pagelgth ...
   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_pagelgth ...
   ... 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.
   ... index s_id,o_id is fine.
   ... index o_id,s_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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id is fine.
   ... done.
Checking table smw_ftp_sesp_views ...
   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_views ...
   ... index s_id is fine.
   ... index o_sortkey 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.
   ... index s_id,o_id is fine.
   ... index o_id,s_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_userblock ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_ftp_sesp_userblock ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_ftp_sesp_userright ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_ftp_sesp_userright ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash is fine.
   ... done.
Checking table smw_ftp_sesp_usergroup ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... done.
Checking index structures for table smw_ftp_sesp_usergroup ...
   ... index s_id is fine.
   ... index o_hash is fine.
   ... index s_id,o_hash 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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id is fine.
   ... done.
Checking table smw_fpt_2irek341litg ...
   Table already exists, checking structure ...
   ... field s_id is fine.
   ... field o_blob is fine.
   ... changing to a CHARSET utf8 field type ... done.
   ... 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.
   ... index s_id,o_id is fine.
   ... index o_id,s_id is fine.
   ... done.

--- Post-creation examination ---------------------------------------------

Checking selected fixed properties IDs ...
   ... done.
Checking internal properties border ...
   ... space for internal properties allocated ...                        ✓
   ... done.
Checking predefined properties ...
   ... initialize predefined properties ...
   ... done.
Checking smw_hash field consistency ...
   ... updating the setup file key ...                                    ✓
   ... done.
Checking smw_sortkey, smw_sort fields ...
   ... done.
Checking smw_touched field ...
   ... done.

--- Table optimization ----------------------------------------------------

The optimization task can take a moment to complete and depending on the
database backend, tables can be locked during the operation.

------------------------------------------------------ Core table(s) ------

Checking table ...
   ... smw_object_ids ...                               [ANALYZE, OPTIMIZE]
   ... smw_object_aux ...                               [ANALYZE, OPTIMIZE]
   ... smw_concept_cache ...                            [ANALYZE, OPTIMIZE]
   ... smw_query_links ...                              [ANALYZE, OPTIMIZE]
   ... smw_ft_search ...                                [ANALYZE, OPTIMIZE]
   ... smw_prop_stats ...                               [ANALYZE, OPTIMIZE]
   ... smw_di_number ...                                [ANALYZE, OPTIMIZE]
   ... smw_di_blob ...                                  [ANALYZE, OPTIMIZE]
   ... smw_di_bool ...                                  [ANALYZE, OPTIMIZE]
   ... smw_di_uri ...                                   [ANALYZE, OPTIMIZE]
   ... smw_di_time ...                                  [ANALYZE, OPTIMIZE]
   ... smw_di_coords ...                                [ANALYZE, OPTIMIZE]
   ... smw_di_wikipage ...                              [ANALYZE, OPTIMIZE]
   ... smw_fpt_type ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_uri ...                                  [ANALYZE, OPTIMIZE]
   ... smw_fpt_inst ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_unit ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_impo ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_pplb ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_prec ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_conv ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_serv ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_pval ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_redi ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_dtitle ...                               [ANALYZE, OPTIMIZE]
   ... smw_fpt_subp ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_subc ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_conc ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_list ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_ask ...                                  [ANALYZE, OPTIMIZE]
   ... smw_fpt_askst ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_askfo ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_asksi ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_askde ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_askpa ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_lcode ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_text ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_sobj ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_askdu ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_mdat ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_attch_link ...                           [ANALYZE, OPTIMIZE]
   ... smw_fpt_cdat ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_newp ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_ledt ...                                 [ANALYZE, OPTIMIZE]
   ... smw_fpt_media ...                                [ANALYZE, OPTIMIZE]
   ... smw_fpt_mime ...                                 [ANALYZE, OPTIMIZE]
   ... done.

---------------------------------------------------- Custom table(s) ------

Checking table ...
   ... smw_fpt_sci_cite_key ...                         [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_cite_reference ...                   [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_cite_text ...                        [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_cite ...                             [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_doi ...                              [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_pmcid ...                            [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_pmid ...                             [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_oclc ...                             [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_viaf ...                             [ANALYZE, OPTIMIZE]
   ... smw_fpt_sci_olid ...                             [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_pageid ...                          [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_pagelgth ...                        [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_euser ...                           [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_cuser ...                           [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_views ...                           [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_subp ...                            [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_nrev ...                            [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_ntrev ...                           [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_userreg ...                         [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_usereditcnt ...                     [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_userblock ...                       [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_userright ...                       [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_usergroup ...                       [ANALYZE, OPTIMIZE]
   ... smw_ftp_sesp_exifdata ...                        [ANALYZE, OPTIMIZE]
   ... smw_fpt_2irek341litg ...                         [ANALYZE, OPTIMIZE]
   ... smw_fpt_46esbjipj510 ...                         [ANALYZE, OPTIMIZE]
   ... done.

--- Supplement jobs -------------------------------------------------------

Adding jobs ...
   ... Property statistics rebuild job ...                                ✓
   ... Entity disposer job ...                                            ✓
   ... done.

--- AfterCreateTablesComplete (Hook) --------------------------------------

Task(s) registered via the hook depend on the functionality implemented and
may take a comment to complete.

-------------------------------------------------------- Import task(s) ---

Importing from smw.vocab.json ...
   ... MediaWiki:Smw import skos ...                          [EXISTS,SKIP]
   ... MediaWiki:Smw import foaf ...                          [EXISTS,SKIP]
   ... MediaWiki:Smw import owl ...                           [EXISTS,SKIP]
   ... Attribut:Foaf:knows ...                                [EXISTS,SKIP]
   ... Attribut:Foaf:name ...                                 [EXISTS,SKIP]
   ... Attribut:Foaf:homepage ...                             [EXISTS,SKIP]
   ... Attribut:Owl:differentFrom ...                         [EXISTS,SKIP]
   ... done.

Importing from smw.groups.json ...
   ... smw/schema:Group:Schema properties ...              [EXISTS,REPLACE]
   ... done.

--- Summary ---------------------------------------------------------------

- Create (or checking) table(s) .................................. 0.28 sec
- Post-creation examination ...................................... 0.55 sec
- Table optimization ............................................ 31.02 sec
- Supplement jobs ................................................ 0.02 sec
- AfterCreateTablesComplete (Hook) ............................... 0.26 sec

References

  1. ^  Semantic MediaWiki: GitHub pull request gh:smw:4403