equal
deleted
inserted
replaced
126 user_homepage text, |
126 user_homepage text, |
127 user_location text, |
127 user_location text, |
128 user_job text, |
128 user_job text, |
129 user_hobbies text, |
129 user_hobbies text, |
130 email_public tinyint(1) NOT NULL DEFAULT 0, |
130 email_public tinyint(1) NOT NULL DEFAULT 0, |
|
131 disable_js_fx tinyint(1) NOT NULL DEFAULT 0, |
131 PRIMARY KEY ( user_id ) |
132 PRIMARY KEY ( user_id ) |
132 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
133 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
133 |
134 |
134 CREATE TABLE {{TABLE_PREFIX}}banlist( |
135 CREATE TABLE {{TABLE_PREFIX}}banlist( |
135 ban_id mediumint(8) NOT NULL auto_increment, |
136 ban_id mediumint(8) NOT NULL auto_increment, |
201 |
202 |
202 CREATE TABLE {{TABLE_PREFIX}}groups( |
203 CREATE TABLE {{TABLE_PREFIX}}groups( |
203 group_id mediumint(5) UNSIGNED NOT NULL auto_increment, |
204 group_id mediumint(5) UNSIGNED NOT NULL auto_increment, |
204 group_name varchar(64), |
205 group_name varchar(64), |
205 group_type tinyint(1) NOT NULL DEFAULT 1, |
206 group_type tinyint(1) NOT NULL DEFAULT 1, |
206 PRIMARY KEY ( group_id ), |
207 system_group tinyint(1) NOT NULL DEFAULT 0, |
207 system_group tinyint(1) NOT NULL DEFAULT 0 |
208 group_rank int(12) unsigned DEFAULT NULL, |
|
209 PRIMARY KEY ( group_id ) |
208 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
210 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
209 |
211 |
210 CREATE TABLE {{TABLE_PREFIX}}group_members( |
212 CREATE TABLE {{TABLE_PREFIX}}group_members( |
211 member_id int(12) UNSIGNED NOT NULL auto_increment, |
213 member_id int(12) UNSIGNED NOT NULL auto_increment, |
212 group_id mediumint(5) UNSIGNED NOT NULL, |
214 group_id mediumint(5) UNSIGNED NOT NULL, |