if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pro_so_main]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[pro_so_main]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[config]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[config_ad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[config_ad]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[member]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[member]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[member_group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[member_group]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[robot]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[robot]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[robot_news]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[robot_news]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[so_class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[so_class]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[so_main]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[so_main]
GO

CREATE TABLE [dbo].[config] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[site_url] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[site_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[site_logo] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[page_meta] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[page_top_info] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[page_foot_info] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[html_dir] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[html_kzm] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[config_ad] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[adid] [int] NULL ,
	[ad] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[member] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[groupid] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[remarks] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[addDate] [datetime] NULL ,
	[addNum] [int] NULL ,
	[qq] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[icq] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[msn] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[question] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[male] [bit] NULL ,
	[birthday] [datetime] NULL ,
	[realname] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[country] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[province] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[city] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[phone] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[postcode] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[bloodType] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[job] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[edu] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[school] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[hideEmail] [bit] NULL ,
	[lastLog] [datetime] NULL ,
	[logTimes] [int] NULL ,
	[photo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[introduction] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[rssTitle] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[vMoney] [int] NULL ,
	[totalMark] [int] NULL ,
	[nSignIn] [int] NULL ,
	[addSignIn] [int] NULL ,
	[expireDate] [datetime] NULL ,
	[jibie] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[member_group] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[moneynum] [int] NULL ,
	[gremark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[robot] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[startUrl] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[startpagenum] [int] NULL ,
	[endpageNum] [int] NULL ,
	[charset] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[downNum] [int] NULL ,
	[downimg] [bit] NULL ,
	[imgMark] [bit] NULL ,
	[autoTitleImg] [bit] NULL ,
	[inverted] [bit] NULL ,
	[linkOut] [bit] NULL ,
	[checkduplicate] [bit] NULL ,
	[PageUrl] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageUrlb] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageUrlp] [nchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[content] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[author] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[source] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[time] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[pageTitle] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[nextPage] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[nextPagenum] [int] NULL ,
	[Filter] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[lastrdate] [datetime] NULL ,
	[Starturllists] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[siteurl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isallout] [bit] NULL ,
	[isallrobot] [bit] NULL ,
	[forclass] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[robot_news] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[source] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[time] [datetime] NULL ,
	[pageTitle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sourceurl] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[forid] [int] NULL ,
	[forsoid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[so_class] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[s_class] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[so_main] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[title] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[sourceurl] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[sotime] [datetime] NULL ,
	[soid] [bigint] NULL ,
	[isindex] [bit] NULL ,
	[lastindextime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[config_ad] WITH NOCHECK ADD 
	CONSTRAINT [PK_config_ad] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[member_group] WITH NOCHECK ADD 
	CONSTRAINT [PK_member_group] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[robot] WITH NOCHECK ADD 
	CONSTRAINT [PK_robot] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[robot_news] WITH NOCHECK ADD 
	CONSTRAINT [PK_robot_news] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[so_class] WITH NOCHECK ADD 
	CONSTRAINT [PK_so_class] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[so_main] WITH NOCHECK ADD 
	CONSTRAINT [PK_so_main] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[member] ADD 
	CONSTRAINT [DF_member_jibie] DEFAULT (0) FOR [jibie]
GO

ALTER TABLE [dbo].[robot] ADD 
	CONSTRAINT [DF__aGatherRu__sortI__1E7B3CAD] DEFAULT (0) FOR [startpagenum],
	CONSTRAINT [DF__aGatherRu__downN__1F6F60E6] DEFAULT (0) FOR [downNum],
	CONSTRAINT [DF__aGatherRu__inver__24341603] DEFAULT (0) FOR [inverted],
	CONSTRAINT [DF__aGatherRu__linkO__25283A3C] DEFAULT (0) FOR [linkOut],
	CONSTRAINT [DF__aGatherRu__check__467F0C66] DEFAULT (0) FOR [checkduplicate]
GO

ALTER TABLE [dbo].[robot_news] ADD 
	CONSTRAINT [DF_robot_news_time] DEFAULT (getdate()) FOR [time]
GO

ALTER TABLE [dbo].[so_main] ADD 
	CONSTRAINT [DF_so_main_isindex] DEFAULT (0) FOR [isindex]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE procedure pro_so_main 
(@startIndex int,
@endIndex int)
as
set nocount on
begin
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select id from so_main  order by id desc
select * from so_main O,@indextable t where O.id=t.nid
and t.id between @startIndex and @endIndex order by t.id
end
set nocount off


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

