Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,883
    Plugin Contributions
    96

    Default products_options, products_options_values: Indexes aren't auto-increment?

    I was surprised to find that the primary index for the subject database tables aren't auto-increment! Is/was there a reason for this?

  2. #2
    Join Date
    Jul 2012
    Posts
    16,816
    Plugin Contributions
    17

    Default Re: products_options, products_options_values: Indexes aren't auto-increment?

    Quote Originally Posted by lat9 View Post
    I was surprised to find that the primary index for the subject database tables aren't auto-increment! Is/was there a reason for this?
    From what I see in review of the products_options and products_options_values tables is that the primary key is a combination of fields (products_options_id or products_options_values_id combined with the language_id) rather than a single unique field (such as an autonumber) thus more than one occurrence of each products_options_id (or products_options_values_id) can exist in the table but in different languages within the table...
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,883
    Plugin Contributions
    96

    Default Re: products_options, products_options_values: Indexes aren't auto-increment?

    Big fat duh on my part; thanks for the update!

  4. #4
    Join Date
    Jul 2012
    Posts
    16,816
    Plugin Contributions
    17

    Default Re: products_options, products_options_values: Indexes aren't auto-increment?

    Quote Originally Posted by lat9 View Post
    Big fat duh on my part; thanks for the update!
    No problemo, and makes sense to have expected an autonumber based on perspective and potential expectation... (Reviewing/writing code and thinking it should easily work one way to find it doesn't... ) :)

    It's Friday, you get a break. :)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. Replies: 4
    Last Post: 12 Jan 2016, 08:59 PM
  2. Custom database auto increment
    By hubert in forum General Questions
    Replies: 3
    Last Post: 14 May 2015, 01:46 AM
  3. Auto Increment Product Model Numbers?
    By jaqdaw in forum General Questions
    Replies: 0
    Last Post: 8 Feb 2011, 06:06 PM
  4. 1062 Duplicate entry after db install is it auto-increment settings?
    By BrookieWookie in forum Upgrading from 1.3.x to 1.3.9
    Replies: 6
    Last Post: 24 Feb 2008, 02:30 PM
  5. Cart not displaying all products_options
    By jds580s in forum General Questions
    Replies: 1
    Last Post: 19 Dec 2007, 06:28 PM

Posting Permissions

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