Do this. Save the create tables commands in a textfile on your harddrive called 'C:\tables.sql' Load mysql from the command line.
@ the prompt, type the following mysql>create database `myDBName`; mysql>use `myDBName`; mysql>source C:\tables.sql; that's it! On Apr 2, 2005 10:26 AM, Niki Lampropoulou <[EMAIL PROTECTED]> wrote: > better description>> > > instructions to be followed for installation of ALICE > PHP chatbot. It is the first time I am using MySQL> > 2. Create a database for the program to use in MySQL. > 3. Create the tables in the new database using db.sql > which is in the sql directory. > > tables > > # > # Table structure for table `bot` > # > > CREATE TABLE bot ( > id int(11) NOT NULL auto_increment, > bot tinyint(4) NOT NULL default '0', > name varchar(255) NOT NULL default '', > value text NOT NULL, > PRIMARY KEY (id), > KEY botname (bot,name) > ) TYPE=MyISAM; > # > -------------------------------------------------------- > > # > # Table structure for table `bots` > # > > 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; > > Send instant messages to your online friends http://uk.messenger.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
