📄 3.0_beta10.sql
字号:
/* * * This SQL script is designed to upgrade your NAV database from * version 3.0_beta9 to 3.0_beta10. * * The collection of memory information from devices has remained * unimplemented in NAV 3 until now, which prompted the addition of a * UNIQUE contraint to the mem table * * Connect to PostgreSQL as the postgres superuser and run this script * like this: * * psql -f 3.0_beta8.sql manage postgres * * Please, also run the updated snmpoid.sql script over again, like * this: * * psql -f snmpoid.sql manage postgres **/BEGIN;-- Make sure the table is empty before we proceedDELETE FROM mem;ALTER TABLE mem ADD CONSTRAINT mem_netboxid_key UNIQUE(netboxid, memtype, device);COMMIT;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -