grant select on autopart.* to 'autopart'@'%' identified by 'contrasenya';
create table variables (ip_servidor_partimage CHAR(16) NOT NULL,port_partimage CHAR(6),usuari CHAR(32) NOT NULL,password CHAR(32) NOT NULL,nivell_compressio CHAR(2),copiar_mbr CHAR(2),comprovar CHAR(2),sobreescriure CHAR(2),dirbase VARCHAR(96) NOT NULL,id_config TINYINT PRIMARY KEY);
create table models (model VARCHAR(30) NOT NULL PRIMARY KEY,descripcio VARCHAR(120));
create table particions (id INT AUTO_INCREMENT PRIMARY KEY,model VARCHAR(30) NOT NULL,particio VARCHAR(30) NOT NULL,device VARCHAR(80) NOT NULL,descripcio VARCHAR(120));
create table equips (equip VARCHAR(30) NOT NULL PRIMARY KEY,descripcio VARCHAR(120),model VARCHAR(30) NOT NULL);
create unique index i_particions on particions (model,particio);

