search

LSIR / gsn

Global Sensor Networks
GNU General Public License v3.0
58 stars 44 forks source link

Database Modification #75

Closed mvishnuprathap closed 8 years ago

mvishnuprathap commented 8 years ago

Is it possible to modify database and then deploy sensors ? I got several errors occured when I tried to modify database and run the sensors again, even when I had default value of the sensors initialized to NULL. problem

ebiiii commented 8 years ago

Normally you shouldn't modify the database (or maybe if you want to add an index) tables that are managed by GSN. GSN supposes that the columns correspond to the field of the virtual sensor and populate them accordingly. If you add columns and provide them a default value (ALTER TABLE vsensorname ALTER latitude SET DEFAULT '46.602'), it should work however...