up.sql 417 B

12345678910111213141516
  1. CREATE TABLE favorites (
  2. user_uuid VARCHAR(40) NOT NULL REFERENCES users(uuid),
  3. cipher_uuid VARCHAR(40) NOT NULL REFERENCES ciphers(uuid),
  4. PRIMARY KEY (user_uuid, cipher_uuid)
  5. );
  6. -- Transfer favorite status for user-owned ciphers.
  7. INSERT INTO favorites(user_uuid, cipher_uuid)
  8. SELECT user_uuid, uuid
  9. FROM ciphers
  10. WHERE favorite = TRUE
  11. AND user_uuid IS NOT NULL;
  12. ALTER TABLE ciphers
  13. DROP COLUMN favorite;