/* 
yTemplateService
version 0.5(2007-10-06)
Copyright (C) 2007 Michael Fuchs
http://www.michael-fuchs.net/

This software is und YPA Library License. See the COPYING files or
http://www.ypa-software.de/pages/ypa-library-license.php for details.
*/

/*CREATE Templates*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Templates](
	[Id] [nvarchar](36) NOT NULL,
	[Name] [nvarchar](255) NOT NULL,
	[Description] [nvarchar](max) NULL,
 CONSTRAINT [PK_Templates] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/*CREATE TemplateTexts*/
CREATE TABLE [dbo].[TemplateTexts](
	[Id] [nvarchar](36) NOT NULL,
	[TemplateId] [nvarchar](36) NOT NULL,
	[Language] [nvarchar](3) NOT NULL,
	[Subject] [nvarchar](255) NULL,
	[Text] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_TemplateTexts] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TemplateTexts]  WITH CHECK ADD  CONSTRAINT [FK_TemplateTexts_Templates] FOREIGN KEY([TemplateId])
REFERENCES [dbo].[Templates] ([Id])
GO
ALTER TABLE [dbo].[TemplateTexts] CHECK CONSTRAINT [FK_TemplateTexts_Templates]

/*CREATE Parameters*/
CREATE TABLE [dbo].[Parameters](
	[Id] [nvarchar](36) NOT NULL,
	[TemplateId] [nvarchar](36) NOT NULL,
	[Name] [nvarchar](255) NOT NULL,
	[Description] [nvarchar](255) NULL,
 CONSTRAINT [PK_Parameters] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Parameters]  WITH CHECK ADD  CONSTRAINT [FK_Parameters_Templates] FOREIGN KEY([TemplateId])
REFERENCES [dbo].[Templates] ([Id])
GO
ALTER TABLE [dbo].[Parameters] CHECK CONSTRAINT [FK_Parameters_Templates]