Skip to content

Instantly share code, notes, and snippets.

@pamelafox

pamelafox/ka_avatars.sql

Created May 8, 2015 18:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pamelafox/0845de92effb238fccb5 to your computer and use it in GitHub Desktop.
Save pamelafox/0845de92effb238fccb5 to your computer and use it in GitHub Desktop.
Download ZIP
ka_avatars.sql
Raw
ka_avatars.sql
/*
Khan Academy Avatars:
This table contains all of Khan Academy's avatars, including their type and name, the requirements to unlock them, and their relative image URL.
Collected by:
https://www.khanacademy.org/profile/chopsor/
*/
CREATE TABLE avatars (
id INTEGER,
type TEXT,
name TEXT,
requirements TEXT,
image_url TEXT
);
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (1, "Leaf", "Leaf-Green", "N/A", "avatars/leaf-green");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (2, "Leaf", "Leaf-Blue", "N/A", "avatars/leaf-blue");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (3, "Leaf", "Leaf-Grey", "N/A", "avatars/leaf-grey");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (4, "Leaf", "Leaf-Red", "N/A", "avatars/leaf-red");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (5, "Leaf", "Leaf-Orange", "N/A", "avatars/leaf-orange");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (6, "Leaf", "Leaf-Yellow", "N/A", "avatars/leaf-yellow");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (7, "Leafers", "Leafers-Seed", "N/A", "avatars/leafers-seed");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (8, "Leafers", "Leafers-Seedling", "Earn 10,000 energy points", "avatars/leafers-seedling");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (9, "Leafers", "Leafers-Sapling", "Earn 50,000 energy points", "avatars/leafers-sapling");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (10, "Leafers", "Leafers-Tree", "Earn 100,000 energy points", "avatars/leafers-tree");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (11, "Leafers", "Leafers-Ultimate", "Earn 250,000 energy points", "avatars/leafers-ultimate");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (12, "πceratops", "πceratops-Seed", "N/A", "avatars/piceratops-seed");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (13, "πceratops", "πceratops-Seedling", "Earn 10,000 energy points", "avatars/piceratops-seedling");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (14, "πceratops", "πceratops-Sapling", "Earn 50,000 energy points", "avatars/piceratops-sapling");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (15, "πceratops", "πceratops-Tree", "Earn 100,000 energy points", "avatars/piceratops-tree");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (16, "πceratops", "πceratops-Ultimate", "Earn 250,000 energy points", "avatars/piceratops-ultimate");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (17, "Aqualine", "Aqualine-Seed", "Complete your first math task", "N/A");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (18, "Aqualine", "Aqualine-Seedling", "Master 1 skill in math", "N/A");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (19, "Aqualine", "Aqualine-Sapling", "Master 3 skills in math", "N/A");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (20, "Aqualine", "Aqualine-Tree", "Master 10 skills in math", "N/A");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (21, "Aqualine", "Aqualine-Ultimate", "Master 20 skills in math", "N/A");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (22, "Spunky Sam", "Spunky Sam", "Earn 10,000 energy points", "avatars/spunky-sam");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (23, "Marcimus", "Marcimus", "Earn 10,000 energy points", "avatars/marcimus");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (24, "Mr. Pink", "Mr. Pink", "Earn 10,000 energy points", "avatars/mr-pink");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (25, "Amelia", "Amelia-First", "Earn 50,000 energy points", "avatars/robot_female_1");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (26, "Amelia", "Amelia-Second", "Earn 100,000 energy points", "avatars/robot_female_2");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (27, "Amelia", "Amelia-Third", "Earn 250,000 energy points", "avatars/robot_female_3");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (28, "Johnny", "Johnny-First", "Earn 50,000 energy points", "avatars/robot_male_1");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (29, "Johnny", "Johnny-Second", "Earn 100,000 energy points", "avatars/robot_male_2");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (30, "Johnny", "Johnny-Third", "Earn 250,000 energy points", "avatars/robot_male_3");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (31, "Orange Juice Squid", "Orange Juice Squid", "Earn 50,000 energy points", "avatars/orange-juice-squid");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (32, "Purple Pi", "Purple Pi", "Earn 50,000 energy points", "avatars/purple-pi");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (33, "Mr. Pants", "Mr. Pants", "Earn 10,000 energy points", "avatars/mr-pants");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (34, "Old Spice Man", "Old Spice Man", "Earn 10,000 energy points", "avatars/old-spice-man");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (35, "Winston", "Winston-Normal", "Make changes to an official program", "creatures/Winston");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (36, "Winston", "Winston-Baby", "Make changes to another user's program", "creatures/BabyWinston");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (37, "Oh Noes", "Oh Noes the Error Buddy", "Watch a computer programming talk-through", "creatures/OhNoes");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (38, "Hopper", "Hopper-1", "Create a program from scratch", "creatures/Hopper-Happy");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (39, "Hopper", "Hopper-2", "Another user created a program based on one of yours", "creatures/Hopper-Jumping");
INSERT INTO avatars(id, type, name, requirements, image_url) VALUES (40, "Hopper", "Hopper-Cool", "Have a red-hot program at the top of the community programs list", "creatures/Hopper-Cool");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment