1 | |
---|
2 | DELETE FROM centros; |
---|
3 | INSERT INTO centros ( |
---|
4 | idcentro, nombrecentro, identidad, comentarios, directorio) |
---|
5 | VALUES |
---|
6 | (1, 'Center', 1, '', ''); |
---|
7 | |
---|
8 | DELETE FROM aulas; |
---|
9 | INSERT INTO aulas ( |
---|
10 | nombreaula, idcentro, urlfoto, grupoid, |
---|
11 | ubicacion, puestos, modomul, ipmul, |
---|
12 | pormul, velmul, router, netmask, ntp, |
---|
13 | dns, proxy, modp2p, timep2p |
---|
14 | ) |
---|
15 | VALUES |
---|
16 | ( |
---|
17 | 'Room', 1, 'aula.jpg', 0, 'Test room.', |
---|
18 | 5, 2, '239.194.2.11', 9000, 70, '192.168.56.1', |
---|
19 | '255.255.255.0', '', '', '', 'peer', |
---|
20 | 30 |
---|
21 | ); |
---|
22 | |
---|
23 | DELETE FROM ordenadores; |
---|
24 | INSERT INTO ordenadores ( |
---|
25 | nombreordenador, ip, mac, idaula, idrepositorio, |
---|
26 | idperfilhard, idmenu, idproautoexec, |
---|
27 | grupoid, router, mascara, arranque, |
---|
28 | netiface, netdriver, fotoord |
---|
29 | ) |
---|
30 | VALUES |
---|
31 | ( |
---|
32 | 'pc2', '192.168.2.1', '0800270E6501', |
---|
33 | 1, 1, 0, 0, 0, 0, '192.168.56.1', '255.255.255.0', |
---|
34 | '00unknown', 'eth0', 'generic', 'fotoordenador.gif' |
---|
35 | ), |
---|
36 | ( |
---|
37 | 'pc2', '192.168.2.2', '0800270E6502', |
---|
38 | 1, 1, 0, 0, 0, 0, '192.168.56.1', '255.255.255.0', |
---|
39 | '00unknown', 'eth0', 'generic', 'fotoordenador.gif' |
---|
40 | ); |
---|
41 | |
---|