Welche MySQL-Version verwendest Du?
5.0.15
Wie sehen die Tabellen aus?
CREATE TABLE b
(
id
int(11) NOT NULL auto_increment,
group\_id
int(11) default NULL,
ext\_for\_id
int(11) default NULL,
title
varchar(255) NOT NULL default '',
description
text NOT NULL,
contact
text NOT NULL,
url
varchar(100) NOT NULL default '',
email
varchar(120) NOT NULL default '',
picture
varchar(100) NOT NULL default '',
cat
tinyint(2) NOT NULL default '0',
date
int(11) NOT NULL default '0',
time
int(11) default NULL,
modif\_date
int(11) default NULL,
modif\_time
int(11) default NULL,
duration
int(11) NOT NULL default '0',
priority
tinyint(4) default '2',
day
tinyint(2) NOT NULL default '0',
month
smallint(2) NOT NULL default '0',
year
smallint(4) NOT NULL default '0',
approved
tinyint(1) NOT NULL default '0',
submit\_by
mediumint(8) unsigned NOT NULL default '0',
type
char(1) NOT NULL default 'E',
access
char(1) default 'P',
price
varchar(50) default NULL,
location
varchar(100) default NULL,
city
varchar(50) default NULL,
band
varchar(100) default NULL,
fotografen
int(1) default NULL,
partyleinwand
int(1) default NULL,
freikarten
varchar(15) default NULL,
beginn
varchar(10) default '',
landkreis
int(3) NOT NULL default '20',
ausweiskontrolle
int(1) default NULL,
partyleinwand\_da
int(1) default NULL,
fotodruck\_da
int(1) default NULL,
needfotografen
int(2) NOT NULL default '0',
fotografencount
int(2) NOT NULL default '0',
forumlink
varchar(255) NOT NULL default '',
PRIMARY KEY (id
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;