I reject repetitive tasks!
Here is the query I am using to insert new membership types into CiviCRM:
INSERT INTO `civicrm_membership_type` (name, domain_id, member_of_contact_id, contribution_type_id, duration_unit, duration_interval, period_type, visibility, weight )
VALUES ('Sponsor', 1, 2, 2, 'year', 1, 'rolling', 'Public', 2)
Obviously 'domain_id' and 'member_of_contact_id' need to be based on pre-existing conditions, so make sure you add one membership type to establish the pattern, then use this for the rest...
