CREATE TABLE clientsignup (
id int(11) NOT NULL auto_increment,
clientid int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
pass1 varchar(100) NOT NULL default '',
agree varchar(100) NOT NULL default '',
confirm varchar(10) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
u_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id)
);


CREATE TABLE contact (
id int(11) NOT NULL auto_increment,
clientid int(11) NOT NULL default '0',
ticket int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
regarding varchar(100) NOT NULL default '',
inquiry text NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id)
);


CREATE TABLE o_ads (
l_id int(11) NOT NULL auto_increment,
l_clientid int(11) NOT NULL default '0',
adid int(11) NOT NULL default '0',
l_cid int(11) NOT NULL default '0',
S_id int(11) NOT NULL default '0',
l_item varchar(255) NOT NULL default '',
l_price varchar(255) NOT NULL default '',
l_info varchar(255) NOT NULL default '',
l_image varchar(200) NOT NULL default '',
l_approved char(1) NOT NULL default '',
l_date date NOT NULL default '0000-00-00',
PRIMARY KEY (l_id)
);


CREATE TABLE o_categories (
c_id int(11) NOT NULL auto_increment,
c_name varchar(100) NOT NULL default '',
c_image varchar(100) default NULL,
c_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (c_id)
) TYPE=MyISAM AUTO_INCREMENT=17 ;


INSERT INTO o_categories VALUES (1, 'Dating', 'love.gif', '2005-01-07 08:09:34');
INSERT INTO o_categories VALUES (2, 'Animals', 'pets.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (3, 'Autos - Trucks', 'cars.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (4, 'Business Opportunities', 'biz-op.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (5, 'Computers', 'computer.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (6, 'Credit Cards', 'creditcard.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (7, 'Collectables', 'collectable.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (8, 'Dining', 'dining.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (9, 'Electronics', 'tv.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (10, 'Free Stuff', 'free.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (11, 'Gambling', 'ard4.gif', '2004-12-08 22:48:10');
INSERT INTO o_categories VALUES (13, 'Musical Instruments', 'guitar.gif', '2005-01-06 14:11:03');
INSERT INTO o_categories VALUES (14, 'Legal Services', 'legal.gif', '2005-01-06 14:12:25');
INSERT INTO o_categories VALUES (15, 'Help Wanted', 'helpwanted.gif', '2005-01-06 14:14:30');
INSERT INTO o_categories VALUES (16, 'Apartments For Rent', 'newspaper.gif', '2005-06-08 09:50:08');



CREATE TABLE o_catimages (
i_id int(11) NOT NULL auto_increment,
i_name varchar(100) NOT NULL default '',
i_image varchar(100) NOT NULL default '',
PRIMARY KEY (i_id)
) TYPE=MyISAM AUTO_INCREMENT=81 ;


INSERT INTO o_catimages VALUES (1, 'announce.gif', 'announce.gif');
INSERT INTO o_catimages VALUES (2, 'bank.gif', 'bank.gif');
INSERT INTO o_catimages VALUES (3, 'bible.gif', 'bible.gif');
INSERT INTO o_catimages VALUES (4, 'bird.gif', 'bird.gif');
INSERT INTO o_catimages VALUES (5, 'biz-op.gif', 'biz-op.gif');
INSERT INTO o_catimages VALUES (6, 'book.gif', 'book.gif');
INSERT INTO o_catimages VALUES (7, 'brass.gif', 'brass.gif');
INSERT INTO o_catimages VALUES (8, 'bulb.gif', 'bulb.gif');
INSERT INTO o_catimages VALUES (9, 'burger.gif', 'burger.gif');
INSERT INTO o_catimages VALUES (10, 'camper.gif', 'camper.gif');
INSERT INTO o_catimages VALUES (11, 'cards.gif', 'cards.gif');
INSERT INTO o_catimages VALUES (12, 'carry.gif', 'carry.gif');
INSERT INTO o_catimages VALUES (13, 'cars.gif', 'cars.gif');
INSERT INTO o_catimages VALUES (14, 'cat.gif', 'cat.gif');
INSERT INTO o_catimages VALUES (15, 'cat2.gif', 'cat2.gif');
INSERT INTO o_catimages VALUES (16, 'chair.gif', 'chair.gif');
INSERT INTO o_catimages VALUES (17, 'chinese.gif', 'chinese.gif');
INSERT INTO o_catimages VALUES (19, 'cleaner.gif', 'cleaner.gif');
INSERT INTO o_catimages VALUES (20, 'coat.gif', 'coat.gif');
INSERT INTO o_catimages VALUES (21, 'computer.gif', 'computer.gif');
INSERT INTO o_catimages VALUES (22, 'construction.gif', 'construction.gif');
INSERT INTO o_catimages VALUES (23, 'contracter.gif', 'contracter.gif');
INSERT INTO o_catimages VALUES (24, 'creditcard.gif', 'creditcard.gif');
INSERT INTO o_catimages VALUES (25, 'delivery.gif', 'delivery.gif');
INSERT INTO o_catimages VALUES (26, 'digger.gif', 'digger.gif');
INSERT INTO o_catimages VALUES (27, 'dining.gif', 'dining.gif');
INSERT INTO o_catimages VALUES (28, 'document.gif', 'document.gif');
INSERT INTO o_catimages VALUES (29, 'dresser.gif', 'dresser.gif');
INSERT INTO o_catimages VALUES (30, 'eggs.gif', 'eggs.gif');
INSERT INTO o_catimages VALUES (31, 'electrician.gif', 'electrician.gif');
INSERT INTO o_catimages VALUES (32, 'elvis.gif', 'elvis.gif');
INSERT INTO o_catimages VALUES (33, 'fdining1.gif', 'fdining1.gif');
INSERT INTO o_catimages VALUES (34, 'fdining2.gif', 'fdining2.gif');
INSERT INTO o_catimages VALUES (35, 'fish.gif', 'fish.gif');
INSERT INTO o_catimages VALUES (36, 'free.gif', 'free.gif');
INSERT INTO o_catimages VALUES (37, 'gamble.gif', 'gamble.gif');
INSERT INTO o_catimages VALUES (38, 'grinder.gif', 'grinder.gif');
INSERT INTO o_catimages VALUES (39, 'guitar.gif', 'guitar.gif');
INSERT INTO o_catimages VALUES (40, 'hammer.gif', 'hammer.gif');
INSERT INTO o_catimages VALUES (41, 'helpwanted.gif', 'helpwanted.gif');
INSERT INTO o_catimages VALUES (42, 'laptop.gif', 'laptop.gif');
INSERT INTO o_catimages VALUES (43, 'lawyer.gif', 'lawyer.gif');
INSERT INTO o_catimages VALUES (44, 'legal.gif', 'legal.gif');
INSERT INTO o_catimages VALUES (45, 'lobster.gif', 'lobster.gif');
INSERT INTO o_catimages VALUES (46, 'lock.gif', 'lock.gif');
INSERT INTO o_catimages VALUES (47, 'love.gif', 'love.gif');
INSERT INTO o_catimages VALUES (48, 'love2.gif', 'love2.gif');
INSERT INTO o_catimages VALUES (49, 'money.gif', 'money.gif');
INSERT INTO o_catimages VALUES (50, 'motorcycle.gif', 'motorcycle.gif');
INSERT INTO o_catimages VALUES (51, 'muffler.gif', 'muffler.gif');
INSERT INTO o_catimages VALUES (52, 'newspaper.gif', 'newspaper.gif');
INSERT INTO o_catimages VALUES (53, 'newspaperc.gif', 'newspaperc.gif');
INSERT INTO o_catimages VALUES (54, 'overdue.gif', 'overdue.gif');
INSERT INTO o_catimages VALUES (55, 'painter.gif', 'painter.gif');
INSERT INTO o_catimages VALUES (56, 'party.gif', 'party.gif');
INSERT INTO o_catimages VALUES (57, 'pets.gif', 'pets.gif');
INSERT INTO o_catimages VALUES (58, 'piano.gif', 'piano.gif');
INSERT INTO o_catimages VALUES (59, 'pickup.gif', 'pickup.gif');
INSERT INTO o_catimages VALUES (60, 'pizza.gif', 'pizza.gif');
INSERT INTO o_catimages VALUES (61, 'plane.gif', 'plane.gif');
INSERT INTO o_catimages VALUES (62, 'plumber.gif', 'plumber.gif');
INSERT INTO o_catimages VALUES (63, 'plumber2.gif', 'plumber2.gif');
INSERT INTO o_catimages VALUES (64, 'radio.gif', 'radio.gif');
INSERT INTO o_catimages VALUES (65, 'repair.gif', 'repair.gif');
INSERT INTO o_catimages VALUES (66, 'ring.gif', 'ring.gif');
INSERT INTO o_catimages VALUES (67, 'ring2.gif', 'ring2.gif');
INSERT INTO o_catimages VALUES (68, 'scooter.gif', 'scooter.gif');
INSERT INTO o_catimages VALUES (69, 'shorts.gif', 'shorts.gif');
INSERT INTO o_catimages VALUES (70, 'slot.gif', 'slot.gif');
INSERT INTO o_catimages VALUES (71, 'snake.gif', 'snake.gif');
INSERT INTO o_catimages VALUES (72, 'sofa.gif', 'sofa.gif');
INSERT INTO o_catimages VALUES (73, 'tech.gif', 'tech.gif');
INSERT INTO o_catimages VALUES (74, 'truck.gif', 'truck.gif');
INSERT INTO o_catimages VALUES (75, 'tv.gif', 'tv.gif');
INSERT INTO o_catimages VALUES (76, 'wallet.gif', 'wallet.gif');
INSERT INTO o_catimages VALUES (77, 'watch.gif', 'watch.gif');
INSERT INTO o_catimages VALUES (78, 'apartment1.gif', 'apartment1.gif');
INSERT INTO o_catimages VALUES (79, 'apartment2.gif', 'apartment2.gif');
INSERT INTO o_catimages VALUES (80, 'apartment3.gif', 'apartment3.gif');



CREATE TABLE o_subcategories (
S_id int(11) NOT NULL auto_increment,
cat_id varchar(100) NOT NULL default '',
S_name varchar(100) NOT NULL default '',
S_image varchar(150) NOT NULL default '',
PRIMARY KEY (S_id)
) TYPE=MyISAM AUTO_INCREMENT=63 ;


INSERT INTO o_subcategories VALUES (1, '5', 'Desktop', 'computer.gif');
INSERT INTO o_subcategories VALUES (2, '5', 'Laptop', 'laptop.gif');
INSERT INTO o_subcategories VALUES (3, '2', 'Cats', 'cat.gif');
INSERT INTO o_subcategories VALUES (4, '2', 'Dogs', 'pets.gif');
INSERT INTO o_subcategories VALUES (6, '5', 'Parts', 'bulb.gif');
INSERT INTO o_subcategories VALUES (7, '3', 'New', 'cars.gif');
INSERT INTO o_subcategories VALUES (8, '3', 'Used', 'cars.gif');
INSERT INTO o_subcategories VALUES (10, '7', 'Cards', 'bulb.gif');
INSERT INTO o_subcategories VALUES (11, '7', 'Action Figures', 'elvis.gif');
INSERT INTO o_subcategories VALUES (12, '7', 'Elvis', 'bulb.gif');
INSERT INTO o_subcategories VALUES (13, '6', 'Merchant Services', 'creditcard.gif');
INSERT INTO o_subcategories VALUES (41, '4', 'Books', 'book.gif');
INSERT INTO o_subcategories VALUES (15, '4', 'Work At Home', 'bulb.gif');
INSERT INTO o_subcategories VALUES (16, '4', 'Business For Sale', 'bulb.gif');
INSERT INTO o_subcategories VALUES (17, '17', 'Email Pals', 'bulb.gif');
INSERT INTO o_subcategories VALUES (18, '17', 'Marriage', 'bulb.gif');
INSERT INTO o_subcategories VALUES (19, '10', 'Promos', 'free.gif');
INSERT INTO o_subcategories VALUES (20, '10', 'Take It Away', 'carry.gif');
INSERT INTO o_subcategories VALUES (21, '8', 'Restaurant', 'bulb.gif');
INSERT INTO o_subcategories VALUES (23, '11', 'Casinos', 'slot.gif');
INSERT INTO o_subcategories VALUES (58, '14', 'Do-It-Yoursel Documents', 'document.gif');
INSERT INTO o_subcategories VALUES (26, '9', 'TVs', 'tv.gif');
INSERT INTO o_subcategories VALUES (27, '9', 'Repair', 'electrician.gif');
INSERT INTO o_subcategories VALUES (28, '15', 'General', '');
INSERT INTO o_subcategories VALUES (29, '15', 'Professional Help', 'bulb.gif');
INSERT INTO o_subcategories VALUES (30, '14', 'Lawyers', 'lawyer.gif');
INSERT INTO o_subcategories VALUES (32, '13', 'Brass', 'brass.gif');
INSERT INTO o_subcategories VALUES (33, '13', 'Guitars & String', 'guitar.gif');
INSERT INTO o_subcategories VALUES (34, '13', 'Pianos', 'piano.gif');
INSERT INTO o_subcategories VALUES (35, '16', 'Apartemts', '');
INSERT INTO o_subcategories VALUES (36, '16', 'Land', '');
INSERT INTO o_subcategories VALUES (37, '16', 'Houses', '');
INSERT INTO o_subcategories VALUES (43, '3', 'Trucks', 'pickup.gif');
INSERT INTO o_subcategories VALUES (56, '9', 'Radio', 'radio.gif');
INSERT INTO o_subcategories VALUES (42, '4', 'Turn Key Business', 'money.gif');
INSERT INTO o_subcategories VALUES (44, '3', 'Utility Trucks', 'truck.gif');
INSERT INTO o_subcategories VALUES (45, '3', 'Motorcycle', 'motorcycle.gif');
INSERT INTO o_subcategories VALUES (46, '2', 'Birds', 'bird.gif');
INSERT INTO o_subcategories VALUES (47, '2', 'Reptiles', 'snake.gif');
INSERT INTO o_subcategories VALUES (48, '5', 'Tech Help', 'tech.gif');
INSERT INTO o_subcategories VALUES (49, '2', 'Fish', 'fish.gif');
INSERT INTO o_subcategories VALUES (50, '8', 'Seafood', 'lobster.gif');
INSERT INTO o_subcategories VALUES (51, '8', 'Subs', 'grinder.gif');
INSERT INTO o_subcategories VALUES (52, '8', 'Delivery', 'delivery.gif');
INSERT INTO o_subcategories VALUES (53, '8', 'Chinese', 'chinese.gif');
INSERT INTO o_subcategories VALUES (54, '8', 'Burger Joints', 'burger.gif');
INSERT INTO o_subcategories VALUES (55, '8', 'Pizza - Italian', 'pizza.gif');
INSERT INTO o_subcategories VALUES (57, '11', 'Poker Parties', 'cards.gif');
INSERT INTO o_subcategories VALUES (59, '14', 'Over Due Bills', 'overdue.gif');
INSERT INTO o_subcategories VALUES (60, '20', 'Studios', 'money.gif');
INSERT INTO o_subcategories VALUES (61, '20', 'One Bedroom', 'money.gif');
INSERT INTO o_subcategories VALUES (62, '20', 'Two Bedroom', 'money.gif');


CREATE TABLE Site_Admin (
id int(11) NOT NULL auto_increment,
admin varchar(100) NOT NULL default '',
passme varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO Site_Admin VALUES (1, 'admin', 'pass');