phpBB.de

Code: Alles auswählen

# Table: 'phpbb_attachments'
ALTER TABLE phpbb_attachments
MODIFY attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY physical_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY real_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY attach_comment text NOT NULL COLLATE utf8_bin,
MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY mimetype varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb_acl_groups'
ALTER TABLE phpbb_acl_groups
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb_acl_options'
ALTER TABLE phpbb_acl_options
MODIFY auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY auth_option varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;