[c2c6ce9] | 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 | |
---|