USE [Ecommerce]
GO
/****** Object: Table [dbo].[Promotion_Acer] Script Date: 05/08/2007 17:39:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Promotion_Acer](
[SysNo] [int] IDENTITY(1,1) NOT NULL,
[MachineSN] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[WarrantyCode] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[PromotionCode] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[PromotionCodeSysNo] [int] NOT NULL,
[CustomerSysNo] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED
(
[SysNo] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
USE [IPP3]
GO
/****** Object: Table [dbo].[Customer] Script Date: 05/08/2007 17:39:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
[SysNo] [int] NOT NULL,
[CustomerID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Pwd] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Status] [int] NOT NULL CONSTRAINT [DF__Customer__Status__3EDC53F0] DEFAULT ((0)),
[CustomerName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Gender] [int] NULL,
[Email] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Phone] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[CellPhone] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Fax] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[DwellAreaSysNo] [int] NOT NULL,
[DwellAddress] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[DwellZip] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReceiveName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReceiveContact] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReceivePhone] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReceiveCellPhone] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReceiveFax] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReceiveAreaSysNo] [int] NOT NULL,
[ReceiveAddress] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[ReceiveZip] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[TotalScore] [int] NOT NULL CONSTRAINT [DF__Customer__TotalS__3FD07829] DEFAULT ((0)),
[ValidScore] [int] NOT NULL CONSTRAINT [DF__Customer__ValidS__40C49C62] DEFAULT ((0)),
[CardNo] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Note] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[IsEmailConfirmed] [int] NOT NULL CONSTRAINT [DF__Customer__EmailS__41B8C09B] DEFAULT ((0)),
[IsSubscribe] [int] NOT NULL CONSTRAINT [DF_Customer_IsSubscribe] DEFAULT ((1)),
[RegisterTime] [datetime] NOT NULL CONSTRAINT [DF__Customer__Regist__42ACE4D4] DEFAULT (getdate()),
[Rank] [int] NULL CONSTRAINT [DF_Customer_Rank] DEFAULT ((1)),
[AuctionRank] [int] NULL CONSTRAINT [DF_Customer_AuctionRank] DEFAULT ((0)),
[VIPRank] [int] NOT NULL CONSTRAINT [DF_Customer_VIPRank] DEFAULT ((1)),
[TotalSOMoney] [decimal](19, 6) NOT NULL CONSTRAINT [DF_Customer_TotalSOMoney] DEFAULT ((0.0)),
[FromLinkSource] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[LastLoginDate] [datetime] NULL,
[IsAllowComment] [int] NOT NULL DEFAULT ((0)),
[Birthday] [datetime] NULL,
[PointExpiringDate] [datetime] NULL DEFAULT (getdate()),
[PromotionRankSign] [int] NOT NULL DEFAULT ((0)),
CONSTRAINT [PK_CUSTOMER] PRIMARY KEY CLUSTERED
(
[SysNo] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]