--/* 易想多用户商城 C2C3.0 升级包*/--



CREATE TABLE [dbo].[YXShop_Cart] (
	[UniqueID] [int] NOT NULL ,
	[ProductId] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CategoryId] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MarkerPrice] [decimal](18, 0) NULL ,
	[Price] [decimal](10, 2) NOT NULL ,
	[IsShoppingCart] [int] NOT NULL ,
	[Quantity] [int] NOT NULL ,
	[ProductName] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[ProductIntegral] [decimal](18, 0) NULL ,
	[ProductImage] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[NeedIntegral] [decimal](18, 0) NULL ,
	[NeedDummyMoney] [decimal](18, 0) NULL ,
	[PutoutTyID] [int] NULL ,
	[PutoutID] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[YX_Zffs] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_fs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Userid] [int] NULL ,
	[YX_Type] [int] NULL ,
	[YX_State] [int] NULL 
) ON [PRIMARY]




CREATE TABLE [dbo].[YXShop_LineItem] (
	[OrderId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ProductID] [int] NOT NULL ,
	[ProductName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UnitPrice] [decimal](10, 2) NOT NULL ,
	[MarketPrice] [decimal](18, 0) NULL ,
	[Quantity] [int] NOT NULL ,
	[ProIntegral] [decimal](18, 0) NULL ,
	[NeedIntegral] [decimal](18, 0) NULL ,
	[NeedDummyMoney] [decimal](18, 0) NULL ,
	[ShopPrice] [decimal](18, 0) NULL 
) ON [PRIMARY]


alter table yx_postform add yx_kddh varchar(100) 
alter table yx_postform add yx_kdgsdh varchar(100) 
alter table yx_postform add yx_msdh varchar(100) 
alter table yx_postform add yx_bz varchar(100) 

CREATE TABLE [dbo].[YXShop_Profiles] (
	[UniqueID] [int] IDENTITY (1, 1) NOT NULL ,
	[Username] [varchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ApplicationName] [varchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IsAnonymous] [bit] NULL ,
	[LastActivityDate] [datetime] NULL ,
	[LastUpdatedDate] [datetime] NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[YXShop_Account] (
	[UniqueID] [int] NOT NULL ,
	[Name] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[MemberId] [int] NULL ,
	[Province] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[Borough] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zip] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [varchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]