108 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
108 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
109 user_lang smallint(5) NOT NULL DEFAULT 1, |
109 user_lang smallint(5) NOT NULL DEFAULT 1, |
110 user_has_avatar tinyint(1) NOT NULL DEFAULT 0, |
110 user_has_avatar tinyint(1) NOT NULL DEFAULT 0, |
111 avatar_type ENUM('jpg', 'png', 'gif') NOT NULL DEFAULT 'png', |
111 avatar_type ENUM('jpg', 'png', 'gif') NOT NULL DEFAULT 'png', |
112 user_registration_ip varchar(39), |
112 user_registration_ip varchar(39), |
113 user_rank int(12) UNSIGNED NOT NULL DEFAULT 1, |
113 user_rank int(12) UNSIGNED DEFAULT NULL, |
114 user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0, |
114 user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0, |
|
115 user_title varchar(64) DEFAULT NULL, |
|
116 user_group mediumint(5) NOT NULL DEFAULT 1, |
115 PRIMARY KEY (user_id) |
117 PRIMARY KEY (user_id) |
116 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
118 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
117 |
119 |
118 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
120 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
119 user_id mediumint(8) NOT NULL, |
121 user_id mediumint(8) NOT NULL, |
374 (2); |
376 (2); |
375 |
377 |
376 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
378 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
377 (1, 'user_rank_member', ''), |
379 (1, 'user_rank_member', ''), |
378 (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'), |
380 (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'), |
379 (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'); |
381 (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'), |
|
382 (4, 'user_rank_guest', ''); |
380 |
383 |
381 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
384 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
382 (2,'Administrators',3,1), |
385 (2,'Administrators',3,1), |
383 (3,'Moderators',3,1); |
386 (3,'Moderators',3,1); |
384 |
387 |