|
Server : LiteSpeed System : Linux srv107862549.host 5.15.0-124-generic #134-Ubuntu SMP Fri Sep 27 20:20:17 UTC 2024 x86_64 User : malam2778 ( 1069) PHP Version : 8.0.30 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory : /usr/share/pdns-backend-bind/schema/ |
Upload File : |
BEGIN TRANSACTION;
CREATE TABLE cryptokeys_temp (
id INTEGER PRIMARY KEY,
domain VARCHAR(255) COLLATE NOCASE,
flags INT NOT NULL,
active BOOL,
published BOOL DEFAULT 1,
content TEXT
);
INSERT INTO cryptokeys_temp SELECT id,domain,flags,active,1,content FROM cryptokeys;
DROP TABLE cryptokeys;
ALTER TABLE cryptokeys_temp RENAME TO cryptokeys;
CREATE INDEX domainnameindex ON cryptokeys(domain);
COMMIT;