Mercurial > altnet-hispano
diff 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 diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/Agendas/trunk/db/v1.0/01 - Ponentes.sql Tue Oct 04 20:42:35 2011 -0300 @@ -0,0 +1,13 @@ +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