先日構築した apache v2.2+php v.5.6.31環境へwordPress ver.4.0.17 をinstall。
今回は、単にinstallするだけで、より深い調査は別途
end0tknr.hateblo.jp
create database と download wordpress
$ /usr/local/mysql/bin/mysql -u root
mysql> CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8;
$ cd /home/endo/dev/Test
$ wget https://wordpress.org/wordpress-4.0.17.tar.gz
$ tar -zxvf wordpress-4.0.17.tar.gz
fileの変化点
自動でinstallされるのは、楽チンですが、何が起こっているのか、
不安?ですので、diffとってみました。以下、diff抜粋です。
ver.4.0.17 -> 4.0.18 に自動updateされたみたい
$ diff -r wordpress_org wordpress
diff -r wordpress_org/readme.html wordpress/readme.html
< <br /> Version 4.0.17
> <br /> Version 4.0.18
なんだか、ゴチャゴチャ変更されていましたが、ver.4.0.17 -> 4.0.18 の影響のようですね。
changelogを読めば、詳細を理解できると思いますが、今回は割愛。
diff -r wordpress_org/wp-admin/about.php wordpress/wp-admin/about.php
< <h3><?php echo _n( 'Maintenance and Security Release', 'Maintenance and Security Releases', 17 ); ?></h3>
> <h3><?php echo _n( 'Maintenance and Security Release', 'Maintenance and Security Releases', 18 ); ?></h3>
:
diff -r wordpress_org/wp-admin/includes/file.php wordpress/wp-admin/includes/file.php
:
< $credentials['hostname'] = defined('FTP_HOST') ? FTP_HOST : (!empty($_POST['hostname']) ? wp_unslash( $_POST['hostname'] ) : $credentials['hostname']);
< $credentials['username'] = defined('FTP_USER') ? FTP_USER : (!empty($_POST['username']) ? wp_unslash( $_POST['username'] ) : $credentials['username']);
< $credentials['password'] = defined('FTP_PASS') ? FTP_PASS : (!empty($_POST['password']) ? wp_unslash( $_POST['password'] ) : '');
---
> $credentials['hostname'] = defined('FTP_HOST') ? FTP_HOST : (!empty($submitted_form['hostname']) ? $submitted_form['hostname'] : $credentials['hostname']);
> $credentials['username'] = defined('FTP_USER') ? FTP_USER : (!empty($submitted_form['username']) ? $submitted_form['username'] : $credentials['username']);
> $credentials['password'] = defined('FTP_PASS') ? FTP_PASS : (!empty($submitted_form['password']) ? $submitted_form['password'] : '');
:
diff -r wordpress_org/wp-includes/class-wp-customize-manager.php wordpress/wp-includes/class-wp-customize-manager.php
:
diff -r wordpress_org/wp-includes/class-wp-xmlrpc-server.php wordpress/wp-includes/class-wp-xmlrpc-server.php
:
diff -r wordpress_org/wp-includes/version.php wordpress/wp-includes/version.php
< $wp_version = '4.0.17';
> $wp_version = '4.0.18';
Only in wordpress/wp-content: upgrade
jsもゴチャゴチャ変更されていましたが、こちらもver.4.0.17 -> 4.0.18 の影響のようですね。
diff -r wordpress_org/wp-admin/js/customize-controls.js wordpress/wp-admin/js/customize-controls.js
:
diff -r wordpress_org/wp-admin/js/customize-controls.min.js wordpress/wp-admin/js/customize-controls.min.js
:
diff -r wordpress_org/wp-includes/js/plupload/handlers.js wordpress/wp-includes/js/plupload/handlers.js
:
diff -r wordpress_org/wp-includes/js/plupload/handlers.min.js wordpress/wp-includes/js/plupload/handlers.min.js
:
ブラウザで日本語を選択すると、言語packも wordpressが自動downloadするみたい
Only in wordpress/wp-content: languages
db接続情報等は、 wp-config.php に記載されていました。
Only in wordpress: wp-config.php
databaseの変化点
$ /usr/local/mysql/bin/mysql -u root wordpress;
mysql> show tables;
+-----------------------+
| Tables_in_wordpress |
+-----------------------+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
mysql> desc wp_commentmeta;
+------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+----------------+
| meta_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| comment_id | bigint(20) unsigned | NO | MUL | 0 | |
| meta_key | varchar(255) | YES | MUL | NULL | |
| meta_value | longtext | YES | | NULL | |
+------------+---------------------+------+-----+---------+----------------+
↓サンプルのコメントが登録されています
mysql> desc wp_comments;
+----------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+---------------------+----------------+
| comment_ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| comment_post_ID | bigint(20) unsigned | NO | MUL | 0 | |
| comment_author | tinytext | NO | | NULL | |
| comment_author_email | varchar(100) | NO | MUL | | |
| comment_author_url | varchar(200) | NO | | | |
| comment_author_IP | varchar(100) | NO | | | |
| comment_date | datetime | NO | | 0000-00-00 00:00:00 | |
| comment_date_gmt | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| comment_content | text | NO | | NULL | |
| comment_karma | int(11) | NO | | 0 | |
| comment_approved | varchar(20) | NO | MUL | 1 | |
| comment_agent | varchar(255) | NO | | | |
| comment_type | varchar(20) | NO | | | |
| comment_parent | bigint(20) unsigned | NO | MUL | 0 | |
| user_id | bigint(20) unsigned | NO | | 0 | |
+----------------------+---------------------+------+-----+---------------------+----------------+
15 rows in set (0.00 sec)
mysql> select * from wp_comments\G
*************************** 1. row ***************************
comment_ID: 1
comment_post_ID: 1
comment_author: Mr WordPress
comment_author_email:
comment_author_url: https://wordpress.org/
comment_author_IP:
comment_date: 2017-08-14 05:30:05
comment_date_gmt: 2017-08-14 05:30:05
comment_content: これはコメントです。
コメントを削除するには、ログインして投稿編集画面でコメントを表示してください。編集または削除するオプションが用意されています。
comment_karma: 0
comment_approved: 1
comment_agent:
comment_type:
comment_parent: 0
user_id: 0
1 row in set (0.00 sec)
mysql> desc wp_links;
+------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------------------+----------------+
| link_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| link_url | varchar(255) | NO | | | |
| link_name | varchar(255) | NO | | | |
| link_image | varchar(255) | NO | | | |
| link_target | varchar(25) | NO | | | |
| link_description | varchar(255) | NO | | | |
| link_visible | varchar(20) | NO | MUL | Y | |
| link_owner | bigint(20) unsigned | NO | | 1 | |
| link_rating | int(11) | NO | | 0 | |
| link_updated | datetime | NO | | 0000-00-00 00:00:00 | |
| link_rel | varchar(255) | NO | | | |
| link_notes | mediumtext | NO | | NULL | |
| link_rss | varchar(255) | NO | | | |
+------------------+---------------------+------+-----+---------------------+----------------+
tbl:wp_optionsは、selectもしましたが、様々なrecordがありましたので、
ここでは記載していません。なんだろう…
mysql> desc wp_options;
+--------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+----------------+
| option_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| option_name | varchar(64) | NO | UNI | | |
| option_value | longtext | NO | | NULL | |
| autoload | varchar(20) | NO | | yes | |
+--------------+---------------------+------+-----+---------+----------------+
mysql> desc wp_postmeta;
+------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+----------------+
| meta_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| post_id | bigint(20) unsigned | NO | MUL | 0 | |
| meta_key | varchar(255) | YES | MUL | NULL | |
| meta_value | longtext | YES | | NULL | |
+------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> select * from wp_postmeta;
+---------+---------+-------------------+------------+
| meta_id | post_id | meta_key | meta_value |
+---------+---------+-------------------+------------+
| 1 | 2 | _wp_page_template | default |
+---------+---------+-------------------+------------+
サンプル投稿やサンプル固定ページが登録されているようです
mysql> desc wp_posts;
+-----------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+---------------------+------+-----+---------------------+----------------+
| ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| post_author | bigint(20) unsigned | NO | MUL | 0 | |
| post_date | datetime | NO | | 0000-00-00 00:00:00 | |
| post_date_gmt | datetime | NO | | 0000-00-00 00:00:00 | |
| post_content | longtext | NO | | NULL | |
| post_title | text | NO | | NULL | |
| post_excerpt | text | NO | | NULL | |
| post_status | varchar(20) | NO | | publish | |
| comment_status | varchar(20) | NO | | open | |
| ping_status | varchar(20) | NO | | open | |
| post_password | varchar(20) | NO | | | |
| post_name | varchar(200) | NO | MUL | | |
| to_ping | text | NO | | NULL | |
| pinged | text | NO | | NULL | |
| post_modified | datetime | NO | | 0000-00-00 00:00:00 | |
| post_modified_gmt | datetime | NO | | 0000-00-00 00:00:00 | |
| post_content_filtered | longtext | NO | | NULL | |
| post_parent | bigint(20) unsigned | NO | MUL | 0 | |
| guid | varchar(255) | NO | | | |
| menu_order | int(11) | NO | | 0 | |
| post_type | varchar(20) | NO | MUL | post | |
| post_mime_type | varchar(100) | NO | | | |
| comment_count | bigint(20) | NO | | 0 | |
+-----------------------+---------------------+------+-----+---------------------+----------------+
23 rows in set (0.00 sec)
mysql> select * from wp_posts\G
*************************** 1. row ***************************
ID: 1
post_author: 1
post_date: 2017-08-14 05:30:05
post_date_gmt: 2017-08-14 05:30:05
post_content: WordPress へようこそ。これは最初の投稿です。編集もしくは削除してブログを始めてください !
post_title: Hello world!
post_excerpt:
post_status: publish
comment_status: open
ping_status: open
post_password:
post_name: hello-world
to_ping:
pinged:
post_modified: 2017-08-14 05:30:05
post_modified_gmt: 2017-08-14 05:30:05
post_content_filtered:
post_parent: 0
guid: http://cent7.a5.jp:8081/wordpress/?p=1
menu_order: 0
post_type: post
post_mime_type:
comment_count: 1
*************************** 2. row ***************************
ID: 2
post_author: 1
post_date: 2017-08-14 05:30:05
post_date_gmt: 2017-08-14 05:30:05
post_content: これはサンプルページです。同じ位置に固定され、(多くのテーマでは) サイトナビゲーションメニューに含まれるため、ブログ投稿とは異なります。サイト訪問者に対して自分のことを説明する自己紹介ページを作成するのが一般的です。たとえば以下のようなものになります。
<blockquote>はじめまして。昼間はバイク便のメッセンジャーとして働いていますが、俳優志望でもあります。これは僕のブログです。ロサンゼルスに住み、ジャックという名前のかわいい犬を飼っています。好きなものはピニャコラーダ (通り雨に濡れるのも) 。</blockquote>
または、このようなものでもよいでしょう。
<blockquote>XYZ 小道具株式会社は1971年の創立以来、高品質の小道具を皆様にご提供させていただいています。ゴッサム・シティに所在する当社では2,000名以上の社員が働いており、様々な形で地域のコミュニティへ貢献しています。</blockquote>
新しく WordPress ユーザーになった方は、<a href="http://cent7.a5.jp:8081/wordpress/wp-admin/">ダッシュボード</a>へ行ってこのページを削除し、独自のコンテンツを含む新しいページを作成してください。それでは、お楽しみください !
post_title: サンプルページ
post_excerpt:
post_status: publish
comment_status: open
ping_status: open
post_password:
post_name: sample-page
to_ping:
pinged:
post_modified: 2017-08-14 05:30:05
post_modified_gmt: 2017-08-14 05:30:05
post_content_filtered:
post_parent: 0
guid: http://cent7.a5.jp:8081/wordpress/?page_id=2
menu_order: 0
post_type: page
post_mime_type:
comment_count: 0
*************************** 3. row ***************************
ID: 3
post_author: 1
post_date: 2017-08-14 14:30:14
post_date_gmt: 0000-00-00 00:00:00
post_content:
post_title: 自動下書き
post_excerpt:
post_status: auto-draft
comment_status: open
ping_status: open
post_password:
post_name:
to_ping:
pinged:
post_modified: 2017-08-14 14:30:14
post_modified_gmt: 0000-00-00 00:00:00
post_content_filtered:
post_parent: 0
guid: http://cent7.a5.jp:8081/wordpress/?p=3
menu_order: 0
post_type: post
post_mime_type:
comment_count: 0
3 rows in set (0.00 sec)
mysql> desc wp_term_relationships;
+------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+-------+
| object_id | bigint(20) unsigned | NO | PRI | 0 | |
| term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 | |
| term_order | int(11) | NO | | 0 | |
+------------------+---------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> select * from wp_term_relationships;
+-----------+------------------+------------+
| object_id | term_taxonomy_id | term_order |
+-----------+------------------+------------+
| 1 | 1 | 0 |
+-----------+------------------+------------+
taxonomy = 分類?
mysql> desc wp_term_taxonomy;
+------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+----------------+
| term_taxonomy_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| term_id | bigint(20) unsigned | NO | MUL | 0 | |
| taxonomy | varchar(32) | NO | MUL | | |
| description | longtext | NO | | NULL | |
| parent | bigint(20) unsigned | NO | | 0 | |
| count | bigint(20) | NO | | 0 | |
+------------------+---------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> select * from wp_term_taxonomy;
+------------------+---------+----------+-------------+--------+-------+
| term_taxonomy_id | term_id | taxonomy | description | parent | count |
+------------------+---------+----------+-------------+--------+-------+
| 1 | 1 | category | | 0 | 1 |
+------------------+---------+----------+-------------+--------+-------+
mysql> desc wp_terms;
+------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+----------------+
| term_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(200) | NO | MUL | | |
| slug | varchar(200) | NO | UNI | | |
| term_group | bigint(10) | NO | | 0 | |
+------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> select * from wp_terms;
+---------+-----------+-----------------------------+------------+
| term_id | name | slug | term_group |
+---------+-----------+-----------------------------+------------+
| 1 | 未分類 | %e6%9c%aa%e5%88%86%e9%a1%9e | 0 |
+---------+-----------+-----------------------------+------------+
1 row in set (0.00 sec)
nickname=adminは、私が管理者として入力したidです
mysql> desc wp_usermeta;
+------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+----------------+
| umeta_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| user_id | bigint(20) unsigned | NO | MUL | 0 | |
| meta_key | varchar(255) | YES | MUL | NULL | |
| meta_value | longtext | YES | | NULL | |
+------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> select * from wp_usermeta;
+----------+---------+---------------------------------------+---------------------------------------------------------------------------------------------+
| umeta_id | user_id | meta_key | meta_value |
+----------+---------+---------------------------------------+---------------------------------------------------------------------------------------------+
| 1 | 1 | nickname | admin |
| 2 | 1 | first_name | |
| 3 | 1 | last_name | |
| 4 | 1 | description | |
| 5 | 1 | rich_editing | true |
| 6 | 1 | comment_shortcuts | false |
| 7 | 1 | admin_color | fresh |
| 8 | 1 | use_ssl | 0 |
| 9 | 1 | show_admin_bar_front | true |
| 10 | 1 | wp_capabilities | a:1:{s:13:"administrator";b:1;} |
| 11 | 1 | wp_user_level | 10 |
| 12 | 1 | dismissed_wp_pointers | wp350_media,wp360_revisions,wp360_locks,wp390_widgets |
| 13 | 1 | show_welcome_panel | 1 |
| 14 | 1 | session_tokens | a:1:{s:64:"b37504ae3e92ef97a98b2f0e34324081b42498e66f90872d23d34b21739445da";i:1502861411;} |
| 15 | 1 | wp_user-settings | editor=html&wplink=1 |
| 16 | 1 | wp_user-settings-time | 1502688609 |
| 17 | 1 | wp_dashboard_quick_press_last_post_id | 3 |
+----------+---------+---------------------------------------+---------------------------------------------------------------------------------------------+
17 rows in set (0.00 sec)
mysql> desc wp_users;
+---------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------------------+----------------+
| ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| user_login | varchar(60) | NO | MUL | | |
| user_pass | varchar(64) | NO | | | |
| user_nicename | varchar(50) | NO | MUL | | |
| user_email | varchar(100) | NO | | | |
| user_url | varchar(100) | NO | | | |
| user_registered | datetime | NO | | 0000-00-00 00:00:00 | |
| user_activation_key | varchar(60) | NO | | | |
| user_status | int(11) | NO | | 0 | |
| display_name | varchar(250) | NO | | | |
+---------------------+---------------------+------+-----+---------------------+----------------+
10 rows in set (0.00 sec)
mysql> select * from wp_users\G
*************************** 1. row ***************************
ID: 1
user_login: admin
user_pass: $P$BqSk6XN58YkpWWUILgkrS2Ulshibp51
user_nicename: admin
user_email: ないしょ
user_url:
user_registered: 2017-08-14 05:30:05
user_activation_key:
user_status: 0
display_name: admin
1 row in set (0.01 sec)