Last active
December 30, 2015 19:39
-
-
Save vanmichael/7875539 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | rating | |
| ------------------------------------------------+-------- | |
| Mulan II | 0 | |
| Beauty and the Beast - The Enchanted Christmas | 0 | |
| Police Academy 5 - Assignment Miami Beach | 0 | |
| InSight | 0 | |
| Police Academy 4 - Citizens on Patrol | 0 | |
| Troll 2 | 0 | |
| That Was Then... This Is Now | 0 | |
| Fred: The Movie | 0 | |
| S. Darko: A Donnie Darko Tale | 0 | |
| The Fox and the Hound 2 | 0 | |
| Double Dragon | 0 | |
| Heavy Metal 2000 | 0 | |
| Hellraiser VI - Hellseeker | 0 | |
| Casper - A Spirited Beginning | 0 | |
| The Neverending Story II: The Next Chapter | 0 | |
| I'll Always Know What You Did Last Summer | 0 | |
| Cinderella II - Dreams Come True | 0 | |
| Father of Invention | 0 | |
| Brother's Justice | 0 | |
| Breaking Point | 0 | |
| One Missed Call | 0 | |
| All I Want (Try Seventeen) | 0 | |
| Redline | 0 | |
| 12 in a Box | 0 | |
| Alone in the Dark | 1 | |
| Disaster Movie | 1 | |
| Daddy Day Camp | 1 | |
| Epic Movie | 2 | |
| Kickin' It Old Skool | 2 | |
| Meet the Spartans | 2 | |
| Deuces Wild | 3 | |
| Cool World | 3 | |
| Jack and Jill | 3 | |
| Speed 2 - Cruise Control | 3 | |
| Twelve | 3 | |
| The Covenant | 3 | |
| Godsend | 4 | |
| The Roommate | 4 | |
| Material Girls | 4 | |
| Scary Movie 5 | 4 | |
| Happily N'ever After | 4 | |
| The Fog | 4 | |
| Christmas with the Kranks | 5 | |
| Old Dogs | 5 | |
| Larry the Cable Guy: Health Inspector | 5 | |
| Bio-Dome | 5 | |
| 88 Minutes | 5 | |
| Big Mommas: Like Father, Like Son | 5 | |
| Broken Bridges | 5 | |
| Serving Sara | 5 | |
| (50 rows) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | year | name | |
| ------------------------------+------+------------------------------- | |
| Frankenstein | 1931 | Universal Pictures Company | |
| The Wolf Man | 1941 | Universal Pictures | |
| The Thing from Another World | 1951 | Warner Home Video | |
| Psycho | 1960 | Paramount Pictures | |
| Night of the Living Dead | 1968 | Continental Distributing Inc. | |
| (5 rows) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | title | year | |
| ----------------+---------------------------------+------ | |
| Sean Connery | Dr. No | 1962 | |
| Sean Connery | From Russia With Love | 1963 | |
| Sean Connery | Goldfinger | 1964 | |
| Sean Connery | Thunderball | 1965 | |
| Sean Connery | You Only Live Twice | 1967 | |
| George Lazenby | On Her Majesty's Secret Service | 1969 | |
| Sean Connery | Diamonds Are Forever | 1971 | |
| Roger Moore | Live and Let Die | 1973 | |
| Roger Moore | The Man with the Golden Gun | 1974 | |
| Roger Moore | The Spy Who Loved Me | 1977 | |
| Roger Moore | Moonraker | 1979 | |
| Roger Moore | Octopussy | 1983 | |
| Roger Moore | A View to a Kill | 1985 | |
| Timothy Dalton | The Living Daylights | 1987 | |
| Pierce Brosnan | GoldenEye | 1995 | |
| Pierce Brosnan | Tomorrow Never Dies | 1997 | |
| Pierce Brosnan | The World Is Not Enough | 1999 | |
| Daniel Craig | Casino Royale | 2006 | |
| Darko Belgrade | Epic Movie | 2007 | |
| Daniel Craig | Quantum of Solace | 2008 | |
| Daniel Craig | Skyfall | 2012 | |
| (21 rows) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | year | name | |
| --------------------------------+------+--------------------------- | |
| The Lost World - Jurassic Park | 1997 | Action & Adventure | |
| Nine Months | 1995 | Comedy | |
| The Big Lebowski | 1998 | Comedy | |
| A Single Man | 2009 | Drama | |
| Benny & Joon | 1993 | Drama | |
| Boogie Nights | 1997 | Drama | |
| Children of Men | 2006 | Drama | |
| I'm Not There | 2007 | Drama | |
| Magnolia | 1999 | Drama | |
| The Forgotten | 2004 | Drama | |
| The Fugitive | 1993 | Drama | |
| The Hours | 2002 | Drama | |
| The Kids Are All Right | 2010 | Drama | |
| Assassins | 1995 | Mystery & Suspense | |
| Chloe | 2010 | Mystery & Suspense | |
| Hannibal | 2001 | Mystery & Suspense | |
| Next | 2007 | Mystery & Suspense | |
| Evolution | 2001 | Science Fiction & Fantasy | |
| (18 rows) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | rating | |
| -------------------------------------------------------------------------+-------- | |
| 10.5 | | |
| 16 To Life | | |
| 18 Year Old Virgin | | |
| 23 | | |
| 400 Years of the Telescope | | |
| 7 Things to Do Before I'm 30 | | |
| A Good Man | | |
| Ace Ventura Jr.: Pet Detective | | |
| Adam and Eve | | |
| Addams Family Reunion | | |
| After Sex | | |
| After the Wedding | | |
| Alabama Moon | | |
| Aladdin | | |
| Alice in Wonderland | | |
| All American Orgy (Cummings Farm) | | |
| All for Melissa | | |
| American Carny: True Tales from the Circus Sideshow | | |
| American Pie 5: The Naked Mile | | |
| American Pie Presents: Beta House | | |
| An Evening with Kevin Smith 2: Evening Harder | | |
| Angela | | |
| Annie | | |
| Another Cinderella Story | | |
| Art City | | |
| As Good as Dead | | |
| Augusta, Gone | | |
| Autumn | | |
| Avatar 2 | | |
| Avatar: The Last Airbender: Book 3 | | |
| Back to the Secret Garden | | |
| Backyard (El traspatio) | | |
| Bad Reputation | | |
| Baghban | | |
| Bam Margera Presents: Where the #$&% is Santa? | | |
| Battlestar Galactica | | |
| Behind Enemy Lines II: Axis of Evil | | |
| Beneath the Dark | | |
| Best of the Best | | |
| Beverly Hills Brats | | |
| Beyond F.A.T. City | | |
| Beyond Sherwood Forest | | |
| Bheja Fry | | |
| Bill Hicks Live: Satirist, Social Critic, Stand Up Comedian | | |
| Blasted!!! The Gonzo Patriots of Hunter S. Thompson | | |
| Blind Spot | | |
| Bloom | | |
| Bodyguards and Assassins (Shi yue wei cheng) | | |
| Book of Pooh: Stories from the Heart | | |
| Born to Raise Hell | | |
| Breath Made Visible: Anna Halprin | | |
| Bridge to Terabithia | | |
| Bring It On Again | | |
| Bring It On: All or Nothing | | |
| Bring It On: In It to Win It | | |
| Buddy | | |
| Bullet | | |
| Burke and Hare | | |
| Buy the Ticket, Take the Ride: Hunter S. Thompson on Film | | |
| By Dawn's Early Light | | |
| CKY2K | | |
| Cadet Kelly | | |
| Carnivale | | |
| Chakushin ari final (One Missed Call Final) | | |
| Champions | | |
| Charlotte's Web 2 - Wilbur's Great Adventure | | |
| Cheaper By the Dozen | | |
| Cheech & Chong's Next Movie | | |
| Children of the Corn | | |
| Choose | | |
| Chronicling Narnia: The C.S Lewis Story | | |
| Circus Camp | | |
| Clerks | | |
| Coffin | | |
| Cougars, Inc. | | |
| Cruel Intentions 3 | | |
| Cube Zero | | |
| Curse of the Zodiac | | |
| D-graduated (Regresados) | | |
| D.C. Sniper | | |
| Da Vinci Code Decoded | | |
| Dark Fury - The Chronicles of Riddick | | |
| Dead Awake | | |
| Dead of Winter | | |
| Derby (Roller Derby) | | |
| Devil's Pond | | |
| Dhoom | | |
| Diary of Anne Frank | | |
| Dil Chahta Hai | | |
| Dil To Pagal Hai (The Heart Is Crazy) | | |
| Dil Toh Baccha Hai Ji | | |
| Dilwale Dulhania Le Jayenge | | |
| Don | | |
| Don | | |
| Don't Try This at Home - The Steve-O Video | | |
| Dr. Dolittle 3 | | |
| Dragon Ball Z: Bojack Unbound | | |
| Dragonheart - A New Beginning | | |
| Drive | | |
| Duffy's Irish Circus | | |
| Ed Gein: The Butcher of Plainfield | | |
| Edges of Darkness | | |
| Elizabeth I | | |
| Eminem AKA | | |
| End Game | | |
| Entry Level | | |
| Fade | | |
| Family Guy - Blue Harvest | | |
| Family Guy Presents Stewie Griffin: The Untold Story | | |
| Family Guy Presents: It's a Trap | | |
| Family Guy Presents: Something Something Something Dark Side | | |
| Farscape: The Peacekeeper Wars | | |
| Faust: Love of the Damned | | |
| Flight 93 | | |
| Flores de Otro Mundo | | |
| Foreign Exchange | | |
| Four Corners of Suburbia | | |
| Freud | | |
| Freud: The Secret Passion | | |
| Frosty the Snowman | | |
| Futurama: Into the Wild Green Yonder | | |
| Garfield As Himself | | |
| Garfield Holiday Celebrations | | |
| Get Well Soon | | |
| Go Fast | | |
| Go Figure | | |
| Greta | | |
| Gulliver's Travels | | |
| Hairspray 2 | | |
| Hannah and Her Brothers | | |
| Happy Ever Afters | | |
| Heart Of A Dragon | | |
| Heidi | | |
| Helen of Troy | | |
| Hellboy Animated: Blood and Iron | | |
| Hey There, It's Yogi Bear | | |
| High School Musical 4: East Meets West | | |
| Hitler: The Rise of Evil | | |
| Holiday in the Sun | | |
| Hooking Up | | |
| Hotel Chevalier | | |
| How I Got Lost | | |
| Hum Tum | | |
| Human Trafficking | | |
| Hunchback of Notre Dame | | |
| Hunt to Kill | | |
| Hussy | | |
| I Come | | |
| I Do & I Don't | | |
| If Only | | |
| In Love We Trust | | |
| In Search of Dr. Seuss | | |
| Inhyeongsa (The Doll Master) | | |
| Insidious | | |
| Intellectual Property (Dark Mind) | | |
| Intimate Affairs | | |
| Iron Eagle | | |
| Iron Jawed Angels | | |
| Irresistible | | |
| Jab We Met | | |
| Jack-Jack Attack | | |
| Jackass 2.5 | | |
| Jada | | |
| John Cleese on How to Irritate People | | |
| Journey To Promethea | | |
| Ju-on: The Grudge | | |
| Kabhi Khushi Kabhie Gham | | |
| Kal Ho Naa Ho | | |
| Khon len khong (Art of the Devil) | | |
| Kidulthood | | |
| Killer Condom: The Rubber That Rubs You Out | | |
| King of the Ants | | |
| Kiseichuu: kiraa pusshii (Sexual Parasite: Killer Pussy) | | |
| Kuch Kuch Hota Hai | | |
| La Ragazza del lago (The Girl by the Lake) | | |
| Ladies and Gentlemen, the Fabulous Stains | | |
| Landspeed: CKY (CKY: The Original) | | |
| Last Stop 174 (Ultima Parada 174) | | |
| Le Chevalier D'Eon | | |
| Le grand blanc de Lambarene | | |
| Legally Blondes | | |
| Linewatch | | |
| Love at Stake | | |
| Lullaby | | |
| Madea Goes to Jail | | |
| Madea's Class Reunion | | |
| Madea's Family Reunion | | |
| Main Hoon Na | | |
| McLintock! | | |
| Meet the Browns | | |
| Mickey's Once Upon A Christmas | | |
| Midnight Clear | | |
| Mohabbatein | | |
| Monty Python Live at the Hollywood Bowl | | |
| Nailed | | |
| Night Train | | |
| Ninja Cheerleaders | | |
| No eres tu, soy yo | | |
| Notebook | | |
| Oliver Twist | | |
| Once Upon a Time in Cuba | | |
| One Man Band | | |
| Origins of Life | | |
| Our Lips Are Sealed | | |
| Passport To Paris | | |
| Peter Pan | | |
| Picture This! | | |
| Pig Hunt | | |
| Planet Earth: Visions of the Earth from Space - South America | | |
| Point of No Return | | |
| Prendimi l'anima (The Soul Keeper) | | |
| Pretty Things | | |
| Pride and Prejudice | | |
| Princess Protection Program | | |
| Princess of Thieves | | |
| Private Eye | | |
| Prowl | | |
| Pursuit of Happiness | | |
| Rab Ne Bana Di Jodi (A Couple Made by God) (A Match Made in Heaven) | | |
| Recien cazado | | |
| Revenge Of The Bridesmaids | | |
| Ringu 0 | | |
| Robinson Crusoe | | |
| Robot Chicken: Star Wars | | |
| Rock On!! | | |
| Rockaway | | |
| Sakebi (Retribution) | | |
| Salaam-e-Ishq | | |
| Sand | | |
| Sauna (Filth) | | |
| Saw (short film) | | |
| Scum | | |
| Shattered Lives | | |
| She's Too Young | | |
| Sherlock Holmes and the Secret Weapon | | |
| Shrek 4-D (Shrek 3-D) | | |
| Shrek Goes Fourth | | |
| Shrek the Halls | | |
| Sin City: A Dame to Kill For | | |
| Single White Female 2: The Psycho | | |
| Sniper 2 | | |
| Sniper: Reloaded | | |
| Sold Out: A Threevening with Kevin Smith | | |
| Solstice | | |
| Some Folks Call It a Sling Blade | | |
| Spartacus | | |
| Stargate: Continuum | | |
| Stargate: The Ark of Truth | | |
| Stephen King's The Shining (MINI-SERIES) | | |
| Strawberry Shortcake Movie: Sky's The Limit | | |
| Street Fighter II: The Animated Movie | | |
| Street Kings 2: Motor City | | |
| Street Thief | | |
| Strictly Sexual | | |
| Stripper Academy | | |
| Sucker Punch | | |
| Summer's Blood (Summer's Moon) | | |
| Superman | | |
| Sweeney Todd - The Demon Barber of Fleet Street | | |
| Sweeney Todd: The Demon Barber of Fleet Street | | |
| Talhotblond | | |
| Team Orion, The Fight For Freedom | | |
| Teenage Dirtbag | | |
| Tekken | | |
| Tenure | | |
| Thank You | | |
| The '60s | | |
| The 300 Spartans | | |
| The 4 Musketeers | | |
| The Aviary | | |
| The Bad Mother's Handbook | | |
| The Brazilian Job | | |
| The Cheetah Girls | | |
| The Cheetah Girls 2 | | |
| The Cheetah Girls: One World | | |
| The Chipmunk Adventure | | |
| The Contractor | | |
| The Count of Monte Cristo | | |
| The Count of Monte-Cristo | | |
| The Curiosity of Chance | | |
| The Cutting Edge: Going for the Gold | | |
| The Experiment | | |
| The Eye 2 (Gin gwai 2) | | |
| The Five People You Meet in Heaven | | |
| The Flight of the Innocent (La corsa dell'innocente) | | |
| The Heart Specialist | | |
| The Hit List | | |
| The Hitcher 2 - I've Been Waiting | | |
| The Hunt | | |
| The Invincible Iron Man | | |
| The James Bond Story | | |
| The Killer Inside Me | | |
| The Land Before Time IX: Journey to Big Water | | |
| The Land Before Time VI - The Secret of Saurus Rock | | |
| The Last Godfather | | |
| The Last Samurai | | |
| The Legend Is Born: Ip Man (Yip Man chinchyun) | | |
| The Legend of Secret Pass | | |
| The Legend of Sleepy Hollow | | |
| The Librarian: Return to King Solomon's Mines | | |
| The Lion, the Witch, and the Wardrobe | | |
| The Little Engine That Could | | |
| The Loss of Nameless Things | | |
| The Lost Treasure of the Grand Canyon | | |
| The Mack | | |
| The Man in the Iron Mask | | |
| The Onion Movie | | |
| The Other Boleyn Girl | | |
| The Painted Veil | | |
| The Prince and Me 2 | | |
| The Queen and I | | |
| The Ramen Girl | | |
| The Sandlot 3: Heading Home | | |
| The Scorpion King 2: Rise of a Warrior | | |
| The Second Front | | |
| The Secret Diary of Sigmund Freud | | |
| The Secret Garden | | |
| The Simpsons' Christmas Message | | |
| The Simpsons: Family Therapy | | |
| The Steam Experiment (The Chaos Experiment) | | |
| The Thing Below (Ghost Rig 2: The Legend of the Sea Ghost) | | |
| The Tournament | | |
| The Truth About Average Guys | | |
| The Way of War | | |
| The Zodiac Killer | | |
| Thirst | | |
| Thomas & Friends - Mud Glorious Mud | | |
| Thomas & Friends: Misty Island Rescue | | |
| Titanic | | |
| Titanic | | |
| Trail of a Serial Killer | | |
| Transformers Energon - The Return of Megatron | | |
| Transformers Energon: Omega Supreme | | |
| Triloquist | | |
| Truands (Crime Insiders)(Paris Lockdown) | | |
| Twilight | | |
| Unconscious | | |
| Unthinkable | | |
| Vampire Journals | | |
| Van Helsing: The London Assignment | | |
| Veer Zaara (Veer-Zaara) | | |
| Vernie | | |
| Vito Bonafacci | | |
| Wake Up, Ron Burgundy: The Lost Movie | | |
| Walking Tall 2: The Payback | | |
| Walking Thunder | | |
| Wallace & Gromit in Three Amazing Adventures | | |
| Wallace and Gromit in 'A Matter of Loaf and Death' | | |
| War Games | | |
| We Remember Marilyn | | |
| Wendy Wu: Homecoming Warrior | | |
| Westworld | | |
| When a Stranger Calls Back | | |
| When in Rome | | |
| Where the Wild Things Are and Other Maurice Sendak Stories | | |
| Whisper | | |
| White Boyz In The Hood | | |
| Wild Things 2 | | |
| Will Ferrell: You're Welcome America - A Final Night with George W Bush | | |
| Winning London | | |
| Wizard of Oz | | |
| Wizards of Waverly Place The Movie | | |
| Wolves in the Snow | | |
| World's Best Dad | | |
| Wrong Turn at Tahoe | | |
| X-Men Origins: Magneto | | |
| XXL | | |
| Yesterday | | |
| Zorro | | |
| (369 rows) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | year | rating | |
| ----------------------------+------+-------- | |
| The Evil Dead | 1981 | 98 | |
| E.T. The Extra-Terrestrial | 1982 | 98 | |
| The Neverending Story | 1984 | 80 | |
| The Thing | 1982 | 79 | |
| Phenomena (Creepers) | 1984 | 77 | |
| Scrooged | 1988 | 66 | |
| Back to the Future Part II | 1989 | 64 | |
| Critters | 1986 | 57 | |
| Spaceballs | 1987 | 54 | |
| Ghostbusters 2 | 1989 | 51 | |
| Willow | 1988 | 50 | |
| Legend | 1986 | 48 | |
| Teen Wolf | 1985 | 47 | |
| Santa Claus - The Movie | 1985 | 17 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | |
| -------------------------------------- | |
| Gnomeo and Juliet | |
| Hugo | |
| Black Swan | |
| Judy Moody and the NOT Bummer Summer | |
| Trollhunter | |
| Prometheus | |
| I Saw the Devil | |
| (7 rows) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE recipes ( id serial, | |
| name varchar not null, | |
| directions text not null, | |
| servings float, | |
| time varchar | |
| ); | |
| CREATE TABLE ingredients ( id serial, | |
| name varchar not null | |
| ); | |
| CREATE TABLE recipe_ingredients ( id serial, | |
| recipe_id int not null, | |
| ingredient_id int not null, | |
| amount float not null, | |
| type_measurement varchar | |
| ); | |
| INSERT INTO recipes (name,directions,servings,time) | |
| VALUES ('Green Eggs & Ham', '1. Cook the eggs. 2. Cook the ham. 3. Combine.', 2, '25 Minutes'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Green Eggs'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Ham'); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount) | |
| VALUES (1,1,4); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount,type_measurement) | |
| VALUES (1,2,1.5,'lb'); | |
| INSERT INTO recipes (name,directions) | |
| VALUES ('Fried Green Tomatoes', '1. Slice the tomatoes 1/2 inch thick. 2. Whisk eggs and milk together. 3. Dip tomatoes in egg mixture and then bread crumbs. 4. Heat oil in a large skillet. 5. Fry the tomatoes in the oil.'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Large Green Tomatoes'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Eggs'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Milk'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Breadcrumbs'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Vegetable Oil'); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount) | |
| VALUES (2,3,3); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount) | |
| VALUES (2,4,2); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount,type_measurement) | |
| VALUES (2,5,1.5,'cup'); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount,type_measurement) | |
| VALUES (2,6,1.5,'cup'); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount,type_measurement) | |
| VALUES (2,7,1,'quart'); | |
| INSERT INTO recipes (name,directions,servings) | |
| VALUES ('Martini', '1. Pour all ingredients into mixing glass with ice cubes. 2. Stir well. 3. Strain in chilled martini cocktail glass. 4. Squeeze oil from lemon peel onto the drink, or garnish with olive.', 1); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Gin'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Dry Vermouth'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Lemon Peel'); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Olive'); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount,type_measurement) | |
| VALUES (3,8,2,'oz'); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount,type_measurement) | |
| VALUES (3,9,1,'oz'); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount) | |
| VALUES (3,10,1); | |
| INSERT INTO recipe_ingredients (recipe_id,ingredient_id,amount) | |
| VALUES (3,11,2); | |
| INSERT INTO ingredients (name) | |
| VALUES ('Vodka'); | |
| UPDATE recipe_ingredients SET ingredient_id = 12 WHERE ingredient_id = 8; | |
| UPDATE recipe_ingredients SET amount = 3 WHERE ingredient_id = 12; | |
| DELETE FROM recipe_ingredients WHERE recipe_id = 1; | |
| DELETE FROM recipes WHERE name = 'Green Eggs & Ham'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment