Mercurial > altnet-hispano

annotate Agendas/trunk/db/v1.0/01 - Otros Ponentes.sql @ 225:f23ee59ef1bd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Otros ponentes
author nelopauselli
date Mon, 26 Sep 2011 08:47:01 -0300
parents
children 4d05b5883eac
rev   line source
225
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
1 drop table OtrosPonentes
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
2 go
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
3
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
4 create table OtrosPonentes (
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
5 evento_key uniqueidentifier not null,
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
6 elt uniqueidentifier not null,
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
7 constraint PK_Colaboradores primary key(evento_key, elt),
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
8 constraint FK_Colaboradores_Evento foreign key (evento_key) references Evento,
f23ee59ef1bd Otros ponentes
nelopauselli
parents:
diff changeset
9 constraint FK_Colaboradores_Persona foreign key (elt) references Persona)