| 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 |