Mercurial > altnet-hispano
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 231:e5959f3405e0 | 235:c61954d24c8c |
|---|---|
| 1 if (OBJECT_ID('Ponentes') is null) | |
| 2 begin | |
| 3 if (OBJECT_ID('OtrosPonentes') is not null) | |
| 4 EXEC sp_rename 'dbo.OtrosPonentes', 'Ponentes' | |
| 5 else | |
| 6 create table Ponentes ( | |
| 7 evento_key uniqueidentifier not null, | |
| 8 elt uniqueidentifier not null, | |
| 9 constraint PK_Ponentes primary key(evento_key, elt), | |
| 10 constraint FK_Ponentes_Evento foreign key (evento_key) references Evento, | |
| 11 constraint FK_Ponentes_Persona foreign key (elt) references Persona) | |
| 12 end | |
| 13 go |