--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Agendas/trunk/db/v1.1/02 - Patrocinadores.sql	Wed Nov 30 08:56:01 2011 -0300
@@ -0,0 +1,45 @@
+/****** Object:  Table [dbo].[Patrocinador]    Script Date: 11/30/2011 07:46:21 ******/
+IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Patrocinador_Evento]') AND parent_object_id = OBJECT_ID(N'[dbo].[Patrocinador]'))
+ALTER TABLE [dbo].[Patrocinador] DROP CONSTRAINT [FK_Patrocinador_Evento]
+GO
+
+/****** Object:  Table [dbo].[Patrocinador]    Script Date: 11/30/2011 07:46:35 ******/
+IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Patrocinador]') AND type in (N'U'))
+DROP TABLE [dbo].[Patrocinador]
+GO
+
+
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+SET ANSI_PADDING ON
+GO
+
+CREATE TABLE [dbo].[Patrocinador](
+	[Id] [uniqueidentifier] NOT NULL,
+	[Nombre] [nvarchar](255) NULL,
+	[Logo] [varbinary](8000) NULL,
+	[evento_key] [uniqueidentifier] NULL,
+	[idx] [int] NULL,
+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
+
+SET ANSI_PADDING OFF
+GO
+
+ALTER TABLE [dbo].[Patrocinador]  WITH CHECK ADD  CONSTRAINT [FK_Patrocinador_Evento] FOREIGN KEY([evento_key])
+REFERENCES [dbo].[Evento] ([Id])
+GO
+
+ALTER TABLE [dbo].[Patrocinador] CHECK CONSTRAINT [FK_Patrocinador_Evento]
+GO
+
+