MySQL Table Creation?

Hi, I've had a good look through your site and can find plenty of examples of how to include the php class in our sites, but i can't find anything anywhere that shows how the initial SQL table should be laid out.

Can someone please let me know the SQL to create the table that is compatible with this script?

I'm guessing it's something close to this?:

CREATE TABLE `users` (
  `userID` int(4) unsigned NOT NULL auto_increment,
  `login` varchar(32) NOT NULL default '',
  `pass` varchar(32) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `active` int(1) NOT NULL default '0',
  PRIMARY KEY  (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

Many Thanks 

[Join us @ facebook]

Using the class gives you the ability to create any table structure you want and then change the $tbFields array to meet your table structure.

To play with the default settings you just need the above SQL:

Code:

CREATE TABLE `users` (
  `userID` mediumint(8) unsigned NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `email` varchar(150) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`userID`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  KEY `active` (`active`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

[Guest]

[35.712]

Googlebot, Yahoo crawler, Baidu Spider