insert into block (name, access, count)
values ("B1",1,0),("B2",1,0),("B3",1,0),("B4",1,0),("B5",1,0);
insert into classroom(name, block_id, access, count)
values ("Sala1",1,1,0),("Sala2",1,1,0),("Sala3",null,1,0),
("Sala4",2,1,0),("Sala5",null,1,0),("Sala6",2,1,0),
("Sala7",null,1,0),("Sala8",4,1,0),("Sala9",2,1,0),
("Sala10",3,1,0),("Sala11",3,1,0),("Sala12",4,1,0),
("Sala13",4,1,0),("Sala14",null,1,0),("Sala15",null,1,0),
("Sala16",1,1,0),("Sala17",5,1,0),("Sala18",5,1,0);
insert into computer(name,access,count)
values ("Asus 1",1,0),("Asus 2",1,0),("Asus 3",1,0),
("Toshiba 1",1,0),("Toshiba 2",1,0),("Toshiba 3",1,0),
("Asus 4",1,0),("asus 10",1,0),("Toshiba 9",1,0),
("Asus 5",1,0),("asus 11",1,0),("Toshiba 10",1,0),
("Asus 6",1,0),("Toshiba 5",1,0),("Toshiba 4",1,0),
("Asus 7",1,0),("Toshiba 6",1,0),("Toshiba 11",1,0),
("Asus 8",1,0),("Toshiba 7",1,0),("Toshiba 12",1,0),
("Asus 9",1,0),("Toshiba 8",1,0),("Toshiba 13",1,0);
insert into networkdrive(name, computer_id,mac)
values ("Rede wireless",1,"00:1D:7D:B2:34:F9"),
("Rede Ethernet",1,"88:12:32:3A:21:4B"),
("Rede wireless",2,"A2:32:B1:88:22:8C"),
("Rede Ethernet",2,"81:12:32:3A:21:4B"),
("Rede wireless",3,"B2:32:B1:88:22:8C"),
("Rede Ethernet",3,"88:13:32:3A:21:4B"),
("Rede wireless",4,"A2:33:B1:88:22:8C"),
("Rede Ethernet",4,"88:12:42:3A:21:4B"),
("Rede wireless",5,"A2:32:B4:88:22:8C"),
("Rede Ethernet",5,"88:14:22:3A:21:4B"),
("Rede wireless",6,"A2:32:B2:88:23:8C"),
("Rede Ethernet",6,"88:12:32:3C:21:4C"),
("Rede wireless",7,"A2:32:B1:C8:22:81"),
("Rede Ethernet",7,"01:12:32:3A:21:4B"),
("Rede Ethernet",8,"01:3c:32:3A:21:4B"),
("Rede wireless",8,"aA2:32:21:88:22:8C"),
("Rede Ethernet",9,"80:12:32:3A:21:40"),
("Rede wireless",9,"A2:32:B1:8D:22:C0"),
("Rede Ethernet",10,"88:10:3D:36:21:4B"),
("Rede wireless",10,"A1:32:E1:07:22:8C"),
("Rede Ethernet",11,"80:12:4A:30:21:4A"),
("Rede wireless",11,"A2:62:B1:88:22:8B"),
("Rede Ethernet",12,"00:82:32:3A:21:4B"),
("Rede wireless",12,"A2:32:B1:88:22:91");
insert into equipmentposition(classroom_id,top,side,computer_id)
values (1,0,0,1),(1,0,0,2),(1,0,0,3),
(2,0,0,4),(2,0,0,5),(2,0,0,6),
(3,0,0,7),(2,0,0,8),(2,0,0,9),
(1,0,0,17),(1,0,0,18),(1,0,0,10),
(5,0,0,19),(1,0,0,21),(1,0,0,11),
(1,0,0,20),(1,0,0,22),(4,0,0,12),
(5,0,0,13),(1,0,0,14),(4,0,0,15),
(3,0,0,16);
insert into aclass(id,name,ano, access, count)
values ("1","9a1",9,1,0),("2","10a2",10,1,0),("3","11a2",11,1,0),("4","12a2",12,1,0),("5","9a2",9,1,0),("6","9a3",9,1,0),("7","9a4",9,1,0),
("8","10a1",10,1,0),("10","10a3",10,1,0),("11","10a4",10,1,0),
("16","11a1",11,1,0),("15","11a3",11,1,0),("12","11a4",11,1,0),
("17","12a1",12,1,0),("14","12a3",12,1,0),("13","12a4",12,1,0);
insert into student(id,name, access, count)
values ("1a","Diogo Corte",1,0),("1b","Manuel Santos",1,0),("1c","Raquel Tavares",1,0),
("1d","Sofia Rocha",1,0),("1e","Eduardo Sousa",1,0),("1f","Sérgio Manso",1,0),
("2a","Eduardo Santos",1,0),("4c","Rui Ribeiro",1,0),("5a","Diogo Manso",1,0),
("2b","Rui Espinha",1,0),
("2c","Daniel Magalhães",1,0),("5b","Cristiano Ronaldo",1,0),
("3a","Rui Guimarães",1,0),("5c","Diogo",1,0),("10a","Diogo",1,0),
("3b","Henrique Sousa",1,0),("6c","Elvira Sousa",1,0),("10ac","Paulo Gaspar",1,0),
("3c","Pedro Passos",1,0),("6b","Anibal Silva",1,0),("11ac","Angela Merkel",1,0),
("4a","Tiago Santos",1,0),("6a","Tatiana Monte",1,0),("12ac","Joana Leite",1,0),
("4b","Luisa Conde",1,0),("6d","Luisa Tavares",1,0),("13ac","José Mourinho",1,0);
insert into student_class(student_id,class_id)
values ("10a","1"),("10ac","1"),("11ac","1"),("12ac","2"),("13ac","2"),("1a","2"),("1b","2"),("1c","3"),("1d","3"),("1e","3"),("1f","3"),("2a","3"),("2b","1"),("2c","1"),("3a","1"),("3b","1"),("3c","1"),("4a","1"),("4b","1"),("4c","1"),("5a","2"),("5b","2"),("5c","2"),("6a","2"),("6b","2"),("6c","2"),("6d","2");
insert into studentdevice(student,device,mac)
values ("1a","mobile","00:1D:7E:BF:34:F9"),
("1a","computer","10:1F:73:BF:35:F1"),
("1d","mobile","13:14:7c:BF:34:F9"),
("1d","computer","1a:44:7c:BF:34:F9"),
("1d","mobile","13:18:7d:BF:34:F9"),
("1d","mobile","00:1D:7E:B2:34:F1");
insert into teacher(object_id,class_id, count)
values ("prof1","1",0), ("prof2","2",0);