Mercurial > altnet-hispano

comparison Agendas/trunk/db/v1.1/02 - Patrocinadores.sql @ 274:72a96459f910

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Ticket #123: Patrocinadores de las vans.
author juanjose.montesdeocaarbos
date Wed, 30 Nov 2011 08:56:01 -0300
parents
children eeca9ddb330a
comparison
equal deleted inserted replaced
273:a7420f05716a 274:72a96459f910
1 /****** Object: Table [dbo].[Patrocinador] Script Date: 11/30/2011 07:46:21 ******/
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]'))
3 ALTER TABLE [dbo].[Patrocinador] DROP CONSTRAINT [FK_Patrocinador_Evento]
4 GO
5
6 /****** Object: Table [dbo].[Patrocinador] Script Date: 11/30/2011 07:46:35 ******/
7 IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Patrocinador]') AND type in (N'U'))
8 DROP TABLE [dbo].[Patrocinador]
9 GO
10
11
12 SET ANSI_NULLS ON
13 GO
14
15 SET QUOTED_IDENTIFIER ON
16 GO
17
18 SET ANSI_PADDING ON
19 GO
20
21 CREATE TABLE [dbo].[Patrocinador](
22 [Id] [uniqueidentifier] NOT NULL,
23 [Nombre] [nvarchar](255) NULL,
24 [Logo] [varbinary](8000) NULL,
25 [evento_key] [uniqueidentifier] NULL,
26 [idx] [int] NULL,
27 PRIMARY KEY CLUSTERED
28 (
29 [Id] ASC
30 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
31 ) ON [PRIMARY]
32
33 GO
34
35 SET ANSI_PADDING OFF
36 GO
37
38 ALTER TABLE [dbo].[Patrocinador] WITH CHECK ADD CONSTRAINT [FK_Patrocinador_Evento] FOREIGN KEY([evento_key])
39 REFERENCES [dbo].[Evento] ([Id])
40 GO
41
42 ALTER TABLE [dbo].[Patrocinador] CHECK CONSTRAINT [FK_Patrocinador_Evento]
43 GO
44
45