[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> on Monday, October 27, 2003 10:52 AM said:
> can you send the contents of your dumpfile up to this point. > assuming its line 118 of hte dumpfile and 21 of this build table query Line 118 is the beginning of the 'customers' table definition and line 21 is the last line of that definition. Thanks for you help so far. Chris. DUMP: -- MySQL dump 8.22 -- -- Host: localhost Database: aardcart --------------------------------------------------------- -- Server version 3.23.56 -- -- Table structure for table 'cart' -- DROP TABLE IF EXISTS cart; CREATE TABLE cart ( id int(10) unsigned NOT NULL auto_increment, phpsessid varchar(32) NOT NULL default '', cust_id int(10) unsigned NOT NULL default '0', created datetime NOT NULL default '0000-00-00 00:00:00', lastaccessed datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id) ) TYPE=MyISAM; /*!40000 ALTER TABLE cart DISABLE KEYS */; -- -- Dumping data for table 'cart' -- LOCK TABLES cart WRITE; INSERT INTO cart VALUES (1,'89ba2322b4b0723bf052ffc2758266a9',6,'2003-10-07 14:50:17','2003-10-10 16:27:49'),(2,'89ba2322b4b0723bf052ffc2758266a9',12,'2003-10-07 16:04:01','2003-10-07 16:05:09'),(10,'cdf88dc1c29adde03b6e3e79942f2a07',0,'2003-10-22 09:48:01','2003-10-22 09:48:01'); /*!40000 ALTER TABLE cart ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table 'cart_contents' -- DROP TABLE IF EXISTS cart_contents; CREATE TABLE cart_contents ( id int(10) unsigned NOT NULL auto_increment, cart_id int(10) unsigned NOT NULL default '0', prod_id varchar(25) NOT NULL default '', price float(4,2) unsigned NOT NULL default '0.00', qty smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; /*!40000 ALTER TABLE cart_contents DISABLE KEYS */; -- -- Dumping data for table 'cart_contents' -- LOCK TABLES cart_contents WRITE; INSERT INTO cart_contents VALUES (1,1,'testing013',99.00,4),(10,1,'MONUTB',145.00,1),(9,1,'MONUTB',145.00 ,1),(6,1,'MONUTB',145.00,2),(8,1,'ATITCB',194.00,1),(11,10,'testing019', 104.00,1),(12,10,'testing011',99.00,1); /*!40000 ALTER TABLE cart_contents ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table 'cart_contents_attributes' -- DROP TABLE IF EXISTS cart_contents_attributes; CREATE TABLE cart_contents_attributes ( cart_cont_id int(10) unsigned NOT NULL default '0', attr_id smallint(5) unsigned NOT NULL default '0', option_id smallint(5) unsigned NOT NULL default '0', cart_id int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; /*!40000 ALTER TABLE cart_contents_attributes DISABLE KEYS */; -- -- Dumping data for table 'cart_contents_attributes' -- LOCK TABLES cart_contents_attributes WRITE; INSERT INTO cart_contents_attributes VALUES (9,40,118,1),(8,24,4,1),(8,7,17,1),(8,6,14,1),(6,40,118,1),(8,2,8,1),(10 ,40,118,1),(12,39,113,10); /*!40000 ALTER TABLE cart_contents_attributes ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table 'categories' -- DROP TABLE IF EXISTS categories; CREATE TABLE categories ( id int(10) unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', lft smallint(5) unsigned NOT NULL default '0', rgt smallint(5) unsigned NOT NULL default '0', description tinytext NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; /*!40000 ALTER TABLE categories DISABLE KEYS */; -- -- Dumping data for table 'categories' -- LOCK TABLES categories WRITE; INSERT INTO categories VALUES (31,'Riot Gear',98,99,''),(30,'Entry Tools',96,97,''),(29,'Hydration',94,95,''),(28,'Load Bearing',78,93,''),(27,'Gloves',74,77,''),(26,'Apparel',70,73,''),(21,'A rmor',52,53,''),(20,'WMD',24,51,''),(19,'Less-Lethal',6,23,''),(25,'Flas hlights',68,69,''),(24,'Batons',62,67,''),(23,'Duty Gear',56,61,''),(22,'Holsters',54,55,''),(32,'Gear Bags/Cases',100,101,''),(38,'Root',1,102,''),(39,'Nuclear',49,50,''),(40 ,'Biological',45,48,''),(41,'Chemical',27,44,''),(73,'Force Protection',4,5,''),(74,'Batons',2,3,''); /*!40000 ALTER TABLE categories ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table 'customers' -- DROP TABLE IF EXISTS customers; CREATE TABLE customers ( id int(10) unsigned NOT NULL auto_increment, fname varchar(20) NOT NULL default '', lname varchar(20) NOT NULL default '', address1 varchar(40) NOT NULL default '', address2 varchar(40) default '', city varchar(20) NOT NULL default '', state char(2) NOT NULL default '', zip varchar(10) NOT NULL default '', phone varchar(20) default '', fax varchar(20) default '', email varchar(32) NOT NULL default '', newsletter tinyint(1) NOT NULL default '0', password varchar(32) NOT NULL default '', signupdate datetime NOT NULL default '0000-00-00 00:00:00', lastvisit datetime NOT NULL default '0000-00-00 00:00:00', type tinyint(3) unsigned NOT NULL default '0', security smallint(6) NOT NULL default '0', company varchar(64) default '', PRIMARY KEY (id), UNIQUE KEY unique (email) ) TYPE=MyISAM; -- Don't like reformatting your Outlook replies? Now there's relief! http://home.in.tum.de/~jain/software/outlook-quotefix/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
