Mercurial > altnet-hispano

comparison Agendas/trunk/db/v1.1/02 - Patrocinadores.sql @ 287:eeca9ddb330a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
286:a8f7c41e3b47 287:eeca9ddb330a
1 /****** Object: Table [dbo].[Patrocinador] Script Date: 11/30/2011 07:46:21 ******/ 1 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]'))
2 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]')) 2 ALTER TABLE [dbo].[Patrocinadores] DROP CONSTRAINT [FK_Patrocinadores_Evento]
3 ALTER TABLE [dbo].[Patrocinador] DROP CONSTRAINT [FK_Patrocinador_Evento]
4 GO 3 GO
5 4
6 /****** Object: Table [dbo].[Patrocinador] Script Date: 11/30/2011 07:46:35 ******/ 5 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]'))
6 ALTER TABLE [dbo].[Patrocinadores] DROP CONSTRAINT [FK_Patrocinadores_Patrocinador]
7 GO
8
9 IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Patrocinadores]') AND type in (N'U'))
10 DROP TABLE [dbo].[Patrocinadores]
11 GO
12
7 IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Patrocinador]') AND type in (N'U')) 13 IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Patrocinador]') AND type in (N'U'))
8 DROP TABLE [dbo].[Patrocinador] 14 DROP TABLE [dbo].[Patrocinador]
9 GO 15 GO
10
11 16
12 SET ANSI_NULLS ON 17 SET ANSI_NULLS ON
13 GO 18 GO
14 19
15 SET QUOTED_IDENTIFIER ON 20 SET QUOTED_IDENTIFIER ON
20 25
21 CREATE TABLE [dbo].[Patrocinador]( 26 CREATE TABLE [dbo].[Patrocinador](
22 [Id] [uniqueidentifier] NOT NULL, 27 [Id] [uniqueidentifier] NOT NULL,
23 [Nombre] [nvarchar](255) NULL, 28 [Nombre] [nvarchar](255) NULL,
24 [Logo] [varbinary](8000) NULL, 29 [Logo] [varbinary](8000) NULL,
25 [evento_key] [uniqueidentifier] NULL,
26 [idx] [int] NULL,
27 PRIMARY KEY CLUSTERED 30 PRIMARY KEY CLUSTERED
28 ( 31 (
29 [Id] ASC 32 [Id] ASC
30 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 33 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
31 ) ON [PRIMARY] 34 ) ON [PRIMARY]
33 GO 36 GO
34 37
35 SET ANSI_PADDING OFF 38 SET ANSI_PADDING OFF
36 GO 39 GO
37 40
38 ALTER TABLE [dbo].[Patrocinador] WITH CHECK ADD CONSTRAINT [FK_Patrocinador_Evento] FOREIGN KEY([evento_key]) 41 SET ANSI_NULLS ON
42 GO
43 SET QUOTED_IDENTIFIER ON
44 GO
45 CREATE TABLE [dbo].[Patrocinadores](
46 [evento_key] [uniqueidentifier] NOT NULL,
47 [elt] [uniqueidentifier] NOT NULL,
48 [idx] [int] NOT NULL,
49 PRIMARY KEY CLUSTERED
50 (
51 [evento_key] ASC,
52 [idx] ASC
53 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
54 ) ON [PRIMARY]
55 GO
56
57 ALTER TABLE [dbo].[Patrocinadores] WITH CHECK ADD CONSTRAINT [FK_Patrocinadores_Evento] FOREIGN KEY([evento_key])
39 REFERENCES [dbo].[Evento] ([Id]) 58 REFERENCES [dbo].[Evento] ([Id])
40 GO 59 GO
41 60
42 ALTER TABLE [dbo].[Patrocinador] CHECK CONSTRAINT [FK_Patrocinador_Evento] 61 ALTER TABLE [dbo].[Patrocinadores] CHECK CONSTRAINT [FK_Patrocinadores_Evento]
43 GO 62 GO
44 63
45 64 ALTER TABLE [dbo].[Patrocinadores] WITH CHECK ADD CONSTRAINT [FK_Patrocinadores_Patrocinador] FOREIGN KEY([elt])
65 REFERENCES [dbo].[Patrocinador] ([Id])
66 GO
67 ALTER TABLE [dbo].[Patrocinadores] CHECK CONSTRAINT [FK_Patrocinadores_Patrocinador]
68 GO