qt-chat-app

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

U1766663148__alter_table_chat_participation.sql (587B)

      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     'sender_id' INTEGER NOT NULL REFERENCES 'profile'('id')
      7 ) STRICT;
      8 
      9 INSERT INTO
     10     "__alter_table_chat_participation" ("id", "chat_id")
     11 SELECT
     12     "id",
     13     "chat_id"
     14 FROM
     15     "chat_participation";
     16 
     17 DROP TABLE "chat_participation";
     18 
     19 PRAGMA legacy_alter_table = ON;
     20 
     21 ALTER TABLE
     22     "__alter_table_chat_participation" RENAME TO "chat_participation";
     23 
     24 PRAGMA legacy_alter_table = OFF;
     25 
     26 PRAGMA foreign_keys = ON;