Mercurial > altnet-hispano
view Agendas/trunk/db/v1.0/01 - Ponentes.sql @ 288:a6037c6c88d8
Se soluciona bug #198 Bug: Summary incorrecto en Google Calendar.
Se parametriza la hora en el mensaje.
author | user@MECHUQUE |
---|---|
date | Mon, 30 Jan 2012 01:52:47 -0300 |
parents | b43dc14886e3 |
children |
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 insert into Ponentes (evento_key, elt) select e.Id, e.Ponente from Evento e where e.Ponente is not null and e.Ponente not in (select p.elt from Ponentes p where p.evento_key = e.Id) go