Results 1 to 2 of 2

Thread: case_number in the Database

  1. #1
    chrislynch8's Avatar
    chrislynch8 is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default case_number in the Database

    Hi,

    How can I reset the case_number in the database - so that I start using cases again it will start at case number 1.

    Rgds
    Chris

  2. #2
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: case_number in the Database

    Quote Originally Posted by chrislynch8 View Post
    Hi,

    How can I reset the case_number in the database - so that I start using cases again it will start at case number 1.

    Rgds
    Chris
    if you are using mysql first delete any cases in the cases table

    then run the sql statement ALTER TABLE cases AUTO_INCREMENT=1
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 2007-12-13, 09:20 AM
  2. case_number from logic hook?
    By Rankie in forum Developer Help
    Replies: 3
    Last Post: 2007-11-10, 06:16 AM
  3. SQL database not available...
    By arunas in forum Help
    Replies: 2
    Last Post: 2007-01-08, 08:41 PM
  4. Replies: 1
    Last Post: 2005-04-06, 06:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •