add the sql and software structure