Jstr

## Table structure for table `catagory`#CREATE TABLE catagory (  ID int(255) NOT NULL auto_increment,  catagoryID int(255) NOT NULL,  PRIMARY KEY  (ID)) TYPE=MyISAM;## Dumping data for table `catagory`#INSERT INTO catagory VALUES (1, 'A');INSERT INTO catagory VALUES (2, 'B');INSERT INTO catagory VALUES (3, 'C');INSERT INTO catagory VALUES (4, 'D');INSERT INTO catagory VALUES (5, 'E');INSERT INTO catagory VALUES (6, 'F');INSERT INTO catagory VALUES (7, 'G');INSERT INTO catagory VALUES (8, 'H');INSERT INTO catagory VALUES (9, 'I');INSERT INTO catagory VALUES (10, 'J');INSERT INTO catagory VALUES (11, 'K');INSERT INTO catagory VALUES (12, 'L');INSERT INTO catagory VALUES (13, 'M');INSERT INTO catagory VALUES (14, 'N');INSERT INTO catagory VALUES (15, 'O');INSERT INTO catagory VALUES (16, 'P');INSERT INTO catagory VALUES (17, 'Q');INSERT INTO catagory VALUES (18, 'R');INSERT INTO catagory VALUES (19, 'S');INSERT INTO catagory VALUES (20, 'T');INSERT INTO catagory VALUES (21, 'U');INSERT INTO catagory VALUES (22, 'V');INSERT INTO catagory VALUES (23, 'W');INSERT INTO catagory VALUES (24, 'X');INSERT INTO catagory VALUES (25, 'Y');INSERT INTO catagory VALUES (26, 'Z');# --------------------------------------------------------## Table structure for table `subcatagory`#CREATE TABLE subcatagory (  catagoryID int(255) NOT NULL auto_increment,  subcatagory_title varchar(200) NOT NULL,  subcatagoryID int(255) NOT NULL default '0',  PRIMARY KEY  (catagoryID)) TYPE=MyISAM;INSERT INTO subcatagory VALUES ('1','Antiques, Liquidators','1') );INSERT INTO subcatagory VALUES ('2','Appraiser, Home','1'),INSERT INTO subcatagory VALUES ('3','Auto Body','1'));INSERT INTO subcatagory VALUES ('4','Carpet Cleaners','3');INSERT INTO subcatagory VALUES ('5','Dentist','4');INSERT INTO subcatagory VALUES ('6','Dent Removal','4');INSERT INTO subcatagory VALUES ('7','Electrician,'5');INSERT INTO subcatagory VALUES ('8','Financial Consultant','6');INSERT INTO subcatagory VALUES ('9','Flooring','6');INSERT INTO subcatagory VALUES ('10','Home Inspectors'8');INSERT INTO subcatagory VALUES ('11','Insurance','9');INSERT INTO subcatagory VALUES ('12','Landscaping','12');INSERT INTO subcatagory VALUES ('13','Mold Inspection and Removal','13');INSERT INTO subcatagory VALUES ('14','Moving Companies','13');INSERT INTO subcatagory VALUES ('15','Odor Removal','15');INSERT INTO subcatagory VALUES ('16','Painter / Paper','16');INSERT INTO subcatagory VALUES ('17','Pest Inspections','16');# --------------------------------------------------------# Table structure for table `listings`CREATE TABLE listings (  subcatagoryID int(11) NOT NULL auto_increment,  companyname varchar(255),  contactname varchar(100),  address varchar(100),  city CHAR(50),  state varchar(100),  zip_code varchar(20),  email varchar(255),  web varchar(255) ),  PRIMARY KEY  (subcatagoryID)) TYPE=MyISAM;