====== Progetto Impianto Fotovoltaico ======

===== Tabelle =====

{{ :cli:franke:sqltabelle.txt |}}

<code sql>
--GRUPPI
INSERT INTO public.sensorsgrp VALUES (1, 'roof_building_n_3');
INSERT INTO public.sensorsgrp VALUES (2, 'parking_area');

--SENSORI
INSERT INTO public.sensorsdev VALUES (276085, 'Inverter 15', 2);
INSERT INTO public.sensorsdev VALUES (276083, 'Inverter 14', 2);
INSERT INTO public.sensorsdev VALUES (276082, 'Inverter 13', 2);
INSERT INTO public.sensorsdev VALUES (276081, 'Inverter 12', 2);
INSERT INTO public.sensorsdev VALUES (276080, 'Inverter 11', 2);
INSERT INTO public.sensorsdev VALUES (276079, 'Inverter 10', 2);
INSERT INTO public.sensorsdev VALUES (276078, 'Inverter 9', 2);
INSERT INTO public.sensorsdev VALUES (276077, 'Inverter 8', 2);
INSERT INTO public.sensorsdev VALUES (276076, 'Inverter 7', 2);
INSERT INTO public.sensorsdev VALUES (276075, 'Inverter 6', 2);
INSERT INTO public.sensorsdev VALUES (276074, 'Inverter 5', 2);
INSERT INTO public.sensorsdev VALUES (276073, 'Inverter 4', 2);
INSERT INTO public.sensorsdev VALUES (276072, 'Inverter 3', 1);
INSERT INTO public.sensorsdev VALUES (276071, 'Inverter 2', 1);
INSERT INTO public.sensorsdev VALUES (276070, 'Inverter 1', 1);
</code>
===== SFTP =====

**SFTP url:** ftp.panpwrws.com:22/Measurements

**Utente**: franke

**Password:** K493qu2TKU%V

**MOUNT command:** 

<code sql> 
sshfs franke@ftp.panpwrws.com:/Measurements /code/sshfs -p 22
</code>