summaryrefslogtreecommitdiffstats
path: root/tests/config/basic_data.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/config/basic_data.sql')
-rw-r--r--tests/config/basic_data.sql41
1 files changed, 41 insertions, 0 deletions
diff --git a/tests/config/basic_data.sql b/tests/config/basic_data.sql
new file mode 100644
index 0000000..aca246d
--- /dev/null
+++ b/tests/config/basic_data.sql
@@ -0,0 +1,41 @@
+
+DELETE FROM centros;
+INSERT INTO centros (
+ idcentro, nombrecentro, identidad, comentarios, directorio)
+VALUES
+(1, 'Center', 1, '', '');
+
+DELETE FROM aulas;
+INSERT INTO aulas (
+ nombreaula, idcentro, urlfoto, grupoid,
+ ubicacion, puestos, modomul, ipmul,
+ pormul, velmul, router, netmask, ntp,
+ dns, proxy, modp2p, timep2p
+)
+VALUES
+ (
+ 'Room', 1, 'aula.jpg', 0, 'Test room.',
+ 5, 2, '239.194.2.11', 9000, 70, '192.168.56.1',
+ '255.255.255.0', '', '', '', 'peer',
+ 30
+ );
+
+DELETE FROM ordenadores;
+INSERT INTO ordenadores (
+ nombreordenador, ip, mac, idaula, idrepositorio,
+ idperfilhard, idmenu, idproautoexec,
+ grupoid, router, mascara, arranque,
+ netiface, netdriver, fotoord
+)
+VALUES
+ (
+ 'pc2', '192.168.2.1', '0800270E6501',
+ 1, 1, 0, 0, 0, 0, '192.168.56.1', '255.255.255.0',
+ '00unknown', 'eth0', 'generic', 'fotoordenador.gif'
+ ),
+ (
+ 'pc2', '192.168.2.2', '0800270E6502',
+ 1, 1, 0, 0, 0, 0, '192.168.56.1', '255.255.255.0',
+ '00unknown', 'eth0', 'generic', 'fotoordenador.gif'
+ );
+