#
# 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
