That SQL command would be issued from within a connection to mysql, often it's easiest to use a utility like phpMyAdmin to do that when you have the citrus database open, use the SQL tab to issue that SQL command. You could also do this from the mysql command line, something like:
to login enter: mysql -u <yourusername> -p (this will prompt you for the mysql users password) then tell it to use the citrus database enter: use <yourdatabasename> then enter that command to alter the table: ALTER TABLE `customer` AUTO_INCREMENT = 10000 Paul On 9/24/07, AJ Becker <[EMAIL PROTECTED]> wrote: > Paul, can this be done to a working system with current users? Where the > next account would be the new #s? or would it have to be done before use. > Also.. Your example context didnt work for me.. What exaclty do I have to > type and how on mySQL. > > Thanks > > ----- Original Message ----- > From: "Paul Yasi" <[EMAIL PROTECTED]> > To: "For users of CitrusDB discussion" > <citrusdb-users@lists.sourceforge.net> > Sent: Monday, September 24, 2007 2:24 PM > Subject: Re: [Citrusdb-users] (no subject) > > > > You can actually start the customer account numbers at any number you > > want, maybe this should be a higher number by default. > > > > If you want to alter the customer table, you can run this SQL command > > to start the number at 10000 for example: > > > > ALTER TABLE `customer` AUTO_INCREMENT = 10000 > > > > It may also be a better idea to use something like the customer email > > address as their account manager login instead of their account > > number... this is something to think about for future versions. > > > > > > > > Paul > > > > On 9/23/07, AJ Becker <[EMAIL PROTECTED]> wrote: > >> only reason i wanted to do this was for users to be able to log into > >> there > >> accounts. Im not fond of low 2-3 digit account numbers to start.. makes > >> it > >> look like you have no customer base. plus its another number they have to > >> remember to get to there account. > >> > >> ----- Original Message ----- > >> From: "Paul Yasi" <[EMAIL PROTECTED]> > >> To: "For users of CitrusDB discussion" > >> <citrusdb-users@lists.sourceforge.net> > >> Sent: Sunday, September 23, 2007 9:41 AM > >> Subject: Re: [Citrusdb-users] (no subject) > >> > >> > >> > It is not possible for citrus to change a customer's account number. > >> > Keeping the account number the same all the time is very important > >> > since it connects the customer with all their information. I would > >> > not use a phone number as their customer number, the customer may move > >> > and get a new phone number, or in a super rare case that number may be > >> > assigned to someone else. > >> > > >> > You can still search by their phone number, and upon a match it will > >> > take you right to that record. > >> > > >> > Paul > >> > > >> > On 9/23/07, AJ Becker <[EMAIL PROTECTED]> wrote: > >> >> > >> >> > >> >> is it possible to change a customers "customer number" ? Would like to > >> >> use > >> >> there phone number as their customer number. > >> >> ------------------------------------------------------------------------- > >> >> This SF.net email is sponsored by: Microsoft > >> >> Defy all challenges. Microsoft(R) Visual Studio 2005. > >> >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> >> _______________________________________________ > >> >> Citrusdb-users mailing list > >> >> Citrusdb-users@lists.sourceforge.net > >> >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users > >> >> > >> >> > >> > > >> > > >> > -- > >> > The CitrusDB Project | http://www.citrusdb.org > >> > Open Source Customer Care & Billing System > >> > > >> > ------------------------------------------------------------------------- > >> > This SF.net email is sponsored by: Microsoft > >> > Defy all challenges. Microsoft(R) Visual Studio 2005. > >> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> > _______________________________________________ > >> > Citrusdb-users mailing list > >> > Citrusdb-users@lists.sourceforge.net > >> > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > >> > >> > >> ------------------------------------------------------------------------- > >> This SF.net email is sponsored by: Microsoft > >> Defy all challenges. Microsoft(R) Visual Studio 2005. > >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> _______________________________________________ > >> Citrusdb-users mailing list > >> Citrusdb-users@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users > >> > > > > > > -- > > The CitrusDB Project | http://www.citrusdb.org > > Open Source Customer Care & Billing System > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Citrusdb-users mailing list > > Citrusdb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care & Billing System ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
