Recordar ajustar el prefijo phpbb_ el los 3 lugares
Código: Seleccionar todo
#
# Table: phpbb_phpbbweb_attachments
DROP TABLE IF EXISTS phpbb_phpbbweb_attachments;
CREATE TABLE `phpbb_phpbbweb_attachments` (
`attach_id` mediumint(8) unsigned NOT NULL default '0',
`page_id` mediumint(8) unsigned NOT NULL default '0',
`in_message` tinyint(1) NOT NULL default '1',
`poster_id` mediumint(8) unsigned NOT NULL default '0',
`is_orphan` tinyint(1) NOT NULL default '0',
`physical_filename` varchar(255) collate utf8_bin NOT NULL default '',
`real_filename` varchar(255) collate utf8_bin NOT NULL default '',
`download_count` mediumint(8) unsigned NOT NULL default '0',
`attach_comment` text collate utf8_bin NOT NULL,
`extension` varchar(100) collate utf8_bin NOT NULL default '',
`mimetype` varchar(100) collate utf8_bin NOT NULL default '',
`filesize` int(20) NOT NULL default '0',
`filetime` int(11) NOT NULL default '0',
`thumbnail` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`attach_id`),
KEY `filetime` (`filetime`),
KEY `poster_id` (`poster_id`),
KEY `is_orphan` (`is_orphan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;