文件操作 - 2016112200.sql
返回文件管理
返回主菜单
删除本文件
文件: /usr/local/cwpsrv/var/services/roundcube-2023/SQL/mssql/2016112200.sql
编辑文件内容
DROP TABLE [dbo].[cache] GO DROP TABLE [dbo].[cache_shared] GO CREATE TABLE [dbo].[cache] ( [user_id] [int] NOT NULL , [cache_key] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL , [expires] [datetime] NULL , [data] [text] COLLATE Latin1_General_CI_AI NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[cache_shared] ( [cache_key] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL , [expires] [datetime] NULL , [data] [text] COLLATE Latin1_General_CI_AI NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[cache] ADD CONSTRAINT [DF_cache_user_id] DEFAULT ('0') FOR [user_id], CONSTRAINT [DF_cache_cache_key] DEFAULT ('') FOR [cache_key] GO CREATE INDEX [IX_cache_expires] ON [dbo].[cache]([expires]) ON [PRIMARY] GO CREATE INDEX [IX_cache_shared_expires] ON [dbo].[cache_shared]([expires]) ON [PRIMARY] GO ALTER TABLE [dbo].[cache] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [user_id],[cache_key] ) ON [PRIMARY] GO ALTER TABLE [dbo].[cache_shared] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [cache_key] ) ON [PRIMARY] GO
修改文件时间
将文件时间修改为当前时间的前一年
删除文件