I've seen that customer_preferences has been fullfilled at the first "prova" login it seems... otherwise, in that table are stored (as the name suggests) preferences for the customer. Having not modified nothing on prova, records for him are:
| prova | UserLoginFailed | 0 | | prova | UserShowTickets | 25 | | prova | UserRefreshTime | | | prova | UserLanguage | en | | prova | UserShowClosedTickets | 1 | | prova | UserTheme | Standard | | prova | UserToken | CISmoxkPZzkpvb7 | | prova | UserAuthBackend | | | prova | UserLastLogin | 1267008164 | On Wed, Feb 24, 2010 at 2:40 PM, Alessandro Cortiana < [email protected]> wrote: > ciao Marco, > > > The problem with a trial that I made is with the password of the user > > created... (could be solved with the Lost your password? from the > > customer.pl ?) > > In my environment there is no password problem. > I can temporarily set a default password and I can instruct the customer to > change > the password on first login. > > > insert into customer_user > > > (login,email,customer_id,first_name,last_name,valid_id,create_time,create_by,change_time,change_by) > > values ('prova', '[email protected]', 'prova', 'p', 'p', 1, sysdate(), 1, > > sysdate(), 1) > > I did a test to try to understand what database modifications are made when > I > add a customer user. > I found modifications in two tables: > customer_users -> one row > customer_preferences -> many rows > > Doing an insert like you propose is enough? > Or I also have to insert entries on the customer_preferences table? > > Thanks, > Alessandro Cortiana > --------------------------------------------------------------------- > 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 > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ >
--------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
