102 user_coppa smallint NOT NULL DEFAULT 0, |
102 user_coppa smallint NOT NULL DEFAULT 0, |
103 user_lang smallint NOT NULL, |
103 user_lang smallint NOT NULL, |
104 user_has_avatar smallint NOT NULL, |
104 user_has_avatar smallint NOT NULL, |
105 avatar_type varchar(3) NOT NULL, |
105 avatar_type varchar(3) NOT NULL, |
106 user_registration_ip varchar(39), |
106 user_registration_ip varchar(39), |
|
107 user_rank int NOT NULL DEFAULT 1, |
107 CHECK (avatar_type IN ('jpg', 'png', 'gif')), |
108 CHECK (avatar_type IN ('jpg', 'png', 'gif')), |
108 PRIMARY KEY (user_id) |
109 PRIMARY KEY (user_id) |
109 ); |
110 ); |
110 |
111 |
111 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
112 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
273 string_id SERIAL, |
274 string_id SERIAL, |
274 lang_id int NOT NULL, |
275 lang_id int NOT NULL, |
275 string_category varchar(32) NOT NULL, |
276 string_category varchar(32) NOT NULL, |
276 string_name varchar(64) NOT NULL, |
277 string_name varchar(64) NOT NULL, |
277 string_content text NOT NULL |
278 string_content text NOT NULL |
|
279 ); |
|
280 |
|
281 -- Added in 1.1.1 |
|
282 |
|
283 CREATE TABLE {{TABLE_PREFIX}}ranks( |
|
284 rank_id SERIAL, |
|
285 rank_title varchar(63) NOT NULL DEFAULT '', |
|
286 rank_style varchar(255) NOT NULL DEFAULT '' |
|
287 ); |
|
288 |
|
289 -- Added in 1.1.1 |
|
290 |
|
291 CREATE TABLE {{TABLE_PREFIX}}captcha( |
|
292 code_id SERIAL, |
|
293 session_id varchar(40) NOT NULL DEFAULT '', |
|
294 code varchar(64) NOT NULL DEFAULT '', |
|
295 session_data text, |
|
296 source_ip varchar(39), |
|
297 user_id int |
278 ); |
298 ); |
279 |
299 |
280 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
300 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
281 ('site_name', '{{SITE_NAME}}'), |
301 ('site_name', '{{SITE_NAME}}'), |
282 ('main_page', 'Main_Page'), |
302 ('main_page', 'Main_Page'), |
322 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '', 0, 0, 'png'), |
342 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '', 0, 0, 'png'), |
323 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png'); |
343 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png'); |
324 |
344 |
325 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
345 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
326 (2); |
346 (2); |
|
347 |
|
348 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
|
349 (1, 'user_rank_member', ''), |
|
350 (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'), |
|
351 (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'); |
327 |
352 |
328 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
353 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
329 (2,'Administrators',3,1), |
354 (2,'Administrators',3,1), |
330 (3,'Moderators',3,1); |
355 (3,'Moderators',3,1); |
331 |
356 |