Mercurial > altnet-hispano
diff Agendas/trunk/db/v1.1/02 - Patrocinadores.sql @ 287:eeca9ddb330a
BUG: Los Patrocinadores quedaban asociados a un único evento. Se armó un test que lo demuestra y se modificó el modelo de la base de datos.
author | juanjose.montesdeocaarbos |
---|---|
date | Mon, 02 Jan 2012 19:44:41 -0300 |
parents | 72a96459f910 |
children |
line wrap: on
line diff
--- a/Agendas/trunk/db/v1.1/02 - Patrocinadores.sql Mon Jan 02 15:51:19 2012 -0300 +++ b/Agendas/trunk/db/v1.1/02 - Patrocinadores.sql Mon Jan 02 19:44:41 2012 -0300 @@ -1,14 +1,19 @@ -/****** 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] +IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Patrocinadores_Evento]') AND parent_object_id = OBJECT_ID(N'[dbo].[Patrocinadores]')) +ALTER TABLE [dbo].[Patrocinadores] DROP CONSTRAINT [FK_Patrocinadores_Evento] GO -/****** Object: Table [dbo].[Patrocinador] Script Date: 11/30/2011 07:46:35 ******/ +IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Patrocinadores_Patrocinador]') AND parent_object_id = OBJECT_ID(N'[dbo].[Patrocinadores]')) +ALTER TABLE [dbo].[Patrocinadores] DROP CONSTRAINT [FK_Patrocinadores_Patrocinador] +GO + +IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Patrocinadores]') AND type in (N'U')) +DROP TABLE [dbo].[Patrocinadores] +GO + 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 @@ -22,8 +27,6 @@ [Id] [uniqueidentifier] NOT NULL, [Nombre] [nvarchar](255) NULL, [Logo] [varbinary](8000) NULL, - [evento_key] [uniqueidentifier] NULL, - [idx] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC @@ -35,11 +38,31 @@ SET ANSI_PADDING OFF GO -ALTER TABLE [dbo].[Patrocinador] WITH CHECK ADD CONSTRAINT [FK_Patrocinador_Evento] FOREIGN KEY([evento_key]) +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +CREATE TABLE [dbo].[Patrocinadores]( + [evento_key] [uniqueidentifier] NOT NULL, + [elt] [uniqueidentifier] NOT NULL, + [idx] [int] NOT NULL, +PRIMARY KEY CLUSTERED +( + [evento_key] ASC, + [idx] 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].[Patrocinadores] WITH CHECK ADD CONSTRAINT [FK_Patrocinadores_Evento] FOREIGN KEY([evento_key]) REFERENCES [dbo].[Evento] ([Id]) GO -ALTER TABLE [dbo].[Patrocinador] CHECK CONSTRAINT [FK_Patrocinador_Evento] +ALTER TABLE [dbo].[Patrocinadores] CHECK CONSTRAINT [FK_Patrocinadores_Evento] GO - +ALTER TABLE [dbo].[Patrocinadores] WITH CHECK ADD CONSTRAINT [FK_Patrocinadores_Patrocinador] FOREIGN KEY([elt]) +REFERENCES [dbo].[Patrocinador] ([Id]) +GO +ALTER TABLE [dbo].[Patrocinadores] CHECK CONSTRAINT [FK_Patrocinadores_Patrocinador] +GO