[sqlite] RE : [sqlite] primary key constraint

What is the difference between : 1/ userid UNSIGNED INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL 2/ userid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL CHECK (userid>0) --- David Nguyen <[EMAIL PROTECTED]> a écrit : > Hello, > > With php, I want to create 2 tables, userid

[sqlite] primary key constraint

Hello, With php, I want to create 2 tables, userid is a primary key in TUser and a foreign key in TRight. I want to create a default user during database creation. $sql1 = 'CREATE TABLE TUser(userid UNSIGNED INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, username TEXT, pseudo TEXT, password TEXT,