Kod: Markera allt
#-----[ SQL ]-------------------------------------------------
#
# forums
#
ALTER TABLE phpbb_forums
ADD forum_type CHAR(1) BINARY NOT NULL DEFAULT 'f' AFTER forum_status,
ADD forum_main SMALLINT(5) UNSIGNED NOT NULL AFTER forum_status,
ADD auth_global_announce TINYINT( 2 ) NOT NULL AFTER auth_announce,
ADD forum_last_title VARCHAR( 255 ),
ADD forum_last_poster MEDIUMINT( 8 ) NOT NULL,
ADD forum_last_username VARCHAR( 25 ),
ADD forum_last_time INT( 11 ) NOT NULL,
ADD forum_link VARCHAR( 255 ),
ADD forum_link_hit_count TINYINT( 1 ) NOT NULL,
ADD forum_link_hit BIGINT(20) UNSIGNED NOT NULL,
ADD forum_link_start INT(11) NOT NULL,
ADD forum_style TINYINT( 4 ) NOT NULL,
ADD forum_nav_icon VARCHAR( 255 ),
ADD forum_icon VARCHAR( 255 ),
ADD forum_topics_ppage TINYINT( 2 ) NOT NULL,
ADD forum_topics_sort VARCHAR( 25 ),
ADD forum_topics_order VARCHAR( 4 ),
ADD forum_index_pack TINYINT( 1 ) NOT NULL,
ADD forum_index_split TINYINT( 1 ) NOT NULL,
ADD forum_board_box TINYINT( 1 ) NOT NULL;
#
#-----[ SQL ]-------------------------------------------------
#
# auths
#
ALTER TABLE phpbb_auth_access
ADD auth_global_announce TINYINT( 1 ) NOT NULL AFTER auth_announce;
#
#-----[ SQL ]-------------------------------------------------
#
# auths definitions
#
CREATE TABLE phpbb_auths_def (
auth_id SMALLINT(5) UNSIGNED NOT NULL auto_increment,
auth_type CHAR(1) BINARY NOT NULL default '',
auth_name VARCHAR(50) NOT NULL default '',
auth_desc VARCHAR(255) NOT NULL default '',
auth_title TINYINT(1) NOT NULL default '0',
auth_order MEDIUMINT(8) UNSIGNED NOT NULL default '0',
PRIMARY KEY (auth_id)
);
#
#-----[ SQL ]-------------------------------------------------
#
# topics
#
ALTER TABLE phpbb_topics
ADD topic_sub_title VARCHAR( 255 ) DEFAULT NULL,
ADD topic_first_username VARCHAR( 25 ),
ADD topic_last_poster MEDIUMINT( 8 ) NOT NULL,
ADD topic_last_username VARCHAR( 25 ),
ADD topic_last_time INT( 11 ) NOT NULL,
ADD topic_icon SMALLINT( 3 ) UNSIGNED NOT NULL,
ADD topic_duration INT( 11 ) NOT NULL;
ALTER TABLE phpbb_topics
CHANGE topic_title topic_title VARCHAR( 255 ) NOT NULL;
#
#-----[ SQL ]-------------------------------------------------
#
# posts
#
ALTER TABLE phpbb_posts
ADD post_icon SMALLINT( 3 ) UNSIGNED NOT NULL;
#
#-----[ SQL ]-------------------------------------------------
#
# posts text
#
ALTER TABLE phpbb_posts_text
ADD post_sub_title VARCHAR( 255 ) DEFAULT NULL;
ALTER TABLE phpbb_posts_text
CHANGE post_subject post_subject VARCHAR( 255 ) DEFAULT NULL;
#
#-----[ SQL ]-------------------------------------------------
#
# users
#
ALTER TABLE phpbb_users
ADD user_unread_date INT( 11 ) NOT NULL,
ADD user_unread_topics TEXT,
ADD user_keep_unreads TINYINT( 1 ) NOT NULL,
ADD user_topics_sort VARCHAR( 25 ) NOT NULL,
ADD user_topics_order VARCHAR( 4 ) NOT NULL,
ADD user_smart_date TINYINT( 1 ) NOT NULL,
ADD user_board_box TINYINT( 1 ) NOT NULL,
ADD user_index_pack TINYINT( 1 ) NOT NULL,
ADD user_index_split TINYINT( 1 ) NOT NULL,
ADD user_session_logged TINYINT( 1 ) NOT NULL;
#
#-----[ SQL ]-------------------------------------------------
#
# groups
#
ALTER TABLE phpbb_groups
ADD group_status TINYINT( 2 ) NOT NULL,
ADD group_user_id MEDIUMINT( 8 ) DEFAULT 0 NOT NULL,
ADD group_user_list TEXT NOT NULL;
#
#-----[ SQL ]-------------------------------------------------
#
# config
#
ALTER TABLE phpbb_config
ADD config_static SMALLINT(1) UNSIGNED NOT NULL DEFAULT 0;
#
#-----[ SQL ]-------------------------------------------------
#
# styles
#
ALTER TABLE phpbb_themes
ADD images_pack VARCHAR( 100 ) NOT NULL AFTER style_name,
ADD custom_tpls VARCHAR( 100 ) NOT NULL AFTER images_pack;
#
#-----[ SQL ]-------------------------------------------------
#
# user cache
#
CREATE TABLE phpbb_users_cache (
user_id MEDIUMINT(8) NOT NULL,
cache_id VARCHAR(5) NOT NULL,
cache_data TEXT,
cache_time INT(11),
PRIMARY KEY ( user_id, cache_id )
);
#
#-----[ SQL ]-------------------------------------------------
#
# presets names
#
CREATE TABLE phpbb_presets (
preset_id MEDIUMINT(5) UNSIGNED NOT NULL auto_increment,
preset_type VARCHAR(5) NOT NULL default '',
preset_name VARCHAR(50) NOT NULL default '',
PRIMARY KEY ( preset_id )
);
#
#-----[ SQL ]-------------------------------------------------
#
# presets data
#
CREATE TABLE phpbb_presets_data (
preset_id MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
preset_auth VARCHAR(50) NOT NULL DEFAULT '',
preset_value TINYINT(1) DEFAULT NULL,
PRIMARY KEY ( preset_id, preset_auth )
);
#
#-----[ SQL ]-------------------------------------------------
#
# messages icons
#
CREATE TABLE phpbb_icons (
icon_id MEDIUMINT(3) NOT NULL AUTO_INCREMENT,
icon_name VARCHAR(50) NOT NULL DEFAULT '',
icon_url VARCHAR(255) NOT NULL DEFAULT '',
icon_acl TINYINT(2) NOT NULL DEFAULT '0',
icon_types VARCHAR(255) DEFAULT NULL,
icon_order MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (icon_id)
);
#
#-----[ SQL ]-------------------------------------------------
#
# control panels fields
#
CREATE TABLE phpbb_cp_fields (
field_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
field_name VARCHAR(50) NOT NULL DEFAULT '',
panel_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
field_order MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
field_attr TEXT NOT NULL,
PRIMARY KEY (field_id),
KEY panel_id (panel_id,field_name)
);
#
#-----[ SQL ]-------------------------------------------------
#
# control panels defs
#
CREATE TABLE phpbb_cp_panels (
panel_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
panel_shortcut VARCHAR(30) NOT NULL DEFAULT '',
panel_name VARCHAR(50) NOT NULL DEFAULT '',
panel_main MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
panel_order MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
panel_file VARCHAR(50) NOT NULL DEFAULT '',
panel_auth_type CHAR(1) binary NOT NULL DEFAULT '',
panel_auth_name VARCHAR(50) NOT NULL DEFAULT '',
panel_hidden TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (panel_id)
);
#
#-----[ SQL ]-------------------------------------------------
#
# control panels patches
#
CREATE TABLE phpbb_cp_patches (
patch_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment,
patch_file VARCHAR(255) NOT NULL DEFAULT '',
patch_time INT(11) NOT NULL DEFAULT '0',
patch_version VARCHAR(25) NOT NULL DEFAULT '',
patch_date VARCHAR(8) NOT NULL DEFAULT '',
patch_ref VARCHAR(255) NOT NULL DEFAULT '',
patch_author VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (patch_id)
);
#
#-----[ SQL ]-------------------------------------------------
#
# extended auths table
#
CREATE TABLE phpbb_auths (
group_id MEDIUMINT(8) NOT NULL DEFAULT '0',
obj_type CHAR(1) BINARY NOT NULL DEFAULT '',
obj_id MEDIUMINT(8) NOT NULL DEFAULT '0',
auth_name VARCHAR(50) NOT NULL DEFAULT '',
auth_value TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (group_id,obj_type,obj_id,auth_name),
KEY group_id (group_id,obj_type),
KEY obj_type (obj_type,obj_id)
);
#
#-----[ SQL ]-------------------------------------------------
#
# indexes addition
#
ALTER TABLE phpbb_topics ADD INDEX ( topic_last_time );
ALTER TABLE phpbb_posts ADD INDEX ( post_icon );
ALTER TABLE phpbb_config ADD INDEX ( config_static );
ALTER TABLE phpbb_groups ADD INDEX ( group_user_id );
