qt-chat-app

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

U1766752610__alter_table_chat.sql (524B)

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