view Agendas/trunk/db/v1.0/01 - Ponentes.sql @ 235:c61954d24c8c

Quitando ponente principal y utilizando siempre la lista de ponentes
author nelopauselli
date Tue, 04 Oct 2011 20:42:35 -0300
parents Agendas/trunk/db/v1.0/01 - Otros Ponentes.sql@4d05b5883eac
children b43dc14886e3
line wrap: on
line source

if (OBJECT_ID('Ponentes') is null)
begin
	if (OBJECT_ID('OtrosPonentes') is not null)
		EXEC sp_rename 'dbo.OtrosPonentes', 'Ponentes'
	else
		create table Ponentes (
			evento_key uniqueidentifier not null,
			elt uniqueidentifier not null,
			constraint PK_Ponentes primary key(evento_key, elt),
			constraint FK_Ponentes_Evento foreign key (evento_key) references Evento,
			constraint FK_Ponentes_Persona foreign key (elt) references Persona)
end
go