比特村新闻发布及管理源代码

/****** 此文件为 SQL Server 2000 脚本文件 制作人: Alger ******/ /****** Object: Table [dbo].[border] Script Date: 2001-5-27 18:49:20 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[border]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[border] GO /****** Object: Table [dbo].[news] Script Date: 2001-5-27 18:49:20 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[news]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[news] GO /****** Object: Table [dbo].[news_parameter] Script Date: 2001-5-27 18:49:20 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[news_parameter]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[news_parameter] GO /****** Object: Table [dbo].[review] Script Date: 2001-5-27 18:49:20 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[review]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[review] GO /****** Object: Table [dbo].[type] Script Date: 2001-5-27 18:49:20 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[type]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[type] GO /****** Object: Table [dbo].[users] Script Date: 2001-5-27 18:49:20 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[users] GO /****** Object: Table [dbo].[border] Script Date: 2001-5-27 18:49:23 ******/ CREATE TABLE [dbo].[border] ( [borderid] [bigint] IDENTITY (1, 1) NOT NULL , [typeid] [bigint] NOT NULL , [bordername] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[news] Script Date: 2001-5-27 18:49:25 ******/ CREATE TABLE [dbo].[news] ( [newsid] [bigint] IDENTITY (1, 1) NOT NULL , [typeid] [bigint] NOT NULL , [borderid] [bigint] NOT NULL , [topic] [char] (80) COLLATE Chinese_PRC_CI_AS NOT NULL , [content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , [ntime] [datetime] NOT NULL , [hits] [bigint] NOT NULL , [keys] [char] (400) COLLATE Chinese_PRC_CI_AS NOT NULL , [img] [image] NULL , [nfrom] [char] (100) COLLATE Chinese_PRC_CI_AS NULL , [modify] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [audit] [int] NOT NULL , [auditer] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [writer] [char] (60) COLLATE Chinese_PRC_CI_AS NULL , [imgsize] [bigint] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[news_parameter] Script Date: 2001-5-27 18:49:25 ******/ CREATE TABLE [dbo].[news_parameter] ( [parameterid] [bigint] NOT NULL , [reviewable] [int] NULL , [reviewnumber] [int] NULL , [newsnumber] [int] NULL , [auditer] [int] NULL , [articlefrom] [char] (100) COLLATE Chinese_PRC_CI_AS NULL , [aboutnews] [int] NULL , [newsstatus] [int] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[review] Script Date: 2001-5-27 18:49:26 ******/ CREATE TABLE [dbo].[review] ( [reviewid] [bigint] IDENTITY (1, 1) NOT NULL , [newsid] [bigint] NOT NULL , [reviewer] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [uip] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [email] [char] (60) COLLATE Chinese_PRC_CI_AS NULL , [url] [char] (100) COLLATE Chinese_PRC_CI_AS NULL , [content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , [rtime] [datetime] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[type] Script Date: 2001-5-27 18:49:27 ******/ CREATE TABLE [dbo].[type] ( [typeid] [bigint] IDENTITY (1, 1) NOT NULL , [typename] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[users] Script Date: 2001-5-27 18:49:27 ******/ CREATE TABLE [dbo].[users] ( [userid] [bigint] IDENTITY (1, 1) NOT NULL , [name] [char] (14) COLLATE Chin�