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 CHECK (user_has_avatar IN ('jpg', 'png', 'gif')), |
107 CHECK (avatar_type IN ('jpg', 'png', 'gif')), |
108 PRIMARY KEY (user_id) |
108 PRIMARY KEY (user_id) |
109 ); |
109 ); |
110 |
110 |
111 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
111 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
112 user_id int NOT NULL, |
112 user_id int NOT NULL, |
316 |
316 |
317 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES |
317 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES |
318 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
318 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
319 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
319 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
320 |
320 |
321 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 |
321 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 |
322 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0), |
322 (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}}'); |
323 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png'); |
324 |
324 |
325 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
325 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
326 (2); |
326 (2); |
327 |
327 |
328 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
328 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |