--ݿļ

--1֧ʺű
/****** :  [dbo].[YX_PayOnLine]    ű: 2008-1-30 17:58:02 ******/
CREATE TABLE [dbo].[YX_PayOnLine] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_Name] [varchar] (50) NULL ,
	[YX_JieKou] [varchar] (50) NULL ,
	[YX_ZhangHao] [varchar] (50) NULL ,
	[YX_MiYao] [varchar] (255) NULL ,
	[YX_PrentID] [varchar] (255) NULL ,
	[YX_Email] [varchar] (50) NULL ,
	[YX_ZhiChiHB] [varchar] (100) NULL ,
	[YX_IsOpen] [bit] NULL ,
	[YX_MiaoShu] [varchar] (500) NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_PayOnLine] WITH NOCHECK ADD 
	CONSTRAINT [PK_YX_PayOnLine] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

--2YX_OrderForm޸ģ
--YX_OrderFormID޸Ϊ"VARCHAR(50)"

ALTER TABLE YX_OrderForm ALTER column [YX_OrderFormID] VARCHAR(50) NULL
; 

--3YX_UserRank޸ģ
--ֶΡYX_YXJ,int
ALTER TABLE YX_UserRank ADD YX_YXJ int  NULL 
;


--4YX_Shoping޸ģ
--ֶΡYX_OrderID޸Ϊ"VARCHAR(50)";
ALTER TABLE YX_Shoping ALTER column [YX_OrderID] VARCHAR(50) 
;



--6ɾYX_Onlinepayment
DROP TABLE YX_Onlinepayment
;

--7޸ıYX_Inves
--CREATE DEFAULT VoteDefault AS 0
--;
--sp_bindefault VoteDefault,'YX_Inves.YX_OkNum'
--;
--sp_bindefault VoteDefault,'YX_Inves.YX_Selected'
--;

--8޸ıYX_Collection,ɾYX_CollNameֶ

ALTER TABLE YX_Collection drop column [YX_CollName]
;

--9޸ıYx_PingLun,ɾYX_ProNameֶ

ALTER TABLE Yx_PingLun drop column [YX_ProName]
;
--10YX_WebInfo޸ģֶΡyx_regitem,text
ALTER TABLE YX_WebInfo ADD yx_regitem text  NULL 
;
--11޸ıYX_LY,YX_LyTimeֶεĬֵΪ(getdate())
--CREATE DEFAULT lytime AS getdate()
--;
--sp_bindefault lytime,'YX_LY.YX_LyTime'
--;

