Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-8674

Sqlite and AUTOINCREMENT

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.1.0-b3
    • 3.0.5
    • None
    • PHP Environment: 5.2.9
      Database: sqlite 2.8.17

      Consider making the INTEGER PRIMARY KEY also AUTOINCREMENT, because otherwise sqlite reuses the same value if you delete the last row. This may have the following implication:
      User A registers.
      Administrator sends a message to user A.
      User A is deleted.
      Then user B registers.
      The administrator sees that his sent message was sent to user B.

      http://www.sqlite.org/autoinc.html

            nickvergessen Joas Schilling
            prekageo prekageo
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: