✏️ 正在编辑: 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;
💾 保存文件
← 返回文件管理器