CSFramework软件版本自动升级程序 - 数据库表结构（MSSQL）

CSFramework AutoUpgrader 版本自动升级 软件升级  csframework@喜鹊软件

AutoUpgrader - 自动升级程序V1.2 - 数据库表结构

sys_Log

CREATE TABLE [dbo].[sys_Log](
	[isid] [int] IDENTITY(1,1) NOT NULL,
	[LogType] [varchar](10) NULL,
	[LogTime] [datetime] NULL,
	[LogText] [nvarchar](250) NULL,
	[PkgFileName] [varchar](250) NULL,
	[IPLocal] [varchar](50) NULL,
	[IPInterNet] [varchar](50) NULL,
	[SystemName] [varchar](50) NULL,
 CONSTRAINT [PK_sys_UpgradingHistory] PRIMARY KEY CLUSTERED 
(
	[isid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

sys_PackageTable

CREATE TABLE [dbo].[sys_PackageTable](
	[ISID] [int] IDENTITY(1,1) NOT NULL,
	[SystemName] [varchar](30) NULL,
	[VersionNo] [nvarchar](50) NULL,
	[FileVersion] [nvarchar](50) NULL,
	[FileName] [nvarchar](50) NULL,
	[FileType] [varchar](10) NULL,
	[FileSize] [decimal](18, 2) NULL,
	[FileBody] [varbinary](max) NULL,
	[CreationTime] [datetime] NULL,
	[Remark] [nvarchar](max) NULL,
 CONSTRAINT [PK_sys_PackageTable] PRIMARY KEY CLUSTERED 
(
	[ISID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

sys_SystemName

CREATE TABLE [dbo].[sys_SystemName](
	[isid] [int] IDENTITY(1,1) NOT NULL,
	[SystemID] [varchar](50) NOT NULL,
	[SystemName] [nvarchar](50) NULL,
 CONSTRAINT [PK_sys_SystemName] PRIMARY KEY CLUSTERED 
(
	[SystemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

sys_UpgraderVersion

CREATE TABLE [dbo].[sys_UpgraderVersion](
	[isid] [int] IDENTITY(1,1) NOT NULL,
	[FileBody] [image] NULL,
	[VersionNo] [varchar](20) NOT NULL,
	[UploadTime] [datetime] NULL,
	[UploadUser] [varchar](20) NULL,
	[UpgraderName] [varchar](20) NULL,
 CONSTRAINT [PK_sys_UpgraderVersion] PRIMARY KEY CLUSTERED 
(
	[VersionNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO