I Syntax of S_Sql-OleDb.sql is correct for ms sql server 2005. Unfortunately it seems like upp always executes upgrade script
Because you do not execute it. Use SqlScheam::SCHEMA to execute the "schema" script.
However, I thing that adding dual primary keys (and maybe even single primary keys) should be the property of "ATTRIBUTES" script too. In other words, "underdevelopment". Could you fix that?
BTW, if you have better idea for dual key (and other multi-key) "syntax", do not keep it secret...