IT工程師數位筆記本

-- 表：StatisticsData
CREATE TABLE "StatisticsData" (

"Id"  TEXT NOT NULL,

"MachineName"  NVARCHAR,

"SessionId"  INTEGER,

"ProcessId"  INTEGER,

"ProcessName"  NVARCHAR,

"ProcessRunningStatus"  NVARCHAR,

"WorkingSetMemory"  NVARCHAR,

"WorkingSetPrivateMemory"  NVARCHAR,

"WorkingSetPeak"  NVARCHAR,

"ThreadCount"  NVARCHAR,

"HandleCount"  NVARCHAR,

"TotalProcessorTime"  NVARCHAR,

"UserProcessorTime"  NVARCHAR,

"PrivilegedProcessorTime"  NVARCHAR,

"StartTime"  DATETIME,

"ExitTime"  DATETIME,

"Domain"  NVARCHAR,

"UserName"  NVARCHAR,

"FileName"  NVARCHAR,

"Arguments"  NVARCHAR,

"WorkingDirectory"  NVARCHAR,

"CreatedTime"  DATETIME,

PRIMARY KEY ("Id" ASC),

CONSTRAINT "PK_Id" UNIQUE ("Id" ASC)

)

DELETE FROM StatisticsData WHERE date('now', '-7 day') >= date(CreatedTime);

DELETE FROM StatisticsData WHERE julianday('now') - julianday(CreatedTime) >= 7;