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 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, email TEXT, lang TEXT)'; > > $sql2 = 'CREATE TABLE TRight(userid INTEGER, > usermanager BOOL, chef BOOL, writer BOOL, reader > BOOL, > root BOOL)'; > > $sql3 = "INSERT INTO TUser(pseudo, password) VALUES > (\''$pseudo\'',\''$password\'')"; > > $sql4 = "INSERT INTO TRight(userid, usermanager, > chef, > writer, reader, root) > VALUES(1,TRUE,TRUE,TRUE,TRUE,TRUE)"; > > (as 1 is the first autoinc unsigned.) > > My question is : does 'unsigned' word recognized as > a > constraint ? > if it is not, how can I write the sql constraint ? > > userid UNSIGNED INTEGER PRIMARY KEY AUTOINCREMENT > NOT > NULL CONSTRAINT userid > 0 > > BR, > David > > > > _____________________________________________________________________________ > > Ne gardez plus qu'une seule adresse mail ! Copiez > vos mails vers Yahoo! Mail > > ----------------------------------------------------------------------------- > To unsubscribe, send email to > [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > _____________________________________________________________________________ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------