# # Table structure for table 'bus_info' # CREATE TABLE bus_info ( info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment, bus_name varchar(100) DEFAULT '' NOT NULL , contact_fname varchar(20) DEFAULT '' NOT NULL , contact_lname varchar(20) DEFAULT '' NOT NULL , refer_by int(8)) zerofill DEFAULT '00000000' NOT NULL , searchwords varchar(100) DEFAULT '' NOT NULL , comments varchar(100) DEFAULT '' NOT NULL , hrs_open varchar(7) DEFAULT '85MF' NOT NULL , address varchar(40) DEFAULT '' NOT NULL , unique_url varchar(100) , phone varchar(20) DEFAULT '' NOT NULL , submit_date date DEFAULT '0000-00-00' NOT NULL , category varchar(6) DEFAULT '' NOT NULL , PRIMARY KEY (info_id), KEY buidx_cat (category), KEY buidx_ph (phone) ); # # Dumping data for table 'bus_info' # INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('1','Thunder Rain Internet Publishing','Mike','Blezien','00000001','Custom Programming,Web Hosting,Database and Ecommerce','Thunder Rain provides custom \r\nCGI programming. Specializing \r\nin Database and Ecommerce \r\nprogrammi','96SAT','34326 W.N. Sibley Rd','http://www.referralsources.com/CO/mickalo.html','12256862002','2001-03-15','COI'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('2','Just Your Type','Pam','Gram','00000002','Website Hosting,Domain Name Registration,Website Design','This company delivers \r\nservices in a timely manner \r\nand at reasonable prices.','85MF','9800 Topanga Canyon Blvd., Suite D329','http://www.referralsources.com/CO/jyt.html','18183419155','2001-03-15','COI'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('3','RKC Inc.','Kris','Christoffel','00000001','','RKC is an independant Mud \r\nEngineering Consulting company \r\n. Profession Mud engineers \r\nthat can h','Call','34326 W.N. Sibley Rd',NULL,'12256861946','2001-03-15','PRC'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('4','Dealersecrets, Inc.','Mitchell','Salloum','00000002','Car Buying Tips,Negotiating Car Prices,Secrets to the Best Car Deals','Dealersecrets offers a great \r\nbook that literally saved me \r\nover a $1,000 when I bought \r\nmy new c','96MF','4045 So. Buffalo Drive, Ste. A101-140','http://www.referralsources.com/VE/dealersecrets.html','18887195888','2001-03-15','VEACO'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('5','Chatsworth Tire','','','00000002','','','85SAT','7624 Winnetka Avenue',NULL,'18189997280','2001-03-19','VEAT'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('6','Enterprise Import Service','Jerry','','00000002','','They perform work on Toyotas \r\nonly. Great service and \r\nprices!','85MF','21444 Ingomar Street',NULL,'18189924788','2001-03-19','VEAREP'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('7','California Muffler','John','','00000002','','','85MF','7624 Winnetka Avenue',NULL,'18189997280','2001-03-19','VEAREP'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('8','Ace Blind Cleaning','Pete','Weaver','00000002','','','85SAT','8341 DeSoto Avenue',NULL,'18183413323','2001-03-19','HODOC'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('9','Emeril\'s Fish House','Emeril','Lagasse','00000002','','This is a great restaurant.','102','122234 Las Vegas Blvd.',NULL,'18005551212','2001-03-19','FORSE'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('10','Tudor Cottage','Diane','','00000002','','Great gifts and WONDERFUL \r\nservice!','105SAT','7424 Lionel',NULL,'18187907424','2001-03-19','SHGI'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('11','Racing Fantasies Gifts and Collectibles','Pete','','00000002','','Great Nascar and NHRA \r\ncollectibles.','86SAT','8341 DeSoto Avenue',NULL,'18187750337','2001-03-19','SHA'); INSERT INTO bus_info (info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category) VALUES('12','Delmonico\'s Steak House','Emeril','Lagasse','00000002','','Terrific food and atmosphere!','112','12234 Las Vegas Blvd.',NULL,'18005551212','2001-03-19','FORST'); # # Table structure for table 'bus_loc' # CREATE TABLE bus_loc ( loc_id int(11) unsigned DEFAULT '' NOT NULL auto_increment, # reference to bus_info info_id city varchar(40) DEFAULT '' NOT NULL , state varchar(10) DEFAULT '' NOT NULL , country char(2) DEFAULT 'US' NOT NULL , zipcode varchar(10) DEFAULT '' NOT NULL , PRIMARY KEY (loc_id), KEY blidx_zp (zipcode), KEY blidx_cs (state,city) ); # # Dumping data for table 'bus_loc' # INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('1','Walker','LA','US','70785'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('2','Chatsworth','CA','US','91311-4000'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('3','Walker','LA','US','70785'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('4','Las Vegas','NV','US','89147'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('5','Chatsworth','CA','US','91311'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('6','Canoga Park','CA','US','91304'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('7','Canoga Park','CA','US','91304'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('8','Canoga Park','CA','US','91304-2706'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('9','Las Vegas','NV','US','89147'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('10','Las Vegas','CA','US','91011'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('11','Canoga Park','CA','US','91304-2706'); INSERT INTO bus_loc (loc_id,city,state,country,zipcode) VALUES('12','Las Vegas','NV','US','89147'); # # Table structure for table 'bus_search' # CREATE TABLE bus_search ( bus_id int(11) DEFAULT '0' NOT NULL , # reference to bus_info info_id keywords varchar(255) , cat_prefix varchar(7) DEFAULT '' NOT NULL , PRIMARY KEY (bus_id), KEY keywords (keywords) # FULLTEXT index ); # # Dumping data for table 'bus_search' # INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('1','Custom Programming Web Hosting Database and Ecommerce','CO'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('2','Website Hosting Domain Name Registration Website Design','CO'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('4','Car Buying Tips Negotiating Car Prices Secrets to the Best Car Deals','VE'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('6','Toyota Repair Engine Rebuilds Transmissions','VE'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('5','Lifetime Brakes Brake Replacement','VE'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('7','Custom Mufflers Tube Bending Catalytic Converters','VE'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('8','Blind Cleaning Window Washing','HO'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('9','Sushi Bar Creole Cajun','FO'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('10','Department 56 Radco Beanie Babies','SH'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('11','NASCAR Collectibles NHRA Collectibles','SH'); INSERT INTO bus_search (bus_id,keywords,cat_prefix) VALUES('12','Fine Dining Creole','FO'); # ----------- Dump ends ----------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php