I want to contribute with DB Models (wiki?)

[jmt4b04d4v@…]

I needed the DB model to prepare a new report query and I didn't knew the DB schema.
That's why I elaborated a DB schema for educational purposes only.
I built this model reversing the script from a PostgreSQL 8.1 database used by my trac installation, then I thought maybe someone needs this for the same purposes.
That's why I'm contributing this model, maybe have defects, but it worth the effort (maybe it can be put in the development section of the wiki as attachments).
Fell free to do whatever you want with it.

Thanks again for trac.
I didn't found another place to contribute this, sorry.

[jmt4b04d4v@…]

Power Designer, Database Model

[jmt4b04d4v@…]

I tried to attach images to the ticket, but got an error from trac.

[jmt4b04d4v@…]

trac detected an internal error
...

Python Traceback

Traceback (most recent call last):

File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 387, in dispatch_request

dispatcher.dispatch(req)

File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch

resp = chosen_handler.process_request(req)

File "/usr/lib/python2.4/site-packages/trac/attachment.py", line 361, in process_request

self._do_save(req, attachment)

File "/usr/lib/python2.4/site-packages/trac/attachment.py", line 475, in _do_save

for field, message in manipulator.validate_attachment(req, attachment):

File "build/bdist.linux-x86_64/egg/tracspamfilter/adapters.py", line 130, in validate_attachment
File "build/bdist.linux-x86_64/egg/tracspamfilter/api.py", line 131, in test
File "build/bdist.linux-x86_64/egg/tracspamfilter/model.py", line 119, in insert
File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

ProgrammingError?: current transaction is aborted, commands ignored until end of transaction block

[jmt4b04d4v@…]

Contact me about uploading the image files (it was a zip file with JPG & PNG images, I also tried uploading the files individually, same error).
It was really hard to create this tickets, your Spam Software started in about 73% and decreasing until I posted this ticket''

[cboos]

Well, unless I'm mistaken, I never received the updated (translated) schemas.

No need to reopen the ticket if you want to complete this, just send us the schemas (encoding your pictures in a non binary format like base64 would make it possible to attach them here despite the #4087 issue).

[anonymous]

Replying to cboos:

Well, unless I'm mistaken, I never received the updated (translated) schemas.

Strange, and yes Christian, you are mistaken. I've sent the images in January 26th directly to your mail, anyway, I've sent it again minutes ago ;-).

¿Maybe content was filtered by binary attachment?, it was a tarball compressed file.

No need to reopen the ticket if you want to complete this, just send us the schemas (encoding your pictures in a non binary format like base64 would make it possible to attach them here despite the #4087 issue).

Greetings, jmt4b04d4v.