文件操作 - 4.2.0_to_4.3.0_schema.sqlite3.sql
返回文件管理
返回主菜单
删除本文件
文件: /usr/share/doc/cpanel-pdns/4.2.0_to_4.3.0_schema.sqlite3.sql
编辑文件内容
.bail on BEGIN TRANSACTION; CREATE TABLE cryptokeys_temp ( id INTEGER PRIMARY KEY, domain_id INT NOT NULL, flags INT NOT NULL, active BOOL, published BOOL DEFAULT 1, content TEXT, FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE ON UPDATE CASCADE ); INSERT INTO cryptokeys_temp SELECT id,domain_id,flags,active,1,content FROM cryptokeys; DROP TABLE cryptokeys; ALTER TABLE cryptokeys_temp RENAME TO cryptokeys; CREATE INDEX domainidindex ON cryptokeys(domain_id); COMMIT;
修改文件时间
将文件时间修改为当前时间的前一年
删除文件