mehr als Strg+C und STRG+V kann ich ja wohl nicht machen. dann geh ich auf SQL und kopier es da rein.
Der ganz originale Code ist so
[code]CREATE TABLE bots (
id tinyint(3) unsigned NOT NULL auto_increment,
botname varchar(255) NOT NULL default ‘’,
PRIMARY KEY (botname),
KEY id (id)
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table conversationlog
CREATE TABLE conversationlog (
bot tinyint(3) unsigned NOT NULL default ‘0’,
id int(11) NOT NULL auto_increment,
input text,
response text,
uid varchar(255) default NULL,
enteredtime timestamp(14) NOT NULL,
PRIMARY KEY (id),
KEY botid (bot)
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table dstore
CREATE TABLE dstore (
uid varchar(255) default NULL,
name text,
value text,
enteredtime timestamp(14) NOT NULL,
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id),
KEY nameidx (name(40))
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table gmcache
CREATE TABLE gmcache (
id int(11) NOT NULL auto_increment,
bot tinyint(3) unsigned NOT NULL default ‘0’,
template int(11) NOT NULL default ‘0’,
inputstarvals text,
thatstarvals text,
topicstarvals text,
patternmatched text,
inputmatched text,
combined text NOT NULL,
PRIMARY KEY (id),
KEY combined (bot,combined(255))
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table gossip
CREATE TABLE gossip (
bot tinyint(3) unsigned NOT NULL default ‘0’,
gossip text,
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id),
KEY botidx (bot)
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table patterns
CREATE TABLE patterns (
bot tinyint(3) unsigned NOT NULL default ‘0’,
id int(11) NOT NULL auto_increment,
word varchar(255) default NULL,
ordera tinyint(4) NOT NULL default ‘0’,
parent int(11) NOT NULL default ‘0’,
isend tinyint(4) NOT NULL default ‘0’,
PRIMARY KEY (id),
KEY wordparent (parent,word),
KEY botid (bot)
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table templates
CREATE TABLE templates (
bot tinyint(3) unsigned NOT NULL default ‘0’,
id int(11) NOT NULL default ‘0’,
template text NOT NULL,
pattern varchar(255) default NULL,
that varchar(255) default NULL,
topic varchar(255) default NULL,
PRIMARY KEY (id),
KEY bot (id)
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table thatindex
CREATE TABLE thatindex (
uid varchar(255) default NULL,
enteredtime timestamp(14) NOT NULL,
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
--------------------------------------------------------
Table structure for table thatstack
CREATE TABLE thatstack (
thatid int(11) NOT NULL default ‘0’,
id int(11) NOT NULL auto_increment,
value varchar(255) default NULL,
enteredtime timestamp(14) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;[/code]
Aber wenn das Type=MyISAM drin ist, kommt dort auch eine Fehlermeldung, wenn ich das aber entferne, dann erstellt er wenigstens die Tabelle “Bots”
Edit:
Wenn ich dei zeile enteredtime timestamp(14) NOT NULL,
entferne dann funktioiniert es. Ist die Zeile denn wichtig?