/ data-imports / scripts / helpers / pilimi_zlib_final.sql
pilimi_zlib_final.sql
1  # Double-check that the new tables indeed exist, before we start dropping a bunch of existing tables.
2  SELECT * FROM allthethings.books LIMIT 1;
3  SELECT * FROM allthethings.isbn LIMIT 1;
4  DROP TABLE IF EXISTS allthethings.zlib_book;
5  DROP TABLE IF EXISTS allthethings.zlib_isbn;;
6  
7  RENAME TABLE allthethings.books TO allthethings.zlib_book;
8  RENAME TABLE allthethings.isbn TO allthethings.zlib_isbn;