MS SQL Server Data Tables
- 2 minutes to read
The following *.sql script should be used to generate two tables to persist appointments and resources data.
SQL Script |
---|
CREATE TABLE [dbo].[Appointments] ( [Unique [Type] [int] NULL , [Start [End [All [Subject] [nvarchar] (50) NULL , [Location] [nvarchar] (50) NULL , [Description] [nvarchar](max) NULL , [Status] [int] NULL , [Label] [int] NULL , [Resource [Resource [Reminder [Recurrence [Custom CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED ( [Unique ) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Resources] ( [Unique [Resource [Resource [Color] [int] NULL , [Image] [image] NULL , [Custom CONSTRAINT [PK_Resources] PRIMARY KEY CLUSTERED ( [Unique ) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO |
Note
If Scheduler