xxzxxzxxzxxz

USE [xxz]
GO
/****** Object:  Table [dbo].[xxz_userCard]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_userCard](
    [cardID] [int] IDENTITY(1,1) NOT NULL,
    [cardNumber] [int] NULL,
    [passworld] [nvarchar](50) NULL,
    [account] [decimal](18, 2) NULL,
    [isDefault] [bit] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_userCard] PRIMARY KEY CLUSTERED 
(
    [cardID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_userAdress]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_userAdress](
    [userAdressID] [int] IDENTITY(1,1) NOT NULL,
    [userAdress] [nvarchar](50) NULL,
    [isDefault] [bit] NULL,
    [ord] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_userAdress] PRIMARY KEY CLUSTERED 
(
    [userAdressID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_user]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_user](
    [userID] [int] IDENTITY(1,1) NOT NULL,
    [loginuser] [int] NULL,
    [passworld] [nvarchar](50) NULL,
    [usertype] [nvarchar](50) NULL,
    [sex] [int] NULL,
    [tel] [nvarchar](50) NULL,
    [cityID] [int] NULL,
    [address] [nvarchar](200) NULL,
    [post] [nvarchar](50) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_user] PRIMARY KEY CLUSTERED 
(
    [userID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_sku]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_sku](
    [skuID] [int] IDENTITY(1,1) NOT NULL,
    [productID] [int] NULL,
    [skuName] [nvarchar](50) NULL,
    [ord] [int] NULL,
    [color] [nvarchar](50) NULL,
    [litpic] [nvarchar](50) NULL,
    [attrs] [nvarchar](50) NULL,
    [marketprice] [nvarchar](50) NULL,
    [salesPrice] [nvarchar](50) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_sku] PRIMARY KEY CLUSTERED 
(
    [skuID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_shoppingcart]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_shoppingcart](
    [shoppingcartID] [int] IDENTITY(1,1) NOT NULL,
    [skuID] [int] NULL,
    [nums] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_shoppingcart] PRIMARY KEY CLUSTERED 
(
    [shoppingcartID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_product]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_product](
    [productID] [int] IDENTITY(1,1) NOT NULL,
    [categoryID] [int] NULL,
    [cityID] [int] NULL,
    [productName] [nvarchar](50) NULL,
    [description] [nvarchar](max) NULL,
    [ord] [int] NULL,
    [isshow] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_product] PRIMARY KEY CLUSTERED 
(
    [productID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_payment]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_payment](
    [paymentID] [int] IDENTITY(1,1) NOT NULL,
    [paymentcode] [nvarchar](50) NULL,
    [orderID] [int] NULL,
    [cardID] [int] NULL,
    [paymentStatus] [int] NULL,
    [state] [int] NULL,
    [paymentuserid] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_payment] PRIMARY KEY CLUSTERED 
(
    [paymentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_orderItem]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_orderItem](
    [orderItemID] [int] IDENTITY(1,1) NOT NULL,
    [orderID] [int] NULL,
    [productID] [int] NULL,
    [skuID] [int] NULL,
    [nums] [int] NULL,
    [price] [decimal](18, 2) NULL,
    [acount] [decimal](18, 2) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_orderItem] PRIMARY KEY CLUSTERED 
(
    [orderItemID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_order]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_order](
    [orderID] [int] IDENTITY(1,1) NOT NULL,
    [reciveAddress] [nvarchar](50) NULL,
    [orderTag] [nvarchar](50) NULL,
    [noticeTime] [datetime] NULL,
    [reciveTime] [datetime] NULL,
    [postman] [nvarchar](50) NULL,
    [postmanTel] [nvarchar](50) NULL,
    [orderStatus] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_order] PRIMARY KEY CLUSTERED 
(
    [orderID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_menu]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_menu](
    [menuID] [int] IDENTITY(1,1) NOT NULL,
    [menuName] [nvarchar](50) NULL,
    [menuValue] [nvarchar](50) NULL,
    [ord] [int] NULL,
    [fbase] [int] NULL,
    [sort] [nvarchar](50) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_menu] PRIMARY KEY CLUSTERED 
(
    [menuID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_help]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_help](
    [helpID] [int] IDENTITY(1,1) NOT NULL,
    [helpName] [nvarchar](50) NULL,
    [helpDesc] [nvarchar](max) NULL,
    [ord] [int] NULL,
    [fbase] [int] NULL,
    [sort] [nvarchar](50) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_help] PRIMARY KEY CLUSTERED 
(
    [helpID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_employeeInCompany]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_employeeInCompany](
    [companyID] [int] IDENTITY(1,1) NOT NULL,
    [employeeID] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_employeeInCompany] PRIMARY KEY CLUSTERED 
(
    [companyID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_employee]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_employee](
    [employeeID] [int] IDENTITY(1,1) NOT NULL,
    [loginuser] [nvarchar](50) NULL,
    [passworld] [nvarchar](50) NULL,
    [cityID] [int] NULL,
    [usertype] [nvarchar](50) NULL,
    [sex] [int] NULL,
    [tel] [nvarchar](50) NULL,
    [IDCard] [nvarchar](50) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_employee] PRIMARY KEY CLUSTERED 
(
    [employeeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_config]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_config](
    [configID] [int] IDENTITY(1,1) NOT NULL,
    [configName] [nvarchar](50) NULL,
    [configValue] [nvarchar](50) NULL,
    [ord] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_config] PRIMARY KEY CLUSTERED 
(
    [configID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_company]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_company](
    [companyID] [int] IDENTITY(1,1) NOT NULL,
    [companyName] [nvarchar](50) NULL,
    [companyCode] [nvarchar](50) NULL,
    [buildTime] [datetime] NULL,
    [adminID] [int] NULL,
    [cityID] [int] NULL,
    [address] [nvarchar](200) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_company] PRIMARY KEY CLUSTERED 
(
    [companyID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_city]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_city](
    [cityID] [int] IDENTITY(1,1) NOT NULL,
    [code] [nvarchar](50) NULL,
    [country] [nvarchar](50) NULL,
    [province] [nvarchar](50) NULL,
    [city] [nvarchar](50) NULL,
    [area] [nvarchar](50) NULL,
    [postcode] [nvarchar](50) NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_city] PRIMARY KEY CLUSTERED 
(
    [cityID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_category]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_category](
    [categoryID] [int] IDENTITY(1,1) NOT NULL,
    [categoryName] [nvarchar](50) NULL,
    [description] [nvarchar](max) NULL,
    [ord] [int] NULL,
    [fbase] [int] NULL,
    [sort] [nvarchar](50) NULL,
    [state] [int] NULL,
    [createAdminID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_category] PRIMARY KEY CLUSTERED 
(
    [categoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_attr]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_attr](
    [attrID] [int] IDENTITY(1,1) NOT NULL,
    [attrName] [nvarchar](50) NULL,
    [ord] [int] NULL,
    [pid] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_attr] PRIMARY KEY CLUSTERED 
(
    [attrID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_ads]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_ads](
    [adsID] [int] IDENTITY(1,1) NOT NULL,
    [AdsName] [nvarchar](50) NULL,
    [description] [nvarchar](max) NULL,
    [postionID] [int] NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_ads] PRIMARY KEY CLUSTERED 
(
    [adsID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[xxz_admin]    Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_admin](
    [adminID] [int] IDENTITY(1,1) NOT NULL,
    [loginuser] [nvarchar](50) NULL,
    [passworld] [nvarchar](50) NULL,
    [sex] [int] NULL,
    [tel] [nvarchar](50) NULL,
    [state] [int] NULL,
    [createUserID] [int] NULL,
    [createtime] [datetime] NULL,
    [ver] [int] NULL,
    [timestamp] [timestamp] NULL,
 CONSTRAINT [PK_xxz_admin] PRIMARY KEY CLUSTERED 
(
    [adminID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO