1. How to create data table for Scheduler?

Create table Events in SQL Server with sql script belows:


CREATE TABLE SchedulerEvents
(
ID int IDENTITY(1,1) NOT NULL,
Subject nvarchar(200),
StartTime datetime NOT NULL,
EndTime datetime NOT NULL,
Place nvarchar(100),
UserID int,
RecurrenceRule nvarchar(30),
RecurrenceParentID int,
Description nvarchar(200),
CategoryID int,
PRIMARY KEY(ID ASC)
)

Create table SchedulerUserSettings in SQL Server with sql script belows:


CREATE TABLE SchedulerUserSettings
(
UserID int IDENTITY(1,1) NOT NULL,
Language nvarchar(10),
Timezone int,
DateFormat nvarchar(20),
ShowWeekend int,
WeekStart int,
TimeFormat nvarchar(20),
DefaultView int,
CustomViewDayNumber int,
BoundStartDate datetime,
BoundEndDate datetime,
PRIMARY KEY(UserID ASC)
)

Create table SchedulerCategory in SQL Server with sql script belows:


CREATE TABLE SchedulerCategories
(
ID int IDENTITY(1,1) NOT NULL,
UserID int,
Name nvarchar(50),
Show bit,
Theme nvarchar(20),
PRIMARY KEY(ID ASC)
)


Notes:You also may download this Scheduler dabtase installer to setup database