drop table if exists link;
create table link (
    linkid      INT PRIMARY KEY AUTO_INCREMENT,
    testo       INT DEFAULT NULL,
    info        INT DEFAULT NULL,
    reference   VARCHAR(256) default '',
    properties  VARCHAR(512) default '',
    class       VARCHAR(128) DEFAULT ''  
) ENGINE=INNODB, AUTO_INCREMENT=0;
