[rt-users] Doubt about an Extension to store information on the SQL database

[Italo Valcy]

Hi guys,

I'd like to hear a tip from you about a RT extension store information
on the SQL database. In other words, I need that my extension has some
place in the SQL database to store some information (this information
is preferences database for my extension)

My initial ideia was to create a new table in the RT database, something like:

CREATE TABLE myextension_prefs (
   id INTEGER NOT NULL  AUTO_INCREMENT,
   prefs_name varchar(30) NOT NULL ,
   prefs_value varchar(30) NOT NULL ,
   PRIMARY KEY (id)
) TYPE=InnoDB;

CREATE INDEX myextension_prefs1 on myextension_prefs(prefs_name);

But.... I really didn't like the ideia of modify the RT database only
for my extension (in addition, I dont know how I'd do this in the
install of the extension -- only put a note on the README would be
enough?).

So, what do you guys think about? What would be the best way to solve
the above problem?


Thank you for any help!


Kind Regards, Italo.

-- 
Saudações,

Italo Valcy :: http://wiki.dcc.ufba.br/~ItaloValcy