[rt-devel] 4k ought to be enough for anyone (schema.Oracle Support in RT)

Brook Schofield B.Schofield at mailbox.gu.edu.au
Tue Mar 18 00:50:30 EST 2003


All,

Looking at RTs database schema (attached in full as the patch is actually 
larger) there are the following table/column combinations which are of type 
CLOB:

Attachments.Content
Attachments.Headers
Scrips.ConditionRules
Scrips.ActionRules
Scrips.CustomIsApplicableCode
Scrips.CustomPrepareCode
Scrips.CustomCommitCode
Users.Comments
Users.Signature
Users.FreeFormContactInfo
Users.PGPKey
Templates.Content
sessions.a_session

Currently all of these columns are of type CLOB. I suggest that moving the 
User table values to VARCHAR(4000) to store 4k of data within them *COULD* 
be a good thing. Can anyone see issues with this?

Users.Comments                  "According to wc this email is only 1743 
characters"
Users.Signature         "Even my awful .signature is only 524 Characters"
Users.FreeFormContactInfo
Users.PGPKey

This will allow common LIKE queries to work with the Users tables. 
Resulting in less work modifying DBIx::SearchBuilder to handle the CLOB 
data type (this actually won't result is less work - but means that some 
functionality will work without changes to SearchBuilder).

NB:- the attached schema.Oracle file still has the Users table using CLOB 
just in case people don't like the idea of changing.

-Brook

=========================================================================
=     _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/  _/ Brook Schofield                =
=    _/  _/ _/  _/ _/  _/ _/  _/ _/ _/   B.Schofield at griffith.edu.au    =
=   _/_/   _/_/_/ _/  _/ _/  _/ _/_/     Ph: +61 7 387 53779 - WCN 0.28 =
=  _/  _/ _/ _/  _/  _/ _/  _/ _/ _/     Directory Services Integration =
= _/_/_/ _/  _/ _/_/_/ _/_/_/ _/  _/     Griffith University QLD 4111   =
=========================================================================
-------------- next part --------------
A non-text attachment was scrubbed...
Name: schema.Oracle
Type: application/octet-stream
Size: 9511 bytes
Desc: not available
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20030318/5eada8b9/schema.obj


More information about the Rt-devel mailing list