At the beginning of this project, we made a set of test tables so that we could develop our project in a stress-free environment using tables with only 1,000 rows each. Using small tables with manageable numbers of rows is important in cases where we are not sure that our queries will work as we want them to, or where we want to experiment with tricky joins, subqueries, weird regular expressions, and so on. At this point, though, if we feel good about the queries and scripts we have written, it is time to rewrite our procedures to use the full-size tables.
Here are the steps we will follow to move the project over to full-size tables:
DROP
the test tables:DROP TABLE IF EXISTS test_badges; DROP TABLE IF EXISTS test_comments; DROP TABLE IF EXISTS test_posts; DROP TABLE IF EXISTS test_post_history; DROP TABLE IF EXISTS test_post_links; DROP TABLE IF EXISTS test_tags; DROP TABLE IF EXISTS test_users; DROP TABLE IF EXISTS test_votes;
Empty the
cleaned_posts_code...