由于之间版本对于黄页内容信息过多而无法存入数据库中, 因此我们对黄页注册表字段类型进行了更新,同时也对字段类型进行了规范化。如之前Int数据类型是以字符形式存入到数据中,我们已将其更正,减小数据库的负荷。
新字段逻辑:
CREATE TABLE [dbo].[ZL_PageReg](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CompanyName] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[PageTitle] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[Keyword] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[Description] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[LOGO] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[Domain] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[Style] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[NodeStyle] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[NavHeight] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[NavColor] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[NavBackground] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[TableName] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[Hits] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[InfoID] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[Recommendation] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[Status] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[UserID] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[UserName] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[ParentPageID] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[ParentPageUserID] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[PageInfo] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[TopWords] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[BottonWords] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[CreationTime] [datetime] NULL,
[UpdateTime] [datetime] NULL,
[Template] [nvarchar](255)NULL,
[ModelID] [int] NULL,
CONSTRAINT [PK_ZL_PageReg] PRIMARY KEY CLUSTERED(
[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO