serverless-demo.sql

CREATE TABLE `characters` (
  `characterId` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `actor` varchar(200) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `debut` varchar(200) DEFAULT NULL,
  `airDate` datetime DEFAULT NULL,
  PRIMARY KEY (`characterId`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;

INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (1,"Homer Simpson","Dan Castellaneta","Husband of Marge; father of Bart, Lisa, and Maggie.","Good Night (The Simpsons short)",19870419);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (2,"Marge Simpson","Julie Kavner","Wife of Homer; mother of Bart, Lisa, and Maggie.","Good Night (The Simpsons short)",19870419);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (3,"Bart Simpson","Nancy Cartwright","Oldest child and only son of Homer and Marge; brother of Lisa and Maggie.","Good Night (The Simpsons short)",19870419);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (4,"Lisa Simpson","Yeardley Smith","Middle child and eldest daughter of Homer and Marge; sister of Bart and Maggie.","Good Night (The Simpsons short)",19870419);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (5,"Maggie Simpson","Liz Georges ","Youngest child and daughter of Homer and Marge; sister of Bart and Lisa.","Good Night (The Simpsons short)",19870419);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (6,"Akira","George Takei, Hank Azaria","Waiter at The Happy Sumo; karate teacher.","One Fish, Two Fish, Blowfish, Blue Fish",19910124);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (7,"Ms. Albright","Tress MacNeille","Sunday school teacher.","The Telltale Head",19900225);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (8,"Aristotle Amadopolis","Jon Lovitz, Dan Castellaneta","Owner of the Shelbyville Nuclear Power Plant.","Homer Defined",19911017);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (9,"Atkins, State Comptroller","Harry Shearer, Hank Azaria","State comptroller","Lisa Gets an A",19981122);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (10,"Mary Bailey","Maggie Roswell","Governor of Springfields state.","Two Cars in Every Garage and Three Eyes on Every Fish",19901101);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (11,"Birchibald ""Birch"" T. Barlow","Harry Shearer","Radio talk show host; Fox News anchor.","Sideshow Bob Roberts",19941009);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (12,"Jasper Beardly","Harry Shearer","Grampas closest neighbor at the Retirement Castle.","Bart the General",19900121);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (13,"Benjamin, Doug, and Gary","Harry Shearer, Hank Azaria, and Dan Castellaneta","Springfield University students.","Homer Goes to College",19931014);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (14,"Bill and Marty","Dan Castellaneta and Harry Shearer","KBBL Radio co-hosts.","Bart vs. Thanksgiving",19901011);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (15,"Blinky","Unvoiced","Three-eyed fish.","Two Cars in Every Garage and Three Eyes on Every Fish",19901101);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (16,"Blue Haired Lawyer[13]","Dan Castellaneta","Attorney.","Bart Gets Hit by a Car",19910110);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (17,"Boobarella","Tress MacNeille","Host of late night TV monster movies.","Im Spelling as Fast as I Can",20030216);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (18,"Wendell Borton","Russi Taylor","Student at Springfield Elementary School.","Homers Odyssey",19900121);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (19,"Jacqueline Bouvier","Julie Kavner","Mother of Selma and Patty Bouvier and Marge Simpson, Grandmother of Bart, Lisa, Maggie and Ling.","Bart vs. Thanksgiving",19900211);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (20,"Patty Bouvier","Julie Kavner","Twin sister of Selma and older sister of Marge.","Simpsons Roasting on an Open Fire",19891217);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (21,"Selma Bouvier","Julie Kavner","Twin sister of Patty and older sister of Marge. Adoptive mother of Ling.","Simpsons Roasting on an Open Fire",19891217);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (22,"Kent Brockman","Harry Shearer","Channel 6 News anchor.","Krusty Gets Busted",19900429);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (23,"Bumblebee Man","Hank Azaria","Star of slapstick sketch comedy show on Canal Ocho.","Itchy & Scratchy: The Movie",19921103);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (24,"Charles Montgomery Burns","Harry Shearer","Owner of the Springfield Nuclear Power Plant.","Simpsons Roasting on an Open Fire",19891217);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (25,"Capital City Goofball","Tom Poston","Mascot of the Capital City Capitals baseball team.","Dancin Homer",19901108);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (26,"Carl Carlson","Hank Azaria","Springfield Nuclear Power Plant employee.","Homers Night Out",19900325);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (27,"Crazy Cat Lady","Tress MacNeille","Mentally ill owner of many cats. Name revealed as Eleanor Abernathy in See Homer Run.","Girly Edition",19980419);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (28,"Gary Chalmers","Hank Azaria","Public schools superintendent.","Whacking Day",19930429);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (29,"Charlie","Dan Castellaneta","Springfield Nuclear Power Plant employee.","Life on the Fast Lane",19900318);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (30,"Chase (Pyro)","Hank Azaria","Luann Van Houtens ex-boyfriend; American Gladiator.","A Milhouse Divided",19961201);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (31,"Scott Christian","Dan Castellaneta","News co-anchor.","Krusty Gets Busted",19900429);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (32,"Comic Book Guy","Hank Azaria","Proprietor of The Androids Dungeon comic book store. Name revealed to be Jeff Albertson in Homer and Neds Hail Mary Pass.","Three Men and a Comic Book",19910509);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (33,"Mr. Costington","Hank Azaria","President of Costingtons Department Store.","Trash of the Titans",19980426);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (34,"Database","Nancy Cartwright","Student at Springfield Elementary School.","Barts Comet",19950205);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (35,"Declan Desmond","Eric Idle","Documentary filmmaker.","Scuse Me While I Miss the Sky",20030320);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (36,"Disco Stu","Hank Azaria","Disco aficionado.","Two Bad Neighbors",19960114);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (37,"Dolph","Tress MacNeille","Springfield Elementary School bully.","The Telltale Head",19900225);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (38,"Lunchlady Doris","Tress MacNeille ","Springfield Elementary School lunch lady.","Lisas Pony",19911107);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (39,"Duffman","Hank Azaria","Spokes-mascot for Duff Beer. His real name is Barry Duffman.","The City of New York vs. Homer Simpson.",19970921);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (40,"Eddie and Lou","Harry Shearer and Hank Azaria","Springfield police officers.","Theres No Disgrace Like Home",19900128);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (41,"Fat Tony","Joe Mantegna","Mob boss.","Bart the Murderer",19911010);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (42,"Maude Flanders","Maggie Roswell","Ned Flanderss wife (dies on Season 11).","Dead Putting Society",19901115);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (43,"Ned Flanders","Harry Shearer","The Simpson familys next door neighbor; owner of The Leftorium (until it closes on Season 29), Bart Simpsons teacher at Springfield Elementary School (Season 29 onwards, substituting the void left by former deceased teacher Edna Krabappel, whom was previously married to Flanders from Seasons 23 to 25).[17][18]","Simpsons Roasting on an Open Fire",19891217);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (44,"Rod Flanders","Pamela Hayden","Ned and Maude Flanderss oldest son.","The Call of the Simpsons",19900218);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (45,"Todd Flanders","Nancy Cartwright","Ned and Maude Flanderss younger son.","Simpsons Roasting on an Open Fire",19891217);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (46,"Frankie the Squealer","Dan Castellaneta","Informant for Fat Tony.","Insane Clown Poppy",20001112);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (47,"Professor John Frink","Hank Azaria","Scientist, inventor.","Old Money",19910328);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (48,"Baby Gerald","Unvoiced","One-eyebrowed baby. Arch-nemesis of Maggie Simpson.","Sweet Seymour Skinners Baadasssss Song",19940428);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (49,"Ginger Flanders","Tress MacNeille","Ned Flanderss Vegas wife.","Viva Ned Flanders",19990110);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (50,"Gino Terwilliger","Tress MacNeille","Sideshow Bobs toddler son.","The Italian Bob",20051211);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (51,"Alice Glick","Cloris Leachman","Elderly.","Three Men and a Comic Book",19910509);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (52,"Gloria Jailbird","Julia Louis-Dreyfus","Snakes pregnant girlfriend.","A Hunka Hunka Burns in Love",20011202);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (53,"Barney Gumble","Dan Castellaneta","Homers drunken old pal.","Simpsons Roasting on an Open Fire",19891217);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (54,"Gil Gunderson","Dan Castellaneta","Unsuccessful salesman.","Realty Bites",19971207);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (55,"The Happy Little Elves","Dan Castellaneta,Hank Azaria, and Harry Shearer[22]","Childrens cartoon series characters.","Simpsons Roasting on an Open Fire",19890212);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (56,"Judge Constance Harm","Jane Kaczmarek","Springfield judge.","The Parent Rap",20011111);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (57,"Herman Hermann","Harry Shearer","Owner of Hermans Military Antiques shop.","Bart the General",19900204);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (58,"Bernice Hibbert","Tress MacNeille","Dr. Hibberts wife.","Barts Dog Gets an F",19910307);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (59,"Dr. Julius Hibbert","Harry Shearer","Medical doctor.","Bart the Daredevil",19901206);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (60,"Elizabeth Hoover","Maggie Roswell","Lisa Simpsons teacher at Springfield Elementary School.","Brush with Greatness",19910411);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (61,"Lionel Hutz","Phil Hartman[24]","Attorney.","Bart Gets Hit by a Car",19910110);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (62,"Itchy & Scratchy","Dan Castellaneta and Harry Shearer","Cartoon cat and mouse.","Theres No Disgrace Like Home",19881120);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (63,"Jacques","Albert Brooks[26]","Bowling instructor.","Life on the Fast Lane",19900318);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (64,"Jimbo Jones","Pamela Hayden","Springfield Elementary School bully.","The Telltale Head",19900225);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (65,"Rachel Jordan","Shawn Colvin[28]","Lead singer of the Christian Rock band Kovenant.","Alone Again, Natura-Diddily",20000213);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (66,"Kang and Kodos","Harry Shearer and Dan Castellaneta","Extraterrestrials.","Treehouse of Horror",19901025);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (67,"Princess Kashmir","Maggie Roswell","Belly dancer.","Homers Night Out",19900325);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (68,"Edna Krabappel","Marcia Wallace","Bart Simpsons teacher at Springfield Elementary School (until season 25), and Ned Flanders wife (Seasons 23-25, when the character is revealed to have died).","Bart the Genius",19900114);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (69,"Rabbi Hyman Krustofski","Jackie Mason","Rabbi; father of Krusty the Clown.","Like Father, Like Clown",19911024);
INSERT INTO characters (characterId,name, actor, description, debut, airDate) VALUES (70,"Krusty the Clown","Dan Castellaneta","TV show clown host, original name Herschel Shmoikel Pinchas Yerucham Krustofski.","The Telltale Head",19890115);