I've always found it's good to set numeric primary keys to UNSIGNED. Gives you a larger range, and it's not very likely those numbers are ever going to be negative.
Also, there is absolutely no need to check Index or Unique when you have selected Primary, as Primary implies both (hence why in newer versions, Primary/Index/Unique are radio buttons). Lastly, unless you expect to have a rediculous amount of records, an INT is more that sufficient (giving you a maximum record count of 4,294,967,295). Also, PHP's mysql_insert_id() doesn't support BIGINT data types. So, the more optimised version of the keyfield would be: > Field: keynum > Type: INT > Length/Values: (blank) > Attributes: UNSIGNED > Null: NOT NULL > Default: (blank) > Extra: AUTO_INCREMENT > Primary: SELECTED > Index: UN-SELECTED > Unique: UN-SELECTED Mike Kevin Stone wrote: > Could be something like.. > > Field: keynum > Type: BIGINT > Length/Values: (blank) > Attributes: (blank) > Null: NOT NULL > Default: (blank) > Extra: AUTO_INCREMENT > Primary: CHECKED > Index: CHECKED > Unique: CHECKED > > Field: username > Type: VARCHAR > Length/Values: 20 > Attributes: (blank) > Null: NOT NULL > Default: (blank) > Extra: (blank) > Primary: UNCHECKED > Index: UNCHECKED > Unique: UNCHECKED > > Field: password > Type: VARCHAR > Length/Values: 20 > Attributes: (blank) > Null: NOT NULL > Default: (blank) > Extra: (blank) > Primary: UNCHECKED > Index: UNCHECKED > Unique: UNCHECKED > > Note I prefer to use VARCHAR instead of PASSWORD becuase I am more > comfortable checking the database contents in PHP rather than SQL. But you > can do a PASSWORD field then in your query statment use the SQL funciton > PASSWORD($pwd) to encrypt the string. Either way, for security, it is > imparative that you encrypt it. > > The field 'keynum' is just a standard thing that I do. It's set up to > auto_increment so you always have a unique key to delete and update records > on. For more information view the SQL documentation on www.mysql.com. > > Hope this helps! > -Kevin > > ----- Original Message ----- > From: "Rodrigo" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 03, 2002 10:18 AM > Subject: [PHP] phpMyAdmin > > > >>Hi guys, I need some help using the phpMyAdmin, I'm trying to create a >>table with three fields, one for the indexing of the database, the >>second for the logins and the third for the password. >> >>I get the following doubts: >> >>On the table of the phpMyAdmin there are the following fields: >> >>A field for the name of the field. >>A field for the kind of information that will be stored in the field >>(TINYINT,DOUBLE,TEXT...) >>A field for the size of the field. >>A field for the atributes of the field (BINARY, UNSIGNED, UNSIGNED ZERO >>FILL) >>A field for the null option (NULL, NOT NULL). >>A field for an information that I don't know... >>A field for the Extra(AUTO_INCREMENT). >>A selectable field named primary(check it or not). >>A selectable field named index(check it or not). >>A selectable field named unique(check it or not). >>A selectable field named Fulltext(Check it or not). >> >>The information that I would need would be what are the configurations >>that I have to put in each of these fields. >>And also I would need to know a php script to access the fields, and >>write to new fields. >> >>Thanx, Rodrigo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
