Am Mittwoch, den 14.06.2006, 10:05 +0200 schrieb Rudolf Harney:
> Hi,
>
> another try, now in english:
>
> we use otrs 2.0.4 with an external (mySQL) customer DB.
>
> Customergroups can't be created. (If we disable the external customer
> db, it works.)
>
> Is it not posible, to use customer Groups with an external customer db?
>
I found it myself:
We had to add a table "valid" into the customer db and we hat to add a
column "valid_id" into the customerdb-table. the mysql code looks like:
ALTER TABLE otrs_myusertable ADD COLUMN valid_id smallint(6) DEFAULT 0;
UPDATE otrs_myusertable SET valid_id=1;
mysql> CREATE TABLE valid (
-> id smallint(6) AUTO_INCREMENT DEFAULT NULL,
-> name varchar(50) UNIQUE,
-> create_time datetime DEFAULT '0000-00-00 00:00:00',
-> create_by int(11) DEFAULT 0,
-> change_time datetime DEFAULT '0000-00-00 00:00:00',
-> change_by int(11) DEFAULT 0,
-> PRIMARY KEY (id)
-> );
INSERT INTO valid (name, create_time, create_by, change_time,
change_by ) VALUES ('valid', '2006-06-14 15:30:00', 1, '2006-06-14
15:30:00', 1)
INSERT INTO valid (name, create_time, create_by, change_time,
change_by ) VALUES ('invalid', '2006-06-14 15:30:00', 1, '2006-06-14
15:30:00', 1)
INSERT INTO valid (name, create_time, create_by, change_time,
change_by ) VALUES ('invalid-temporarily', '2006-06-14 15:30:00', 1,
'2006-06-14 15:30:00', 1)
Rudolf
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
