Commit | Line | Data |
---|---|---|
b42b2bf9 H |
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 |