自制ASP.NET 2.0 新闻网站

create default [newid] as newid() GO create default [now] as getdate() GO CREATE TABLE [dbo].[t_access] ( [Access_id] [uniqueidentifier] NOT NULL , [Access_uid] [uniqueidentifier] NULL , [Access_cid] [uniqueidentifier] NULL , [Access_rank] [tinyint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[t_article] ( [Article_id] [uniqueidentifier] NOT NULL , [Article_cid] [uniqueidentifier] NULL , [Article_sort] [int] NULL , [Article_time] [datetime] NOT NULL , [Article_title] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [Article_content] [varchar] (7000) COLLATE Chinese_PRC_CI_AS NULL , [Article_author] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Article_hit] [int] NULL , [Article_status] [tinyint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[t_column] ( [Column_id] [uniqueidentifier] NOT NULL , [Column_fid] [uniqueidentifier] NULL , [Column_sort] [int] NULL , [Column_time] [datetime] NOT NULL , [Column_child_sum] [smallint] NULL , [Column_name] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [Column_desc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Column_status] [tinyint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[t_remark] ( [Remark_id] [uniqueidentifier] NOT NULL , [Remark_aid] [uniqueidentifier] NULL , [Remark_sort] [int] NULL , [Remark_time] [datetime] NOT NULL , [Remark_name] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [Remark_email] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [Remark_title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Remark_content] [varchar] (400) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[t_resource] ( [Resource_id] [uniqueidentifier] NOT NULL , [Resource_aid] [uniqueidentifier] NULL , [Resource_uid] [uniqueidentifier] NULL , [Resource_sort] [int] NULL , [Resource_time] [datetime] NOT NULL , [Resource_name] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [Resource_desc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Resource_filename] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Resource_url] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[t_user] ( [User_id] [uniqueidentifier] NOT NULL , [User_sort] [int] NULL , [User_time] [datetime] NOT NULL , [User_name] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [User_pwd] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [User_realname] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [User_tel] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [User_email] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL , [User_rank] [tinyint] NULL , [User_status] [tinyint] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[t_access] ADD CONSTRAINT [PK_t_access] PRIMARY KEY CLUSTERED ( [Access_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[t_article] ADD CONSTRAINT [PK_t_article] PRIMARY KEY CLUSTERED ( [Article_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[t_column] ADD CONSTRAINT [PK_t_column] PRIMARY KEY CLUSTERED ( [Column_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[t_remark] ADD CONSTRAINT [PK_t_remark] PRIMARY KEY CLUSTERED ( [Remark_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[t_resource] ADD CONSTRAINT [PK_t_resource] PRIMARY KEY CLUSTERED ( [Resource_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[t_user] ADD CONSTRAINT [PK_t_user] PRIMARY KEY CLUSTERED ( [User_id] ) ON [PRIMARY] GO setuser GO EXEC sp_bindefault N'[dbo].[newid]', N'[t_access].[Access_id]' GO setuser GO setuser GO EXEC sp_bindefault N'[dbo].[newid]', N'[t_article].[Article_id]' GO EXEC sp_bindefault N'[dbo].[now]', N'[t_article].[Article_time]' GO setuser GO setuser GO EXEC sp_bindefault N'[dbo].[newid]', N'[t_column].[Column_id]' GO EXEC sp_bindefault N'[dbo].[now]', N'[t_column].[Column_time]' GO setuser GO setuser GO EXEC sp_bindefault N'[dbo].[newid]', N'[t_remark].[Remark_id]' GO EXEC sp_bindefault N'[dbo].[now]', N'[t_remark].[Remark_time]' GO setuser GO setuser GO EXEC sp_bindefault N'[dbo].[newid]', N'[t_resource].[Resource_id]' GO EXEC sp_bindefault N'[dbo].[now]', N'[t_resource].[Resource_time]' GO setuser GO setuser GO EXEC sp_bindefault N'[dbo].[newid]', N'[t_user].[User_id]' GO EXEC sp_bindefault N'[dbo].[now]', N'[t_user].[User_time]' GO setuser GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.v_article AS SELECT * FROM dbo.t_article LEFT OUTER JOIN dbo.t_resource ON dbo.t_article.Article_id = dbo.t_resource.Resource_aid GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.v_remark AS SELECT dbo.t_remark.*, dbo.t_article.Article_cid AS Column_id FROM dbo.t_remark INNER JOIN dbo.t_article ON dbo.t_remark.Remark_aid = dbo.t_article.Article_id GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO