Mercurial > altnet-hispano
view Agendas/trunk/db/v1.1/02 - Patrocinadores.sql @ 274:72a96459f910
Ticket #123: Patrocinadores de las vans.
author | juanjose.montesdeocaarbos |
---|---|
date | Wed, 30 Nov 2011 08:56:01 -0300 |
parents | |
children | eeca9ddb330a |
line wrap: on
line source
/****** 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