New schema.py with Elixir defined model (sqlalchemy-ng branch)

[sevenseeker]

Since I am more familiar with Elixir (and thus the new SQLAlchemy declarative language as well) I have produced an Elixir declared model for Trac with minimal relations. I assumed a 'User' class and table as well for some of the relations to demonstrate its use. I will be submitting a revised edition with relations defined in the top SQLAlchemy section hopefully this afternoon.

[sevenseeker (jtgalyon@…]

Elixir defined model

[jruigrok]

Looking at the SQLAlchemy change notes, we might even have to move to UnicodeText? instead of Unicode.

[jruigrok]

Actually, we might need to revisit the entirety of the types based on the now documented stuff in http://www.sqlalchemy.org/docs/04/types.html

[jtgalyon@…]

String or Unicode without a numerical specifier results in Text, btw. Should all of these fields be Text or some varchar with lengths?