qt-chat-app

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs

U1766771122__alter_table_chat_participation.sql (614B)

      1 PRAGMA foreign_keys = OFF;
      2 
      3 CREATE TABLE "__alter_table_chat_participation" (
      4     'id' INTEGER PRIMARY KEY NOT NULL,
      5     'chat_id' INTEGER NOT NULL REFERENCES 'chat'('id'),
      6     'profile_id' BLOB NOT NULL REFERENCES '_user'('id')
      7 ) STRICT;
      8 
      9 INSERT INTO
     10     "__alter_table_chat_participation" ("chat_id", "id", "profile_id")
     11 SELECT
     12     "chat_id",
     13     "id",
     14     "profile_id"
     15 FROM
     16     "chat_participation";
     17 
     18 DROP TABLE "chat_participation";
     19 
     20 PRAGMA legacy_alter_table = ON;
     21 
     22 ALTER TABLE
     23     "__alter_table_chat_participation" RENAME TO "chat_participation";
     24 
     25 PRAGMA legacy_alter_table = OFF;
     26 
     27 PRAGMA foreign_keys = ON;