Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-8674

Sqlite and AUTOINCREMENT

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: