1 CREATE TABLE {{TABLE_PREFIX}}bans (

     2     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

     3     username VARCHAR(200),

     4     ip VARCHAR(255),

     5     email VARCHAR(80),

     6     message VARCHAR(255),

     7     expire INT(10) UNSIGNED,

     8     ban_creator INT(10) UNSIGNED NOT NULL DEFAULT 0,

     9     PRIMARY KEY (id)

    10   ) ENGINE = MyISAM CHARACTER SET utf8;

    11 

    12 CREATE TABLE {{TABLE_PREFIX}}categories (

    13     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

    14     cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',

    15     disp_position INT(10) NOT NULL DEFAULT 0,

    16     PRIMARY KEY (id)

    17   ) ENGINE = MyISAM CHARACTER SET utf8;

    18 

    19 CREATE TABLE {{TABLE_PREFIX}}censoring (

    20     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

    21     search_for VARCHAR(60) NOT NULL DEFAULT '',

    22     replace_with VARCHAR(60) NOT NULL DEFAULT '',

    23     PRIMARY KEY (id)

    24   ) ENGINE = MyISAM CHARACTER SET utf8;

    25 

    26 CREATE TABLE {{TABLE_PREFIX}}config (

    27     conf_name VARCHAR(255) NOT NULL DEFAULT '',

    28     conf_value TEXT,

    29     PRIMARY KEY (conf_name)

    30   ) ENGINE = MyISAM CHARACTER SET utf8;

    31 

    32 CREATE TABLE {{TABLE_PREFIX}}extensions (

    33     id VARCHAR(50) NOT NULL DEFAULT '',

    34     title VARCHAR(255) NOT NULL DEFAULT '',

    35     version VARCHAR(25) NOT NULL DEFAULT '',

    36     description TEXT,

    37     author VARCHAR(50) NOT NULL DEFAULT '',

    38     uninstall TEXT,

    39     uninstall_note TEXT,

    40     disabled TINYINT(1) NOT NULL DEFAULT 0,

    41     PRIMARY KEY(id)

    42   ) ENGINE = MyISAM CHARACTER SET utf8;

    43 

    44 CREATE TABLE {{TABLE_PREFIX}}extension_hooks (

    45     id VARCHAR(50) NOT NULL DEFAULT '',

    46     extension_id VARCHAR(50) NOT NULL DEFAULT '',

    47     code TEXT,

    48     installed INT(10) UNSIGNED NOT NULL DEFAULT 0,

    49     PRIMARY KEY(id, extension_id)

    50   ) ENGINE = MyISAM CHARACTER SET utf8;

    51 

    52 CREATE TABLE {{TABLE_PREFIX}}forum_perms (

    53     group_id INT(10) NOT NULL DEFAULT 0,

    54     forum_id INT(10) NOT NULL DEFAULT 0,

    55     read_forum TINYINT(1) NOT NULL DEFAULT 1,

    56     post_replies TINYINT(1) NOT NULL DEFAULT 1,

    57     post_topics TINYINT(1) NOT NULL DEFAULT 1,

    58     PRIMARY KEY (group_id, forum_id)

    59   ) ENGINE = MyISAM CHARACTER SET utf8;

    60 

    61 CREATE TABLE {{TABLE_PREFIX}}forums (

    62     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

    63     forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',

    64     forum_desc TEXT,

    65     redirect_url VARCHAR(100),

    66     moderators TEXT,

    67     num_topics MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

    68     num_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

    69     last_post INT(10) UNSIGNED,

    70     last_post_id INT(10) UNSIGNED,

    71     last_poster VARCHAR(200),

    72     sort_by TINYINT(1) NOT NULL DEFAULT 0,

    73     disp_position INT(10) NOT NULL DEFAULT 0,

    74     cat_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

    75     PRIMARY KEY (id)

    76   ) ENGINE = MyISAM CHARACTER SET utf8;

    77 

    78 CREATE TABLE {{TABLE_PREFIX}}groups (

    79     g_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

    80     g_title VARCHAR(50) NOT NULL DEFAULT '',

    81     g_user_title VARCHAR(50),

    82     g_moderator TINYINT(1) NOT NULL DEFAULT 0,

    83     g_mod_edit_users TINYINT(1) NOT NULL DEFAULT 0,

    84     g_mod_rename_users TINYINT(1) NOT NULL DEFAULT 0,

    85     g_mod_change_passwords TINYINT(1) NOT NULL DEFAULT 0,

    86     g_mod_ban_users TINYINT(1) NOT NULL DEFAULT 0,

    87     g_read_board TINYINT(1) NOT NULL DEFAULT 1,

    88     g_view_users TINYINT(1) NOT NULL DEFAULT 1,

    89     g_post_replies TINYINT(1) NOT NULL DEFAULT 1,

    90     g_post_topics TINYINT(1) NOT NULL DEFAULT 1,

    91     g_edit_posts TINYINT(1) NOT NULL DEFAULT 1,

    92     g_delete_posts TINYINT(1) NOT NULL DEFAULT 1,

    93     g_delete_topics TINYINT(1) NOT NULL DEFAULT 1,

    94     g_set_title TINYINT(1) NOT NULL DEFAULT 1,

    95     g_search TINYINT(1) NOT NULL DEFAULT 1,

    96     g_search_users TINYINT(1) NOT NULL DEFAULT 1,

    97     g_edit_subjects_interval SMALLINT(6) NOT NULL DEFAULT 300,

    98     g_post_flood SMALLINT(6) NOT NULL DEFAULT 30,

    99     g_search_flood SMALLINT(6) NOT NULL DEFAULT 30,

   100     PRIMARY KEY (g_id)

   101   ) ENGINE = MyISAM CHARACTER SET utf8;

   102 

   103 CREATE TABLE {{TABLE_PREFIX}}online (

   104     user_id INT(10) UNSIGNED NOT NULL DEFAULT 1,

   105     ident VARCHAR(200) NOT NULL DEFAULT '',

   106     logged INT(10) UNSIGNED NOT NULL DEFAULT 0,

   107     idle TINYINT(1) NOT NULL DEFAULT 0,

   108     csrf_token VARCHAR(40) NOT NULL DEFAULT '',

   109     prev_url VARCHAR(255)

   110   ) TYPE=HEAP;

   111 

   112 CREATE TABLE {{TABLE_PREFIX}}posts (

   113     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   114     poster VARCHAR(200) NOT NULL DEFAULT '',

   115     poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1,

   116     poster_ip VARCHAR(15),

   117     poster_email VARCHAR(80),

   118     message TEXT,

   119     hide_smilies TINYINT(1) NOT NULL DEFAULT 0,

   120     posted INT(10) UNSIGNED NOT NULL DEFAULT 0,

   121     edited INT(10) UNSIGNED,

   122     edited_by VARCHAR(200),

   123     topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   124     PRIMARY KEY (id)

   125   ) ENGINE = MyISAM CHARACTER SET utf8;

   126 

   127 CREATE TABLE {{TABLE_PREFIX}}ranks (

   128     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   129     rank VARCHAR(50) NOT NULL DEFAULT '',

   130     min_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   131     PRIMARY KEY (id)

   132   ) ENGINE = MyISAM CHARACTER SET utf8;

   133 

   134 CREATE TABLE {{TABLE_PREFIX}}reports (

   135     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   136     post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   137     topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   138     forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   139     reported_by INT(10) UNSIGNED NOT NULL DEFAULT 0,

   140     created INT(10) UNSIGNED NOT NULL DEFAULT 0,

   141     message TEXT,

   142     zapped INT(10) UNSIGNED,

   143     zapped_by INT(10) UNSIGNED,

   144     PRIMARY KEY (id)

   145   ) ENGINE = MyISAM CHARACTER SET utf8;

   146 

   147 CREATE TABLE {{TABLE_PREFIX}}subscriptions (

   148     user_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   149     topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   150     PRIMARY KEY (user_id, topic_id)

   151   ) ENGINE = MyISAM CHARACTER SET utf8;

   152 

   153 CREATE TABLE {{TABLE_PREFIX}}topics (

   154     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   155     poster VARCHAR(200) NOT NULL DEFAULT '',

   156     subject VARCHAR(255) NOT NULL DEFAULT '',

   157     posted INT(10) UNSIGNED NOT NULL DEFAULT 0,

   158     first_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   159     last_post INT(10) UNSIGNED NOT NULL DEFAULT 0,

   160     last_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   161     last_poster VARCHAR(200),

   162     num_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   163     num_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,

   164     closed TINYINT(1) NOT NULL DEFAULT 0,

   165     sticky TINYINT(1) NOT NULL DEFAULT 0,

   166     moved_to INT(10) UNSIGNED,

   167     forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,

   168     PRIMARY KEY (id)

   169   ) ENGINE = MyISAM CHARACTER SET utf8;

   170 

   171 CREATE TABLE {{TABLE_PREFIX}}users (

   172     id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

   173     group_id INT(10) UNSIGNED NOT NULL DEFAULT 4,

   174     username VARCHAR(200) NOT NULL DEFAULT '',

   175     password VARCHAR(40) NOT NULL DEFAULT '',

   176     salt VARCHAR(12),

   177     email VARCHAR(80) NOT NULL DEFAULT '',

   178     title VARCHAR(50),

   179     realname VARCHAR(40),

   180     url VARCHAR(100),

   181     jabber VARCHAR(80),

   182     icq VARCHAR(12),

   183     msn VARCHAR(80),

   184     aim VARCHAR(30),

   185     yahoo VARCHAR(30),

   186     location VARCHAR(30),

   187     signature TEXT,

   188     disp_topics TINYINT(3) UNSIGNED,

   189     disp_posts TINYINT(3) UNSIGNED,

   190     email_setting TINYINT(1) NOT NULL DEFAULT 1,

   191     save_pass TINYINT(1) NOT NULL DEFAULT 1,

   192     notify_with_post TINYINT(1) NOT NULL DEFAULT 0,

   193     auto_notify TINYINT(1) NOT NULL DEFAULT 0,

   194     show_smilies TINYINT(1) NOT NULL DEFAULT 1,

   195     show_img TINYINT(1) NOT NULL DEFAULT 1,

   196     show_img_sig TINYINT(1) NOT NULL DEFAULT 1,

   197     show_avatars TINYINT(1) NOT NULL DEFAULT 1,

   198     show_sig TINYINT(1) NOT NULL DEFAULT 1,

   199     timezone FLOAT NOT NULL DEFAULT 0,

   200     dst TINYINT(1) NOT NULL DEFAULT 0,

   201     time_format INT(10) UNSIGNED NOT NULL DEFAULT 0,

   202     date_format INT(10) UNSIGNED NOT NULL DEFAULT 0,

   203     language VARCHAR(25) NOT NULL DEFAULT 'English',

   204     style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',

   205     num_posts INT(10) UNSIGNED NOT NULL DEFAULT 0,

   206     last_post INT(10) UNSIGNED,

   207     registered INT(10) UNSIGNED NOT NULL DEFAULT 0,

   208     registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',

   209     last_visit INT(10) UNSIGNED NOT NULL DEFAULT 0,

   210     admin_note VARCHAR(30),

   211     activate_string VARCHAR(80),

   212     activate_key VARCHAR(8),

   213     PRIMARY KEY (id)

   214   ) ENGINE = MyISAM CHARACTER SET utf8;

   215 

   216 ALTER TABLE {{TABLE_PREFIX}}online ADD UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx(user_id,ident(25));

   217 ALTER TABLE {{TABLE_PREFIX}}online ADD INDEX {{TABLE_PREFIX}}online_user_id_idx(user_id);

   218 ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_topic_id_idx(topic_id);

   219 ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_multi_idx(poster_id, topic_id);

   220 ALTER TABLE {{TABLE_PREFIX}}posts ADD FULLTEXT {{TABLE_PREFIX}}posts_message_idx(message);

   221 ALTER TABLE {{TABLE_PREFIX}}reports ADD INDEX {{TABLE_PREFIX}}reports_zapped_idx(zapped);

   222 ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_forum_id_idx(forum_id);

   223 ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_moved_to_idx(moved_to);

   224 ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_last_post_idx(last_post);

   225 ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_first_post_id_idx(first_post_id);

   226 ALTER TABLE {{TABLE_PREFIX}}topics ADD FULLTEXT {{TABLE_PREFIX}}topics_subject_idx(subject);

   227 ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_registered_idx(registered);

   228 ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_username_idx(username(8));

   229 

   230 INSERT INTO {{TABLE_PREFIX}}config ( conf_name, conf_value ) VALUES

   231   ('o_cur_version', '{{PUN_VERSION}}'),

   232   ('o_board_title', 'My PunBB Forum'),

   233   ('o_board_desc', 'Unfortunately no one can be told what PunBB is - you have to see it for yourself.'),

   234   ('o_default_timezone', '0'),

   235   ('o_time_format', 'H:i:s'),

   236   ('o_date_format', 'Y-m-d'),

   237   ('o_check_for_updates', '0'),

   238   ('o_timeout_visit', '1800'),

   239   ('o_timeout_online', '300'),

   240   ('o_redirect_delay', '1'),

   241   ('o_show_version', '0'),

   242   ('o_show_user_info', '1'),

   243   ('o_show_post_count', '1'),

   244   ('o_signatures', '1'),

   245   ('o_smilies', '1'),

   246   ('o_smilies_sig', '1'),

   247   ('o_make_links', '1'),

   248   ('o_default_lang', 'English'),

   249   ('o_default_style', 'Oxygen'),

   250   ('o_default_user_group', '3'),

   251   ('o_topic_review', '15'),

   252   ('o_disp_topics_default', '30'),

   253   ('o_disp_posts_default', '25'),

   254   ('o_indent_num_spaces', '4'),

   255   ('o_quickpost', '1'),

   256   ('o_users_online', '1'),

   257   ('o_censoring', '0'),

   258   ('o_ranks', '1'),

   259   ('o_show_dot', '0'),

   260   ('o_topic_views', '1'),

   261   ('o_quickjump', '1'),

   262   ('o_gzip', '0'),

   263   ('o_additional_navlinks', ''),

   264   ('o_report_method', '0'),

   265   ('o_regs_report', '0'),

   266   ('o_mailing_list', '{{ENANO_ADMIN_EMAIL}}'),

   267   ('o_avatars', '0'),

   268   ('o_avatars_dir', 'img/avatars'),

   269   ('o_avatars_width', '60'),

   270   ('o_avatars_height', '60'),

   271   ('o_avatars_size', '10240'),

   272   ('o_search_all_forums', '1'),

   273   ('o_sef', 'Default'),

   274   ('o_admin_email', '{{ENANO_ADMIN_EMAIL}}'),

   275   ('o_webmaster_email', '{{ENANO_ADMIN_EMAIL}}'),

   276   ('o_subscriptions', '1'),

   277   ('o_smtp_host', NULL),

   278   ('o_smtp_user', NULL),

   279   ('o_smtp_pass', NULL),

   280   ('o_smtp_ssl', '0'),

   281   ('o_regs_allow', '1'),

   282   ('o_regs_verify', '0'),

   283   ('o_announcement', '0'),

   284   ('o_announcement_heading', 'Sample announcement'),

   285   ('o_announcement_message', '<p>Enter your announcement here.</p>'),

   286   ('o_rules', '0'),

   287   ('o_rules_message', 'Enter your rules here.'),

   288   ('o_maintenance', '0'),

   289   ('o_maintenance_message', 'The forums are temporarily down for maintenance. Please try again in a few minutes.<br />\\n<br />\\n/Administrator'),

   290   ('p_message_bbcode', '1'),

   291   ('p_message_img_tag', '1'),

   292   ('p_message_all_caps', '1'),

   293   ('p_subject_all_caps', '1'),

   294   ('p_sig_all_caps', '1'),

   295   ('p_sig_bbcode', '1'),

   296   ('p_sig_img_tag', '0'),

   297   ('p_sig_length', '400'),

   298   ('p_sig_lines', '4'),

   299   ('p_allow_banned_email', '1'),

   300   ('p_allow_dupe_email', '0'),

   301   ('p_force_guest_email', '1');

   302   

   303 INSERT INTO {{TABLE_PREFIX}}groups (g_title, g_user_title, g_moderator, g_mod_edit_users, g_mod_rename_users, g_mod_change_passwords, g_mod_ban_users, g_read_board, g_view_users, g_post_replies, g_post_topics, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES

   304   ('Administrators', 'Administrator', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),

   305   ('Guest', NULL, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0),

   306   ('Members', NULL, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30),

   307   ('Moderators', 'Moderator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0);

   308 

   309 INSERT INTO {{TABLE_PREFIX}}forums (forum_name, forum_desc, num_topics, num_posts, last_post, last_post_id, last_poster, disp_position, cat_id) VALUES('Test forum', 'This is just a test forum', 1, 1, {{NOW}}, 1, 'Enano', 1, 1);

   310 INSERT INTO {{TABLE_PREFIX}}topics (poster, subject, posted, first_post_id, last_post, last_post_id, last_poster, forum_id) VALUES('Enano', 'Test post', {{NOW}}, 1, {{NOW}}, 1, 'Enano', 1);

   311 INSERT INTO {{TABLE_PREFIX}}posts (poster, poster_id, poster_ip, message, posted, topic_id) VALUES('Enano', 2, '127.0.0.1', 'If you are looking at this (which I guess you are), the install of PunBB appears to have worked! Now log in and head over to the administration control panel to configure your forum.', {{NOW}}, 1);

   312 INSERT INTO {{TABLE_PREFIX}}ranks (rank, min_posts) VALUES('New member', 0);

   313 INSERT INTO {{TABLE_PREFIX}}ranks (rank, min_posts) VALUES('Member', 10);

   314 INSERT INTO {{TABLE_PREFIX}}users (id, group_id, username, password, email) VALUES(1, 2, 'Guest', 'Guest', 'Guest');