GO
CREATE TABLE [dbo].[ZL_Group](
[GroupID] [int] IDENTITY(1,1) NOT NULL,
[GroupName] [nvarchar](50) NOT NULL,
[OtherName] [nvarchar](255) NULL,
[Description] [nvarchar](255) NULL,
[RegSelect] [bit] NULL,
[IsDefault] [bit] NULL,
[CCountPerDay] [int] NULL,
[FavCount] [int] NULL,
[ConsumeType] [int] NULL,
[UpGradeMoney] [money] NULL,
[UpSIcon] [money] NULL,
[UpPoint] [money] NULL,
[CompanyGroup] [int] NULL,
[VIPNum] [int] NULL,
[VIPGroup] [int] NULL,
[RebateRate] [float] NULL,
[Credit] [int] NULL,
[Enroll] [varchar](500) NULL,
[ParentGroupID] [int] NULL,
[SignImg] [nvarchar](200) NULL,
[OrderID] [int] NULL,
CONSTRAINT [PK_ZL_UserGroup] PRIMARY KEY CLUSTERED
([GroupID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [ZL_Group] ON
INSERT [ZL_Group] ( [GroupID] , [GroupName] , [OtherName] , [Description] , [OrderID] , [RegSelect] , [IsDefault] , [CCountPerDay] , [FavCount] , [ConsumeType] , [UpGradeMoney] , [CompanyGroup] , [VIPNum] , [VIPGroup] , [RebateRate] ,[ParentGroupID] ) VALUES ( 1 , '普通会员' , '普通' , '普通会员注册' , 1 , 1 , 1 , 0 , 0 , 0 , .0000 , 0 , 0 , 0 , 0.69999998807907104 , 0 )
INSERT [ZL_Group] ( [GroupID] , [GroupName] , [OtherName] , [Description] , [OrderID] , [RegSelect] , [IsDefault] , [CCountPerDay] , [FavCount] , [ConsumeType] , [UpGradeMoney] , [CompanyGroup] , [VIPNum] , [VIPGroup] , [RebateRate] ,[ParentGroupID] ) VALUES ( 2 , '企业会员' , '企业' , '企业用户注册' , 2 , 1 , 0 , 0 , 0 , 0 , .0000 , 1 , 0 , 0 , 0.80000001192092896 , 0 )
SET IDENTITY_INSERT [ZL_Group] OFF