#
#		site categories table
#
CREATE TABLE categories (

	id int not null auto_increment primary key,
	parent_id int not null default 0,
	category_name  varchar(250) not null
	
);

#
#	indexes
#
CREATE UNIQUE INDEX ix_categories_category_name ON categories(parent_id,category_name);


#
#	data
#
INSERT INTO `categories` VALUES (1, 0, 'Arts and Culture');
INSERT INTO `categories` VALUES (2, 0, 'Business');
INSERT INTO `categories` VALUES (3, 0, 'Computers');
INSERT INTO `categories` VALUES (4, 2, 'Finance');
INSERT INTO `categories` VALUES (5, 0, 'Home');
INSERT INTO `categories` VALUES (6, 1, 'Antiques');
INSERT INTO `categories` VALUES (7, 1, 'Architecture');
INSERT INTO `categories` VALUES (8, 1, 'Music');
INSERT INTO `categories` VALUES (9, 1, 'Animation');
INSERT INTO `categories` VALUES (10, 1, 'Movies and Video');
INSERT INTO `categories` VALUES (11, 1, 'Photography');
INSERT INTO `categories` VALUES (12, 1, 'Artists');
INSERT INTO `categories` VALUES (13, 2, 'Real Estate');
INSERT INTO `categories` VALUES (14, 2, 'Automotive');
INSERT INTO `categories` VALUES (15, 2, 'Services');
INSERT INTO `categories` VALUES (16, 2, 'Information Technology');
INSERT INTO `categories` VALUES (17, 2, 'Classifieds');
INSERT INTO `categories` VALUES (18, 2, 'Accounting');
INSERT INTO `categories` VALUES (19, 2, 'Aerospace');
INSERT INTO `categories` VALUES (20, 2, 'Agriculture');
INSERT INTO `categories` VALUES (21, 3, 'Software');
INSERT INTO `categories` VALUES (22, 3, 'Web design');
INSERT INTO `categories` VALUES (23, 3, 'Hardware');
INSERT INTO `categories` VALUES (24, 3, 'Security');
INSERT INTO `categories` VALUES (25, 3, 'Multimedia');
INSERT INTO `categories` VALUES (26, 3, 'Programming');
INSERT INTO `categories` VALUES (27, 3, 'Reference');
INSERT INTO `categories` VALUES (28, 3, 'Algorithms');
INSERT INTO `categories` VALUES (29, 3, 'Artificial Intelligence');
INSERT INTO `categories` VALUES (30, 5, 'Apartment Living');
INSERT INTO `categories` VALUES (31, 5, 'Consumer Information');
INSERT INTO `categories` VALUES (32, 5, 'Cooking');
INSERT INTO `categories` VALUES (33, 5, 'Home Improvement');
INSERT INTO `categories` VALUES (34, 5, 'Moving and Relocating');
INSERT INTO `categories` VALUES (35, 5, 'Family');
INSERT INTO `categories` VALUES (36, 5, 'Personal finance');
INSERT INTO `categories` VALUES (37, 5, 'Other');
INSERT INTO `categories` VALUES (38, 0, 'Internet');
INSERT INTO `categories` VALUES (39, 38, 'Directories');
INSERT INTO `categories` VALUES (40, 38, 'Hosting');
INSERT INTO `categories` VALUES (42, 0, 'News');
INSERT INTO `categories` VALUES (43, 0, 'Science');
INSERT INTO `categories` VALUES (44, 0, 'Sports');
INSERT INTO `categories` VALUES (45, 0, 'Games');
INSERT INTO `categories` VALUES (46, 44, 'Football');
INSERT INTO `categories` VALUES (47, 44, 'Soccer');
INSERT INTO `categories` VALUES (48, 44, 'Hockey');
INSERT INTO `categories` VALUES (49, 44, 'Billiard');
INSERT INTO `categories` VALUES (50, 44, 'Fishing');
INSERT INTO `categories` VALUES (51, 44, 'Baseball');
INSERT INTO `categories` VALUES (52, 45, 'Board Games');
INSERT INTO `categories` VALUES (53, 45, 'Card Games');
INSERT INTO `categories` VALUES (54, 42, 'Weather');
INSERT INTO `categories` VALUES (55, 42, 'Magazines');
INSERT INTO `categories` VALUES (56, 42, 'Archives');
INSERT INTO `categories` VALUES (57, 42, 'Newspapers');
INSERT INTO `categories` VALUES (58, 42, 'Journalism');
INSERT INTO `categories` VALUES (59, 42, 'People and Society');
INSERT INTO `categories` VALUES (60, 0, 'Education');
INSERT INTO `categories` VALUES (61, 0, 'Recreation');
INSERT INTO `categories` VALUES (62, 0, 'Travel');
INSERT INTO `categories` VALUES (63, 0, 'Shops');
INSERT INTO `categories` VALUES (64, 60, 'Mathematics');
INSERT INTO `categories` VALUES (65, 60, 'Biology');
INSERT INTO `categories` VALUES (66, 60, 'Technology');
INSERT INTO `categories` VALUES (67, 60, 'Earth Sciences');
INSERT INTO `categories` VALUES (68, 61, 'Humor');
INSERT INTO `categories` VALUES (69, 61, 'Food');
INSERT INTO `categories` VALUES (70, 61, 'Horoscopes');
INSERT INTO `categories` VALUES (71, 61, 'Gardening');
INSERT INTO `categories` VALUES (72, 61, 'Boating');
INSERT INTO `categories` VALUES (73, 61, 'Aviation');
INSERT INTO `categories` VALUES (74, 61, 'Motorcycles');
INSERT INTO `categories` VALUES (75, 61, 'Pets');
INSERT INTO `categories` VALUES (76, 61, 'Scouting');
INSERT INTO `categories` VALUES (77, 63, 'Flowers');
INSERT INTO `categories` VALUES (78, 63, 'Jewelry');
INSERT INTO `categories` VALUES (79, 63, 'Books');
INSERT INTO `categories` VALUES (80, 0, 'Society');
INSERT INTO `categories` VALUES (81, 0, 'Health');
INSERT INTO `categories` VALUES (82, 21, 'PHP scripts');
INSERT INTO `categories` VALUES (83, 81, 'Nursing');
INSERT INTO `categories` VALUES (84, 81, 'Medicine');
INSERT INTO `categories` VALUES (85, 81, 'Beauty');
INSERT INTO `categories` VALUES (86, 43, 'Astronomy');
INSERT INTO `categories` VALUES (87, 43, 'Chemistry');
INSERT INTO `categories` VALUES (88, 43, 'Computer Science');
INSERT INTO `categories` VALUES (89, 43, 'Earth Sciences');
INSERT INTO `categories` VALUES (90, 43, 'Math');
INSERT INTO `categories` VALUES (91, 43, 'Physics');
INSERT INTO `categories` VALUES (92, 43, 'Social Sciences');
INSERT INTO `categories` VALUES (93, 62, 'Travel Agents');
INSERT INTO `categories` VALUES (94, 62, 'Travelogues');
INSERT INTO `categories` VALUES (95, 62, 'Tour Operators');
INSERT INTO `categories` VALUES (96, 80, 'Advice');
INSERT INTO `categories` VALUES (97, 80, 'Politics');
INSERT INTO `categories` VALUES (98, 80, 'Subcultures');
INSERT INTO `categories` VALUES (99, 80, 'People');
INSERT INTO `categories` VALUES (100, 80, 'Military');
INSERT INTO `categories` VALUES (101, 80, 'Sociology');
INSERT INTO `categories` VALUES (102, 80, 'History');
INSERT INTO `categories` VALUES (103, 80, 'Economics');
INSERT INTO `categories` VALUES (104, 80, 'Law');
INSERT INTO `categories` VALUES (105, 45, 'Party Games');
INSERT INTO `categories` VALUES (106, 45, 'Roleplaying');
INSERT INTO `categories` VALUES (107, 45, 'Puzzles');
INSERT INTO `categories` VALUES (108, 45, 'Dice');
INSERT INTO `categories` VALUES (109, 38, 'Security');
INSERT INTO `categories` VALUES (110, 38, 'E-mail');
INSERT INTO `categories` VALUES (111, 63, 'Auctions');