文件操作 - 2021081000.sql
返回文件管理
返回主菜单
删除本文件
文件: /usr/local/cwpsrv/var/services/roundcube-1.6.4/SQL/oracle/2021081000.sql
编辑文件内容
CREATE TABLE "responses" ( "response_id" integer PRIMARY KEY, "user_id" integer NOT NULL REFERENCES "users" ("user_id") ON DELETE CASCADE, "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, "del" smallint DEFAULT 0 NOT NULL, "name" varchar(128) NOT NULL, "data" long NOT NULL, "is_html" smallint DEFAULT 0 NOT NULL ); CREATE INDEX "responses_user_id_idx" ON "responses" ("user_id", "del"); CREATE SEQUENCE "responses_seq" START WITH 1 INCREMENT BY 1 NOMAXVALUE; CREATE TRIGGER "responses_seq_trig" BEFORE INSERT ON "responses" FOR EACH ROW BEGIN :NEW."response_id" := "response_seq".nextval; END; /
修改文件时间
将文件时间修改为当前时间的前一年
删除文件