ASP.NET Scheduler - Database Installation Guide

You can download the Scheduler database installer to setup the database.

Create table Events in SQL Server with sql script belows:


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


Create table SchedulerUserSettings in SQL Server with sql script belows:


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


Create table SchedulerCategory in SQL Server with sql script belows:


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