EventPlus/script_codeFirst.sql at main · Pedrohbedin/EventPlus · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
INSERT INTO TiposUsuario
VALUES (NEWID(),'Administrador')
	  ,(NEWID(),'Comum');

SELECT * FROM TiposUsuario

INSERT INTO Usuario
VALUES (NEWID(),'Carlos','admin@admin.com','12345','AD1D2D55-2CBE-4F33-ADC0-F7471B683EC2')
	  ,(NEWID(),'Gabriel','gabriel@gmail.com','43214','E666945F-D4A5-4F69-AF54-A9E411F3526C')
	  ,(NEWID(),'Tiago','tiago@yahoo.com','98576','E666945F-D4A5-4F69-AF54-A9E411F3526C');

SELECT * FROM Usuario

INSERT INTO Instituicao
VALUES (NEWID(),'12345678912345','Av.Niterói 180','Escola Event+');

SELECT * FROM Instituicao

INSERT INTO TiposEvento
VALUES (NEWID(),'C#')
	  ,(NEWID(),'ReactJS')
	  ,(NEWID(),'SQL Server');

SELECT * FROM TiposEvento

INSERT INTO Evento
VALUES (NEWID(),'2021-08-09','POO','Conceitos de POO','EBA9AE6C-64A6-4B35-BEC3-FF6DE0DBF8BF','278A31D7-7D58-414F-A44F-72B9DCE5C42C')
	  ,(NEWID(),'2021-02-15','ReactJS','Ciclos de Vidas React JS','EBA9AE6C-64A6-4B35-BEC3-FF6DE0DBF8BF','278A31D7-7D58-414F-A44F-72B9DCE5C42C')
	  ,(NEWID(),'2021-12-25','Introdução ao SQL','Conceitos básicos do SQL Server','EBA9AE6C-64A6-4B35-BEC3-FF6DE0DBF8BF','278A31D7-7D58-414F-A44F-72B9DCE5C42C');

SELECT * FROM Evento

INSERT INTO PresencasEvento
VALUES (NEWID(),1,'133C32F0-F299-4034-94CE-9145B99F771B','62D0F76E-1F4B-412E-A63F-4BD814609421')
      ,(NEWID(),0,'133C32F0-F299-4034-94CE-9145B99F771B','0EFC2FED-94CE-4D06-8DDD-8CAF1E917BFE')
	  ,(NEWID(),1,'AB00B78A-BD90-46FD-AED9-A452C134A48D','B0AB53D9-FDD9-4D44-9955-BE3AA831DF44');

SELECT * FROM PresencasEvento

INSERT INTO ComentariosEvento
VALUES (NEWID(),'ótimo evento',0,'133C32F0-F299-4034-94CE-9145B99F771B','0EFC2FED-94CE-4D06-8DDD-8CAF1E917BFE')
      ,(NEWID(),'péssimo evento',1,'133C32F0-F299-4034-94CE-9145B99F771B','62D0F76E-1F4B-412E-A63F-4BD814609421')
	  ,(NEWID(),'porcaria de evento',1,'AB00B78A-BD90-46FD-AED9-A452C134A48D','B0AB53D9-FDD9-4D44-9955-BE3AA831DF44');

SELECT * FROM ComentariosEvento