CREATE TABLE user (
   userid int(10) unsigned NOT NULL auto_increment,
   usergroupid smallint(5) unsigned NOT NULL,
   username varchar(50) NOT NULL,
   password varchar(50) NOT NULL,
   email varchar(50) NOT NULL,
   parentemail varchar(50) NOT NULL,
   coppauser smallint(6) NOT NULL,
   homepage varchar(100) NOT NULL,
   icq varchar(20) NOT NULL,
   aim varchar(20) NOT NULL,
   yahoo varchar(20) NOT NULL,
   biography mediumtext NOT NULL,
   signature mediumtext NOT NULL,
   adminemail smallint(6) NOT NULL,
   showemail smallint(6) NOT NULL,
   invisible smallint(6) NOT NULL,
   usertitle varchar(250) NOT NULL,
   customtitle smallint(6) NOT NULL,
   joindate int(10) unsigned NOT NULL,
   canpost smallint(6) NOT NULL,
   cookieuser smallint(6) NOT NULL,
   daysprune smallint(6) NOT NULL,
   lastvisit int(10) unsigned NOT NULL,
   lastactivity int(10) unsigned NOT NULL,
   lastpost int(10) unsigned NOT NULL,
   posts smallint(5) unsigned NOT NULL,
   timezoneoffset smallint(6) NOT NULL,
   emailnotification smallint(6) NOT NULL,
   PRIMARY KEY (userid),
   KEY idxgroups (username, usergroupid)
);