103 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
103 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
104 user_lang smallint(5) NOT NULL DEFAULT 1, |
104 user_lang smallint(5) NOT NULL DEFAULT 1, |
105 user_has_avatar tinyint(1) NOT NULL DEFAULT 0, |
105 user_has_avatar tinyint(1) NOT NULL DEFAULT 0, |
106 avatar_type ENUM('jpg', 'png', 'gif') NOT NULL DEFAULT 'png', |
106 avatar_type ENUM('jpg', 'png', 'gif') NOT NULL DEFAULT 'png', |
107 user_registration_ip varchar(39), |
107 user_registration_ip varchar(39), |
|
108 user_rank int(12) UNSIGNED NOT NULL DEFAULT 1, |
108 PRIMARY KEY (user_id) |
109 PRIMARY KEY (user_id) |
109 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
110 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
110 |
111 |
111 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
112 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
112 user_id mediumint(8) NOT NULL, |
113 user_id mediumint(8) NOT NULL, |
253 id int(12) NOT NULL auto_increment, |
254 id int(12) NOT NULL auto_increment, |
254 ipaddr varchar(40) NOT NULL, |
255 ipaddr varchar(40) NOT NULL, |
255 action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', |
256 action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', |
256 timestamp int(12) NOT NULL DEFAULT 0, |
257 timestamp int(12) NOT NULL DEFAULT 0, |
257 PRIMARY KEY ( id ) |
258 PRIMARY KEY ( id ) |
258 ) CHARACTER SET `utf8`; |
259 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
259 |
260 |
260 -- Added in 1.1.1 |
261 -- Added in 1.1.1 |
261 |
262 |
262 CREATE TABLE {{TABLE_PREFIX}}language( |
263 CREATE TABLE {{TABLE_PREFIX}}language( |
263 lang_id smallint(5) NOT NULL auto_increment, |
264 lang_id smallint(5) NOT NULL auto_increment, |
264 lang_code varchar(16) NOT NULL, |
265 lang_code varchar(16) NOT NULL, |
265 lang_name_default varchar(64) NOT NULL, |
266 lang_name_default varchar(64) NOT NULL, |
266 lang_name_native varchar(64) NOT NULL, |
267 lang_name_native varchar(64) NOT NULL, |
267 last_changed int(12) NOT NULL DEFAULT 0, |
268 last_changed int(12) NOT NULL DEFAULT 0, |
268 PRIMARY KEY ( lang_id ) |
269 PRIMARY KEY ( lang_id ) |
269 ) CHARACTER SET `utf8`; |
270 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
270 |
271 |
271 -- Added in 1.1.1 |
272 -- Added in 1.1.1 |
272 |
273 |
273 CREATE TABLE {{TABLE_PREFIX}}language_strings( |
274 CREATE TABLE {{TABLE_PREFIX}}language_strings( |
274 string_id bigint(15) NOT NULL auto_increment, |
275 string_id bigint(15) NOT NULL auto_increment, |
275 lang_id smallint(5) NOT NULL, |
276 lang_id smallint(5) NOT NULL, |
276 string_category varchar(32) NOT NULL, |
277 string_category varchar(32) NOT NULL, |
277 string_name varchar(64) NOT NULL, |
278 string_name varchar(64) NOT NULL, |
278 string_content longtext NOT NULL, |
279 string_content longtext NOT NULL, |
279 PRIMARY KEY ( string_id ) |
280 PRIMARY KEY ( string_id ) |
280 ); |
281 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
|
282 |
|
283 -- Added in 1.1.1 |
|
284 |
|
285 CREATE TABLE {{TABLE_PREFIX}}ranks( |
|
286 rank_id int(12) NOT NULL auto_increment, |
|
287 rank_title varchar(63) NOT NULL DEFAULT '', |
|
288 rank_style varchar(255) NOT NULL DEFAULT '', |
|
289 PRIMARY KEY ( rank_id ) |
|
290 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
|
291 |
|
292 -- Added in 1.1.1 |
|
293 |
|
294 CREATE TABLE {{TABLE_PREFIX}}captcha( |
|
295 code_id int(12) NOT NULL auto_increment, |
|
296 session_id varchar(40) NOT NULL DEFAULT '', |
|
297 code varchar(64) NOT NULL DEFAULT '', |
|
298 session_data text, |
|
299 source_ip varchar(39), |
|
300 user_id int(12), |
|
301 PRIMARY KEY ( code_id ) |
|
302 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
281 |
303 |
282 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
304 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
283 ('site_name', '{{SITE_NAME}}'), |
305 ('site_name', '{{SITE_NAME}}'), |
284 ('main_page', 'Main_Page'), |
306 ('main_page', 'Main_Page'), |
285 ('site_desc', '{{SITE_DESC}}'), |
307 ('site_desc', '{{SITE_DESC}}'), |
324 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '{{IP_ADDRESS}}'), |
346 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '{{IP_ADDRESS}}'), |
325 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1, '{{IP_ADDRESS}}'); |
347 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1, '{{IP_ADDRESS}}'); |
326 |
348 |
327 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
349 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
328 (2); |
350 (2); |
|
351 |
|
352 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
|
353 (1, 'user_rank_member', ''), |
|
354 (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'), |
|
355 (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'); |
329 |
356 |
330 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
357 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
331 (2,'Administrators',3,1), |
358 (2,'Administrators',3,1), |
332 (3,'Moderators',3,1); |
359 (3,'Moderators',3,1); |
333 |
360 |