Maintenance script "setupStore.php" example (--skip-import parameter)

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

The following command either updates an existing Storage Engine for use with Semantic MediaWiki or sets it up while at the same time skipping the import of data. Usually the --skip-import parameter is chosen if the respective content was already imported or the import is not desired, e.g. when doing the recommended weekly or monthly data table optimization via cron.

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

The prompt shown gives an example of the output by Semantic MediaWiki 3.2.0Released on an unknown date and compatible with unknown versions of MediaWiki. 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) ---

Import support was not enabled (or skipped), stopping the task.

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

- Create (or checking) table(s) .................................. 0.21 sec
- Post-creation examination ...................................... 0.61 sec
- Table optimization ............................................ 29.30 sec
- Supplement jobs ................................................ 0.02 sec
- AfterCreateTablesComplete (Hook) ............................... 0.00 sec

References

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