Move authcode scopes into a new table

[alexbilbie]

As mentioned in point 6 in #41

cc/ @ziege

[cziegenberg]

The automatically generated foreign key names you used in your changes exceed the maximum length for foreign keys in other DBMS (as far as I can remeber it's 30 characters in Oracle). Of course this can be changed in the Oracle script only, but I think the naming should be the same in all databases.

[alexbilbie]

I've never used Oracle in my life so I don't know of it's limitations

[cziegenberg]

No problem. My offer to check the database structure and prepare it for other DBMS is still valid... but first the basic structure needs to be clear. At the moment I use it with Postgres (and it works great). And I have the possibility to test it with SqlServer and Oracle (which I don't use personally).

[alexbilbie]

If you could check it and provide import scripts that would be great please.

[cziegenberg]

I had a look at it and I plan to integrate several changes into the dev version:

• Several foreign key and index updates
• Table renaming (to make the table structure clearer and the names shorter for better compatibility)
• Some column renaming (belongs to the previous point)
• Remove unnecessary column
• Update the table script for MySQL
• Add table script for Postgres

Okay?

[cziegenberg]

I just added the mentioned changes. Other SQL scripts will follow later...

[joaorobertopb]

Sorry for asking in a topic already closed.

I take much OAuth2 use with Oracle Database!

I wonder if there is already a solution for it?