iTunes podCast Categories SQL

I am busy writing a podCast plugin for WordPress and figured that it would be most efficient if I created a Category model which will hold all the podCast feed categories which can be specified in the feed specifically for the iTunes store.

The SQL code creates a database table named “categories” and inserts all the podCast categories available in the iTunes store, together with appropriate parent and child associations. You’ll notice a “parent_id” field which tells you what the ID of the parent of each individual category is. Of course, those with a 0 value in the “parent_id” field are main/top level categories.

You can either copy and paste the code below or download the attached zip file. It is recommended that you download the zip archive since the code below might give you encoding issues as a result of both WordPress and the copy/pasting procedure.

I hope that you find this useful!

Download : iTunes Podcast_Categories SQL

CREATE TABLE `categories` (
 `id` INT(11) NOT NULL AUTO_INCREMENT,
 `title` VARCHAR(100) NOT NULL DEFAULT '',
 `parent_id` INT(11) NOT NULL DEFAULT '0',
 `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
 `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
 PRIMARY KEY (`id`)
)	ENGINE=MyISAM AUTO_INCREMENT=1;  

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('1', 'Arts', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('2', 'Business', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('3', 'Comedy', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('4', 'Education', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('5', 'Games & Hobbies', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('6', 'Government & Organizations', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('7', 'Health', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('8', 'Kids & Family', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('9', 'Music', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('10', 'News & Politics', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('11', 'Religion & Spirituality', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('12', 'Science & Medicine', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('13', 'Society & Culture', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('14', 'Sports & Recreation', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('15', 'Technology', '0');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('16', 'TV & Film', '0');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('17', 'Design', '1');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('18', 'Fashio & Beauty', '1');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('19', 'Food', '1');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('20', 'Literature', '1');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('21', 'Performing Arts', '1');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('22', 'Visual Arts', '1');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('23', 'Business News', '2');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('24', 'Careers', '2');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('25', 'Investing', '2');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('26', 'Management & Marketing', '2');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('27', 'Shopping', '2');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('28', 'Education Technology', '4');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('29', 'Higher Education', '4');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('30', 'K-12', '4');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('31', 'Language Courses', '4');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('32', 'Training', '4');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('33', 'Automation', '5');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('34', 'Aviation', '5');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('35', 'Hobbies', '5');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('36', 'Other Games', '5');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('37', 'Video Games', '5');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('38', 'Local', '6');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('39', 'National', '6');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('40', 'Non-Profit', '6');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('41', 'Regional', '6');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('42', 'Alternative Health', '7');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('43', 'Fitness & Nutrition', '7');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('44', 'Self-Help', '7');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('45', 'Sexuality', '7');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('46', 'Buddhism', '11');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('47', 'Christianity', '11');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('48', 'Hinduism', '11');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('49', 'Islam', '11');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('50', 'Judaism', '11');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('51', 'Other', '11');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('52', 'Spirituality', '11');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('53', 'Medicine', '12');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('54', 'Natural Sciences', '12');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('55', 'Social Sciences', '12');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('56', 'History', '13');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('57', 'Personal Journals', '13');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('58', 'Philosophy', '13');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('59', 'Places & Travel', '13');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('60', 'Amateur', '14');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('61', 'College & High School', '14');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('62', 'Outdoor', '14');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('63', 'Professional', '14');

INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('64', 'Gadgets', '15');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('64', 'Tech News', '15');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('66', 'Podcasting', '15');
INSERT INTO `categories` (`id`, `title`, `parent_id`) VALUES ('67', 'Software How-To', '15');

No Responses

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>