phpBB.de

Code: Alles auswählen

CREATE TABLE `phpbb_album` (
  `pic_id` int(11) unsigned NOT NULL default '0',
  `pic_filename` varchar(255) collate latin1_general_ci NOT NULL default '',
  `pic_thumbnail` varchar(255) collate latin1_general_ci default '',
  `pic_title` varchar(255) collate latin1_general_ci NOT NULL default '',
  `pic_desc` text collate latin1_general_ci,
  `pic_user_id` mediumint(8) NOT NULL default '0',
  `pic_username` varchar(32) collate latin1_general_ci default '',
  `pic_user_ip` varchar(8) collate latin1_general_ci NOT NULL default '0',
  `pic_time` int(11) unsigned NOT NULL default '0',
  `pic_cat_id` mediumint(8) unsigned NOT NULL default '1',
  `pic_view_count` int(11) unsigned NOT NULL default '0',
  `pic_lock` tinyint(3) NOT NULL default '0',
  `pic_approval` tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (`pic_id`),
  KEY `pic_cat_id` (`pic_cat_id`),
  KEY `pic_user_id` (`pic_user_id`),
  KEY `pic_time` (`pic_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Code: Alles auswählen

 MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '',
  `pic_thumbnai