文件操作 - oracle.initial.sql
返回文件管理
返回主菜单
删除本文件
文件: /root/.local/share/Trash/files/roundcube/plugins/calendar/drivers/kolab/SQL/oracle.initial.sql
编辑文件内容
/** * Roundcube Calendar Kolab backend * * @author Aleksander Machniak * @licence GNU AGPL **/ CREATE TABLE "kolab_alarms" ( "alarm_id" varchar(255) NOT NULL PRIMARY KEY, "user_id" integer NOT NULL REFERENCES "users" ("user_id") ON DELETE CASCADE, "notifyat" timestamp DEFAULT NULL, "dismissed" smallint DEFAULT 0 NOT NULL ); CREATE INDEX "kolab_alarms_user_id_idx" ON "kolab_alarms" ("user_id"); CREATE TABLE "itipinvitations" ( "token" varchar(64) NOT NULL PRIMARY KEY, "event_uid" varchar(255) NOT NULL, "user_id" integer NOT NULL REFERENCES "users" ("user_id") ON DELETE CASCADE, "event" long NOT NULL, "expires" timestamp DEFAULT NULL, "cancelled" smallint DEFAULT 0 NOT NULL ); CREATE INDEX "itipinvitations_user_id_idx" ON "itipinvitations" ("user_id", "event_uid"); INSERT INTO "system" ("name", "value") VALUES ('calendar-kolab-version', '2014041700');
修改文件时间
将文件时间修改为当前时间的前一年
删除文件