Primary Keys

2005-11-21
2013-04-23
  • If I create a table using this SQL for example.

    CREATE TABLE articles (id INTEGER AUTOINCREMENT UNSIGNED DEFAULT 0 NOT NULL, title TEXT, body TEXT, author INTEGER, score DOUBLE, PRIMARY KEY (id))

    Although it creates a perfectly valid SQLite PRIMARY key it is not shown in SQLiteManager, is there a reason for this?

    PRAGMA table_info (articles); shows the primary key is correctly set.

     
    • Hi,
      effectively, this don't work!
      It's a bug of SQLiteManager.
      I'll fix it asap

      Thanks you for your help

       
    • Hi!
      I've juste fix it!!
      You can get it from CVS!
      You can just take the file 'SQLiteTableProperties.class.php' from webcvs!

      Thanks for your help
      regards
      Fred

       
    • No, thank YOU for the best SQLite admin tool available anywhere so far!!!

      I will try the new file.

      Regards John