CREATE TABLE IF NOT EXISTS provisioning_group
( 
	provisioning_group_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 
	displayname VARCHAR( 50 ) , 
	groupname VARCHAR( 50 ) , 
	picture MEDIUMBLOB
); 
CREATE TABLE IF NOT EXISTS provisioning_device
( 
	provisioning_device_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 
	provisioning_group_id INT ,
	displayname VARCHAR( 50 ) , 
	groupname VARCHAR( 50 ) , 
	devicename VARCHAR( 50 ) ,
	file MEDIUMBLOB 
);