/*******************************************************************************************

Ʒ˵QICMS̼վϵͳv2.5
ʱ䣺2009121
ٷַwww.qicms.com  
֧֣TEL0532-81801615  QQ1055908157
˵v2.0 Sql汾v2.5 Sql汾

*******************************************************************************************/
ע⣺ǰվݱݡ


1.

һ:

ֹͣվУɾվеbinĿ¼

ڶϴ򸲸ԭļ


2.ݿSQLִ

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[bots](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[botname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sj] [datetime] NULL,
	[hits] [int] NULL,
	[url] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[ip] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_bots] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** :  Table [dbo].[custom]    ű: 12/02/2009 09:48:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[custom](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sql] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[sj] [datetime] NULL CONSTRAINT [DF_custom_sj]  DEFAULT (getdate()),
 CONSTRAINT [PK_custom] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** :  Table [dbo].[netLink]    ű: 12/02/2009 09:48:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[netLink](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[website] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[link] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[px] [int] NULL CONSTRAINT [DF_netLink_px]  DEFAULT ((0)),
 CONSTRAINT [PK_netLink] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** :  Table [dbo].[news]    ű: 12/02/2009 09:48:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[news](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[lbid] [int] NULL,
	[bt] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
	[lj] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[lx] [int] NULL,
	[gj] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ly] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[author] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[nr] [text] COLLATE Chinese_PRC_CI_AS NULL,
	[rq] [int] NULL,
	[bt_color] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[bt_b] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[tp] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sj] [datetime] NULL CONSTRAINT [DF_news_sj]  DEFAULT (getdate()),
	[des] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_news] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
/****** :  Table [dbo].[news_lb]    ű: 12/02/2009 09:48:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[news_lb](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[cid] [int] NULL,
	[mc] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[cang] [bit] NULL CONSTRAINT [DF_news_lb_cang]  DEFAULT ((1)),
	[cid_list] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_news_lb] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** :  Table [dbo].[placard]    ű: 12/02/2009 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[placard](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[train] [int] NOT NULL CONSTRAINT [DF_Table_1_order]  DEFAULT ((0)),
	[title] [varchar](500) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[startTime] [datetime] NOT NULL,
	[endtime] [datetime] NOT NULL,
	[type] [int] NOT NULL,
	[author] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[contents] [text] COLLATE Chinese_PRC_CI_AS NOT NULL,
 CONSTRAINT [PK_placard] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

alter table storeinfo add s_parent int default(0)
update storeinfo set s_parent=0

/******  ******/