91 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
91 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
92 |
92 |
93 CREATE TABLE {{TABLE_PREFIX}}users( |
93 CREATE TABLE {{TABLE_PREFIX}}users( |
94 user_id mediumint(8) NOT NULL auto_increment, |
94 user_id mediumint(8) NOT NULL auto_increment, |
95 username text, |
95 username text, |
96 password varchar(255), |
96 password varchar(40), |
|
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 tinyint(1) NOT NULL DEFAULT 2, |
100 user_level tinyint(1) 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', |
371 |
372 |
372 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES |
373 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES |
373 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
374 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
374 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
375 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
375 |
376 |
376 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, email, real_name, user_level, theme, style, signature, reg_time, account_active, user_registration_ip) VALUES |
377 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) VALUES |
377 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '{{IP_ADDRESS}}'), |
378 (1, 'Anonymous', 'invalid-pass-hash', '', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0, '{{IP_ADDRESS}}'), |
378 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1, '{{IP_ADDRESS}}'); |
379 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_PASS_SALT}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1, '{{IP_ADDRESS}}'); |
379 |
380 |
380 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
381 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
381 (2); |
382 (2); |
382 |
383 |
383 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
384 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |