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

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

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


1.

һ:

ֹͣվУɾվеbinĿ¼

ڶϴ򸲸ԭļ


2.ݿSQLִ

һ
use ݿ
alter table comments add hy_id int

ڶ
update comments set hy_id=0


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[huiyuan](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[uid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[uname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[password] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sj1] [datetime] NULL,
	[sj2] [datetime] NULL,
	[ip1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ip2] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sh] [bit] NULL,
	[sex] [int] NULL CONSTRAINT [DF_huiyuan_sex]  DEFAULT ((1)),
	[realname] [char](20) COLLATE Chinese_PRC_CI_AS NULL,
	[address] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
	[post] [char](20) COLLATE Chinese_PRC_CI_AS NULL,
	[bir] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[phone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[tp] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_huiyuan] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** :  Table [dbo].[ka]    ű: 10/26/2009 18:36:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ka](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[kh] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[password] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sj] [datetime] NULL CONSTRAINT [DF_ka_sj]  DEFAULT (getdate()),
	[hy_id] [int] NULL CONSTRAINT [DF_ka_hy_id]  DEFAULT ((0)),
 CONSTRAINT [PK_ka] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** :  Table [dbo].[ka_jilu]    ű: 10/26/2009 18:36:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ka_jilu](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[low] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[high] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[id1] [int] NULL,
	[id2] [int] NULL,
	[sj] [datetime] NULL CONSTRAINT [DF_ka_jilu_sj]  DEFAULT (getdate()),
 CONSTRAINT [PK_ka_jilu] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
/****** :  Table [dbo].[shenqing]    ű: 10/26/2009 18:36:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[shenqing](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[uid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sj] [datetime] NULL CONSTRAINT [DF_shenqing_sj]  DEFAULT (getdate()),
	[mode] [bit] NULL CONSTRAINT [DF_shenqing_mode]  DEFAULT ((0)),
	[hy_id] [int] NULL,
 CONSTRAINT [PK_shenqing] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


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