📄 0_2_0-systemdatabase.sql
字号:
ALTER TABLE network_places ADD COLUMN scheme varchar DEFAULT '' NOT NULL;
ALTER TABLE network_places ALTER COLUMN uri RENAME TO path;
UPDATE network_places SET scheme = 'smb' WHERE path LIKE 'smb:%';
UPDATE network_places SET scheme = 'cifs' WHERE path LIKE 'cifs:%';
UPDATE network_places SET scheme = 'ftp' WHERE path LIKE 'ftp:%';
UPDATE network_places SET scheme = 'file' WHERE path LIKE 'file:%';
UPDATE network_places SET scheme = 'sftp' WHERE path LIKE 'sftp:%';
UPDATE network_places SET scheme = 'file' WHERE path NOT LIKE 'sftp:%' AND path NOT LIKE 'smb:%' AND path NOT LIKE 'ftp:%' AND path NOT LIKE 'file:%' AND path NOT LIKE 'cifs:%';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -