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