Welcome to the Treehouse Community
The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.
Phil Ward4,204 Points
Where can i get a completed project file for this Database deep dive?
At some point in the deep dive we create additional databases and delete data. i have a perfect database with all the correct new columns, foreign keys etc but it has no movies data in it.
The only data file i can find is the file on the first video which has all the data, but is prior to making all the changes on the table.
I'd like to get a complete data set before working on the query/count vids towards the end.
David Ker14,439 Points
In the original movie_db.sql file, you can copy the line that inserts all the movie data (looks like it's line 67), and then paste it into the query window. Before you run it, since you've got the extra columns, you'll want to modify the statement so that it inserts the data into the correct columns. It'll look something like:
INSERT INTO 'movies' (title, year) VALUES ...
Might take it a bit for it to insert all 250 rows...but it's much easier than re-watching all the videos to re-create DB from scratch!