Hi,

while trying to use SAPDB as OTRS database I ran into some problems:

If you use VARCHAR without value, how long can it be?
SAPDB only knows about VARCHAR with a defined value, otherwise its length
is 1.

The other problem is:
CREATE TABLE session
(
    id serial,
    session_id VARCHAR (120) NOT NULL,
    value VARCHAR (1000) NOT NULL,
    PRIMARY KEY(id),
    UNIQUE (session_id)
)

the name "value" is a reserved identifier in SAPDB. So would it be
possible to change this sometime?

CU,
 Wolfgang


_______________________________________________
OpenTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

Reply via email to