--
-- Table structure for table `Site_Admin`
--

CREATE TABLE Site_Admin (
id int(11) NOT NULL auto_increment,
admin_name varchar(200) NOT NULL default '',
admin_email varchar(200) NOT NULL default '',
admin_user varchar(200) NOT NULL default '',
admin_pass varchar(200) NOT NULL default '',
Site_Name varchar(250) NOT NULL default '',
passkey varchar(100) NOT NULL default '0',
log_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Dumping data for table `Site_Admin`
--

INSERT INTO Site_Admin VALUES (1, 'Your Name', '[e-mail]', 'admin', 'pass', 'Classified Ads Version 6', '0', '2007-01-15 14:48:24');


--
-- Table structure for table `primecat`
--

CREATE TABLE primecat (
pc_id int(11) NOT NULL auto_increment,
pcat_name varchar(200) NOT NULL default '',
PRIMARY KEY (pc_id)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

--
-- Dumping data for table `primecat`
--

INSERT INTO primecat VALUES (1, 'Automobiles');
INSERT INTO primecat VALUES (8, 'Free Stuff');
INSERT INTO primecat VALUES (9, 'Cash Loans');
INSERT INTO primecat VALUES (10, 'Merchant Services');
INSERT INTO primecat VALUES (11, 'Animals');
INSERT INTO primecat VALUES (16, 'Musical Instruments');
INSERT INTO primecat VALUES (14, 'General Merchandise');
INSERT INTO primecat VALUES (15, 'Flea Markets');
INSERT INTO primecat VALUES (17, 'Collectables');

-- --------------------------------------------------------

--
-- Table structure for table `subcat`
--

CREATE TABLE subcat (
sc_id int(11) NOT NULL auto_increment,
PC_id int(11) NOT NULL default '0',
scat_name varchar(200) NOT NULL default '',
PRIMARY KEY (sc_id)
) TYPE=MyISAM AUTO_INCREMENT=47 ;

--
-- Dumping data for table `subcat`
--

INSERT INTO subcat VALUES (1, 1, 'Cars');
INSERT INTO subcat VALUES (2, 1, 'Trucks');
INSERT INTO subcat VALUES (3, 1, 'Minivans');
INSERT INTO subcat VALUES (4, 1, 'Classics');
INSERT INTO subcat VALUES (23, 8, 'Take It Away');
INSERT INTO subcat VALUES (26, 10, 'Credit Cards Processing');
INSERT INTO subcat VALUES (25, 8, 'Promos');
INSERT INTO subcat VALUES (27, 9, 'Payday Loans');
INSERT INTO subcat VALUES (28, 9, 'Pawn Shops');
INSERT INTO subcat VALUES (29, 11, 'Cats');
INSERT INTO subcat VALUES (30, 11, 'Live Stock');
INSERT INTO subcat VALUES (31, 11, 'Dogs');
INSERT INTO subcat VALUES (32, 11, 'Birds');
INSERT INTO subcat VALUES (33, 14, 'Furniture');
INSERT INTO subcat VALUES (34, 14, 'Clothes');
INSERT INTO subcat VALUES (35, 14, 'Appliances');
INSERT INTO subcat VALUES (36, 15, 'Venders');
INSERT INTO subcat VALUES (37, 15, 'Wholesalers');
INSERT INTO subcat VALUES (38, 15, 'When & Where');
INSERT INTO subcat VALUES (39, 16, 'Guitars & String');
INSERT INTO subcat VALUES (40, 16, 'Brass');
INSERT INTO subcat VALUES (41, 16, 'Pianos & Organs');
INSERT INTO subcat VALUES (42, 17, 'Dolls');
INSERT INTO subcat VALUES (43, 17, 'Action Figures');
INSERT INTO subcat VALUES (44, 17, 'Trading Cards');
INSERT INTO subcat VALUES (45, 17, 'Hummel Figurines');


--
-- Table structure for table `ads_contact`
--

CREATE TABLE ads_contact (
cmnt_id int(11) NOT NULL auto_increment,
cmnt_ticket varchar(200) NOT NULL default '',
cmnt_name varchar(200) NOT NULL default '',
cmnt_email varchar(200) NOT NULL default '',
cmnt_regarding varchar(200) NOT NULL default '',
cmnt_query text NOT NULL,
cmnt_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (cmnt_id)
) TYPE=MyISAM;


--
-- Table structure for table `site_ads`
--

CREATE TABLE site_ads (
ad_id int(11) NOT NULL auto_increment,
ad_ticket varchar(11) NOT NULL default '',
PC_ID int(11) NOT NULL default '0',
SC_ID int(11) NOT NULL default '0',
name varchar(200) NOT NULL default '',
email varchar(200) NOT NULL default '',
item varchar(200) NOT NULL default '',
price varchar(200) NOT NULL default '',
item_info varchar(200) NOT NULL default '',
imagefile varchar(200) NOT NULL default '',
active varchar(25) NOT NULL default '',
confirm varchar(25) NOT NULL default '',
alert varchar(25) NOT NULL default '',
ad_date date NOT NULL default '0000-00-00',
PRIMARY KEY (ad_id)
) TYPE=MyISAM;