alter

#----------------------------------------------------------
# -> update auf Version 0.1.11
#----------------------------------------------------------

alter table samples change address address int(4) unsigned;
alter table valuefacts change address address int(4) unsigned;
alter table menu change address address int(4) unsigned;
alter table schemaconf change address address int(4) unsigned;
alter table jobs change address address int(4) unsigned;


#----------------------------------------------------------
# -> update auf Version 0.1.12
#----------------------------------------------------------

alter table samples drop column sensorid;
alter table samples add column aggregate varchar(1) after type;
alter table samples add column samples integer(3) after text;
alter table samples drop primary key, add primary key(address, type, aggregate, time);

#----------------------------------------------------------
# -> update auf Version 0.1.18
#----------------------------------------------------------

alter table sensoralert add column lastalert int(10) after mbody;
alter table sensoralert add column maxrepeat int(10) after lastalert;