102 activation_key varchar(40) NOT NULL DEFAULT 0, |
102 activation_key varchar(40) NOT NULL DEFAULT 0, |
103 old_encryption tinyint(1) NOT NULL DEFAULT 0, |
103 old_encryption tinyint(1) NOT NULL DEFAULT 0, |
104 temp_password text, |
104 temp_password text, |
105 temp_password_time int(12) NOT NULL DEFAULT 0, |
105 temp_password_time int(12) NOT NULL DEFAULT 0, |
106 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
106 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
|
107 user_lang smallint(5) NOT NULL, |
107 PRIMARY KEY (user_id) |
108 PRIMARY KEY (user_id) |
108 ) CHARACTER SET `utf8`; |
109 ) CHARACTER SET `utf8`; |
109 |
110 |
110 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
111 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
111 user_id mediumint(8) NOT NULL, |
112 user_id mediumint(8) NOT NULL, |
251 page_id varchar(255) NOT NULL, |
252 page_id varchar(255) NOT NULL, |
252 namespace varchar(255) NOT NULL, |
253 namespace varchar(255) NOT NULL, |
253 user mediumint(8) NOT NULL DEFAULT 1, |
254 user mediumint(8) NOT NULL DEFAULT 1, |
254 PRIMARY KEY ( tag_id ) |
255 PRIMARY KEY ( tag_id ) |
255 ) CHARACTER SET `utf8`; |
256 ) CHARACTER SET `utf8`; |
|
257 |
|
258 -- Added in 1.1.1 |
|
259 |
|
260 CREATE TABLE {{TABLE_PREFIX}}lockout( |
|
261 id int(12) NOT NULL auto_increment, |
|
262 ipaddr varchar(40) NOT NULL, |
|
263 action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', |
|
264 timestamp int(12) NOT NULL DEFAULT 0, |
|
265 PRIMARY KEY ( id ) |
|
266 ) CHARACTER SET `utf8`; |
|
267 |
|
268 -- Added in 1.1.1 |
|
269 |
|
270 CREATE TABLE {{TABLE_PREFIX}}language( |
|
271 lang_id smallint(5) NOT NULL auto_increment, |
|
272 lang_code varchar(16) NOT NULL, |
|
273 lang_name_default varchar(64) NOT NULL, |
|
274 lang_name_native varchar(64) NOT NULL, |
|
275 last_changed int(12) NOT NULL DEFAULT 0, |
|
276 PRIMARY KEY ( lang_id ) |
|
277 ) CHARACTER SET `utf8`; |
|
278 |
|
279 -- Added in 1.1.1 |
|
280 |
|
281 CREATE TABLE {{TABLE_PREFIX}}language_strings( |
|
282 string_id bigint(15) NOT NULL auto_increment, |
|
283 lang_id smallint(5) NOT NULL, |
|
284 string_category varchar(32) NOT NULL, |
|
285 string_name varchar(64) NOT NULL, |
|
286 string_content longtext NOT NULL, |
|
287 PRIMARY KEY ( string_id ) |
|
288 ); |
256 |
289 |
257 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
290 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
258 ('site_name', '{{SITE_NAME}}'), |
291 ('site_name', '{{SITE_NAME}}'), |
259 ('main_page', 'Main_Page'), |
292 ('main_page', 'Main_Page'), |
260 ('site_desc', '{{SITE_DESC}}'), |
293 ('site_desc', '{{SITE_DESC}}'), |