make primary keys AUTO_INCREMENT fields
remove spl_variable.scope attribute as it is implicitly given through foreign keys