Maintenance script "setupStore.php" example (no parameter)
From semantic-mediawiki.org
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
- ^ Semantic MediaWiki: GitHub pull request gh:smw:4403