文件操作 - 2016112200.sql
返回文件管理
返回主菜单
删除本文件
文件: /root/.local/share/Trash/files/roundcube/SQL/postgres/2016112200.sql
编辑文件内容
DROP TABLE "cache"; DROP TABLE "cache_shared"; CREATE TABLE "cache" ( user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE, cache_key varchar(128) DEFAULT '' NOT NULL, expires timestamp with time zone DEFAULT NULL, data text NOT NULL, PRIMARY KEY (user_id, cache_key) ); CREATE INDEX cache_expires_idx ON "cache" (expires); CREATE TABLE "cache_shared" ( cache_key varchar(255) NOT NULL PRIMARY KEY, expires timestamp with time zone DEFAULT NULL, data text NOT NULL ); CREATE INDEX cache_shared_expires_idx ON "cache_shared" (expires);
修改文件时间
将文件时间修改为当前时间的前一年
删除文件