File manager - Edit - /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/dbmigrations/0021-addressbookflags/sqlite3.sql
Back
-- Note: SQLite since version 3.35 supports DROP COLUMN -- We support versions starting with version 3.22, so we do not use this mechanism and instead create a copy of the -- table with the modifications -- disable foreign key constraint check PRAGMA foreign_keys=off; -- start a transaction BEGIN TRANSACTION; -- Here you can drop column or rename column CREATE TABLE IF NOT EXISTS TABLE_PREFIXcarddav_addressbooks0021 ( id integer NOT NULL PRIMARY KEY, name TEXT NOT NULL, url TEXT NOT NULL, last_updated BIGINT NOT NULL DEFAULT 0, -- time stamp (seconds since epoch) of the last update of the local database refresh_time INT NOT NULL DEFAULT 3600, -- time span (seconds) after that the local database will be refreshed, default 1h sync_token TEXT NOT NULL DEFAULT '', -- sync-token the server sent us for the last sync account_id integer NOT NULL, flags integer NOT NULL DEFAULT 5, -- default: discovered:2 | active:0 -- not enforced by sqlite < 3.6.19 FOREIGN KEY(account_id) REFERENCES TABLE_PREFIXcarddav_accounts(id) ON DELETE CASCADE ON UPDATE CASCADE ); -- copy data from the table to the new_table INSERT INTO TABLE_PREFIXcarddav_addressbooks0021 SELECT id,name,url,last_updated,refresh_time,sync_token,account_id, ( ((active != 0) << 0) | ((use_categories != 0) << 1) | ((discovered != 0) << 2) ) FROM TABLE_PREFIXcarddav_addressbooks; -- drop the table DROP TABLE TABLE_PREFIXcarddav_addressbooks; -- rename the new_table to the table ALTER TABLE TABLE_PREFIXcarddav_addressbooks0021 RENAME TO TABLE_PREFIXcarddav_addressbooks; CREATE INDEX TABLE_PREFIXcarddav_addressbooks_account_id_idx ON TABLE_PREFIXcarddav_addressbooks(account_id); -- commit the transaction COMMIT; -- enable foreign key constraint check PRAGMA foreign_keys=on;
| ver. 1.4 |
Github
|
.
| PHP 8.1.34 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings