20 lines
621 B
SQL
20 lines
621 B
SQL
CREATE TABLE IF NOT EXISTS DiscussionForums (
|
|
ForumId BIGINT NOT NULL,
|
|
OrgUnitId INT,
|
|
Name VARCHAR(400),
|
|
Description VARCHAR(1000),
|
|
MustPostToParticipate TINYINT(1),
|
|
AllowAnon TINYINT(1),
|
|
IsHidden TINYINT(1),
|
|
RequiresApproval TINYINT(1),
|
|
SortOrder INT,
|
|
IsDeleted TINYINT(1),
|
|
DeletedDate DATETIME,
|
|
DeletedByUserId INT,
|
|
ResultId INT,
|
|
StartDate DATETIME,
|
|
StartDateAvailabilityType SMALLINT COMMENT '0=AccessRestricted, 1=SubmissionRestricted, 2=Hidden',
|
|
EndDate DATETIME,
|
|
EndDateAvailabilityType SMALLINT,
|
|
PRIMARY KEY (ForumId)
|
|
) CHARACTER SET utf8mb4; |