#author("2019-01-01T12:04:17+09:00","default:kuji","kuji") CONTENTS #contents ---- Lastmodified &lastmod; ---- *OpenPNE3 File [#o86abaf6] [[&resizeimage(PNE_Files.PNG,640,480,70,k);>https://piano2nd.smb.net/PukiWiki/index.php?plugin=attach&refer=OpenPNE3%20File&openfile=PNE_Files.PNG]] id とファイル名の関連は「file」に格納されている。 mysql> show columns from file; +-------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(64) | NO | UNI | | | | type | varchar(64) | NO | | | | | filesize | int(11) | NO | | 0 | | | original_filename | text | YES | | NULL | | | created_at | datetime | NO | | NULL | | | updated_at | datetime | NO | | NULL | | +-------------------+-------------+------+-----+---------+----------------+ 7 rows in set (0.00 sec) 画像ファイルは「`file_bin`」に格納されている。 mysql> show columns from file_bin; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | file_id | int(11) | NO | PRI | 0 | | | bin | longblob | YES | | NULL | | | created_at | datetime | NO | | NULL | | | updated_at | datetime | NO | | NULL | | +------------+----------+------+-----+---------+-------+ 4 rows in set (0.01 sec) http://blog.livedoor.jp/atsu1997/archives/4613674.html https://www.ipentec.com/document/sql-multi-record-update http://daiyamamoto.hatenablog.com/entry/20080616/p1 ---- Total access &counter(total);:本日 &counter(today);:昨日 &counter(yesterday); #counter([total|today|yesterday]);