/tests/testfiles/sqlite-zero_tables.sql

https://code.google.com/p/camelbox/ · SQL · 10 lines · 8 code · 0 blank · 2 comment · 0 complexity · 201c19ecdc287329e6837821f5300033 MD5 · raw file 

    

  1. -- drop all of the tables
    2. 

  2. DROP TABLE IF EXISTS install_type;
    3. 

  3. DROP TABLE IF EXISTS base_urls;
    4. 

  4. DROP TABLE IF EXISTS manifest;
    5. 

  5. DROP TABLE IF EXISTS groups;
    6. 

  6. DROP TABLE IF EXISTS groups_sections;
    7. 

  7. DROP TABLE IF EXISTS packages;
    8. 

  8. DROP TABLE IF EXISTS package_install_type;
    9. 

  9. -- clean up the database file
    10. 

  10. VACUUM;
    11.