1 -- Enano - an open-source CMS capable of wiki functions, Drupal-like sidebar blocks, and everything in between |
1 -- Enano - an open-source CMS capable of wiki functions, Drupal-like sidebar blocks, and everything in between |
2 -- Version 1.0.2 (Coblynau) |
2 -- Version 1.1.1 |
3 -- Copyright (C) 2006-2007 Dan Fuhry |
3 -- Copyright (C) 2006-2007 Dan Fuhry |
4 |
4 |
5 -- This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License |
5 -- This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License |
6 -- as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. |
6 -- as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. |
7 |
7 |
24 comment_data text, |
24 comment_data text, |
25 name text, |
25 name text, |
26 approved tinyint(1) default 1, |
26 approved tinyint(1) default 1, |
27 user_id mediumint(8) NOT NULL DEFAULT -1, |
27 user_id mediumint(8) NOT NULL DEFAULT -1, |
28 time int(12) NOT NULL DEFAULT 0, |
28 time int(12) NOT NULL DEFAULT 0, |
|
29 ip_address varchar(39), |
29 PRIMARY KEY ( comment_id ) |
30 PRIMARY KEY ( comment_id ) |
30 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
31 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
31 |
32 |
32 CREATE TABLE {{TABLE_PREFIX}}logs( |
33 CREATE TABLE {{TABLE_PREFIX}}logs( |
33 log_type varchar(16), |
34 log_type varchar(16), |
101 temp_password_time int(12) NOT NULL DEFAULT 0, |
102 temp_password_time int(12) NOT NULL DEFAULT 0, |
102 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
103 user_coppa tinyint(1) NOT NULL DEFAULT 0, |
103 user_lang smallint(5) NOT NULL, |
104 user_lang smallint(5) NOT NULL, |
104 user_has_avatar tinyint(1) NOT NULL, |
105 user_has_avatar tinyint(1) NOT NULL, |
105 avatar_type ENUM('jpg', 'png', 'gif') NOT NULL, |
106 avatar_type ENUM('jpg', 'png', 'gif') NOT NULL, |
|
107 user_registration_ip varchar(39), |
106 PRIMARY KEY (user_id) |
108 PRIMARY KEY (user_id) |
107 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
109 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
108 |
110 |
109 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
111 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
110 user_id mediumint(8) NOT NULL, |
112 user_id mediumint(8) NOT NULL, |
316 |
318 |
317 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES |
319 INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES |
318 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
320 ('oxygen', 'Oxygen', 1, 'bleu.css', 1), |
319 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
321 ('stpatty', 'St. Patty', 2, 'shamrock.css', 1); |
320 |
322 |
321 INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, email, real_name, user_level, theme, style, signature, reg_time, account_active) VALUES |
323 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 |
322 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0), |
324 (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0), |
323 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1); |
325 (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1, '{{IP_ADDRESS}}'); |
324 |
326 |
325 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
327 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES |
326 (2); |
328 (2); |
327 |
329 |
328 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |
330 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1), |