sql/create_users.sql

   1 CREATE TABLE users (
   2   user_id int(13) NOT NULL default '0',
   3   login char(66) default NULL,
   4   password char(32) default NULL,
   5   icq char(10) default NULL,
   6   email char(50) default NULL,
   7   last_action timestamp(14) NOT NULL,
   8   user_action char(75) default NULL,
   9   user_status enum('waiting','restricted','newbie','user','protector','editor') default NULL,
  10   user_mode enum('normal','happy','sad','stoned','love','agressive') default NULL,
  11   user_ad enum('yes','no') default NULL,
  12   www char(50) default NULL,
  13   user_mail int(5) default NULL,
  14   user_mail_name char(40) default NULL,
  15   listing_amount int(8) default '32',
  16   charisma int(8) default NULL,
  17   happiness char(123) default NULL,
  18   sad char(123) default NULL,
  19   love char(123) default NULL,
  20   agressive char(123) default NULL,
  21   session_string char(64) default NULL,
  22   template_set char(23) default 'kyberia',
  23   old_user_id int(11) default NULL,
  24   PRIMARY KEY  (user_id),
  25   UNIQUE KEY session_string (session_string),
  26   UNIQUE KEY login (login)
  27 ) TYPE=MyISAM