3 Answers, 1 is accepted
0
Hi,
Of course, here is the script for the basic structure (no resources):
Best wishes,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Of course, here is the script for the basic structure (no resources):
USE [Northwind] |
GO |
CREATE TABLE [dbo].[Appointments] |
( |
[ID] int IDENTITY(1,1) NOT NULL, |
[Subject] nvarchar(255) NOT NULL, |
[Start] datetime NOT NULL, |
[End] datetime NOT NULL, |
[RecurrenceRule] nvarchar(1024) NULL, |
[RecurrenceParentID] int NULL, |
[Annotations] nvarchar(50) NULL, |
CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED |
([ID]), |
CONSTRAINT [FK_Appointments_ParentAppointments] FOREIGN KEY |
([RecurrenceParentID]) |
REFERENCES |
[dbo].[Appointments] ([ID]) |
) |
GO |
Best wishes,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
drgorin
Top achievements
Rank 1
answered on 07 Jan 2008, 04:52 PM
Thank you for this abbreviated script, which builds 1 of the database tables. We would greatly appreciate the script that builds the *entire* database solution, including all tables, PK's , FK's resources, users, rooms, etc.
0
Hello,
Sorry, I assumed that you will not be using the resource definitions from the examples. Here is the complete script:
Greetings,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Sorry, I assumed that you will not be using the resource definitions from the examples. Here is the complete script:
USE [DBName] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [Rooms] ( [ID] int IDENTITY(1,1) NOT NULL, [RoomName] nvarchar(255) NOT NULL, CONSTRAINT [PK_Rooms] PRIMARY KEY CLUSTERED ([ID]) ) GO CREATE TABLE [Users] ( [ID] int NOT NULL, [UserName] nvarchar(255) NOT NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ([ID]) ) GO CREATE TABLE [dbo].[Appointments] ( [ID] int IDENTITY(1,1) NOT NULL, [Subject] nvarchar(255) NOT NULL, [Start] datetime NOT NULL, [End] datetime NOT NULL, [RoomID] int NULL, [UserID] int NULL, [RecurrenceRule] nvarchar(1024) NULL, [RecurrenceParentID] int NULL, [Annotations] nvarchar(50) NULL, CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED ([ID]), CONSTRAINT [FK_Appointments_ParentAppointments] FOREIGN KEY ([RecurrenceParentID]) REFERENCES [Appointments] ([ID]), CONSTRAINT [FK_Appointments_Rooms] FOREIGN KEY ([RoomID]) REFERENCES [Rooms] ([ID]), CONSTRAINT [FK_Appointments_Users] FOREIGN KEY ([UserID]) REFERENCES [Users] ([ID]) ) GO |
Greetings,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center