Ticket #8396 (new enhancement)
Opened 3 years ago
Last modified 17 months ago
[Database schema] Ticket description field might be too short.
| Reported by: | guillaume.brocard@… | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | next-major-0.1X |
| Component: | database backend | Version: | 0.11.4 |
| Severity: | normal | Keywords: | mysql |
| Cc: | |||
| Release Notes: | |||
| API Changes: | |||
Description
He,
have you ever considered using mediumtext instead of text for the description field of a ticket ?
I've got tickets exceeding the 65536 characters limit, that have been tested ok when switching to mediumtext type (in my case, this is useful for an import from clearquest tickets).
I have checked Bugzilla, and they are using mediumtext pretty much everywhere (at least in version 3.2).
Attached is the modified schema file.
Thx,
Guillaume.
System information :
os : windows xp 32 bits sp2
py : 2.5
db : mysql server 5.0
Attachments
Change History
Changed 3 years ago by guillaume.brocard@…
- Attachment db_default.py added
comment:1 Changed 3 years ago by cboos
- Keywords mysql added; patch removed
Please, take the time to produce and submit a real patch.
Also, be sure to review related tickets, in particular #6986.
comment:2 Changed 3 years ago by cboos
- Component changed from ticket system to database backend
- Milestone set to 1.0
- Severity changed from trivial to normal
comment:3 Changed 22 months ago by cboos
- Milestone changed from 1.0 to unscheduled
Milestone 1.0 deleted
comment:4 Changed 17 months ago by cboos
- Milestone changed from triaging to next-major-0.1X
Related to the distinction of string vs. text in GenericTrac.
Default db schema definition, modified under "Ticket system" for the description column type.