添加群组表AppGroup和群组详细表AppGroupDetails
CREATE TABLE [dbo].[AppGroup](
[Id] [nvarchar](50) NOT NULL PRIMARY KEY,
[GroupName] [nvarchar](50) NOT NULL,
[Portrait] [nvarchar](200) NULL,
[Description] [nvarchar](500) NULL,
[CreateDate] [datetime] NULL,
[CreateUserId] [nvarchar](50) NULL,
[CreateUserName] [nvarchar](50) NULL,
[ModifyDate] [datetime] NULL,
[ModifyUserId] [nvarchar](50) NULL,
[ModifyUserName] [nvarchar](50) NULL,
) CREATE TABLE [dbo].[AppGroupDetails](
[Id] [nvarchar](50) NOT NULL PRIMARY KEY,
[GroupId] [nvarchar](50) NOT NULL,
[UserId] [nvarchar](50) NOT NULL,
[CreateDate] [datetime] NULL,
[CreateUserId] [nvarchar](50) NULL,
[CreateUserName] [nvarchar](50) NULL,
)
表AppGroup添加字段DiscussionId
alter table AppGroup add DiscussionId nvarchar(50)