#4562 closed enhancement (wontfix)
I want to contribute with DB Models (wiki?)
Reported by: | Owned by: | Jonas Borgström | |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | wiki system | Version: | |
Severity: | normal | Keywords: | database model |
Cc: | Branch: | ||
Release Notes: | |||
API Changes: | |||
Internal Changes: |
Description
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.
Attachments (1)
Change History (6)
by , 18 years ago
Attachment: | trac-schema.pdm added |
---|
comment:2 by , 18 years ago
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
comment:3 by , 18 years ago
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''
follow-up: 5 comment:4 by , 18 years ago
Resolution: | → wontfix |
---|---|
Status: | new → closed |
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).
comment:5 by , 18 years ago
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
.
Power Designer, Database Model