92 |
92 |
93 CREATE TABLE {{TABLE_PREFIX}}users( |
93 CREATE TABLE {{TABLE_PREFIX}}users( |
94 user_id SERIAL, |
94 user_id SERIAL, |
95 username text, |
95 username text, |
96 password varchar(255), |
96 password varchar(255), |
|
97 password_salt varchar(40) NOT NULL DEFAULT '', |
97 email text, |
98 email text, |
98 real_name text, |
99 real_name text, |
99 user_level smallint NOT NULL DEFAULT 2, |
100 user_level smallint NOT NULL DEFAULT 2, |
100 theme varchar(64) NOT NULL DEFAULT 'bleu.css', |
101 theme varchar(64) NOT NULL DEFAULT 'bleu.css', |
101 style varchar(64) NOT NULL DEFAULT 'DEFAULT', |
102 style varchar(64) NOT NULL DEFAULT 'DEFAULT', |
388 |
389 |
389 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, DEFAULT_style, enabled) VALUES |
390 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, DEFAULT_style, enabled) VALUES |
390 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
391 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
391 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
392 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
392 |
393 |
393 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, email, real_name, user_level, theme, style, signature, reg_time, account_active, user_registration_ip, user_lang, user_has_avatar, avatar_type) VALUES |
394 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, password_salt, email, real_name, user_level, theme, style, signature, reg_time, account_active, user_registration_ip, user_lang, user_has_avatar, avatar_type) VALUES |
394 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '', 0, 0, 'png'), |
395 (1, 'Anonymous', 'invalid-pass-hash', '', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '', 0, 0, 'png'), |
395 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png'); |
396 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_PASS_SALT}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png'); |
396 |
397 |
397 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
398 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
398 (2); |
399 (2); |
399 |
400 |
400 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
401 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |