文件操作 - 2018021600.sql
返回文件管理
返回主菜单
删除本文件
文件: /root/.local/share/Trash/files/roundcube/SQL/oracle/2018021600.sql
编辑文件内容
CREATE TABLE "filestore" ( "file_id" integer PRIMARY KEY, "user_id" integer NOT NULL REFERENCES "users" ("user_id") ON DELETE CASCADE ON UPDATE CASCADE, "filename" varchar(128) NOT NULL, "mtime" integer NOT NULL, "data" long, CONSTRAINT "filestore_user_id_key" UNIQUE ("user_id", "filename") ); CREATE SEQUENCE "filestore_seq" START WITH 1 INCREMENT BY 1 NOMAXVALUE; CREATE TRIGGER "filestore_seq_trig" BEFORE INSERT ON "filestore" FOR EACH ROW BEGIN :NEW."user_id" := "filestore_seq".nextval; END; /
修改文件时间
将文件时间修改为当前时间的前一年
删除文件