OBOUT - ASP.NET Scheduler - Database Installation Guide

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 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)

)