• AppCenter -> 多媒体插件 -> 安装TMDb for Movie插件
• Video Station -> 设置 -> 电影 -> 数据库来源 设置为 TMDb
• 终端连接NAS SSH

vi /etc/hosts

# 在最后添加接口IP映射
13.224.161.90  api.themoviedb.org

UPDATE user SET avatar = REPLACE( avatar, 'http://', 'https://' ) WHERE avatar LIKE 'http://%';

SELECT id FROM (SELECT uid, score, (@rowno:=@rowno+1) as rowno from user, (SELECT (@rowno:=0)) b ORDER BY score DESC) c WHERE rowno=1;

在超长字段上创建索引时, 会报错:

ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

在my.ini中设置 innodb_large_prefix = 1

执行下面命令, 变更数据格式

alter table <表名> row_format=dynamic;
alter table <表名> row_format=compressed;

如果报错:

South migrate error, InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope

在my.ini中设置 innodb_file_format = Barracuda 再执行上述SQL

参考: https://stackoverflow.com/questions/23556926/south-migrate-error-innodb-row-format-dynamic-requires-innodb-file-format-an
https://help.aliyun.com/knowledge_detail/155946.html

// 1. 取出对象的第一个key来获取
obj[Object.keys(obj)[0]]

// 2. 取出对象的值数组的第一个
Object.values(obj)[0]